IT Skills     Data and Databases     Data Visualization     Design Data Models in Power BI

---

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.

---

---

Objectives

PL-300: An Overview of Data Modeling in Power BI 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