Microsoft Power BI Training Courses in London & Online

We run our courses the way we would want them to be run if we were customers:

1. We are a Microsoft partner and have been rated Outstanding by Feefo every year since 2013 because of our excellent customer feedback.
2. We’ve run more Power BI courses than anyone else in the UK.
3. We offer a 100% money-back guarantee on all of our courses. If you don’t think we have delivered a top quality course we will refund your money.
4. Our Power BI trainers all have over 7 years of Power BI experience which isn’t bad when Power BI has only been around for 10 years! They have a deep knowledge of how Power BI works which means that if you get stuck they’ll be able to get you back on track.
5. Our courses are CPD-certified allowing you to use them to meet formal professional development requirements.
6. Our training gets you hands-on and using Power BI as quickly as possible so that you learn practical skills that you can use when you return to work.
8. We offer 6 months of post-course support so if you get stuck on anything from your Power BI course simply drop us an email and we’ll come back ASAP.

Yes we frequently run closed courses for our clients.

We can run instructor-led training courses at your offices or one of our training centres.

Online courses can be run either on Zoom or MS Teams whichever you would prefer.

Our corporate training is fully customisable.

We work with you to create a tailor made course focused on the content that is most relevant to your industry and business needs.

For groups of 3 or more people a private course will be cheaper than booking one of our public courses.

Exact pricing depends on number of delegates and delivery method so please get in touch to discuss your specific requirements.

Our Power BI introduction training course is for complete beginners, you do not need any previous experience with Power BI to attend.

It is designed for people who will be:

1. Using complex dashboards and reports which have been prepared by other analysts
2. Creating simple data visualisations from scratch.
3. Going on to attend our Advanced course and need to master the basics.

By the end of this course, you will be able to:

1. Connect to a range of data sources using Power BI
2. Prepare and transform your data.
3. Create data visualisations like KPIs and charts.
4. Publish reports that you have crated via the web or PDF.

This course gives you a high-level overview of Power BI and introduces basic best practices and its drag and drop functionality.

Our advanced training course is for people who are already Power BI users and want to develop their skills further.

It is designed for people who will be creating complex dashboards and reports from scratch.

By the end of this course, you will be able to:

1. Customise a report.
2. Use the query editor to interrogate the data in a data model, data relationships and hierarchies.
3. Build interactivereports like drill-through reports and relative date reports.
4. Creating a wide variety of compelling visualisations including maps, bullet and scatter charts.
5. Set security and data permissions, and control when your data is updated.

We provide certificates of completion to everyone who completes one of our Microsoft Power BI programmes.

Our training is not an official PL-300 Microsoft Power BI Data Associate course, however, taken together our courses cover the vast majority of the syllabus and so would work very well for someone working towards that certification.

We have mapped our training in detail against the official Microsoft PL-300 exam syllabus, please contact us if you would like more details.

You do not need to be an advanced Power BI user to attend our introduction to DAX course.

The pre-requisite to attend is that you are comfortable using Power BI and understand it to at least the level that you would if you had attended our Introduction course.

This course covers creating basic DAX formulas using M langugage.

Power BI is Microsoft’s data analytics and business intelligence platform.

It allows you to connect to hundreds of data sources, prepare data, and create beautiful, interactive reports and dashboards converting raw data into easily actionable insights.

It was launched in 2014 and its main competitors are data tools like Tableau, Google Data Studio and Qlik.

It comes in a range of versions from Power BI Desktop which is free through to Power BI Premium which is a full enterprise business intelligence solution hosted in the cloud.

Microsoft Excel is widely used as a general purpose tool for all sorts of calculations and simple data management.

Power BI is a business intelligence platform designed specifically for data analytics and visualisation for large volumes of data which Excel could not handle. It allows users to very quickly and simply share data and business insights across their organisation.

Power BI Desktop:

Power BI Desktop (free) gives you access to Power BI’s basic features and is where you create data models and carry out data cleansing and analysis. It is also how you access the full cloud-based version of Power BI – Power BI Service – if you are a subscriber.

Power BI Pro:

Power BI is the full version of Power BI. It includes the ability to build and share dashboards and reports that you have built which you can’t with BI Desktop.

Power BI Service or Premium:

Power BI Service is designed for large organisations. It gives your company access to its own dedicated capacity and allows for analysis of very large scale datasets.

Power BI toolkit is comprised of several key components:

1. Power Query: A data extraction and transformation tool used to connect to, clean, and shape data in Power BI Desktop.
2. Power Pivot: An in-memory data modeling component that allows for the creation of relationships between data tables.
3. Power BI Desktop: A free tool for building for analysing your data, building data models and designing reports.
4. Power BI Service: A cloud-based service for publishing, sharing (inc via mobile app) and collaborating on reports and dashboards.
5. DAX (Data Analysis Expressions): A formula language with a library of functions and operators. It allows you to create custom calculations, measures and calculated columns, and usee complex logic to derive deeper insights.

Power BI can connect to a wide variety of data sources, including Microsoft Fabric, Excel files, SQL Server databases, SharePoint lists, and online services like Google Analytics and Salesforce allowing you to bring all your data together in one place.

A Power BI report is a multi-page collection of visualisations and data created from a single dataset.

A dashboard is a single-page interface that provides a high-level overview of key metrics, with visualisations, drawn from multiple reports.

Our online training is designed to be as similar to a classroom as possible.

We use Zoom for our courses and the instructor is there throughout to answer questions and lead you through the course as they would in a physical course.

To attend a virtual Power BI course you will need:

• A stable internet connection fast enough for video conferencing
• An up to date version of Power BI Desktop (free) running on your PC

A second screen isn’t vital but if you have one we would recommend using it.

We cap our classes at 6 people for Power BI to ensure you get plenty of time to ask questions.

For in-person classes we provide everything you will need.

A computer with the appropriate software, electronic courseware and the exercises to go with it, a comfortable air-conditioned training room and lots of tea, coffee and chocolate biscuits.

For virtual, online courses we provide the electronic courseware and data files.

We provide the data files so that you can review the training material and exercises after the course and practice in your own time.

We offer 6 months of post-course support for all of our courses in case you have questions afterwards.

If you get stuck on something from your course, simply email us the question and your trainer will come back to you as soon as possible. When you email us please give plenty of detail so that your trainer is able to fully understand the issue.

We ask you to email your question as our trainers are usually busy with training courses during the day. If they are busy training they may not be able to come back until after their course.

Microsoft have not released a Mac version of Power BI and so we’re not able to provide Power BI training on a Mac