Skip to content

Data Analysis with Microsoft Power BI - Advanced

Classroom based 3 days course with LIVE TRAINER with Post Course Support - Nationwide £748

Infero Training Ltd


£897.60 inc VAT
Finance options

Live Virtual training - £748+VAT for 3 days training

Group Discounts available

Pay via:


Study method
Online + live classes
3 days · Full-time
No formal qualification
21 CPD hours / points
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

27 students enquired about this course

Add to basket or enquire


This intensive 3 days, hands-on Power BI PRO course helps you to gain a comprehensive, practical understanding of Power BI and takes you from complete beginner to advanced level.

Creating data-backed visualisations is key for data scientists, or any professional, to explore, analyse, and report insights and trends from data. Microsoft® Power BI software is designed for this purpose. Power BI was built to connect to a wide range of data sources. It enables users to quickly create visualisations of connected data to gain insights, show trends, and create reports.

Power BI's data connection capabilities and visualisation features go far beyond those that can be found in spreadsheets. It enables users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.

Since a tool is only as good as the person using it, it is important to gain an understanding of Power BI to maximize your effectiveness when analysing data.

You can choose either our Classroom training at one of our venues or Live, Instructor-led Virtual training from the comfort of your home.


Benefits of Studying Data Analysis with Power BI PRO with Infero Training:

  • Classroom training in Small Groups for Max Focus
  • Only Microsoft Approved Courseware and Exercise Files are used
  • Free Assessment of Skills prior to booking
  • Certificate of Completion & Complementary 12 Months Post Course Support
  • Premier Locations, Latest Tech, Refreshments, OR We Come to You
  • 100% Money Back Guarantee & Price Match Guarantee
  • Bespoke Courses & Group Discounts from £89 per person



This Data Analysis with Power BI PRO course is designed for professionals who want to pursue the Microsoft Certification Exam DA-100: Analysing Data with Microsoft Power BI.


Certificate of completion

Digital certificate - Included


21 CPD hours / points
Accredited by The CPD Certification Service


Course Content

Lesson 1: Analysing Data with Self-Service BI

Topic A: Data Analysis and Visualization for Business Intelligence
Topic B: Self-Service BI with Microsoft Power BI

Lesson 2: Connecting to Data Sources

Topic A: Create Data Connections
Topic B: Configure and Manage Data Relationships
Topic C: Save Files in Power BI

Lesson 3: Performing Data Cleaning, Profiling, and Shaping

Topic A: Clean, Transform, and Load Data with the Query Editor
Topic B: Profile Data with the Query Editor
Topic C: Shape Data with the Query Editor
Topic D: Combine and Manage Data Rows

Lesson 4: Visualising Data with Power BI

Topic A: Create Visualizations in Power BI
Topic B: Chart Data in Power BI

Lesson 5: Enhancing Data Analysis

Topic A: Customise Visuals and Pages
Topic B: Incorporate Tooltips

Lesson 6: Modelling Data with Calculations

Topic A: Create Calculations with Data Analysis Expressions (DAX)
Topic B: Create Calculated Measures and Conditional Columns

Lesson 7: Creating Interactive Visualisations

Topic A: Create and Manage Data Hierarchies
Topic B: Filter and Slice Reports
Topic C: Create Dashboards

Lesson 8: Using Advanced Analysis Techniques

Topic A: Create Calculated Tables, Variables, and Parameters
Topic B: Enhance Visuals with Statistical Analysis
Topic C: Perform Advanced Analysis

Lesson 9: Enhancing Reports and Dashboards

Topic A: Enhance Reports
Topic B: Enhance Dashboards

Lesson 10: Publishing and Sharing Reports and Dashboards

Topic A: Publish Reports
Topic B: Create and Manage Workspaces
Topic C: Share Reports and Dashboards

Lesson 11: Extending Power BI Beyond the Desktop

Topic A: Use Power BI Mobile
Topic B: Extend Access with the Power BI API


Course Objectives

Upon successful completion of this Data Analysis with Microsoft Power BI PRO course, you will be able to:

  • Analyse data with self-service BI.
  • Connect to data sources.
  • Perform data cleaning, profiling, and shaping.
  • Visualise data with Power BI.
  • Enhance data analysis by adding and customizing visual elements.
  • Model data with calculations.
  • Create interactive visualizations.
  • Use advanced analysis techniques.
  • Enhance reports and dashboards.
  • Publish and share reports and dashboards.
  • Extend Power BI beyond the desktop.


Testimonials from our Website and Google Reviews

I was absolutely delighted with the Excel courses that Infero delivered which more than exceeded my expectation. I learnt new ways of using Excel that I can now use in my day to day work to make my work more efficient. Pivot tables were always a mystery to me but now I use them regularly to display HR and Payrol data.

Lisa Dunstan (Payroll Manager) from Decathlon UK


Had Excel training with Infero last week, I must say it was a good day, I am not the most gifted on excel, but after spending the day with our tutor Martin I came away with a lot more confidence and knowledge, and i will be back for more at a later date, Martin paced the course excellently so no one got left behind or not understanding how to do something. We had good rapport with Martin, even though he forgot how to spell his name :) must be an age thing Lol

Martin Pountney


I attended the level 3b training course offered by Infero Training and, like with many similar courses I have attended, was initially worried that it would be too much information to take in at once. However, the manuals and exercises provided along with the guidance and experience of our trainer Martin made the course interactive, concise and, dare i say it, enjoyable. I would highly recommend.

Michael Sexton


I attended the Microsoft Excel Basic and Excel Intermediate course which I found very useful. Martin is an excellent trainer, made you feel at ease, he is very helpful and patient. I wish I had undertaken the training ages ago as would have been very beneficial in my previous role.

Leela Patel

Who is this course for?

This Data Analysis with Microsoft Power BI PRO course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyse business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients.


To ensure your success in this Power BI course you should have experience managing data with Microsoft Excel, which you could obtain by taking the following courses.

  • Microsoft Excel Introduction
  • Microsoft Excel Intermediate

Optionally, having experience with other data analytics tools, as well as an understanding of database design concepts and basic programming constructs will help you get even more out of this Power BI course. The following courses are helpful but not required:

  • Database Design: A Modern Approach
  • Microsoft Excel - Data Analysis with Power Pivot
  • Data Analysis and Visualization with Microsoft Excel

Career path

Being proficient in Power BI can open the door to many career opportunities such as:

  • Administrative Assistant
  • Data Analyst
  • Accountants
  • Financial Analyst
  • Retail Store Manager
  • Project Manager
  • Business Analyst

Questions and answers


Currently there are no reviews for this course. Be the first to leave a review.


Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.