Advanced Power BI for Business - Transform, Shape and Model Data.

Course Aims

Business Intelligence (BI) is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is a simple Excel spreadsheet, or a collection of cloud-based and onpremises hybrid data warehouses, Power BI lets you easily connect to your data sources, visualise (or discover) what’s important, and share that with anyone or everyone you want. The aim of this course is to ensure delegates are comfortable with extracting data from a variety of data sources, performing transformations on the data and creating a data model.

Course Brief

Module 1 - Connecting to Data Sources with Power BI Desktop

  • View all Connection Options
  • Connect to an Excel Workbook
  • Connect to Text/CSV Files 
  • Manage Data Sources

Module 2 - Using Data View

  • Use Data View
  • Clean Irregularly Formatted Data
  • Manage Columns
  • Sort Table Data

Module 3  - Using the Power Query Editor

  • Open the Power Query Editor
  • Use the Query Settings Pane
  • Transform and Shape Data Use Merge Queries
  • Use Append Queries
  • View the Power Query M formula language in the Advanced Editor

Module 4 - Using Model View

  • Use the Model View
  • Understand Model Relationships
  • Create and Manage Relationships
  • Create a Hierarchy
  • Lesson 4: Calculations
  • Learn DAX basics
  • Create a Table
  • Create a Calculated Column
  • Create a Measure
  • Use Quick Measures

Who is this content for?

This course is aimed at all those using Power BI for data analysis. Participants should have completed the Introduction to Power BI course prior to completing this course.

Training Method

This course is delivered online and is delivered over 2 half days.