Desktop POWER BI – September – I1209

This listing has been expired.

Programme Aim

This 1 Day course covers the essential skills needed to begin using the Power BI Desktop to produce Visual Reports and learn how to bring data into the Power Query Editor to transform into Power BI.  This hands-on interactive course is focused on real-world techniques utilising the amazing capabilities of Power BI.  The course covers the core elements needed to get an understanding of what Microsoft Power BI can do.

What will you Learn

How to get your data into Power BI, how to link it together and how to construct a dynamic visual representation of it.

How is it Delivered

Tutor-Led online Virtual classroom.

How Long is the Course

This course is 1 day in duration.

Learning Objectives

After completing this course, you will be able to:

  • How to connect to a range of Data Sources
  • The Art of creating Data Models to base the interactive dashboards and reports
  • How to manipulate Data and run Reports

Who Should Attend

Experienced Excel users (you should be familiar with pivot tables and vlookups) who are curious about Power BI and how they could use it to visualise and present their data.


Attendees must be familiar with working with large data sets, either in Excel or other database programmes (SQL, Access etc.)

Course Outline

Module 1: Getting Started with Power BI Desktop

  • Explore the Power BI Application
  • Import Data from Excel
  • Importing Data from Online Services
  • Refresh Data from a Data Source
  • Creating the Data Model
  • Linking Tables and Data

Module 2: Manipulating Data 

  •  Organize and Format Tables
  • Creating DAX Formulas
  • Create Calculated Columns/Measures
  • Sort and Filter PowerPivot Data
  • Create and Manage Table Relationships

Module 3: Creating Simple Reports

  • Introduction to Power Apps
  • How to build a canvas app
  • How to build a model-driven app

Module 4: Using Power Query

  • Importing Data direct from the Internet
  • Removing unwanted data from the import
  • Appending data to tables or data sets
  • Shaping Data to analyse
  • Merging and Appending Queries
  • Saving and Loading Queries

Module 5: Working with Power View

  • What is Power View?
  • Using the Power View Window
  • Adding Data to a Report Page
  • Applying Filters/Slicers
  • Adding extra Report Pages

Module 6: Using Power View Features

  • Working with the Mapping Function
  • Changing Data into Charts
  • Applying a TimeLine to the data

Module 7: Using Power View Features

  • Publishing to Power BI Online
  • Creating an Online Dashboard
  • Sharing Reports Internally/Externally
  • Publishing a report to SharePoint

Scroll to Top