Canadian Academy of IT

Microsoft Power BI for Beginners

Learn Power BI to connect disparate data sets, transform, and provide visuals
  • Beginner
  • Online Classes
  • Total 8 hours in class
  • Microsoft Power BI for Beginners


You should have basic computing knowledge. Basic knowledge of MS Excel and SQL is helpful but not essential.

Class Details

This course will cover the aspects of self-service Business Intelligence for excel analysts. In this course, the students will be able to learn and practise the Power BI tools such as Power Query, Power Pivot, Power View. Also, you will learn about DAX for efficient processing and reporting.

Course Outline

  1. Introduction to Power BI
    • Power BI Overview
    • Introduction to PowerBI Desktop
  2. Create Reports
    • Connecting to data sources
    • Creating Tables in Power BI
    • Matrix Visualisation
    • Methods of Aggregation
    • Cards and Multi Row Cards
    • Filtering Data
  3. Graphs and Data Visualisation
    • Introduction to Visualisation
    • Creating Charts
    • Decomposition Tree
    • Creating Interactive Dashboards
  4. Query Editor
    • Introduction to Power BI Query Editor
    • Basic Transformations
    • Aggregation
  5. Power BI Service
    • Introducing Power BI Service
    • Load Data into the Power BI Service

Request for Course Dates and Booking

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

  • book a course on different dates
  • book for a group of delegates
  • book corporate training
  • book a customised training
  • book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:

Subscribe to our newsletter

Sign up for our newsletter, so you can be the first to find out the latest news and tips about our classes, as well as general updates throughout the year.