Description: A well-designed data model eliminates irrelevant and uninterpretable analyses and ensures insightful and well-performing reports. Use this course to step up your data analysis using Power BI's advanced data modeling features.
Begin by loading a sales dataset containing a large fact table and multiple dimension tables and modeling it into a snowflake schema. See how Power BI automatically detects relationships. Then, learn how to apply detailed configurations of relationships, from setting the right cardinality to applying bi-directional cross-filtering.
Next, explicitly define a hierarchy in your data to model a set of geographical values. Learn further detailed configurations, such as setting a default aggregation operation on fields and hiding specific ones from the reports view. Lastly, learn how to implement row-level security.
When you're done, you'll be able to use Power BI's advanced data modeling capabilities. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target Audience:
Duration: 01:57
Description: A big part of data analysis is evaluating how data behaves over time. Power BI's DAX language includes time intelligence functions that enable you to aggregate, compare, and manipulate data using time periods. Use this course to learn how to model data using time-based analysis.
Begin by creating a date table. Then use DAX time intelligence functions to extract values from a date. Also, learn how to define dates as a hierarchy, which can then be applied in visualizations.
Moving along, practice operating on a range of dates that are shifted from the range in the current context by a specified interval. Finally, perform year-to-date and month-to-date computations from the date in the current context.
When you're done, you'll be able to apply a variety of time functions to your data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target Audience:
Duration: 00:54
Description: The more you master DAX in Power BI, the better the insights and reports you'll get from data. The filter context is a need-to-know DAX concept. Use this course to get hands-on experience working with this aspect of Power BI.
Start by exploring the relationships between tables in Power BI. Move on to using the CALCULATE function. Then, see how a filter context can be defined so that it only points to a subset of the overall data and how you can continue to perform operations within this filter context.
Moving on, examine a breadth of options for ignoring the filter context for specific use cases, including how to bypass filters using various DAX functions.
When you're done, you'll be able to use DAX functions to perform operations on a subset of data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target Audience:
Duration: 01:22
Description: Power BI does the heavy lifting when it comes to analyzing data. One way it does this is through the DAX formula language. By learning how to use this language, you can vastly improve the insights you get from data.
Use this course to learn how to conduct several data analysis operations using the DAX formula language. Begin by performing aggregation operations, such as sum and average. Learn how to generate and work with blank data in DAX. Explore a variety of counting functions, ranging from simple counts of values to conditional counts based on filters. Lastly, practice using the IF and SWITCH functions.
Upon course completion, you'll know how to use DAX to calculate values and reference table data in Power BI. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target Audience:
Duration: 01:16
Description: 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.
Target Audience:
Duration: 01:50