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.

Event Details

Location and date:
Online (English) On-Demand Event

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.

Additional options and pricing may be available. See pricing and registration for more details.

Members $1,340| Non-members $1628

15.5 CPD hour(s)
Pricing & registration

You will learn about:

  • 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

Who should attend?

  • controllers
  • financial analysts
  • business professionals
  • senior accountants
  • IT professionals
  • consultants
  • business intelligence educators

More Details:

Frequently asked questions:

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)

You may also be interested in:

The world needs leaders who are thoughtful, decisive and digitally literate. Learn how to make better business decisions by improving your approach to critical thinking, skepticism and bias awareness.

Technology keeps changing and so do the value levers of business. Be prepared for what’s next and arm yourself with the right skills to play an active role in shaping the future of the profession.

Analytics can make or break your bottom line. Learn how to harness the power of data science to enhance business intelligence and deliver precise, high-quality insights to your stakeholders.

Microsoft Power BI is an excellent tool for building effective dashboards. Discover the key concepts you need to create data visualizations that communicate meaningful strategic information with your audience.


Please contact:

Member Development and Support
Tel: 1-800-268-3793
Email: [email protected]