Microsoft Power BI Training Course

Duration : 2 Days

About the Course 

Microsoft Power BI Training Course enables Microsoft Excel users to improve the quality of their reports drastically. Microsoft Power BI is a business intelligence technology from Microsoft that gathers and processes your data, analyses and provides data driven insights that enables managers, business analysts and key decision makers to make informed decisions real time. It allows one to ask questions and get answers about their data. Users of Power BI are able to create interactive dashboards and insights by self-interacting with the technology.

Target Participants 

This course is aimed at professionals who need to analyse and visualise data utilising Microsoft Power BI.

What you will learn  

By the end of this training the participants will be able to: 

  • Connect, import, shape, and transform data for business intelligence (BI)
  • Model data with Power BI desktop
  • Custom create data visualisations and style reports for lucid data representation
  • Visualise data, author reports, and schedule automated refresh of your reports
  • Create and share dashboards based on reports in Power BI desktop
  • Share and collaborate with data with Power BI
  • Understand Power BI Data Analysis Expression(DAX), and its functions

Course Outline 

Introduction to Power BI 

  • Components of Power BI
  • Features of Power BI
  • Power BI workflow
  • Self Service ETL (Extract Transform Load)
  • Setup and Configuration of Power BI

Connecting to Data Sources

  • Excel
  • Online sources
  • SQL

Data Transformation: Data Management and Data Cleaning in Power BI (Power Query)

  • Using first rows as headers
  • Rename fields & replacing data values in cells, rows
  • Changing data types & change order of columns
  • Un-pivoting columns
  • Grouping and splitting column into multiple
  • extract feature (before /after delimiter)
  • Adding new columns
  • Filters and parameters
  • View native queries vs unfold queries


  • Table relationship (one to one, one to many, many to many)
  • Data Analysis Expression (DAX)
  • Measures and calculated Columns
  • Mastering DAX using quick measures

Visualization and Charts (Power View)

  • Stacked bar chart and stacked column chart
  • Clustered bar chart and clustered column chart
  • Line chart & area chart
  • Line and clustered column chart
  • Line and stacked column chart
  • Ribbon & waterfall chart
  • Funnel & tree map visuals
  • Pie-chart and doughnut chart
  • Table chart and matrix chart
  • Slicer, gauge, card visuals
  • Map and filled map
  • ArcGIS maps for Power BI
  • KPI
  • Q & A visual
  • Fine tune your visualisation using parameters and slicers
  • Deciding on when to use a particular visual

Building and Sharing a Dashboard

  • Workspace
  • Datasets
  • Reports
  • Create Dashboard
  • Modify and update Dashboard
  • Share your Dashboard
  • Power Q&A and Insights

Data Security in Power BI

  • Configuring row level security
  • Setting up user roles

Configuring Data Refresh

  • Types of data refresh (Package Refresh, Model/Data refresh, Tile Refresh, Visual/Container Refresh)
  • Understand & configure data management gateways
  • Configuring & scheduling data refresh

Power BI for Mobile

  • Configuring Power BI for Mobile
  • Visualise dashboards and report on Power BI Mobile
  • Commenting on eports and dashboards in Power BI Mobile

Excel Power BI

  • Power Query and Power Pivot on Excel
  • Visualise and Edit Power BI reports using excel analyser
  • Building reports on Excel and Publishing to Power BI service

Training Course Approach

This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.

Training Course manuals and additional reference materials are provided to the participants.


Upon successful completion of this course, participants will be issued with a certificate.

Tailor-Made Course

We can also do this as a tailor-made course to meet organisation-wide needs.

Contact us to find out more or to enrol for the course:

    Advanced Statistical Analysis Using SPSS Training Course

    SPSS Data Analysis Training Course

    Microsoft Excel Data Analysis Training Course

    6th Floor Batanai Gardens
    57 Jason Moyo Avenue,
    Harare, Harare 263
    Phone: 0719397464