As a result:
This course is only available as a private booking for an individual or group.
Our private courses can run online, in-person at your offices or at one of our training centres.
Please contact us for full details.
Payment Of Invoices
For bookings from established businesses, we do not require payment at the point of booking.
We will send you an invoice which you can submit to your accounts payable system.
Purchase Orders
If your employer uses a purchase order (P.O.) system to manage supplier invoices that is no problem.
PAYMENT METHODS:
You are not able to pay directly online at the time of booking, we issue an invoice for all bookings.
We accept payment either via direct bank transfer or card
Our invoices contain our bank details if you would like to pay by bank transfer and there is also information on how to pay by card.
Please note, if you are using a business card there is a surcharge of 2% to cover the payment processing charges.
For beginners looking for a thorough grounding in the basics.
Become a Power BI power user and learn to use its most powerful tools.
The fastest way to go from beginner to Power BI expert.
Save £100 when you book our Introduction and Advanced Power BI courses at the same time.
Start controlling your data with DAX
Learn to use DAX’s most powerful functions.
The quickest way to become a DAX expert.
Save £100 when you book our Introduction and Advanced DAX courses at the same time!
We also provide Power BI consultancy and implementation services.
All assignments are different by typical requests include:
If you are unsure which course is most appropriate for you, please call us and we’ll be very happy to advise you.
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:
By the end of this course, you will be able to:
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:
The combined course is a combination of our Introduction to Power BI course and our Advanced course.
We offer a discount when these two courses are booked at the same time.
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.
Our Power BI courses can be at your offices, at one of our training centres in London and Guildford or online.
Our online courses can be run using either Zoom or Microsoft Teams.
Yes we do.
We frequently run in-house courses for companies, and individuals who want to focus on a specific part of Power BI.
Not yet!
We are actively looking for a high-quality training location in Manchester and hope to launch our courses during the summer of 2025. So watch this space as our Manchester Power BI training courses should launch soon.
We have been training delegates from Manchester and the North-West for a number of years online so if you can’t wait do please look at our online courses.
The trainer's style and delivery was excellent, particularly around anticipating areas which may be harder to grasp.
Jodie SmythI learnt a lot of new tips and tricks that may have been difficult to find searching online.
Kristen ChungAlpesh was an excellent and engaging tutor.
Craig BrownhillThe course had really clear explanations, answers to questions and great content.
Jayne WellsAlpesh kept the course very interactive, he allowed everyone to follow and understand every step.
Joe HemmingsThe tutor was really engaging and kept it fun!
Mahek AvlaniI appreciated the more in depth background knowledge, and the more advanced functions within Power BI.
Andrew ThomsonIt was great learning how to build Power BI dashboards and understanding their functionality.
Darren WatsonThe course was very well-organised, and Alpesh is a great trainer with lots of patience.
Lucie CrumpAlpesh was really good at explaining everything and giving background as to why you would use different tools and methods in Power BI.
Madeleine JoyrceOakley is our usual Power BI trainer.
We offer all of our Power BI training courses remotely, as well as in-person.
Our remote Power BI courses cover the same content as our in-person courses and run over Zoom or Microsoft Teams.
Our trainers have plenty of experience online and in-person.
So whichever option is best for you, we will ensure you get the best training possible.
Directions
Directions
Looking for private group training or a 1-2-1 Power BI course?
Our custom courses are organised on dates to suit you, either at your office or ours or online whichever you’d prefer.
Our free pre-course reviews ensure that our custom Power BI course is focused on the topics you need.
Everything you need for a great day's training.
A full-colour course manual
Your course exercises to practice at home.
Pens, pads and everything you'll need to take notes
Plenty of tea, coffee and biscuits
6 months of support after the course
A comfortable, modern air-conditioned training room
See how our structured training translates into real success for our delegates.
Rennie Grove Peace Hospice is a palliative care and bereavement support charity working in Buckinghamshire and Hertfordshire.
They needed to upgrade their business analytics capability and make better use of their data across the organisation.
Having decided that Power BI would be the best solution, team members from their fundraising, marketing, clinical reporting and IT teams wanted to learn how to use Power BI to analyse and present their data.
Rennie Grove Peace ultimately decided that a private Power BI course at their offices would meet their needs best.
Doing this was more cost-effective than attending public courses, saved on staff travel time and allowed the training to be focused on their exact requirements.
A private one-day introduction to Power BI course was run at Rennie Grove Peace’s offices.
Everyone left having learned a huge amount about Power BI and ready to start putting it into practice.
After the course, each attendee was tasked with sharing what they learned with their department to broaden the organisation’s understanding of Power BI.
Yes, our classrooms are Covid compliant.
As we limit our classes to a maximum of 4 there is plenty of room for everyone.
If you have any specific questions please contact us.
Yes, we provide everyone who completes one of our courses with a certificate of completion.
We do not provide Microsoft certification.
We provide certificates of completion to everyone who completes one of our Microsoft Power BI programmes as proof of the knowledge that they have.
Our training is designed to prepare your staff for certification as an MCSA in BI Reporting, which is achieved by passing these two exams:
Please note, the actual exams will need to be organised separately, at an exam centre, and cost approximately £130, plus VAT.
Please come wearing whatever you are comfortable in, we do not have a dress code for our courses.
Our London training centre is located in the City of London.
It is 3-minutes from Blackfriars tube station and Thameslink station.
For full details on our London centre see this link: London location
Power BI is Microsoft’s data analytics and business intelligence platform.
It was launched in 2014 and its main competitors are 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.
A Microsoft Power BI training course is ideal for professionals, such as business analysts, accountants, sales executives, marketers, and those in managerial roles.
Adding it to your CV will improve your career prospects.
Our courses show you how to transform data to generate insights and make intelligent decisions from your datasets.
Power BI is a different tool to Excel.
They are both great so long as they are used for the right job.
Excel is great for quick, simple ad-hoc analysis. It is very widely used and understood. Sharing your analysis can be a little fiddley, however.
Power BI is a business analytics and data analysis tool, designed to work with large amounts of data.
It was designed with collaboration in mind and makes sharing your work to mobile apps or over the internet straightforward.
Data Analysis Expressions (DAX) is the native language for PowerPivot, Power BI Desktop and SQL Server Analysis Services (SSAS).
It is quick and simple to use and includes some of Excel’s functions to work with relational data.
We offer both beginners and advanced DAX courses.
Power Query allows you to retrieve, extract, and transform (ETL) data prior to bringing it into Excel (and/or into a Power Pivot data model). It allows you to insert & remove columns, filter and sort tables, and change data types.
It runs on the M Language (short for Mashup) and is labelled as “Get and Transform,” in the “Data” Ribbon in Excel, and is an optional tool. When importing data into Power Pivot can import it directly into Power Pivot, or you can channel it first through Power Query if your data is noisy.
Also known as the DAX Engine (Data Analysis Expression), Power Pivot is an Excel feature that allows you to build a data model with relationships, create calculated columns and measures.
Power Pivot allows Excel to import larger data sets from a variety of sources and create more sophisticated data models using DAX.
Power Pivot allows you to create visualizations using Power View and Power Map. Power Maps is a geographic visualization tool, while Power View allows you to present data in interactive dashboards.
Power Pivot is a free add-on for Excel 2010 and Excel 2013. From Office 2016 onwards, it can be found in Excel.
Power BI works on top of the Power Pivot and Power Query engines. You can shape and analyse your data, either using Get Data in Power Query or Data Model in Power Pivot. You can then Power BI reports and interactive dashboards using Power BI’s wide variety of data visualisations.
Business intelligence (BI for short) refers to the collection of technologies involved in collecting and analysing data and then presenting the information generated in dashboards and Power BI reports.
The aim of business intelligence is to make sense of the vast amounts of data that organisations hold. It allows the data to be analysed to guide business decision-making and management.
For example, many retail businesses use Power BI to sort and report their POS data, especially when that data is held in Azure Cloud. As another Microsoft product, they interface very simply with each other.
Power Pivot is an Excel add-in and part of Power BI.
It is used to create data models. It allows you to combine large amounts of data from a variety of data sources, and create reports and dashboards with custom visuals.
A data model is a collection of tables with relationships. A data model that you can see in Excel is available in Power Pivot and vice versa.
Learning Power BI is no more difficult than other data analysis software.
It is very powerful software that can combine data from a number of data sources. That data can then be used for business analytics, to produce reports and dashboards.
As with other big data software, learning Power BI for straightforward analysis of simple datasets is not difficult.
Learning to use the full suite of big data tools that Power BI contains for more complex data analysis is obviously more complex and time-consuming.
Still not sure which course is best for you? Check out some of the use cases here:
Our introduction course covers how you can create your own dashboard, as well as giving a complete introduction to the software.
Our introduction to DAX course will teach you everything you need to know to get going with DAX, as well as feel confident in an interview situation.
Our advanced course cover all aspects of data visualisation.
We offer a DAX introduction course that will teach you the DAX language, which is your best tool for dealing with big data sets.
If you are already familiar with DAX, you might want to take a look at our advanced course.
