Online Course
PowerBI & DAX-A
Complete Course
from A to Z
Start Now
Simply about complicated
Mentor support
Practical assignments
Certificate
About the Data Analyst
Profession with Power BI
Power BI is a powerful analytics tool that enables companies to structure, analyze and visualize data from a variety of sources. With its help, professionals transform raw data into interactive dashboards and reports, helping businesses make informed decisions.
Who the training is suitable for
Beginning
analysts
Training will provide a basis for further professional development
Marketing and sales
professionals
Will be able to work with data more efficiently and automate reporting
Project managers
Will be able to create easy-to-understand reports and monitor the progress of tasks
IT specialists
Knowledge will be useful for expanding skills in analytical applications and improve
What this course will give you
Freedom from routine
Power BI will save you from tedious manual reporting in Excel and endless searches for data in disparate files. Automating processes will give you additional hours of productive work.
Confidence in decision making
You will be able to react quickly to changes in business indicators thanks to visual analytical dashboards with up-to-date data.
Financial Perspectives
Mastering Power BI will open doors to higher-paying positions or directly impact company profits through smart data management.
What you
will learn
1
You will learn PowerBI from basic to advanced level
2
You will learn about data modeling, and power types
3
You will learn how to create stunning dashboards using dax
4
You will learn all
about Powerbi
5
You will learn how to create visual elements and match them to BI functions
6
We will cover
DAX in detail
What this course will give you
Alexander Kovalev
12 years of experience in business intelligence and data visualization Lead architect of Power BI solutions at DataArt
Dmitry Smirnov
Expert in DAX and data model optimization Author of Power BI courses for Microsoft Learning Partners
Stas Bystrov
Microsoft Certified Trainer (MCT) with 8- years of experience Developed 50+ dashboards for retail chains
Igor Melnikov
Specialist in integrating Power BI with cloud services Technical head of BI projects in CROC
Training Program
Module 1
Power BI Desktop
Visual and Functions
About the course - What will we learn?
Basics of PowerBI and Import Excel Data
How BI behaves if source data changes with Clustered Column Visual
Legends & Small Multiples
Add same field for more calculations and a Tooltip feature
Stacked Column Visuals in detail
Slicers - Game changer
How to change source path, if need be
Drill On feature - Fantastic
Import files from a folder & PQ Basic important features
Cards Visual for Process performance
Table Visual
How to Sort Months in X axis
More Sorting techniques
Matrix - Our pivot
Pie
Doughnut
Funnel Visuals
Weblinks & Decomposition & Gauge Visuals
Multi Card and New Cards visuals
KPI Visual & Shapes with Navigation Bars
Drill Through in BI
Customize Themes and Analytical Pane
Line and Area Visuals
Filter Pane in BI for visuals
Power Query to connect with SQL Server
Module 2
DAX begins
Basic DAX - SUM, COUNT, COUNTROWS, DISTINCT COUNT, AVG - How to write DAX
CALCULATE DAX - In full detail
FILTER and ALL/ALLSELECTED/ALLEXCEPT
SUMMARIZE DAX
TOPN - real practical knowledge
SUMX, COUNTX, AVERAGEX - ITERATORS
Challenge Solved - TOPN with SUMX - Amazing knowledge
Questions by Students
Selected Value
Write DAX in steps - Amazing way
Module 3
DAX Test for you
Solve these DAX Questions
Module 4
Data Modelling
Relationships in PowerBI
One to One
One to Many
Many to Many
Many to Many - One more example
Attrition report on RELATIONSHIPS
Module 5
Dashboard 1
Executive Performance Dashboard. Part 1
Creating Top and Bottom performances in 2nd page. Part 2
Module 6
Dashboard 2
Executive and sales Dashboard
Module 7
BI Service - Sharing
Your Dashboards
Sharing the reports using BI License version - Cloud
Module 8
BookMarks
With Selections
Everything about BookMarks and Selections
Module 9
Date and Time
Intelligence DAX
Calendar Creating
YTD, MTD, QTD
Exercise for you
First Date and Last Date
End of month
Closing Balance
Date Add
Rates
Certificate of Completion
Upon successful completion of the course, you
will receive a personalized certificate that:
  • Confirm your skills with Power BI and the DAX language
  • Strengthen your resume in the eyes of employers and clients
  • Set you apart from other data analytics professionals
Why 7,000 people have already chosen this course
Freedom from routine
Video lessons that you can watch at your convenience and rewatch many times
Practicing experts
Experts with a wealth of practical experience who know exactly how to get you to your goal
Practical skills
No “water” - just knowledge that you will definitely need for employment or career advancement
Career prospects
We provide solid knowledge and skills that will take you to the top of your game.
Why 7,000 people have already chosen this course
Anna Data Analyst
This course turned my understanding of working with data upside down. Before the training, I spent hours on routine reports in Excel, and now I automate processes in a matter of minutes. The sections on DAX were especially useful — formulas no longer seem like magic. The instructors explain complex things in simple language, and practical assignments help you immediately apply your knowledge to your work.
Dmitry CFO
As a manager, I have been looking for a course that will give not just theory, but real tools for business analysis. Power BI is now our primary reporting solution. Thanks to the course, we reduced the time for preparing monthly reports from 3 days to 3 hours. I recommend this course to everyone who wants to make decisions based on data rather than guesses.
Ekaterina Marketer
I came with zero experience in analytics, but thanks to the structured presentation of the material, I was able to understand even complex topics. Now I visualize data on advertising campaigns and see exactly which channels are profitable. The course is worth every penny — it paid off for me in a month!
Ivan a novice BI specialist
I was looking for a course that would cover both Power BI and DAX without water. And this course is exactly what I was looking for: a lot of practice, analysis of real cases, and support from teachers. After the training, I got a promotion — now I am engaged in dashboards for the entire company. A special advantage is that you get access to the materials forever, and you can return to the lessons at any time.
Olga Business owner
As an entrepreneur, I value time and specific results. This course gave me the ability to control key business metrics without the help of outsourced analysts. Now I create sales reports myself and see the points of growth. If you want to manage your business through data, start here.
We will refund your money
if the course does not
meet your expectations
Your confidence in your choice is most important to us. If you realize during the course that the course is not right for you, we guarantee a full refund after the first three lessons. After the fourth lesson, we will offer an individual refund calculation or help you find an alternative training program.
Questions and Answers
What are the requirements for enrolling in the course?
No specialized knowledge of Power BI is required to take the course. However, a basic understanding
of working with data (e.g., Excel) and computer literacy will help you learn the material more quickly.
What software will I need for the course?
You will only need Power BI Desktop, which is a completely free version available for download
on the Microsoft website. Paid subscriptions (Pro/Premium) are not required for the training.
What topics are covered in the program?
The course covers all key aspects: from Power BI basics and data visualization to complex DAX formulas, data
modeling, and publishing reports to the cloud. You will learn how to create turnkey interactive dashboards.
Is a certificate issued upon completion of the course?
Yes, upon successful completion of the program, you will receive a personalized certificate
verifying your Power BI and DAX skills. This credential can be added to your resume or LinkedIn.
How is the training: face-to-face or online?
Training is fully online - you get access to video lectures, practical assignments and
additional materials on our educational platform. You can study at your own pace.
Is there teacher support during the course?
Yes, on supported plans you can show assignments and get feedback, ask
questions to tutors and discuss difficult issues in chat with other students.