Course Description

Microsoft Power BI is a suite of business analytics tools for presenting data from a variety of sources. It is available offline as Windows software (Power BI Desktop), as a mobile app, and online via a web interface (Power BI Online). With Power BI, you can create rich reports that display metrics in a way that is easy for users to understand and interact with.

Prerequisites

Participants must already have experience working with Excel charts.

Course Outline

Module 1: What is Power BI

• Where to Get It
• Installation

Module 2: Get Started with Power BI

• Knowing Your Way Around

Module 3: Getting Data in Power BI

Learn to join multiple data sources into one in order to combine diverse sources of information in an analytical solution.

• Getting Data from One Source
• Getting Data from Multiple Sources
• Data Transformations

Module 4: Creating and Managing Relationships in Power BI

Relationships in Power BI are used to define the connections between two or more tables and perform analysis.

• Power BI Relationships
• Creating Power BI Relationships

Module 5: Applying Data Analysis Expressions (DAX)

• Calculated columns – creating columns with filtered/sorted information
• Measures – creating fields with aggregated values, e.g. sums, percentages, averages, etc.

Module 6: Data Visualization with Power BI

Select the most relevant type of visualization for different scenarios and presentations – bubble chart, line chart, card, matrix, KPI, etc.

• Formatting of Visualizations
• Color Saturation in Charts
• Inserting Custom Visualizations
• Delivering your presentation in a focused, comprehensible and convincing manner