Why take this course
If you already create reports in Power BI and want to take your skills to the next level, this training will help you build visualizations that go beyond standard reporting techniques.
You will gain advanced skills in data preparation, modeling, and visualization, enabling you to independently create sophisticated reports using DAX and advanced Power BI capabilities.
What you'll learn
- Prepare, model, and visualize data using advanced Power BI features.
- Create visually rich reports that go beyond standard reporting templates.
- Independently build complex reports using DAX.
- Establish a strong foundation for further self-development and advanced Power BI learning.
Certification & Exam
Upon completion of the training, participants receive a personalized certificate confirming their intermediate-level Microsoft Power BI skills.
There is no final exam. Active participation during the training is sufficient for successful completion.
Who is this course for
This course is designed for professionals who work with data analysis and reporting, already have basic experience with Power BI, and want to expand their skills to an intermediate level.
Topics covered
- Introduction – How to Create Professional Reports
- Principles of human perception
- How psychology helps create better reports
- The storytelling concept in business reporting
- Power Query
- Grouping, references, and duplicates
- Creating custom columns
- Merging and grouping queries
- Advanced Data Visualization
- Small multiples and decomposition trees
- Drill-through, tooltips, and labels
- Bookmarks for page organization
- Advanced templates and report backgrounds
- DAX Time Intelligence Functions
- The most commonly used DAX time-related expressions
- Practical aspects and usage nuances
- Time intervals, calendar periods, and point-in-time analysis
- DAX for Tables and Columns
- Common table operations in DAX
- Using virtual tables
- Working with disconnected tables
- Using DAX within measures
- Advanced DAX Scenarios
- Common business problems solved with DAX
- Measures used as filters
- Power BI Service Administration
- Datasets: refresh management and scheduling
- Creating applications in Power BI Service
- Row-Level Security (RLS) and role assignment management
