Excel is a vital tool for boosting your efficiency and productivity when you’re dealing with large amounts of data and calculations. This course is a journey through the key topics for Excel power users and majors on Macros and Pivot Tables…
Microsoft Power BI Courses
Microsoft Power BI Courses
The aim of business intelligence (BI) is to make sense of the vast amounts of data that organisations hold. Our Microsoft Power BI courses help you analyse and visualise your data and thus guide business decision making and management. We provide Power BI courses from beginner to advanced levels. Our courses can be tailored to best suit your requirements.
All our courses are available online with either Zoom or Teams. You are welcome to attend our training centre, or we can come to you. Call 020 7920 9500 today for further details.
Power BI Introduction
Our Microsoft Power BI Introduction training course helps you extract, analyse and comprehend large quantities of data. This will ensure that you can present data in a logical manner and make informed business decisions. Microsoft Power BI (Business Intelligence) is a user-friendly, report-based analytical tool that is transforming the way that businesses read their performance data.
The course starts from first principles and assumes no previous knowledge. You will learn how to link and model your data in Power BI and then create and share visual reports that reveal business insights.
Power BI Advanced
Our two-day Microsoft Power BI Advanced training course is designed for those who are already using Power BI. But they need to explore its features in more depth. It is ideal for business or financial analysts, data scientists and staff.
Learn about the Data Model, its structure and function and how best to share it. Work with more advanced DAX functions to effectively manipulate your business data. See how to use complex Queries for data load. And use bookmarks and buttons to develop an interactive visual interface.
Our two-day Microsoft Power BI Mastering DAX (Data Analysis Expressions) training course gives you a deeper understanding of this powerful data manipulation language. Although it’s often described as “simple but difficult”, DAX is a simple language. But it can be quite a challenge to do the calculations you actually need! However, once mastered, effective DAX formulas are the key to getting the most out of your data.
Our course covers how to use DAX to join and generate tables, control table relationships, gain an understanding filters and context and how to use Time Intelligence calculations.
Functions are the backbone of most worksheets. But there are around 500 worksheet functions in Excel! Our course covers the most important Excel functions. The ones you will actually use time and time again…
Pivot Tables are one of Excel’s most powerful features. And one of the easiest to learn! You can summarise and analyse huge amounts of data easily and rapidly. Produce calculations, slicers, dynamic reports and a whole lot more…
Get the best from Excel, it’s one of the most used office applications. But, at the same time, it’s one of the most under-used. Come along on our Excel Intermediate course and open the door to what Excel can do for you…
There’s been quite a few changes to Excel in recent years and they’re easily missed. Our New Functions course covers functions like XLOOKUP, FILTER and many more. Number crunchers should check out our Power Query course…