Power BI Training

Decision Intelligence with Power BI

From zero to decision-ready dashboards

A complete, hands-on program that follows the real workflow of a report builder: from installing Power BI Desktop to publishing and sharing a finished report. By the end, you can take a raw business dataset and deliver an executive-ready report on your own.

Who it's for

Designed for professionals who report on business performance

Finance, accounting & FP&A teams

Spend less time consolidating data and more time analyzing performance, with reliable, automated reporting.

Reporting & MIS professionals

Replace repetitive manual reporting with automated, refreshable reports that stakeholders trust.

Analysts

Turn large, scattered datasets into clear insights faster, using a structured and repeatable approach.

Managers & team leads

Gain timely visibility into team performance and make confident, data-driven decisions.

Supply chain & planning professionals

Bring demand, inventory and supply data together to plan ahead and respond to change faster.

What you'll learn

By the end of the program, you will be able to

  • Connect to multiple data sources and transform raw data into clean, reporting-ready tables
  • Design star-schema semantic models that deliver consistent, reusable and scalable reporting
  • Write DAX measures for KPIs, time intelligence and business calculations, following proven best practices
  • Build interactive dashboards that highlight trends, drivers and exceptions for faster decision-making
  • Use AI assistants and Power BI's AI features to accelerate development and uncover insights faster
  • Publish, secure and share reports in the Power BI Service, with scheduled refresh, row-level security and optimized performance
Course outline

10 modules, one complete workflow

Each module builds on the one before it. Select a module to view its topics.

Download the full outline (PDF)
01Introduction to Business Intelligence & Power BI
  • BI concepts and the self-service BI workflow
  • Power BI Desktop, Service and Mobile, and the licensing options
  • A guided tour of Power BI Desktop and its views
  • The end-to-end workflow: get data, transform, model, visualize, publish, share
02Getting & Transforming Data with Power Query
  • Connect to Excel, CSV, folders, SharePoint, SQL Server and the web
  • Import, DirectQuery and Live Connection modes
  • Clean, profile and reshape data: unpivot, group by, conditional columns
  • Combine data with Merge and Append, and use parameters
  • Read M code and build custom columns
03Data Modelling and Semantic Models
  • Fact and dimension tables, and why a star schema is preferred
  • Relationships: cardinality, filter direction, active and inactive
  • Build and mark a proper Date table
  • Hierarchies, display folders, field parameters and the TMDL view
04Data Analysis with DAX
  • Calculated columns, measures and calculated tables
  • Evaluation context: row context, filter context and context transition
  • CALCULATE, filter modifiers, iterators and variables
  • Time intelligence: year-to-date, prior year and period comparisons
  • The DAX query view and visual calculations
05Building Interactive Dashboards
  • Core visuals, slicers and the Filters pane
  • Drill-down, drill-through and report page tooltips
  • Bookmarks, buttons and page navigation for guided experiences
  • Conditional formatting and the Analytics pane
06Data Visualization Best Practices
  • Choosing the right visual for comparison, trend, composition and distribution
  • Page layout with clear hierarchy: KPIs first, context second, detail last
  • Using color deliberately, including accessible and color-blind safe palettes
  • Executive KPI pages, data storytelling and reusable report themes
07Working Smarter with AI Assistants (ChatGPT, Claude etc.)
  • Use AI as a reporting partner: explain data, suggest layouts and draft management commentary
  • Get help writing, explaining and fixing DAX and Power Query in plain business language
  • Speed up documentation: measure descriptions, clear names and report explanations
  • See how Claude Code and MCP connect AI directly to Power BI to help build and update reports
  • Write clear prompts, check AI answers and use AI responsibly with company data
08AI Features in Power BI
  • Key Influencers, Decomposition Tree and Smart Narrative
  • Anomaly detection
  • The Analyze feature: explain increases and decreases, and find where distributions differ
09Power BI Service, Security & Report Sharing
  • Publish reports and work with workspaces and workspace roles
  • Share with links, direct access and apps
  • Row-level security: define, assign and test roles
  • Data gateways and scheduled refresh
  • Mobile app, subscriptions, alerts and exporting to PowerPoint, PDF and Excel
10Performance Optimization & Best Practices
  • Find slow visuals with Performance Analyzer
  • Reduce model size and understand how Power BI stores data
  • Write efficient DAX and keep Power Query fast with query folding
  • Document models with descriptions, display folders and naming standards
How it's delivered

Learn by doing, not just by watching

Guided demonstrations

Every topic is shown step by step in Power BI Desktop before you try it.

Hands-on exercises

Practice each module on sample business datasets designed for training, with practice files to keep.

Business capstone project

Finish by building a complete executive report from a raw dataset.

Session recordings

Online participants can watch the session recordings online for 6 months after the program ends (view only, no downloads).

Led by experienced BI trainers

Trainers who deliver real BI projects for businesses and bring that practical experience to every session.

Before you join

  • No prior Power BI knowledge is needed
  • A Windows laptop with Power BI Desktop installed (it's free; we'll share setup steps before the training)
Upcoming dates

Join the next public batch

After you enroll, we share the detailed program brochure, including the schedule and course fee. Seats are confirmed once enrollment is completed.

Training a team? Explore corporate training.

FAQ

Common questions

How do I enroll?

Select an upcoming batch and click Enroll now, or contact us. We will share the detailed program brochure, including the schedule and course fee. Your seat is confirmed once your enrollment is completed.

Do I need any experience with Power BI?

No. The program starts from the basics and builds up step by step, so complete beginners can follow along.

Can you deliver this training for our team?

Yes. We deliver this program as a customized in-house training, online or at your office, with the topics and depth aligned to your team's skill level.

How are the 21 hours scheduled?

The hours are split into sessions to suit the group, for example over several days or across a few weeks. Contact us for the current scheduling options.

Do I need a paid Power BI license?

Not to learn. Power BI Desktop is free. Publishing and sharing in the Power BI Service needs a work account, and we cover the licensing options in Module 1.

Is the course on a Mac?

Power BI Desktop runs on Windows only. Mac users can join using a Windows virtual machine or a cloud PC; contact us for setup assistance.

Ready to build decision-ready dashboards?

Contact us to enroll in the next batch or to arrange this program for your team.