Reporting and Analytics

with Power BI Desktop

Connect to hundreds of data sources,
simplify data prep, and drive ad hoc analysis

Get in Touch With Us
Reporting and

Analytics with

Power BI Desktop

Connect to hundreds of data
sources, simplify data prep,
and drive ad hoc analysis

Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis

Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis.
This course will introduce all the Power BI technologies including: Power Query, DAX, Data Modelling (Power Pivot), M. We will go through a methodology for automating all your reporting needs and how to create beautiful reports and dashboards giving you a 360-degree view of your business.
Participants will use Microsoft’s free Power BI Desktop Application which hosts all Power Bi Technologies to build a detailed reporting model from scratch. They then publish this report to the service to share insights with everyone.
Key Learning Outcomes

Upon completion, participants should be able to demonstrate each of the following outcome:-

  • Recall the Power BI Technologies and ecosystem
  • Use a framework for building a Data Model
  • Assess various data visualisation options in Power BI Desktop
  • Make sense of the DAX formula Language
  • Produce typical business reports using DAX formulas you will build on a Power BI Data Model
  • Incorporate budget data to your reporting Building budget variable analysis reports
  • Produce a complete reporting solution from scratch in a full Day Case Study Session
Course Modules Covered in the Reporting and Analytics with Power BI Desktop program
Module 1 - Overview of Power BI Desktop

Overview of Power BI Desktop

  1. Intro to the Power BI Desktop interface
  2. Review of Power BI Desktop visuals
  3. Choong the right visual
  4. Building your first report
Module 2 - Framework for Building a Data Model

Framework for Building a Data Model

  1. What is a Data Model
  2. Big picture view of your reporting needs
  3. Reviewing Step-by-step Methodology
  4. How to create relationship
  5. Secrets for optimizing your report model
  6. The importance of implementing a plan on paper first Draft your first Power BI Data Model Build Plan.
  7. Building a Data Model in Power BI Desktop
  8. Implementing your Data Model Build Plan
  9. Loading data into Power BI Desktop
  10. How to create relationships
  11. Review of Facts, dimensions and Relationships
  12. Use of implicit DAX measures
  13. Build reports in Power BI (Simple Visualizations using Implicit Measures)
Module 3 - Review of the DAX Formula Language

Review of the DAX Formula Language

  1. Why is DAX so great for Analysts
  2. How DAX Works, the Vertipaq Engine
  3. The 3 Core DAX Measures
  4. DAX functions vs Excel Functions
  5. Introduction to CALCULATE - Why it is the most important DAX Function
  6. Overview of the Filter Context
Module 4 - Time Intelligence Calculation in DAX

Time Intelligence Calculation in DAX

  1. Examples The concept of a calendar
  2. Year to Date (YTD)
  3. Same Period Last Year (SPLY)
  4. Same Period Last Month (SPLM)
Module 5 - Variance Calculations in DAX

Variance Calculations in DAX

  1. Year on Year Variance in ₦ (YoY)
  2. Year on Year Variance %age (YoY)
  3. Month on Month Variance ₦ (MoM)
  4. Month on Month Variance %ag (MoM)
  5. Other variance calculations
Module 6 - Utilizing Quick Measures

Utilizing Quick Measures

  1. Using Quick Measures
  2. Interpreting Quick Measures
  3. Modifying Quick Measures
Module 7 - Comparisons to Budget

Highlights of the Standard Library

  1. Incorporate budget data in the Data Model Compare budget to Actuals
Module 8 - Power BI Standard & Custom Visualizations

Power BI Standard & Custom Visualisations

  1. Building Standard Visualisations
  2. Techniques for deciding on a Visual
  3. Introduction to Custom Visualisations
  4. Formatting Visuals
  5. Comparative Analysis
Module 9 - Introduction to Power Query

Introduction to Power Query

  1. Review of the Power Query interface
  2. Clean-up Exercise using Power Query
  3. Appending Data from a Folder
  4. Using “M” code to correct errors in Data
Module 10 - Practice - Case Study Application

Practice - Case Study Application

  1. Reviewing your Case Studies
  2. Drawing up your Data Model paper Plans
  3. Transforming your Data with Power Query
  4. Building your Data Model
  5. Incorporating simple DAX Formulas to your Data
  6. Incorporating Quick Measures to your Reports
  7. Connecting budget information into your model
  8. Carrying our Variance Reporting and Analytics
  9. Building a Dashboard
Module 11 - Overview of Advanced Features in Power BI

Overview of Advanced Features in Power BI

  1. Inserting Bookmarks
  2. Inserting Buttons
  3. Using Q&A
  4. Telling a Story with the Scatterplot visual Using Quick measure
Module 12 - Publishing to

Publishing to

  1. Publishing to
  2. Personal vs On-Prem Gateway for data refresh
  3. Creating a Dashboard from your reports
  4. Creating Groups, Content Packs and other collaboration tools
Our Training Methodology
Program Key Highlights

48 hours of Remote Online Learning
Additional Coaching Hours
Live Hands-on Projects
Certified by International Body
Mentorship with Industry Experts
Designed for Beginners & Professionals
Get in Touch With Us Today!

This training program is suitable for anyone who intends to enter into the field of Analytics. This program is being conducted in Malaysia and can be joined by anyone, anywhere in the world remotely.
Program Fee

MYR 6800 per pax.
Funding price MYR 3700 per pax .

Funding Schemes for Companies who are claiming from their HRDF levy or from the MDEC MyWiT scheme.

Limited scholarships available for early self applying individual applicants.

Find out how you can qualify for a scholarship.

Enquire NOW on the various funding options available.

One-time fee. One year access to course materials and resources.

Please fill in the form and a Program Advisor will reach out to you. You can also reach out to us at or +60123661502
Contact us on Whatsapp for more enquiries