Power BI Desktop - intermediate
Add to LinkedIn
Certificate ID:
816435
Authentication Code:
0bfa1
Certified Person Name:
Weronika Welter
Trainer Name:
Lukasz Lubina
Duration Days:
2
Duration Hours:
14
Course Name:
Power BI Desktop - intermediate
Course Date:
21 July 2025 09:00 to 22 July 2025 17:00
Course Outline:
1. Advanced Data Loading and Transformation:
- Query Editor Exploration: Dive deeper into Power Query Editor. Connect to diverse data
sources, apply complex transformations, and clean data using the M language. - Data Fetching and Transformation: Learn advanced techniques for fetching data from
databases, files, APIs, and applying intricate transformations. - Mastering Table Joins: Understand how to combine data from multiple tables using
various join types based on common fields.
2. Data Modeling Excellence:
- Data Model Schemas: Explore data modeling concepts in-depth. Understand how tables
relate to each other, forming a coherent structure. - Creating Robust Relationships: Master the art of establishing relationships between
tables for a powerful data model. - Advanced Calculations (Calculated Columns, Measures): Dive into more advance DAX
(Data Analysis Expressions) language. Create calculated columns and measures to
enhance your data analysis.
3. Sophisticated Visualizations:
- Creating Complex Visuals: Build advanced visualizations beyond basic charts. Explore
gauges, heatmaps, and custom visuals. - Fine-Tuning Visuals: Customize visualizations by adjusting colors, labels, and formatting
for precision. - Drill-Down Techniques: Learn how to drill down into specific data points within visuals
for deeper insights. - Enhancing Reports: Add and remove chart elements like legends, titles, and annotations
to refine your reports. - AI-Driven Insights: Discover AI-powered visuals that elevate your reports’ impact.