PL-300: An Overview of Data Modeling in Power BI

Microsoft Power BI    |    Beginner
  • 12 videos | 1h 49m 47s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 227 users Rating 4.6 of 227 users (227)
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 PL-300: Power BI Data Analyst 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course PL-300: Analysis & Sharing Features in Power BI
Rating 4.6 of 137 users Rating 4.6 of 137 users (137)
Course Data Loading & Visualization in Power BI: Advanced Visualizations
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course PL-300: Power BI for Data Analysis
Rating 4.5 of 1379 users Rating 4.5 of 1379 users (1379)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course PL-300: Working with Filters in Power BI
Rating 4.4 of 115 users Rating 4.4 of 115 users (115)
Course Business Reporting: Getting Started with Power BI Desktop for Data Analysis
Rating 4.6 of 1028 users Rating 4.6 of 1028 users (1028)
Course PL-300: Understanding Data Visualization
Rating 4.5 of 407 users Rating 4.5 of 407 users (407)