MS Power BI

Why take this course

If you work with data processing and analysis, this training will provide you with a comprehensive introduction to all phases of creating a modern report in Power BI. You’ll gain the essential skills for data visualization, performing basic operations, and effectively preparing business reports.

What you’ll learn

• Prepare reports that present business information.
• Understand the principles of data transformation.
• Learn the basic formulas of the DAX language.
• Gain a solid foundation for further self-development in data analysis.

Who is this course for

This course is intended for anyone involved in data processing and analysis, creating reports, and automating reporting-related processes.

Topics covered

1. Introduction to Power BI

• General overview
• Purspose and usage of Power BI Desktop and Power BI Services
• Key elements and structure of Power BI desktop as an authoring tool
• Concept of Relations between tables – Star Schema/ Fact & Dimensions

2. Data Sourcing and Modeling in Power Query

• Key functions and operations with Power Query
• Data ingestion and Transformation
• Formatting, Creating and Combining
• Data Model creation

3. Data visualization

• Visualization types
• Filters and Slicers
• Visualization Formatting
• Conditional formatting
• Themes and custom visuals

4. DAX language

• Calculating Measures
• Creating Calculations for Visualization
• Calculated Tables and Columns
• Time Intelligence
• Most popular DAX expressions in action

5. Data storytelling – how to create a good report

• Report Navigation / Descriptions/ Good practices
• From general to specific
• Drill-down / Drill-through
• Relationships between visualizations

6. Publishing and sharing report

• Overview of Power BI services
• Publishing and sharing report or dataset
• Editing / Reworking / Saving a published report
• Creating a dashboard