Build a Data Model for Analysis in Power BI (C63924)

Log In to Register

Cancellation Policy

Please note that this webinar Is from a third party vendor, CPA Crossings. We strongly recommend registering no later than one-hour before the webinar begins. Please contact CPA Crossings webinar hotline if you do Not receive your webinar invitation via email within five minutes after registering:  877-370-2220 ext. 1. Thank you.

Date(s):

08/07/2024

Registration Open:

12:00 AM - 10:00 AM

Time:

10:00 AM - 2:00 PM

Facility:

 Online

Meeting Type:

Webinars

CPE Credit:

4.00

Field(s) Of Study:

Computer Software and Applications (4.00)

Level of Knowledge:

Intermediate

Price:

Member: $149.00
Nonmember: $169.00

Individual Discounts:

Not Available

Overview

After attending this presentation, you will be able to...

  • Apply fundamental principles of data modeling in Power BI to integrate various data sources effectively.
  • Determine the most appropriate scenarios for using calculated columns versus measures in Power BI data analysis.
  • Choose and implement the correct type of DAX measures (explicit or implicit) for specific data modeling needs.
  • Use pivot tables in Power BI to validate and refine data measures, ensuring accuracy and reliability in reporting.

Highlights

The major topics that will be covered in this class include:

  • Data Modeling Essentials: Understanding the core concepts of data modeling in Power BI, including integration of various data sources.
  • Building Relationships: Techniques to establish and manage relationships between different data sets.
  • Calculated Columns and Basic DAX Measures: Introduction to DAX (Data Analysis Expressions) and its application in creating calculated columns and basic measures.
  • Calculated Columns vs Measures: Insights into when to use calculated columns and when to opt for measures.
  • Explicit vs Implicit Measures: Understanding the difference and appropriate application of explicit and implicit measures in data analysis.
  • Hierarchies in Data: Creating and utilizing hierarchies to enhance data analysis and reporting.
  • Using Pivot Tables to Validate Measures: Practical skills in using pivot tables within Power BI to validate and refine measures.

Speaker(s)

Prerequisites

Attended a Pivot Table course or experience using Pivot Tables