Logo

Power BI – Analytics and Reporting

This course is for learners who have a basic working knowledge of Power BI and wish to understand and apply most advanced features with a specific focus on the data analysis, visualisation and reporting.

i

Description

Learner Profile:

The course is for learners who want to increase their hands-on knowledge of Power BI and its advanced capabilities. Learners should have a good working knowledge of Excel. It recommended that learners have previously completed the Introduction to Power BI course or similar.

What you will get:

  • Learners will be learned to use and apply advanced custom visualisations in Power Bi.
  • Learners will understand how to analyse and visualise data using Power BI dashboards
  • Understand how to transform data of varying quality and consistency.
  • Understand how to create reports in Power BI
  • Understand how to write powerful advanced Dax calculations in Microsoft Power BI

Course Content (Modules)





Add Calculated Fields with DAX


  • Introduction to Data Analysis Expressions (DAX)
  • Calculated Columns vs. Measures
  • Row Context vs. Filter Context in Power BI
  • DAX Syntax & Operators
  • Common Power BI Functions
  • Basic Date & Time Formulas
  • Logical & Conditional Statements
  • Text, Math & Stats Functions
  • Joining Data with RELATED
  • CALCULATE, ALL & FILTER Functions
  • DAX Iterators (SUMX, AVERAGEX)
  • Time Intelligence Formulas
  • DAX & Power BI Best Practices

Design Interactive Power BI Reports


  • Intro to the Power BI Report View
  • Adding Basic Charts to Power BI Reports
  • Formatting & Filtering Options
  • Matrix Visuals
  • Slicers & Timelines
  • Cards & KPIs
  • Power BI Map Visuals (Basic, Fill, ArcGIS)
  • Treemaps, Lines, Areas & Gauges
  • Editing Report interactions
  • Adding Drillthrough Filters
  • Linking to Report Bookmarks
  • Using "What-If" Parameters
  • Managing & Viewing Roles
  • PREVIEW: Publishing to Power BI Service
  • Power BI Data Viz Best Practices

Duration

2 Days