On-Demand

2 CPE Credits

Build a Data Model for Analysis in Power BI

On-Demand
2 CPE Credits

This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions.

Learning Objectives

  • Apply best practices when creating your spreadsheets
  • Determine which controls you need to develop for your spreadsheets
  • Use controls to build more accurate spreadsheets

Major Topics

  • Learn best practices when designing your spreadsheets 
  • How to create a proper worksheet structure
  • Learn to use Excel's built in features to find errors
  • How to create your custom controls to prevent and find errors
  • Using links to quickly move to controls
  • Using Conditional Formatting to highlight errors

CPE Credits Available

2 CPE Credits
2
Auditing

Things to Know About This Course

Course Level

  • Intermediate

Professional Area of Focus

  • Technology

Prerequisites

A good knowledge of using Excel

Advanced Preparation

None

Intended Audience

Any Excel user that wants to learn how to create controls within Excel to improve accuracy

Provider

CPA Crossings

This can not be purchased at this time.