In this course you will learn:

  • What is Power BI and why you should be using it.
  • To import CSV and Excel files into Power BI Desktop.
  • How to use Merge Queries to fetch data from other queries.
  • How to prevent some queries from loading to the model.
  • How to create relationships between the different tables of the data model.
  • To create a dynamic list of dates using DAX.
  • All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.
  • All about using the card visual to create summary information.
  • How to use other visuals such as clustered column charts, maps, and trend graphs.
  • How to use Slicers to filter your reports.
  • How to use the Matrix visualization.
  • How to use themes to format your reports quickly and consistently.
  • About using Conditional Formatting to highlight key information.
  • How to edit the interactions between your visualizations and filter at visualization, page, and report level.
  • How to drill down from one report to another in Power BI.

Power BI is the powerful, Business Intelligence (BI) tool from Microsoft. Power BI is perfect for people with a limited technical background as it allows you to perform complex analysis in just a few clicks.

In this Power BI course, we start by looking at Power Query, and how to use this tool to organize and clean our data. If you’ve used Power Query in Excel, then you’ll find it simple moving to Power BI. We then show you how to build a Data Model and relate separate tables - this allows us to start to combine huge amounts of data. After that, we teach you all about the powerful data analysis language DAX. Finally, we look at how to present this data using the huge number of charts and graphs available.

Power BI allows anyone to create beautiful looking charts and graphs that generate business insight and fuels decision making.

Course curriculum

  • 1

    Introduction

    • Welcome and Overview

    • What is Power BI?

    • Install Power BI Desktop

    • A Tour of BI Desktop

    • Explore Commonly Used Power BI Options

    • Quiz
  • 2

    Getting and Transforming Data

    • Import Files from a Folder into Power BI Desktop

    • Get Data from Excel and Text Files

    • Reference Queries to Create Additional Lookup Tables

    • Merge Queries in Power Query

    • Prevent Queries from Loading into Power BI Desktop

    • Practise Exercise

    • Quiz
  • 3

    Data Modelling

    • Create Relationships Between tables

    • Create a Dynamic List of Dates

    • Create Additional Date Columns for Analysis

    • Sort the Month and Weekday Names Correctly

    • Mark the Table as a Date Table

    • Hide Unnecessary Fields from Report View

    • Practise Exercise

    • Quiz
  • 4

    Introduction to DAX Measures

    • Calculate the Total Revenue

    • Count the Total Rows of a Table

    • Use the CALCULATE Function

    • Calculate the Total Revenue Last Year

    • Difference Compared to Last Year

    • Practise Exercise

    • Quiz
  • 5

    Adding Visualizations to your Report

    • Show Summary Information with Cards

    • Columns Charts to Compare Values

    • Map Visual to Plot Georgraphic Data

    • Slicers to Filter your Reports

    • KPI Card to Measure Performance Against a Goal

    • Line Graps to Visualise Trend

    • Show Detail with the Matrix

    • Top N Lists with the Table Visualisation

    • Practise Exercise

    • Quiz
  • 6

    Report Design

    • Adding Text Boxes and Shapes

    • Use Themes

    • Conditional Formatting

    • Practise Exercise

    • Quiz
  • 7

    Editing Interactions and Filters

    • Edit the Interactions between your Visualisations

    • The Filter Pane to Filter at Any Level

    • Drill Through to More Detail

    • Practise Exercise

    • Quiz
  • 8

    Power BI Service

    • Publish Your Report to the Power BI Service

    • Different Ways to Share your Power BI Report

    • Practise Exercise

    • Quiz
  • 9

    Closing

    • Wrap Up
  • 10

    Demo & Exercise Files

    • Exercise Files

    • Instructor Demo Files