COURSE INFORMATION

This course is aimed at Business Analysts who want to examine large amounts of related data and produce reports summarising the data.

Overview of Power BI Desktop

  • What is Power BI, Power Query and Power Pivot?
  • The Power BI Service
  • Power BI Report Server
  • Power BI Desktop
  • Understanding Dashboards, Reports and Datasets
  • Creating, editing & saving PBIX files

Importing Data into Power BI Desktop 

  • Connecting to CSV Files, Excel Data
  • Other data sources
  • What are Table Relationships?
  • Creating Relationships
  • Cardinality
  • Working with a Date Table

Transforming and Combining Data

  • The Query Editor within Power BI
  • Applied Steps
  • Shaping Data
  • Formatting Data
  • Transforming Data
  • Combining Data
  • Merging Data

Visualising Data

  • Overview of Visualisations
  • Choosing the right visual
  • Changing visuals
  • Sorting and formatting
  • Drilling down and filtering
  • Slicers

Modelling Data 

  • What is DAX?
  • DAX Syntax
  • DAX Aggregate Functions
  • CALCULATE Function
  • Creating Measures
  • Debugging DAX Functions

Reports and Output Options 

  • Report Elements and Options
  • Working with Pages
  • Refresh Data
  • Add Graphics and Text
  • Filter settings
  • Display for Mobile view
  • Performance – small files and fast calculations
  • Options for Sharing your data
  • An understanding of Relational Database theory, Data modelling, Excel Tables, Excel Function based formula, and Excel Pivots & Charting are beneficial to this course.
  • £495
  • Intermediate Power BI Desktop