Power BI Desktop Essentials - 1 Day course

Prerequisites

Participants should have at least Intermediate Excel and database user skills. They need:
An understanding of basic data concepts
Ability to create and format chart outputs
Ability to create formulas using standard aggregate functions

Learning Objectives

Participants will learn: Power BI Desktop concepts and main features Data sources compatible with Power BI Desktop Connecting to data with Power BI Desktop Exploring data visualisations Creating new columns using DAX formula Creating and publishing reports

Getting Started with Power BI

An Introduction to Power BI Working with Power BI Desktop Files Connecting to Data Sources with Power BI Desktop Creating a Report with Visualisations Doing More with Visualisations

Working with Data examples

Exercise 1 - Importing data from CSV files. Exercise 2 – Using multiple datasets imported from Excel Exercise 3 – Automatically updating data from files in a Folder Exercise 4 – Un-pivoting Data using Power Query

Relational Databases and Power BI

Creating Data Tables in Power BI from Excel Creating Lookup Tables Creating and Managing Relationships between Tables Creating Visuals based on Linked Data

Introduction to Data Analysis Expressions - DAX

The concept of DAX Creating new columns Creating quick and New Measures

A Closer Look at Visualizations

Matrixes, Tables, and Charts
Maps
Cards, Gauges, and KPIs
Slicers

Introduction to the Power BI Online Services

Getting Started in Power BI Online Publishing reports to Power BI Online Web View and Phone View Creating a Dashboard and Sharing the Dashboard