Description

Course Overview

This course will give you all the skills you need to jump-start your Power BI journey. It discusses in depth the industry-recognised steps from raw data to detailed analysis via five main stages:
• Loading data into Power BI from a wide range of data sources, such as CSV and XLS files
• Transforming data using Data Analysis Expressions (DAX), M, and Power Query languages
• Creating and extending a comprehensive data model with DAX
• Visualizing data in Power BI desktop using built-in tools
• Sharing and collaborating with the Power BI service or Power BI server

Introduction to Power BI Training Delivery Methods
• In-Person

Course objectives
In this course, you will:

• Create interactive visualizations to deliver business insights.
• Extract business intelligence by using DAX, M, and Power Query.
• Share Datasets, Reports, and Dashboards in the Power BI Service.
• Pre-format and import data from an Excel Report using Power Query and M.
• Add value with measures, calculated columns, and calculated tables using DAX.
• Import data from relational databases and integrate it with other data sources.
• Profile, shape, and filter tables to prepare for analyses by fixing data issues.
• Integrate data from CSV files and Excel Workbooks.
• Explore and extend a Power BI data model.

Training Prerequisites
• None.

Introduction to Microsoft Power BI Training Course Outline
Module 1: Power BI Overview
• Visual analysis and visual analytics
• Power BI Infrastructure
• Loading Data
• Introduction to Power BI Desktop
Hands-On Exercise 1.1 Loading and Visualizing data
Module 2: Transforming Data
• Using Power Query to clean, transform and load data
• Profiling your data
• Resolve data quality issues
• Apply user-friendly names to Queries, tables, and columns
• Import data from an Excel formatted report
Hands-On Exercise 2.1 Transforming Data with Power Query
Hands-On Exercise 2.2 Appending, Merging, and Combining Queries

Module 3: Creating a Data Model
• Understand the role of the Data Model in Power BI
• Create table relationships
• Understand Cardinality and Cross Filtering
• Discuss Star and Snowflake schema
• Create a Date Dimension
• Build a Data Model from multiple Data sources
Hands-On Exercise 3.1 Creating a Data Model
Module 4: Visualising your Data
• Discuss Report settings
• Choosing the right visualizations
• Creating, formatting, and styling your reports
• Using Hierarchies and Drilldown
• Utilizing Slicers and Filters
• Adding Custom Visualizations
Hands-On Exercise 4.1 Creating Reports Part 1
Hands-On Exercise 4.2 Creating Reports Part 2
Hands-On Exercise 4.3 Creating Reports Part 3

Module 5: Introduction to DAX, Calculated Columns and Measures
• Gain an Introduction to DAX
• Differentiate between Calculated Columns and Measures
• Create Calculated Columns
• Create Measures
• Understand Filter and Row context
• Understand the power of the Calculate function
Hands-on Exercise 5.1 Introduction to DAX
Optional Hands-on Exercise 5.2 Intermediate Level DAX
Module 6: Collaboration and Sharing (Publishing Reports and Creating Dashboards)
• Discuss the Power BI Service and Power BI Server
• Understand the main components of the Power BI Service
• Publish a Power BI Project to the Power BI Service
• Share Reports
• Build and Share Dashboards
Hands-On Exercise 6.1 Collaboration and Sharing in the Power BI Service