Power BI DAX Course
Measures, filter context, CALCULATE, time intelligence and iterators - the calculation layer of Power BI.
View course →
Microsoft Power BI training
Power BI Course
Build interactive, shareable reports end to end: connect to data, clean it, model it, write DAX measures and publish dashboards in Power BI Service.
- Hands-on, project-based
- Trainer feedback on every module
- Free counselling & demo on request
- Format
- Live, instructor-led
- Duration
- Shared at counselling
- Fees
- Shared on enquiry
- Level
- Beginner to advanced
Power BI course overview
Power BI is Microsoft’s business intelligence tool for turning data from many sources into interactive reports. Unlike a static spreadsheet, a Power BI report is driven by a data model: tables connected by relationships, with measures that recalculate as a user filters.
This course teaches that model-first way of working. You learn Power Query for preparation, star-schema modeling, DAX for calculations, visual design for clarity and Power BI Service for sharing. Learners with strong Excel skills move fastest, so if you are not there yet the Excel course is a good first step.
Who this course is for
- Excel users who have outgrown spreadsheets
- Aspiring data and business analysts
- Finance, sales, HR and operations professionals who report to leadership
- Students and graduates adding a hireable BI skill
Prerequisites
- Comfort with Excel tables, formulas and pivot tables
- A Windows PC (Power BI Desktop is Windows-only; tell us if you use a Mac)
- No coding experience needed
What is Power BI?
Power BI has three parts you will use: Power BI Desktop (where you build), the Power BI Service (where you publish and share) and mobile apps (where people view). Most of the learning is in Desktop - data, model, measures, visuals - and that is where the course spends most of its time.
Key skills in the Power BI course
Power Query
Connect, clean and shape data from Excel, CSV, folders and databases using the same editor as Excel. Learn more.
Data modeling and relationships
Fact and dimension tables, one-to-many relationships and filter direction. Learn more.
DAX measures and calculated columns
CALCULATE, FILTER, time intelligence, and when to use a measure vs a column. Learn more.
Visualisation and interactive dashboards
Choose visuals, set up slicers, drill-through and tooltips. Learn more.
Power BI Service
Publish reports, schedule refresh, create workspaces and apply row-level security basics.
Reporting for decisions
Structure pages around questions, not charts.
What you will learn
- Connect to and prepare data in Power Query
- Design a star-schema model with correct relationships
- Write core DAX measures including time intelligence
- Build clear, interactive report pages
- Publish to Power BI Service and manage refresh
- Follow performance and design best practices
- Present findings in a short business walkthrough
Tools covered
- Power BI Desktop
- Power BI Service
- Power Query
- DAX
- Excel
- CSV / folder sources
Practical projects
Sales performance dashboard. Revenue, margin and target tracking by region and product.
Finance KPI report. P&L view with budget vs actual and variance measures.
HR analytics report. Headcount and attrition with drill-through to employee lists.
Detailed curriculum
The program is taught module by module. Each module ends with a hands-on exercise built on business-style data.
Module 1Power BI fundamentals
- Desktop, Service and the report workflow
- Importing data, first visuals
Module 2Power Query
- Cleaning, types, merges, appends
- Query folding and staging ideas
Module 3Data modeling
- Star schema, relationships, cardinality
- Date tables and role-playing dimensions
Module 4DAX fundamentals
- Measures vs calculated columns
- Row and filter context
- CALCULATE, FILTER, ALL, RELATED
Module 5Time intelligence
- YTD, MTD, same period last year
- Rolling averages
Module 6Visualisation
- Chart choice, formatting, accessibility
- Slicers, bookmarks, drill-through, tooltips
Module 7Power BI Service
- Publishing, workspaces, refresh
- Sharing and security basics
Module 8Capstone project
- Build, publish and present an end-to-end report
Learning methodology
Every concept is taught on a working file. You see the business question first - for example, "which regions missed target last quarter?" - and then build the formula, query or measure that answers it.
Each module closes with an exercise you complete yourself, followed by trainer feedback. Mistakes are part of the process: we cover the errors people actually hit, such as text-formatted numbers, broken lookups and wrong relationship direction.
Training files and practice datasets are provided so you can repeat every exercise after class.
Training format, batches and certification
Format. Instructor-led, practical sessions. Online, classroom and hybrid options are confirmed when you speak to us.
Batches. Upcoming batch dates are shared during counselling so you get current information. Ask for weekday, weekend or fast-track availability.
Certification. You receive a CharterPeak course completion certificate on completing the program and its assessments. This is not a Microsoft certification. If you want to prepare for a Microsoft exam such as PL-300, tell us and we will map the syllabus to the official skills outline.
Your trainers
Trainer names, backgrounds and areas taught are listed on our trainers page. Ask for a short demo class or a call with the trainer before you enrol.
Sample project: sales dashboard walkthrough
We start from three Excel exports (sales, products, customers), clean them in Power Query, build a star schema with a date table, write measures for Revenue, Margin % and Revenue vs Target, and finish with a two-page report: an executive summary and a regional drill-down. You publish it to the Service and set up the refresh.
Career applications
- Power BI developer / report developer
- Business intelligence and data analyst roles
- Finance, sales and operations reporting
- See Power BI career paths and how Power BI jobs are described
Continue your learning path
- Master calculations with the Power BI DAX course
- Strengthen models in Power BI data modeling
- Design better reports in Power BI dashboards
- Put it all together in the Excel + Power BI + Data Analytics program
Frequently asked questions
Is Power BI suitable for beginners?
Yes, if you are comfortable with data in tables. The course starts with importing data and simple visuals before modeling and DAX.
Is Power BI free?
Power BI Desktop is free to download. Publishing and sharing in Power BI Service needs a licence; your trainer will explain the options for learning and for work.
Do you prepare for Microsoft PL-300?
The syllabus covers most skills in the official PL-300 outline, but the course completion certificate is separate from Microsoft’s exam. Ask us if you want exam-focused practice.
Do I need Excel first?
Basic Excel is required. If you do not have it, begin with the Excel course or join the combined program.
Does it run on a Mac?
Power BI Desktop is Windows-only. Mac users can use a Windows virtual machine or a Windows PC; ask us for options before enrolling.
What is the duration of the Power BI Course?
Duration depends on the batch (weekday, weekend or fast-track). We confirm the schedule and total hours when you speak to us, so you get current information rather than a fixed number on a web page.
Who can join the Power BI Course?
Students, graduates, working professionals and career changers. The prerequisites are listed on this page; if you are unsure, book a free counselling call and we will point you to the right starting course.
Is the training practical?
Yes. Each module is taught on working files with exercises you complete yourself, followed by trainer feedback and project work.
Is the training online or in a classroom?
Delivery options depend on the batch. Ask about current online, offline and hybrid availability when you enquire.
Is certification provided?
You receive a CharterPeak completion certificate after finishing the program and its assessments. It is not a Microsoft certification and we do not promise exam results.
What fees and payment options apply?
Fees depend on the batch and format and are shared on enquiry. See our refund policy before you enrol.
Related courses
Power BI Dashboard Course
Design KPI, sales, finance, HR, marketing and operations dashboards that people actually use.
View course →Power BI Data Modeling Course
Star schema, fact and dimension tables, relationships and performance - the foundation of reliable Power BI reports.
View course →Power BI Data Analytics Course
Project-driven analytics in Power BI: question, data, model, analysis and a stakeholder-ready story.
View course →Excel + Power BI + Data Analytics
Our complete practical program: Excel, Power Query, Power Pivot, Power BI, DAX, dashboards, projects and analytics career preparation.
Explore the flagship program →Data Analytics Course
The analytics workflow end to end: Excel, Power Query, Power BI, visualization and business intelligence with projects.
View course →Related learning resources
What Is Power BI? A Plain-English Introduction
A plain-English explanation of Power BI, its components and who uses it.
Read guide →DAX in Power BI: Fundamentals and Essential Functions
Understand filter context, CALCULATE and time intelligence so your measures stay correct.
Read guide →How to Create a Power BI Dashboard
Step-by-step process for building a clear, interactive Power BI dashboard.
Read guide →Ready to start?
Talk to us about your background and goals. We will recommend the right batch and starting point - no pressure.