Cart 0

Introduction to Power BI Training

Course 1360
3 DAY COURSE
Price:
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

Course Dates
Attendance Method
Additional Details (optional)