Microsoft Power BI is a data analytics and visualisation tool that is robust enough for the most demanding data scientists yet user-friendly enough for anyone who wants to get more out of data on a regular basis.

This condensed overview of Power BI covers all of the essential capabilities and components required to advance with data and visualizations from “zero to hero.”

If you regularly work with data in Microsoft Excel, this course will show you how to become proficient with Power BI and use it as a regular tool for data analysis and reporting.

Course Level: Basic to Intermediate

You will learn the following:

Module 1: Intro to Power BI

  • What is Power BI
  • How did we get to Power BI?
    • SQL Server: Microsoft Relational Database
    • SQL Server Analysis Services Multidimensional: One small step to BI
    • SQL Server Reporting Services
    • Excel
    • Power Pivot
  • Power BI Desktop Under the Hood
    • VertiPaq: The storage engine
    • DAX: The formula engine
  • What makes Power BI different from its competitors

Module 2: The Report and Data Views

  • Report View
    • Home section
    • Insert tab
    • Modeling tab
    • View tab
    • Help section
  • Pane interface of Report View
  • Data View

Module 3: Importing and Modeling Data

  • Getting Data
  • Power Query Ribbon
  • Model View
    • Relationships
    • Properties

Module 4: Visualizing Data

  • Why visualize?
  • Visualization Pane
  • Visual interactivity
  • Column and Bar charts
  • Line and Area charts
  • Donuts, Dots, and Maps
    • Funnel
    • Scatter
    • Pie and Donut
    • Treemap
    • Map visual
  • Flat visual
    • Gauge
    • Card/Multi-row card
    • KPI
    • Table/Matrix
    • Slicer

Module 5: Aggregations, Measures and DAX

  • DAX intro
    • Measures
    • Calculated columns
    • Calculated tables
    • Types of functions
  • Aggregations (more than just SUMs)
    • Sum
    • Average
    • Min and Max
    • Standard deviation, Variance, Median
    • Count and Count (distinct)
    • First, last, earliest, latest
  • Measures and DAX fundamentals
    • Implicit and explicit measures
    • DAX syntax fundamentals
    • Row and Filter context

Module 6: From Row Data to Report

  • Your first data import
  • Data wrangling
  • Building relationships
  • Reporting

Module 7: Advanced Reporting Topics

  • AI powered visuals
    • Key influencers
    • Decomposition tree
    • Q&A
    • Smart narrative
  • What-If analysis
    • Parameter setup
    • DAX integration of the parameter
    • Parameter modification
  • R and Python integration
    • Limitation of using R and Python
    • Enabling R and Python for Power BI
    • R and Python in Power Query
    • R and Python visuals

Module 8: Introduction to Power BI Service

  • Basics
  • Navigation menu
  • Publishing your work
  • What is a workspace?
    • My Workspace
    • Shared capacity workspace
    • Dataflows in Shared workspaces
  • Putting your data infront of others
    • Adding users to workspaces
    • Sharing via a link or Teams
    • Sharing via SharePoint
    • Creating an App

Module 9: Licensing and Deployment

  • Licensing
    • Pro licensing
    • Premier per user licensing
    • Premier per capacity
  • Workspace and App management
    • Workspace generation and access control
    • Managing users in a workspace
    • Adding users to Roles for RLS implementation
    • App creation and management

Module 10: Third Party Tools

  • Get to know Business Ops
  • DAX Studio
  • Tabular Editor
  • The ALM Toolkit for Power BI
  • Bravo
    • Analyze model
    • DAX formatting
    • Manage Dates
    • Export Data