Microsoft Power BI Training

We don’t want to be the biggest training company but we are trying to be the best.

We have now won the Feefo Gold Award for customer service for 6 years in a row.

We always limit our classes to a maximum of 8 delegates but try to keep them smaller. During 2018 our average class size was 4 people.

To back up our promise of great training we offer a 100% money back guarantee.

We provide everything that you will need for a fun, productive day of training.

Everyone has their own computer to work on in a comfortable, bright, air-conditioned room.

We provide plenty of tea, coffee & biscuits, a delicious, freshly prepared lunch and a USB stick so that you can take files home with you.

We provide 6 months of post-course support as well.

If you get stuck on anything that you learned during the course simply get in touch and explain the issue.

We will make sure your trainer contacts you as soon as possible to help you out.

We also include dummy data that you can practice running analysis on and creating reports with as you learn.

Yes. We provide all attendees on our course with certificates.

This means that in future you can demonstrate that you have received professional bi training.

Our focus is on you being a faster, more capable Power BI user when you return to work.

Our courses combine traditional teaching to explain new concepts and tools with hands-on exercises.

The exercises ensure that you get plenty of time to try out what you have just been taught and make sure that you really understand it, for example creating simple reports using dummy data.

We also make sure that there is plenty of time for you to ask questions in case there is anything you are unsure of.

Please come wearing whatever you are most comfortable in, we do not have a dress code.

Most people come wearing casual clothes.

We provide training at our training centres in Guildford and London.

We also provide training at our clients’ offices. In 2019 we have provided training in Oxford, Reading, Southampton, Swindon, Bristol, Basingstoke, Maidstone, Portsmouth and Brighton.

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

Our training is design to prepare your staff for certification as an MCSA in BI Reporting which is achieved by passing these two exams:

• 70-778 Analyzing and Visualizing Data with Power BI
• 70-779 Analyzing and Visualizing Data with Microsoft Excel

Please note, the actual exams will need to be organised separately, at an exam centre, and cost approximately £130, plus VAT.

We cover PQ in our introduction & intermediate Power BI course. It allows you to connect to and combine sources of data for your analysis.

It is available in both Excel and Power BI desktop.

Business intelligence (BI for short) refers to the collection of technologies involved in collecting, analysing and presenting BI in dashboards and reports.

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.

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 is Microsoft’s business intelligence and visualization solution which 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 create interactive dashboards and reports; visualizing your data with Power BI’s wide variety of data visualizations.