Power BI Course

In the modern world, one of the significant challenges in business is managing data and processing it effectively. On one hand, there is the challenge of receiving data, and on the other hand, the ability to accurately analyze the received data is crucial. In response to these challenges, the demand for the position of a data analyst is increasing, making it one of the growing and popular career directions of the 21st century.

Power BI is a modern data visualization tool that will allow you to process, visualize and analyze large amounts of data quickly and efficiently.

Who is the training intended for?

The training is intended for those who are interested in data analytics, who often have to produce various types of reports and want to learn modern data processing techniques.

Trainers

The training will be led by Giorgi Jokhadze, the co-founder of Kaizen Institute Georgia and AOTS Georgia, the official representative of TEMOS International in Georgia, who has many years of experience in the field of business analytics.

The course will be held in Georgian, and a Syntax Academy certificate will be issued.

Global trend – digital transformation

BI and the World market

Task #1 (Excel format)

Task Review (#1)

Preparing a test Power BI database

Principles of database operation

Task #2 (Excel format)

Task Review (#2)

DAX – Power BI programming language

Creating the first formulas in DAX

Integrating formulas into Power BI visuals

Task #3 (DAX & Power BI Format)

Task Review (#3)

Programming in DAX and Data Processing (continued)

Task #4 (DAX & Power BI Format)

Task Review (#4)

Programming in DAX and Data Processing (continued)

Task #5 (DAX & Power BI Format)

Task Review (#5)

Talking with Data (The Importance of Visualization)

Reviewing the results of the task (#2)

Summary of the course

Questions and Answers

Satisfaction survey

Certifications

Microsoft 365 Training

The aim of the training course is for the trainees to get:

  1. General information about Microsoft 365
  2. Learn more about specific features in Teams, Planner, and OneDrive that will make their day-to-day work easier

Training Format

  • Combined training format (theory with practice)
  • Workshop

Main topics

  1. What is Microsoft 365
  2. What is Teams and What do we use it for?
    • How to download, install and manage our Teams
    • What we can do in chat and how we share documents with each other
    • Creating a group and related channel
    • What functionality is available within our group and related channels
    • Manage users and rights in the group
    • How we schedule and manage meetings both within and outside the group
    • Sharing files and working on them at the same time
    • Using other third party applications both within the group and individually
  3. What is Planner and What do we use it for?
    • Create Project
    • Creating subtasks and attaching them to a specific person
    • An overview of the created project: how many tasks have been created, which have been completed on time, which tasks are overdue, etc.
    • Using Planner both within a group and individually
  4. What is OneDrive and What do we use it for?
    • How to create different types of documents (Word, Excel, PowerPoint) and files.
    • How to share files and folders with each other according to appropriate security policies
    • How to work together on the same document with several employees at the same time
  5. Workshop

Training results and competencies

After completing the course, the training participant will know:

  • What are the three specific services of Microsoft 365 Teams, Planner, OneDrive and what are they used for.
  • Full user functionality and usage.

What is Microsoft 365

What is Teams and What do we use it for?

  • How to download, install and manage our Teams
  • What we can do in chat and how we share documents with each other
  • Creating a group and related channel
  • What functionality is available within our group and related channels
  • Manage users and rights in the group
  • How we schedule and manage meetings both within and outside the group
  • Sharing files and working on them at the same time
  • Using other Third party applications both within the group and individually

What is Planner and What do we use it for?

  • Create Project
  • Creating subtasks and attaching them to a specific person
  • An overview of the created project: how many tasks have been created, which have been completed on time, which tasks are overdue, etc.
  • Using Planner both within a group and individually

What is OneDrive and What do we use it for?

  • How to create different types of documents (Word, Excel, PowerPoint) and files.
  • How to share files and folders with each other according to appropriate security policies
  • How to work together on the same document with several employees at the same time

Workshop

Project management using the Kanban methodology

Course Description/Details:

The Kanban method is an agile approach to managing work (tasks, projects) for individuals, teams and organizations that want to improve their products and services. The Kanban method teaches organizations how to visualize work and measure performance to continuously improve and consistently increase organizational results. Implementing the Kanban method is the best step for teams and organizations to improve the efficiency of work processes. By understanding the basic concepts of the Kanban method, you will be able to create a better work environment by improving visibility, communication and collaboration within the team.

Target Audience

Anyone from any role in an organization who wants to better manage workflow, tasks, and projects, as well as those who want to use agile approaches in practice to increase efficiency, can benefit from this.

What will you learn?

  • Lean production and the history of the creation of the Kanban method
  • What is Kanban?
  • Comparison of Kanban with other Agile approaches
  • Basics and benefits of the Kanban method
  • “Pull” systems and STATIK approach
  • What is a Kanban board – essential elements and benefits
  • Personal Kanban
  • How to manage Kanban meetings
  • 6 practices of the Kanban method
  • Kanban cards
  • Using the Kanban method in organizing team tasks
  • How to use Kanban metrics to measure work efficiency

ITIL V4 Foundation Course

ITIL® is the world’s leading best practice framework for implementing IT Service Management. ITIL 4 introduces IT Service Management through the lens of a Service Value System (SVS), which provides a holistic end-to-end view of how to successfully contribute to business value. This foundational course immerses you in the guiding principles, dimensions, and practices of ITIL® 4.

By completion of this course, you will have a deep understanding of the 7 Guiding Principles, 4 Dimensions of Service Management, 34 ITIL® Practices, and the new Value Service Chain that incorporate the core of ITIL® 4.

ITIL 4 OVERVIEW

  • Introduction to ITIL
  • Key Concepts of ITIL

THE ITIL FRAMEWORK

  • The Four Dimensions of Service Management
  • The ITIL Service Value System

THE ITIL GUIDING PRINCIPLES

  • Focus on Value
  • Start Where You Are
  • Progress Iteratively with Feedback
  • Collaborate and Promote Visibility
  • Think and Work Holistically
  • Keep It Simple and Practical
  • Optimize and Automate

THE ITIL SERVICE VALUE SYSTEM

  • Governance
  • The Service Value Chain
  • Continual Improvement

KEY ITIL PRACTICES

  • Continual Improvement
  • Service Level Management
  • Change Control
  • Incident Management
  • Service Request Management
  • Service Desk
  • Problem Management

OTHER ITIL PRACTICES

  • General Management Practices
  • Service Management Practices
  • Technical Management Practices

© 2023 Syntax. All right reserved.