From Beginner to Expert

Power BI + Expert Training = Data Reporting Pro
Turning You into a Reporting Powerhouse.

Perfect for professionals at any stage, whether you're just starting or looking to refine your skills. This course covers everything from core fundamentals to advanced Power BI features, equipping you to build dynamic reports, dashboards, and analytics that drive actionable business insights.

Tools You'll Master in Power BI Training

Visualization Tool

Power BI

Data Modeling Tools

Power Pivot, DAX

Data Transformation Tool

Power Query

Data Analysis & Calculation Tool

DAX

What You’ll Achieve in Just 2 Weeks with Power BI Training?

Create Professional-Grade Power BI Dashboards - for better decision-making.

Master Power Query for Data Cleaning – Learn to transform messy data into structured reports.

Design Efficient Data Models – Establish relationships and use calculated tables in Power Pivot.

Write Powerful DAX Formulas – Gain confidence in handling calculations and logic-based analysis.

Integrate Data from Various Sources – Work with Excel, CSV, and SQL (import mode) effortlessly.

Enhance Report Performance – Apply best practices for optimized speed and responsiveness.

What You’ll Achieve in Just 2 Weeks with Power BI Training?

Create Professional-Grade Power BI Dashboards - for better decision-making.

Master Power Query for Data Cleaning – Learn to transform messy data into structured reports.

Design Efficient Data Models – Establish relationships and use calculated tables in Power Pivot.

Write Powerful DAX Formulas – Gain confidence in handling calculations and logic-based analysis.

Integrate Data from Various Sources – Work with Excel, CSV, and SQL (import mode) effortlessly.

Enhance Report Performance – Apply best practices for optimized speed and responsiveness.

Ideal For:

Finance & Operations

looking to improve reporting, forecasting, and trend analysis

Data Analysts

looking to enhance their data visualization and reporting capabilities.

Business Analysts

aiming to transform data into interactive reports and dashboards.

Managers

who need insights to make informed business decisions.

Non-Technical Professionals

wanting to improve their BI Reporting skills without technical expertise.

IT & Database Professionals

seeking to create business reports without deep SQL knowledge.

A snapshot of what you'll be learning in 2-weeks.

Power BI Course Syllabus

Power BI

Building Blocks of Power BI

Visualizations
Datasets
Reports
Dashboards
Tiles

Building Your First Power BI Report

Connect to Data Sources in Power BI Desktop
Clean and Transform Your Data With the Query Editor
Create a report in Power BI Desktop
Publish the report in the Power BI service

Data Modelling with Power BI

Fundamentals of Modelling
How to Manage Your Data Relationships
Create Calculated Columns
Optimizing Data Models for Better Visuals
Create measures and work with time-based functions
Create Calculated Tables
Explore Time-Based Data

Visualizations

Create and Customize Simple Visualizations

Building compelling data visualizations

Identify metrics and pair them with appropriate data visuals
Using slicers
Creating Map Visualizations
Creating Tables and Matrixes
Creating Waterfall and Funnel Charts
Using Gauges and Single Number Cards
Charting Options including Formatting with Colors, Shapes, Text Boxes, Images, etc.

Designing User-friendly reports

Customize themes
Create versatile layouts for your reports
Design principles to reduce noise and highlight data stories

Creating interactive reports for data exploration

Filtering & drilling for insights
Difference between filters & slicers
Filter pane for reporting needs

DAX Functions

Overview

What is DAX?
Data Types
Table-Valued Functions
Building a Calendar Table
Date and Time Functions
Filter Functions
Information Functions
Logical Functions
Mathematical and Trigonometric Functions
Statistical Functions
Text Functions
Time Intelligence Functions
Creating Advanced DAX Measures With Advanced DAX Functions

Creating Advanced Dax Measures With Advanced Dax Functions

Calculate()
All()
Filter()
IF()
Switch()
SumX()

Evaluation Context

