From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
Learning objectives - Power BI Tutorial
From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press
Learning objectives
“
- This lesson focuses on the things that we can do to clean the data prior to loading it to the target data model. In this lesson, we will cover how to evaluate data, including data statistics and column properties, resolve inconsistencies, unexpected or null values, and data quality issues, resolve data import errors. Let us begin.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Watch this course anytime, anywhere.
Get started with a free trial today.
Contents
-
-
(Locked)
Module introduction: Prepare the data1m 10s
-
(Locked)
Learning objectives28s
-
Identify and connect to data sources or a shared semantic model9m 47s
-
(Locked)
Change data source settings, including credentials and privacy levels3m 58s
-
(Locked)
Choose between DirectQuery and import6m 9s
-
(Locked)
Create and modify parameters6m 9s
-
(Locked)
-
-
(Locked)
Learning objectives47s
-
(Locked)
Select appropriate column data types6m 53s
-
(Locked)
Create and transform columns9m 21s
-
(Locked)
Group and aggregate rows2m 55s
-
(Locked)
Pivot, unpivot, and transpose data5m 23s
-
(Locked)
Convert semi-structured data to a table4m 44s
-
(Locked)
Create fact tables and dimension tables4m 2s
-
(Locked)
When to use reference or duplicate queries and their impact4m 51s
-
(Locked)
Merge and append queries8m 38s
-
(Locked)
Identify and create appropriate keys for relationships2m 8s
-
(Locked)
Configure data loading for queries2m 32s
-
(Locked)
-
-
(Locked)
Module introduction: Model the data29s
-
(Locked)
Learning objectives30s
-
Configure table and column properties3m 54s
-
(Locked)
Implement role-playing dimensions2m 27s
-
(Locked)
Define a relationship's cardinality and cross-filter direction4m 37s
-
(Locked)
Create a common date table9m 56s
-
(Locked)
Use cases for calculated columns and calculated tables2m 58s
-
(Locked)
-
-
(Locked)
Learning objectives34s
-
(Locked)
Create single aggregation measures12m 43s
-
(Locked)
Use the CALCULATE function3m 42s
-
(Locked)
Implement time intelligence measures2m 57s
-
(Locked)
Use basic statistical functions4m 34s
-
(Locked)
Create semi-additive measures4m 44s
-
(Locked)
Create a measure using quick measures5m 10s
-
(Locked)
Create calculated tables or columns5m 57s
-
(Locked)
Create calculation groups9m 38s
-
(Locked)
-
-
(Locked)
Module introduction: Visualize and analyze the data31s
-
(Locked)
Learning objectives35s
-
(Locked)
Select an appropriate visual7m 54s
-
(Locked)
Format and configure visuals3m 13s
-
(Locked)
Apply and customize a theme2m 22s
-
(Locked)
Apply conditional formatting3m 36s
-
(Locked)
Apply slicing and filtering4m 52s
-
Configure the report page2m 50s
-
(Locked)
Choose when to use a paginated report1m 49s
-
(Locked)
Create visual calculations by using DAX8m 25s
-
(Locked)
-
-
(Locked)
Learning objectives54s
-
(Locked)
Configure bookmarks6m 15s
-
(Locked)
Create custom tooltips3m 22s
-
(Locked)
Edit and configure interactions between visuals4m 23s
-
(Locked)
Configure navigation for a report5m 12s
-
(Locked)
Apply sorting to visuals2m 20s
-
(Locked)
Configure sync slicers3m 20s
-
(Locked)
Group and layer visuals using the Selection pane4m 18s
-
(Locked)
Configure drill through navigation3m 16s
-
(Locked)
Configure export settings5m 13s
-
(Locked)
Design reports for mobile devices3m 8s
-
(Locked)
Enable personalized visuals in a report4m 56s
-
(Locked)
Design and configure Power BI reports for accessibility5m 59s
-
(Locked)
Configure automatic page refresh2m 27s
-
(Locked)
-
-
(Locked)
Module introduction: Manage and secure Power BI46s
-
(Locked)
Learning objectives41s
-
(Locked)
Create and configure a workspace3m 41s
-
(Locked)
Configure and update a workspace app5m 20s
-
(Locked)
Publish, import, or update items in a workspace5m 35s
-
(Locked)
Create dashboards4m 45s
-
(Locked)
Choose a distribution method1m 53s
-
(Locked)
Configure subscriptions and data alerts7m 48s
-
(Locked)
Promote or certify Power BI content2m 43s
-
(Locked)
Identify when a gateway is required1m 55s
-
(Locked)
Configure a semantic model scheduled refresh2m 59s
-
(Locked)
-
-
(Locked)
Learning objectives31s
-
(Locked)
Assign workspace roles2m 30s
-
(Locked)
Configure item-level access1m 26s
-
(Locked)
Configure access to semantic models2m 39s
-
(Locked)
Implement row-level security roles6m 58s
-
(Locked)
Configure row-level security group membership2m 56s
-
(Locked)
Apply sensitivity labels1m 57s
-
(Locked)