Reporting and Analytics with Power BI - dbrownconsulting
Reporting and Analytics with Power BI

Reporting and Analytics with Power BI

Reporting and Analytics with Power BI

CPD 24 units | 24 PL credits
Online Prework + 3 Days Classroom or 6 Virtual Sessions or Online Self-Paced




dbrownconsulting focuses on helping organizations and individuals achieve more with their data. We partner with CFA Society Nigeria to deliver world-class learning and professional development solutions to its members and candidates in Nigeria. We are also an accredited training provider of the Financial Modeling Institute based in Canada, Microsoft partners, a member of CPD UK.


Earn 24 CPD Credits for this course

Online Prework + 3 Days Classroom or 6 Virtual Sessions or Online Self-PacedEnroll NOW

Overview of Power BI Desktop

  • Intro to the Power BI Desktop interface
  • Review of Power BI Desktop visuals
  • Choosing the right visual
  • Building your first report

Framework for Building a Data Model

  • What is a Data Mode
  • Big picture view of your reporting needs
  • Why you need FACT files and DIMENSION files

Overview of Advanced Features in Power BI

  • Inserting Bookmarks
  • Telling a Story with the Scatterplot visual Using Quick measure
  • Inserting Buttons

Building a Data Model in Power BI Desktop

  • Implementing your Data Model Build plan
  • Loading data into Power BI Desktop
  • How to create relationships

Review of the DAX Formula Language

  • Why is DAX so great for Analysts
  • How DAX Works, the Vertipaq Engine
  • Introduction to CALCULATE – Why it is the most important DAX Function

Time Intelligence Calculation in DAX

  • Examples The concept of a calenda
  • Same Period Last Year (SPLY)
  • Same Period Last Month (SPLM)

Introduction to Power Query

  • Clean-up Exercise using Power Query
  • Using “M” code to correct errors in Data