Filter Context
Row Context
Using RELATED in a Row Context
Filters and Relationships
USERELATIONSHIP

Hierarchies in DAX Querying with DAX Relationships

One-to-Many Relationships
Many-to-Many Relationships

Power Query

Overview

Introduction
Loading & Refresh
Combine data from multiple data sources

Data Transformation

Editing Queries Created with Power Query
Editing Column Headers in Power Query
Splitting Column Data with Power Query
Sorting Data
Multi-Level Sorting
Filtering Data
Aggregate data from a column
Insert a custom column into a table
Merge columns
Remove columns
Remove rows with errors
Promote a row to column headers
Transforming Text Values
Replacing Data
Using the Fill command
Pivot and Unpivot Column
Transpose Query Data
Pivot Column Command in Action
Unpivot Columns Command
Grouping Data
Create a Duplicate Query
Group and Summarize Data
Advanced Data Grouping
Working with multiple sources in Power Query
Multiple Excel Tables
Expand a column containing an associated table
Understanding Table Relationships
Merging Queries

Loading Power Query Data to Destinations

Familiarity with the Load & Refresh Settings
Loading it to Workbook
Loading it to Data Model

Power Pivot

Introduction to PowerPivot

Limitation of Excel Functions
Limitation of Excel PivotTable
Why PowerPivot?
PowerPivot Features - Overview

PowerPivot Environment

Opening PowerPivot Environment
Understanding External Data Section
Understanding Formatting
PowerPivot Views
Understanding Measures

Taking Data into PowerPivot

From Excel
From MS Access
From MS-SQL
From Custom Query
From Text Files
From Other Sources

Calculated Columns

Calculated Columns
Entering Formulas
Using AutoComplete Feature
Renaming Columns
Understanding Tables

Creating Measures

Creating Simple DAX Measures
Explicit Measure Vs Implicit Measure
Referencing Measures in Other Measures
Formatting Measures

Manage Data Relationships Working with Multiple Tables Disconnected Tables Creating custom calendars using ADVANCED FILTER() Advanced calculated columns

Understanding Relationship Concept
JOIN TABLES
LEFT JOIN TABLES
RIGHT JOIN TABLES
Using UNION QUERIES

Data visualization Using

Power View
Charts, Score Cards and Dashboards
Slicers
Map Visualizations
Data Binding and Formatting

Creating Advanced Dashboards with PowerPivot

Power BI System Requirements

Required Software (Free Downloads):
- Power BI Desktop: Download here
- Microsoft Excel (2016 or later) (Required for Power Query & Power Pivot features)
Required Specifications:
- High-Speed Internet: A stable and fast connection is required for a smooth learning experience, software downloads, and data connections.
Recommended Specifications:
- Operating System: Windows 10 (Professional, Enterprise, or Education) or Windows 11 (Power BI Desktop is not supported on Windows 10 Home or macOS)
- Processor: Intel Core i5 / AMD Ryzen 5 or higher (Core i3/Ryzen 3 minimum)
- RAM: 16 GB or more (8 GB minimum, but higher is recommended for large datasets)
- Secondary Monitor: Useful for multitasking across reports and datasets
For Mac Users:

