LTC Consultants logo

Mastering Power BI

Data Management and Analytics

Course Overview

Most organisations own Power BI licences; few extract real value from them. The difference is skill: modelling data properly instead of fighting it, writing DAX that means what you think it means, and designing reports people actually use to decide things. This hands-on course takes delegates from importing messy data to publishing polished, refreshable dashboards — laptops open the whole way, building a complete project across the five days.

What You Will Achieve

  • Import and transform messy data reliably with Power Query
  • Build proper data models: star schemas, relationships and date tables
  • Write DAX measures with confidence, including time intelligence
  • Design reports that communicate: visuals, interactions, performance
  • Publish, refresh and share securely through the Power BI service

Who Should Attend

Analysts, accountants, managers and reporting professionals who work with data in Excel and are ready to build proper interactive reporting — no prior Power BI experience needed.

Course Outline

  1. 01Power BI landscape: Desktop, Service and licensing
  2. 02Power Query: importing and cleaning real messy data
  3. 03Data modelling: star schemas and relationships done right
  4. 04DAX foundations: calculated columns versus measures
  5. 05Time intelligence: YTD, prior year, moving averages
  6. 06Report design: visuals, slicers and user experience
  7. 07Performance and refresh: keeping reports fast
  8. 08Publishing and sharing: workspaces, apps, security

More in Data Management and Analytics

View all →
NewData Management and Analytics

Advanced Data Analysis Techniques

Data Analysis Techniques has become a defining capability for organisations that want to compete and grow. The programme runs 5 days and treats every topic the same way: brief grounding, worked example, then delegates do it themselves. Delegates leave with a personal action plan and the confidence to make an immediate difference back at work.

Next session
24 – 28 May 2027
Venue
Lagos
Price
R23,000 / $1,245
NewData Management and Analytics

Advanced Data Management for Oil and Gas Professionals

Data Management for Oil and Gas Professionals is one of those disciplines everyone claims and few have actually been taught. Delegates spend the 5 days working real examples end to end, with the facilitator turning each exercise into transferable technique. Certificates are awarded on completion, but the real takeaway is a set of skills delegates have already practised.

Next session
3 – 7 May 2027
Venue
Dar es Salaam
Price
R24,000 / $1,295
NewData Management and Analytics

Advanced Energy Finance Analytics Markets, Instruments & Risk Management

Organisations across Africa are investing in Energy Finance Analytics Markets, Instruments & Risk Management because the returns show up quickly in performance. Over 5 focused days, delegates work through real scenarios, current good practice and practical tools under the guidance of an experienced facilitator. Participants finish the course ready to apply what they have learned from the first day back on the job.

Next session
14 – 18 Sep 2026
Venue
Lagos
Price
R22,000 / $1,190