Data preparation: Cleansing, modelling and dashboards
For most organizations, it’s impossible to avoid navigating substantial amounts of data. Learn how to cleanse that data, create value-added models and build effective dashboards.
To extract the benefits of raw data, it must be refined into content that supports management reporting and other strategic business objectives.
In this course, you will learn how to prepare data for cleansing, modelling and dashboards. You will also study how to interpret and transform data into meaningful information using tools like Excel and Power Pivot.
Note: This course can be taken individually or as part of the Data Management Foundations Certificate.
- fundamentals of data acquisition and preparation
- data cleansing and transformation techniques
- data modelling techniques
- data aggregations and DAX
- how to create effective dashboards
- Power Pivot data models
- writing formulas to aggregate KPI values
- controllers
- financial analysts
- business professionals
- senior accountants
- IT professionals
- consultants
- business intelligence educators
+
Minimum software requirements:
- Microsoft Excel 2013 or higher
- PC (not all functions noted in the course for Excel, Power Query and Power Pivot are compatible with iOS devices)
- Microsoft Power Query for Excel (free download for Excel 2013, built-in for higher versions)
- Power Pivot for Excel (Excel add-on)