Power BI Desktop is not available for macOS. To run Power BI on a Mac, you can use:
- Windows via Boot Camp (Requires partitioning your Mac's storage)
- Virtual Machines (e.g., Parallels, VMware, or VirtualBox with a licensed Windows OS)
Secondary Monitor (optional, but recommended)

Having a secondary monitor will greatly assist in following the pace of the trainer. It allows you to view instructions and your own workspace simultaneously, enhancing your learning experience.

Advanced power bi courses – now available.

Take Power BI to the Next Level

Power BI with SQL

Advanced DAX for Complex Reporting

View Details ➝

Power BI with Microsoft Fabric

For Scalable Reporting

View Details ➝

Taught by Microsoft-Certified Power BI Trainers

All our classes are live,
hands-on and with
real-trainers.

Build Real-World Power BI Dashboards.

Real-time Projects (Practical Application)

This Power BI course includes 12-14 hands-on projects, focusing on creating interactive dashboards, transforming data with Power Query, and writing DAX formulas. Gain real-world experience in data analytics and reporting automation. Here are the top 6 dashboards you'll work on:

Inventory & Supply Chain

Create dynamic visualizations that track inventory levels, order fulfillment rates, and supplier performance. Learn to automate real-time data alerts to ensure optimal stock levels and timely deliveries.

Financial Health Dashboard

Build financial dashboards that display key metrics like revenue, expenses, and cash flow, with live updates. Automate reports that compare actual vs. budget figures and offer real-time insights for business decisions.

Customer Support Dashboard

Visualize customer service metrics such as ticket status, response times, and customer satisfaction. Learn how to automate ticket updates and generate insights to improve support efficiency.

Sales Performance Dashboard

Track sales revenue, regional performance, and top-selling products using dynamic visualizations. Create automatic reports to measure progress against sales targets.

Project Management Dashboard

Design a project management dashboard that tracks timelines, budgets, and milestones in real time. Automate status updates to identify risks or delays early.

Marketing Campaign Dashboard

Build dashboards that visualize key marketing metrics, such as conversions, impressions, and ROI. Automate reports to evaluate campaign success and optimize marketing strategies.

Visualize customer service metrics such as ticket status, response times, and customer satisfaction. Learn how to automate ticket updates and generate insights to improve support efficiency.

Track sales revenue, regional performance, and top-selling products using dynamic visualizations. Create automatic reports to measure progress against sales targets.

Design a project management dashboard that tracks timelines, budgets, and milestones in real time. Automate status updates to identify risks or delays early.

Build dashboards that visualize key marketing metrics, such as conversions, impressions, and ROI. Automate reports to evaluate campaign success and optimize marketing strategies.

Power BI Specialist Certification

Certification:
Power BI Associate – Data Analysis & Dashboards

A piece of paper means nothing if you can’t apply the skills. Our certifications are industry-recognized and backed by hands-on training—ensuring you’re not just qualified, but ready to perform from day one.

Eligibility:

On clearing post-training assessment.

View Sample Certificate

Shareable certificate

Add to your LinkedIn profile

Level : ASSOCIATE

Certificate Code : EG-ASC-003

Eligibility:

On clearing post-training assessment.

Shareable certificate

Add to your LinkedIn profile

Power BI Training Schedule

Jan 6 - Mar 28, 2025

Limited Seats. Registration Closing Soon

Have Questions?

Tel:

+44 (0)20 3769 3689

Email:

support@excelgoodies.uk

Projects & Assignments

What's included?

20 hours of live, instructor-led sessions
14 Power BI + DAX projects
6 Power Query projects
3 Power Pivot models
30-day post-training email support
BI Reporting Specialist Certificate

Upcoming Cohort

Starts On

Time

Course Fee

£599

Tel: +44 (0)20 3769 3689

Power BI Training FAQs

Yes! The course starts from the fundamentals and progressively covers advanced reporting, making it ideal for both beginners and experienced professionals.

If you miss a session, we provide class notes and exercises to help you catch up. You can also attend the same session in a future batch (subject to availability).

We accept credit/debit cards, wire transfers, and corporate invoices for employer-sponsored payments.

No! We start from scratch and progressively cover advanced concepts, making it beginner-friendly. However, basic Excel skills are recommended.

Required Software (Free Downloads):
- Power BI Desktop: Download here
- Microsoft Excel (2016 or later) (Required for Power Query & Power Pivot features)
Required Specifications:
- High-Speed Internet: A stable and fast connection is required for a smooth learning experience, software downloads, and data connections.
Recommended Specifications:
- Operating System: Windows 10 (Professional, Enterprise, or Education) or Windows 11 (Power BI Desktop is not supported on Windows 10 Home or macOS)
- Processor: Intel Core i5 / AMD Ryzen 5 or higher (Core i3/Ryzen 3 minimum)
- RAM: 16 GB or more (8 GB minimum, but higher is recommended for large datasets)
- Secondary Monitor: Useful for multitasking across reports and datasets
For Mac Users:

Power BI Desktop is not available for macOS. To run Power BI on a Mac, you can use:
- Windows via Boot Camp (Requires partitioning your Mac's storage)
- Virtual Machines (e.g., Parallels, VMware, or VirtualBox with a licensed Windows OS)
Secondary Monitor (optional, but recommended)

Having a secondary monitor will greatly assist in following the pace of the trainer. It allows you to view instructions and your own workspace simultaneously, enhancing your learning experience.

No, we use Power BI Desktop (free version) for training. However, if you want to publish reports to Power BI Service, a Pro or Premium license may be required.

Yes! We provide corporate invoices for employer-sponsored payments. You can either use a company card or request an invoice for your finance team.

Yes! We offer discounts for teams of 10 or more enrolling together. We also provide customized corporate training options. Contact us for details

Yes! Upon successfully completing the course and passing the final assessment, you will receive a Power BI Associate – Data Analysis & Dashboards Certificate.

Yes! You will learn DAX for advanced calculations and Power Query for data transformation, helping you build scalable and efficient reports.

This is a live, instructor-led course with hands-on exercises, real-world case studies, and interactive Q&A discussions.

You can retake sessions from a future batch (subject to availability), but full course re-enrollment may require an additional fee.

Unlike pre-recorded tutorials, this is a live, interactive course with expert-led training, hands-on projects, and real-time support.

See all frequently asked questions

Master In-Demand Power BI & Data Analytics Skills

Key Skills You'll Master

Interactive Dashboards & Visualization

Data Transformation

Data Modeling & Relationships

Advanced DAX Calculations

Multi-Source Data Integration

Automated Reporting & Refresh

Performance Optimization

Role-Based Security & Access Control

About The Trainer

Mr. Sami

MCT, MCP, MEE, MOS

30,000+

Students Trained

18+

Year of Experience

4.9

Reviews

Mr. Sami is an exceptionally accomplished and certified Microsoft Trainer, possessing extensive expertise in the fields of Finance, HR, and Information Technology. With an impressive 14-year tenure in the industry, he has successfully trained and empowered over 23,000 professionals, and the number continues to grow.

He has undertaken assignments with the renowned IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.

Build Real-World Solutions During the Course

The Excelgoodies Difference

We Spot Trends Before They Become Industry Standards

The analytics industry moves fast. We move faster. We constantly update our courses to match the latest industry needs, so you’re always learning what’s in demand—before everyone else.

Learn What Matters, Not Just What’s Trending

BI & Analytics isn’t about knowing one tool—it’s about knowing how to use the right tools together. Our courses don’t just teach software; they teach end-to-end reporting, automation, and cloud-driven analytics workflows—exactly what businesses need.

Tech-Enabled Learning,
Zero Hassles

Forget scattered emails and outdated PDFs. Our AI-powered student portal keeps everything in one place—live classes, assignments, progress tracking, instructor feedback, invoices, and instant support—so you stay focused on learning.

Real Projects, Real Experience, Real Confidence

No more theory-only learning—you’ll walk out of our courses with proven expertise in the tools and techniques hiring managers want.

Corporate Power BI Training

Avail additional 10% Corporate Benefit on the total course fee for 10+participants.

Get you team BI ready, today.

Daniel Carter

Business Associate

+44 (0)20 3769 3689

support@excelgoodies.uk

Prove you're human: Type the code shown.

By clicking any of the above buttons, I agree to the terms & conditions and privacy policy, and I consent to receive updates via SMS or email

Esteemed Clientele

Thousands Trained. Here’s What They Say.

Total Reviews 2080k

Average Rating

4.5

Quotes icon Sami is great, a lot to learn but helps guide through the process and move at a pace which is workable for all.

Dean Mckinney | Finance Director | Republic Of Media | UK (Power BI Training)

Quotes icon Its been great learning something new again. Very interactive sessions. Thanks Sami for taking us through everything set by step and ensuring we all understood everything

Hazel Lowe | Systems Support Analyst | Complementary Pathways (Full Stack BI Reporting & Automation Course)

Quotes icon Sami's very knowledgeable and professional and clearly an expert in what he does. He was patient with us and provided us with a lot of content, giving us the tools to succeed while not giving away the farm sot to speak. I feel like I learned a great deal and looking forward to going back to reference material as well as completing the project for this class completion. thank you. Quotes icon

Susan Rodezno | Analyst, Process Improvement, Corporate Budgeting & Reporting | Essex Property Trust | United States (Power BI Training)

Quotes icon This is an excellent training. Sami is a great and patient instructor. He made sure everyone is on course and understands the topic fully before he moves on, if help is needed beyond class time, he also was there before the class to answer questions. I am really impressed with his knowledge and expertise, it seems he always knows the answer to questions. I will definitely take another class with Sami and Excelgoodies again.

Tao Peng | Information Technology Specialist | Minnesota State College Southeast (Power BI Training)

Quotes icon Great class! Very fast paced and my only issue was not having a computer that could keep up, but the class itself was awesome and I learned a lot. I highly recommend this class! Sami is a great teacher.

Michelle Harris | SC Assoc Analyst | Pepsico (Power BI & SQL Training)

Thousands Trained. Here’s What They Say.

Dean Mckinney

Power BI Training

Finance Director

Republic Of Media

Sami's very knowledgeable and professional and clearly an expert in what he does. He was patient with us and provided us with a lot of content, giving us the tools to succeed while not giving away the farm sot to speak. I feel like I learned a great deal and looking forward to going back to reference material as well as completing the project for this class completion. thank you.

Hazel Lowe

Full Stack BI Reporting & Automation Course

Systems Support Analyst

Complementary Pathways

Its been great learning something new again. Very interactive sessions. Thanks Sami for taking us through everything set by step and ensuring we all understood everything

Susan Rodezno

Power BI Training

Analyst, Process Improvement,Corporate Budgeting & Reporting

Essex Property Trust

Tao Peng

Power BI Training

Information Technology Specialist

Minnesota State College Southeast

This is an excellent training. Sami is a great and patient instructor. He made sure everyone is on course and understands the topic fully before he moves on, if help is needed beyond class time, he also was there before the class to answer questions. I am really impressed with his knowledge and expertise, it seems he always knows the answer to questions. I will definitely take another class with Sami and Excelgoodies again.

Michelle Harris

Power BI & SQL Training

SC Assoc Analyst

Pepsico

Great class! Very fast paced and my only issue was not having a computer that could keep up, but the class itself was awesome and I learned a lot. I highly recommend this class! Sami is a great teacher.

Google Reviews

Jennifer McNeill, Financial Controller, ACCA Global

Excellent hands on training in manageable chunks. Sami is very knowledgeable and patient with the team, and I would love to attend more of his training programmes.

Omer Awad, Assistant MIS Manager, Notre Dame

Excellent Power BI training! Sami is a knowledgeable and well-organised trainer who delivered the content clearly and effectively. I highly recommend his training to anyone looking to enhance their Power BI skills.

Spencer Hughes, SR Info Assurance Analyst, ATCSI

Great course to help with reporting. Instructor made sure everyone understood the steps.

Industry Insights

Power BI

7 Advanced DAX Functions to Supercharge Your Power BI Reports

Power BI

Creating Mobile-Friendly Reports with Power BI

Power BI

The Fast-Food Chain Data Story with Power BI: Do’s & Don’ts of data storytelling

Industry Insights

Power BI

7 Advanced DAX Functions to Supercharge Your Power BI Reports

Power BI

Creating Mobile-Friendly Reports with Power BI

Power BI

The Fast-Food Chain Data Story with Power BI: Do’s & Don’ts of data storytelling

APPLICATION DEADLINE

Registration Closes
on .

+44 (0)20 3769 3689

support@excelgoodies.uk

Prove you're human: Type the code shown.

By clicking any of the above buttons, I agree to the terms & conditions and privacy policy, and I consent to receive updates via SMS or email

+44 (0)20 3769 3689

support@excelgoodies.uk

Compare Power BI Bootcamp to Similar Courses

For Power Users

Power BI Pro:
SQL-Driven Advanced DAX & Reporting

Power BI | Power Query | Advanced DAX | SQL - Query & Programming

Compare

End-to-End Reporting

Full Stack BI& Automation (On Prem)

Compare

Compare Now

Select one or more checkboxes

Fill-in the details.

Business Professionals

Techno-Business Professionals

Technology Professionals

Power BI Training in London, Manchester, Birmingham & UK-Wide

Power BI Reporting: Beginner to Expert.

Power BI Training – Program Overview

Training Schedule

Pre-Requisite

Power BI Course Fee

Power BI + Expert Training = Data Reporting Pro Turning You into a Reporting Powerhouse.

Tools You'll Master in Power BI Training

Visualization Tool

Power BI

Data Modeling Tools

Power Pivot, DAX

Data Transformation Tool

Power Query

Data Analysis & Calculation Tool

DAX

What You’ll Achieve in Just 2 Weeks with Power BI Training?

What You’ll Achieve in Just 2 Weeks with Power BI Training?

Ideal For:

Power BI Course Syllabus

Power BI

DAX Functions

Power Query

Power Pivot

Power BI System Requirements

Take Power BI to the Next Level

Taught by Microsoft-Certified Power BI Trainers

All our classes are live, hands-on and with real-trainers.

Build Real-World Power BI Dashboards.

Real-time Projects (Practical Application)

Power BI

Inventory & Supply Chain

Financial Health Dashboard

Customer Support Dashboard

Sales Performance Dashboard

Project Management Dashboard

Marketing Campaign Dashboard

Power BI Specialist Certification

Certification: Power BI Associate – Data Analysis & Dashboards

Power BI Training Schedule

Projects & Assignments

What's included?

Upcoming Cohort

Course Fee

Power BI Training FAQs

Is this Power BI course suitable for beginners?

What happens if I miss a live Power BI session?

What payment methods are available for Power BI training enrollment?

Do I need prior experience with Power BI, DAX, or Power Query?

What are the system requirements for Power BI training?

Is a Power BI Pro license required for this training?

Can my employer sponsor my Power BI course enrollment?

Do you offer corporate discounts for Power BI team training?

Will I receive an official Power BI certification after completing the course?

Does this Power BI training cover DAX and Power Query in-depth?

Are the Power BI classes live and interactive?

Can I retake the Power BI course if needed?

How does this course compare to online tutorials?

Master In-Demand Power BI & Data Analytics Skills

Key Skills You'll Master

About The Trainer

The Excelgoodies Difference

Corporate Power BI Training

Avail additional 10% Corporate Benefit on the total course fee for 10+participants.

Get you team BI ready, today.

Esteemed Clientele

Thousands Trained. Here’s What They Say.

Thousands Trained. Here’s What They Say.

Google Reviews

Industry Insights

Industry Insights

Registration Closes on .

Compare Power BI Bootcamp to Similar Courses

Power BI Reporting:
Beginner to Expert.

Power BI + Expert Training = Data Reporting Pro
Turning You into a Reporting Powerhouse.

All our classes are live,
hands-on and with
real-trainers.

Certification:
Power BI Associate – Data Analysis & Dashboards

Registration Closes
on .