Course: Advanced Data Analysis and Visualization Using Microsoft Excel

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 …

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 …

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 …

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 …

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

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

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 …

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 …

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