Audience
This 2-day course is intended for anyone who is new to designing and implementing self-service Business Intelligence (BI) solutions using Microsoft Power BI Desktop and the Power BI Service. It is ideal for anyone who needs to quickly get up to speed with analysing and reporting on data in Power BI.
Prerequisites
There are no specific technical prerequisites for this course, but a familiarity with Excel may prove beneficial. The main consideration is to have a basic understanding of your business needs to collect, cleanse, and analyse data, in order to be able to visualise and gain insights into that data.
Duration
2 days. Hands on.
Course Objectives
Upon successful completion of this course, students will be able to:
- Understand Key Components of Power BI
- Load Data From Commonly Used Sources
- Shape and Transform Datasets
- Merge and Append Data
- Parameterise Queries
- Implement a Data Model
- Create and Manage Relationships
- Gain an Understanding of DAX
- Implement Calculated Columns
- Implement Measures
- Implement Time Intelligence
- Create Reports with Text-Based Visuals
- Implement Conditional Formatting
- Create and Implement Charts
- Implement Gauges and KPIs
- Implement Maps
- Implement Slicers
- Understand the Power BI Web Service
- Manage Content in Workspaces
- Publish Reports and Create Dashboards
Course Content
Part 1: Introduction and Power Query
1. Introducing Power BI
Introducing Power BI Products and Services
Introducing Power BI Desktop
2. Loading Data
Load Data from Text Files
Load Data from Excel Files
Load Data from OneDrive and SharePoint
Review Other Supported Data Sources
3. Transforming Data
Cleanse Data
Shape Datasets
Transform Datasets
Merge and Append Data
Power Query Parameters
Power BI Template Files
Part 2: Data Modelling and DAX
4. Data Modelling
Data Modelling Concepts
Configure Table and Column Properties
Categorise Data
Sorting Columns
Create and Manage Relationships
Understand Filter Propagation
5. The DAX Expression Language
Introducing DAX
Create Calculated Columns
Add Measures to the Data Model
Implicit v Explicit Measures
Quick Measures
Manipulate the Filter Context with CALCULATE
Analyse Data over Time (Time Intelligence)
Part 3: Reports and Visuals
6. Visualising Data
Implement and Format Table and Matrix Visuals
Rename Fields in Visuals
Show Items with no Data
Conditionally Format Visual Content
Use Card Visuals
Implement and Format Charts
Use Tooltips
Implement and Use Hierarchies
Group and Bin Data
Automatically Find Clusters of Data
Animate Scatter Charts
Gauges and KPIs
Implement Maps
Implement Slicers
Cross-Filtering and Cross-Highlighting
Implement Bookmarks
Implement Buttons
Text Boxes, Shapes, and Images
Control the Display of Content
Part 4: Publishing Reports
7. The Power BI Web Service
Introducing the Power BI Web Service
Publish Reports to the Power BI Web Service
Manage and Organise Content in Workspaces
Create and Manage Dashboards
Dashboard Themes