Course: Microsoft Excel: Advanced Data Analysis and Visualisation

In the previous activities, you looked at some common data sources you could use to import into your Excel data model. Now you’ve been put in a much more limited …

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, …

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, …

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 …

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 …

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 …

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. …

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 …