Microsoft Power BI Training

• Maximum number of delegates who can attend has been reduced to 4 or 5 depending on location
• Temperature checks on arrival
• Desk distancing complies with guidelines
• Hand sanitising on arrival
• Facemasks available
• In the office all training equipment and furniture sanitised thoroughly after use
• Stationery used by the delegates during training to be taken away with the delegate or disposed of at the end of the day
• The building cleaning staff regularly disinfect all of all of the doors, handles, stair hand rails, etc.
• During this time lunch is not provided

Our online power bi training is designed to re-create the classroom experience as closely as possible.

It is a live training session using Zoom or Teams and the trainer is there throughout. The training is still hands-on so you will need to have the software installed on your own computer.

The trainer will share their screen to demonstrate techniques and there is also the option of being able to share your screen if you are really stuck! Depending on the class size, which we still keep to a maximum of 8, questions can be asked at any time or at set points throughout the day.

The trainers like to see you! They much prefer it if you have a camera on so they can see you as well as you being able to see them.

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 which will transition well when you return to work in your business.

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 and relax while they enjoy their learning.

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 and analysing data, and then presenting the information generated in dashboards and reports.

Given the number of new business intelligence tools available learning power bi is becoming an increasingly important skill for finance and IT professionals.

Depending on your existing level of expertise either our Beginners Power BI training course or our Advanced power BI training course will probably be most appropriate for you.

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.

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 the functions from Excel that work with relational data.

You can find our more about how to learn DAX here: Beginners DAX training course and here: Advanced DAX training course.