Introduction to Power BI Training
Course Outline
This Introduction to Power BI Training will give you all the skills you need to jump-start your Power BI journey. It discusses in depth the industry-recognized 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 Benefits
-
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
Chapter 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
Chapter 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
Chapter 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
Chapter 4: Visualizing 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
Chapter 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
Chapter 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
- choosing a selection results in a full page refresh