TRAIENT Experience
HRD Corp Claimable

Data Visualisation and Reporting with Power BI

A TRAIENT training session in progress
Duration
2 Days
Modules
10
Language
English
HRD Corp
Claimable

Learning outcomes

  • Understand the role, components, and interface of Power BI for data analysis and reporting
  • Connect, clean, and transform data from various sources using Power Query Editor
  • Build relationships between tables and understand the importance of primary and foreign keys
  • Create and format basic visualisations, including charts, cards, and KPIs, to present insights effectively
  • Apply basic DAX functions to perform calculations and enhance data analysis
  • Publish, share, and present interactive Power BI reports for business decision-making

Methodology

  • Interactive lectures

  • Hands-on exercises

  • Case studies

  • Group discussions

Course outline

Day 1

Module 1: Introduction to BI and Power BI
  • What is BI and why it matters
  • Overview of Power BI ecosystem
  • Power BI end-to-end workflow
Module 2: Power BI Desktop Overview
  • Navigating the Power BI interface
  • Understand core building blocks
  • Power BI workflow in practice
Module 3: Connecting to Data
  • Data sources and connection methods
  • Loading and previewing data
  • Managing multiple tables
Module 4: Power Query Basics
  • Introduction to ETL (Extract, Transform, Load)
  • Simple data cleaning and transformations
  • Applied steps & query dependencies
Module 5: Data Modelling Basics
  • Fact vs Dimension tables
  • Types of table relationships
  • Conceptual overview of Star Schema

Day 2

Module 6: Introduction to DAX
  • Introduction to Measures
  • Concept of Calculated Columns
  • Basic aggregations
Module 7: Creating Basic Visualisations
  • Creating visuals and charts
  • Adding slicers for interactivity
  • Basic formatting options
Module 8: Interactivity and Drill Down
  • Drill-down basics
  • Drill-through basics
  • Using simple tooltips
Module 9: AI Features in Power BI
  • Q&A visual
  • Analyze & Smart Narratives
  • Key Influencers & Decomposition Tree
Module 10: Publishing, Mini Project & Wrap-Up
  • Publish to Power BI Service and sharing basics
  • Guided mini project: create a simple report
  • Recap, key takeaways, and next steps

Run this programme for your team

Message us on WhatsApp to schedule it in person or online for your organisation.

WhatsApp for more info