This free online course explains how to use MS Excel Power Pivot to create useful data models from complex data sets.

Working efficiently with large volumes of data can be a challenge. To overcome this, Microsoft introduced the Power Pivot add-on to extend the capabilities of Excel. With its interactive and rich features, this Excel component is today a powerful tool used to work with large and complex volumes of data. This has resulted in a great interest among data analysts and anyone involved in data interpretation and analysis to become proficient in this skill and take their data visualisation abilities to the next level. This course dissects all the intricacies of Power Pivot and teaches you all the procedures required to navigate Power Pivot and harness massive data work with ease and confidence.

This course trains you in all the functions and capabilities of Power Pivot to help you become proficient with its data visualisation and analysis tools. We explain how to enable and navigate Power Pivot, import data from various data sources, organise and format tables, sort and filter data, create and manage table relationships and create Pivot Tables. We then show you how to manipulate Power Pivot data using DAX functions, perform data extraction and export. This course provides the training required to generate interactive data analysis and reports using Power Pivot like a pro.

This course benefits data professionals who want to take their data analysis and visualisation skills to the next level. It is also the ultimate solution for Excel users who want to unlock the true data science power of Excel and work with large amounts of data. The course suits anyone who wants to improve their data analysis abilities with MS Excel Power Pivot's many advanced features. Sign up to master Power Pivot’s powerful data science capabilities and learn how to generate data models you can use to analyse data and guide decision-making.