Power BI Data Model Design: An Overview of Data Modeling

Microsoft Power BI 2.96    |    Beginner
  • 12 Videos | 1h 49m 47s
  • Includes Assessment
  • Earns a Badge
Data as a form of currency is an analogy that's been around since the early 2000s. However, data itself is worthless. The real value is in the insights you gain from it; this is where data analysis comes in. Data modeling is a crucial part of data analysis, helping turn raw data into accurate insights and meaningful reports. Use this course to learn how to design and optimize data models through Power BI Desktop. Examine the star and snowflake schemas. Learn about the DAX formula language. Then, conduct a range of tasks, including combining tables, defining calculated columns, creating measures, and counting values. Upon course completion, you'll know how to use data modeling to transform raw data into powerful visuals and reports. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    identify some of the critical steps involved in modeling data for analysis in Power BI
    recognize what the star schema is and why it's crucial in the context of data analysis in Power BI
    summarize the power of the DAX formula language and the types of operations it can perform
    describe the important techniques for optimizing data for performance when modeling data in Power BI
    use the UNION operation to combine the contents of two tables with identical schemas
  • apply a DAX formula to compute a value based on existing data for each row in a table
    define a measure using the DAX formula language and contrast it with a calculated column
    create a simple table visual in order to view data stored in tables
    model a numeric value as a discrete rating on a 0-5 scale
    count the number of values in a column based on an expression
    summarize the key concepts covered in this course

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.