<< Return to Calendar

Power BI: Data Analysis & Reporting

Overview

This practical 2‑day Power BI programme equips delegates with the skills to transform raw data into meaningful, interactive insights. Through hands‑on exercises, real‑world datasets, and guided instruction, participants learn how to import, clean, model, analyse, and visualise data effectively using Microsoft Power BI.
The course bridges foundational understanding with intermediate analytical skills—empowering attendees to design dynamic dashboards, apply DAX for enhanced insights, and publish reports to support data‑driven decision‑making across the organisation. 

Why Should an Individual Attend?

  • Create professional, interactive dashboards: Gain the skills to design compelling, user‑friendly visual reports that enable clear insights for stakeholders.
  • Improve data quality and reliability: Learn to clean, shape, and transform data to ensure accuracy and consistency for reporting.
  • Strengthen analytical capabilities: Develop confidence in using DAX formulas, calculated columns, and measures to extract deeper insights.
  • Support organisational decision‑making: Empower teams by producing reports that reveal trends, highlight performance, and guide strategy.
  • Enhance efficiency through automation: Automate report refreshes and streamline processes by publishing reports to the Power BI service. 

Outcomes

On completion of this course, the delegate will be able to:

  • Understand the Power BI ecosystem, including Desktop, Service, and Mobile apps.
  • Import data from multiple sources and perform data cleaning, shaping, and transformation using Power Query.
  • Build efficient, well‑structured data models and manage relationships between tables.
  • Create calculated columns and measures using DAX, and understand filter context and time intelligence.
  • Design visually appealing dashboards using charts, slicers, filters, images, and formatting techniques.
  • Publish, share, and manage reports securely via the Power BI Service. 

Program Outline

Day 1
Module 1: Introduction to Power BI

  • What is Power BI
  • Understanding the Power BI architecture
  • Installing Power BI Desktop
  • Signing up for the Power BI Service
  • Power BI licensing overview

Module 2: Importing Data Using Power BI

  • Loading data from files and databases
  • Removing unwanted rows and columns
  • Transforming data
  • Cleansing and shaping data
  • Using functions and parameters
  • DirectQuery vs Live Query
  • Power Query best practice

Module 3: Building the Data Model

  • Building relationships
  • Working with complex relationships
  • Usability enhancements
  • Data model performance considerations

Day 2
Module 4: Enriching Your Data Model with DAX

  • Creating calculated columns and measures
  • Understanding filter context
  • Time intelligence functions
  • Role‑playing tables
  • DAX best practice

Module 5: Visualising Data

  • Chart types
  • Formatting charts
  • Reports, pages, visual filters, and slicers
  • Designing interactive reports
  • Enhancing reports with text boxes, annotation shapes, and images 

Who Should Attend?

  • Business Analysts seeking to deepen reporting capabilities
  • Managers and Executives who rely on data‑driven insights
  • Data Enthusiasts beginning their BI journey
  • IT Professionals supporting BI systems
  • Small Business Owners leveraging data for competitive advantage 
  • Engineers, Technologists, Technicians
  • Project Managers
  • Senior Managers
Validation Number/s:
Coordinator: Blessings Banda
Fee:
Schedules:

No upcoming schedules were found for this course.