Course Overview on Microsoft Power BI Bootcamp
This intensive 3-day bootcamp is fast-paced and practical, using realistic datasets to build a solid foundation of job-ready skills. It's suitable whether you're new to Power BI or an experienced user looking to sharpen your skills.
As a bonus, the content is aligned with Microsoft's PL-300 Power BI Data Analyst Associate exam, so it also doubles as excellent exam prep if you would like to pursue that certification.
What You Will Learn
By the end of this course, you will be able to:
- Prepare and transform data for analysis in Power BI.
- Build and configure data models, including relationships, hierarchies and parameters.
- Create DAX calculations and measures to support data analysis.
- Create, design and enhance Power BI reports and visualisations.
- Analyse data to identify trends, patterns and insights, including using Copilot and other analytical tools.
- Manage, publish, distribute and secure Power BI content, including workspaces, semantic models, apps and row-level security.
Delivery Methods
| Delivery Method | Duration | ||
|---|---|---|---|
| 3 days | Get a Quote | ||
| 3 days | Get a Quote |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
Customer Testimonials
Sandvik Mining & Construction Ltd
Lawrence exudes passion in what he does and that comes through in the training
Sandvik Mining & Construction Ltd
Very Professional and Interactive way of conducting training
Rockwell Automation (Pty) Ltd
I feel this is a mandatory course for all data analysist, the power of the different functions to gain insights so quickly on the data you already have
Sandvik Mining & Construction Ltd
Yes. see below Our Central Africa Finance, Business Control and Logistics team recently had the privilege of attending a training session facilitated by Leading Edge Solutions, and it has been an exciting and truly educational experience. The course was well-structured, engaging, and tailored to our needs, particularly around developing our Power BI capabilities. We gained valuable insights into concepts and practical applications that will enable us to take our dashboarding and reporting to the next level. The hands-on approach and clear guidance made it easy for our team to understand and apply the techniques. We are especially excited to put into practice what we’ve learned, as these new skills will help us build impactful dashboards and deliver meaningful insights to our management team. The training has undoubtedly strengthened our analytical capabilities and enhanced our confidence in using Power BI. A big thank you to Leading Edge Solutions for delivering such a high-quality program. We look forward to continuing this journey of learning and applying these concepts in our daily work.
Audience
This bootcamp is ideal for anyone looking to build practical, job-ready Power BI skills, whether you're starting from scratch or already using Power BI and want to sharpen your abilities. It's a great fit for:
- Business analysts and reporting professionals looking to build stronger, more effective reports.
- Managers and executives who want to get hands-on with their business's data to drive better decisions.
- Small business owners looking to use data analysis and forecasting to gain an edge over competitors.
Pre-Requisites
- Basic Computer Skills: You should be familiar with the Windows/Office 365 environment and comfortable navigating and managing files.
New to using computers professionally? Start with our Windows Basic training course. - Foundational Excel Knowledge: A working understanding of spreadsheets (e.g. formulas, tables) is helpful.
Build these skills in our Microsoft Excel Fundamentals course. - A laptop with Power BI installed
IMPORTANT!
Power BI is a Microsoft application and does not run on macOS. You will need a computer with Windows installed for the practical portions of this course.
Course Outline / Curriculum
Introduction to Microsoft Power BI and "Power" Platform
- Understand the purpose of Microsoft Power BI and its role within the Microsoft Power Platform.
- Identify the key elements and components of Power BI.
- Understand the Power BI reporting workflow.
- Explain Power BI Report Server and on-premises reporting.
- Understand the basic functionality of Power BI Desktop.
Get started with Microsoft data analytics
- Roles in data.
- Data analysis tasks.
- Building blocks of Power BI.
- End-to-end analytics with Microsoft Fabric.
Get data in Power BI
- Identify and connect to a data source.
- Select a storage mode.
- Fix performance issues.
- Resolve data import errors.
Clean, transform, and load data
- Resolve inconsistencies, unexpected or null values, and data quality issues.
- Apply data shape transformations to columns and table structures.
- Apply user-friendly naming conventions.
Configure a semantic model
- Set modelling options.
- Create and configure relationships.
- Configure table and column properties.
- Create hierarchies.
- Create quick measures.
- Create numeric range and field parameters.
Create DAX calculations in semantic models
- Understand DAX concepts and syntax.
- Create calculated tables and columns.
- Create measures.
- Use iterator functions.
Modify DAX filter context
- Understand filter context.
- Use the CALCULATE function to modify filter context.
- Use inactive relationships with DAX.
- Perform context transition.
Use DAX time intelligence functions
- Create a custom date table for time intelligence.
- Use DAX time intelligence functions.
Create visual calculations
- Understand visual calculations and how they differ from measures.
- Create visual calculations in Power BI Desktop.
- Use parameters in visual calculations.
Design Power BI reports
- Report structure.
- Report objects.
- Different visualisation types.
- Filtering techniques.
Enhance reports for user experience
- Present details and highlight key values.
- Build intuitive navigation and app-like experiences.
- Enhance user experience using bookmarks, visual headers, and built-in assistance.
- Incorporate specialised visuals to meet unique reporting needs.
Perform analytics in Power BI
- Use the Analyse feature.
- Group, bin, and cluster data.
- Identify patterns and trends.
Get started with Copilot in Power BI
- Use Copilot in Power BI during report development.
- Prepare semantic models for use with AI.
- Interact with data using natural language in Copilot Chat.
Optimise model performance (optional)
- Use variables to improve performance and troubleshooting.
- Review the performance of measures, relationships, and visuals.
Manage Workspaces in Power BI
- Describe the Power BI service and its building blocks.
- Create workspaces, assign license modes, and manage access.
- Publish reports to the Power BI service.
Manage semantic models
- Use a Power BI gateway to connect to on-premises data sources.
- Configure a scheduled refresh for a semantic model.
- Configure incremental refresh settings.
- Manage and promote semantic models.
- Boost performance with query caching.
- Use lineage and impact analysis.
Choose a content distribution method
- Understand the different content distribution methods available in Power BI.
- Create a Power BI app.
- Apply data governance principles.
- Track a report or dashboard.
Secure data access in Power BI
- Configure row-level security by using a static method.
- Configure row-level security by using a dynamic method.
Schedule Dates and Booking
To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.
| Start Date | End Date | Branch | Status | |
|---|---|---|---|---|
| Mon 5 Oct 2026 | Wed 7 Oct 2026 | Not Applicable | Scheduled | |
| Mon 2 Nov 2026 | Wed 4 Nov 2026 | Not Applicable | Scheduled | |
| Mon 30 Nov 2026 | Wed 2 Dec 2026 | Not Applicable | Scheduled |
