MS Power BI

Course objectives

Learning the capabilities of Microsoft Power BI gaining the ability to create reports/dashboards from connecting to a data source to developing interactive reports and publishing them.

Benefits

• Workshop participants will learn:
  • basic concepts related to data collection, preparation, modeling and visualization
  • capabilities of the Power BI platform
• Knowledge gained during the workshop will allow to:
  • prepare visually rich reports presenting business information,
  • master the basic aspects of the Self-Service BI approach
  • prepare a strong base for further self-development of acquired knowledge

Training scope

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

Audience

All people involved in handling and analyzing data, creating reports, and automating reporting processes.