PL-300: An Overview of Data Modeling in Power BI
Microsoft Power BI
| 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 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
-
2m 59s
-
13m 14s
-
3. The Star Schema9m 54s
-
4. The DAX Language8m 8s
-
5. Optimizing Data Models11m 5s
-
6. Combining Two Tables11m 1s
-
7. Defining a Calculated Column10m 58s
-
8. Creating a Quick Measure12m 51s
-
9. Working with Table Visuals7m 20s
-
10. Defining a Star Rating Measure11m 45s
-
11. Using the COUNTAX Function8m 13s
-
12. Course Summary2m 19s
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.
