Skip main navigation

£199.99 £139.99 for one year of Unlimited learning. Offer ends on 28 February 2023 at 23:59 (UTC). T&Cs apply

Find out more

Where to Next?

In the final activity of this course, you were taken through the usefulness of Power BI. This was by no means a comprehensive discussion. If you found the content interesting …

Power BI Mobile App

As Dany demonstrates in the video, Power BI can be a very versatile tool for creating and sharing data visualisations across different platforms and devices. Furthermore, the visualisation techniques you’ve …

Using Excel with Power BI

In the previous activity, you covered data visualisation in Excel. Another powerful tool offered by Microsoft is Power BI, which Dany covers in the video. If you haven’t already taken …

Pivot Charts and Cube Functions

The previous activities in this week focused exclusively on manipulating the data in your Excel data model. Now that you have everything the way you want it, it’s time to …

Using Advanced DAX Functions

Functions are predefined formulas that perform calculations by using specific values called arguments in a particular order or structure. Arguments can be other functions, another formula, column references, numbers, text, …

Creating and Formatting Measures

In this video, Dany introduces you to some very important functions in the DAX language. Make sure you have a good understanding of them and to supplement your new knowledge, …

Welcome to the Course

Welcome to the Data Analysis and Visualisation Using Excel course. Every day millions of people use Excel for their daily tasks, whether it’s for number crunching, reporting, calculations – you …

VanArsdel Overview

Please review this information carefully. VanArsdel sales data will be used throughout the course, especially in the lab exercises. Scenario VanArsdel is a company that manufactures and sells sporting goods. …