Level 1: Creating and formatting a table visualization

1. Welcome to Part 1: Visualizations

3:00

2. 1b. Importing from Excel, and Creating our first visualization

5:00

3. Viewing data

6:00

4. Focus mode and Different visualizations

3:00

5. Why do I need a Work email address? And how can I get one, if I don't have it?

7:00

6. 10b. Saving visualization to the Desktop and to the Power BI service

5:00

7. Practice Activity Number 1 - The Solution

7:00

Level 2: Formatting our first visualization

1. Formatting font and font size

5:00

2. Formatting colors

5:00

3. Stylistic options

7:00

4. 8g. Position visuals

6:00

5. 8g. Align visuals

5:00

6. 8f. Configuring summarization, both default and in a specific visualization

10:00

7. 8i. Changing number and date formatting

7:00

8. Practice Activity Number 2 - The Solution

8:00

Level 3: 8a. Creating different visualizations: Matrices and bar charts

1. Matrix

7:00

2. Drill down data, see data and records, and export data

8:00

3. Stacked bar charts and 8j. switch theme for reports

7:00

4. Bar Chart formatting

5:00

5. 8c. Configure interactions between visual (Edit interactions)

9:00

6. Clustered and 100% Stacked bar charts

6:00

7. Line and area charts, including 8b. Configure duplicate pages

5:00

8. Combo charts (Line and column charts)

6:00

9. Practice Activity Number 3 - The Solution

8:00

Level 4: Adding more control to your visualizations

1. 11a. Adding Text boxes, Images and Shapes

7:00

2. 11b. Visual level, page level and report level filters - basic filters

7:00

3. Advanced Filtering

11:00

4. Filter Top N Items

5:00

5. Slicer

11:00

6. Slicer Warning

3:00

7. 8g. Sort visuals

7:00

8. 8j. Use Bookmarks for reports

6:00

9. Drillthrough

11:00

10. Buttons and Actions

14:00

11. 11e. Enable Natural Language Queries (Ask A Question)

8:00

12. Tooltip Pages

9:00

13. Practice Activity Number 4 - The Solution

11:00

Level 5: 8a. Other visualizations

1. Ribbon charts

6:00

2. Waterfall charts

8:00

3. Scatter, bubble and dot charts

10:00

4. Pie charts and donut charts

4:00

5. Treemaps

2:00

6. Funnel charts

3:00

7. Adding Marketplace visualizations (Import a Custom Visual)

3:00

8. Practice Activity Number 5 - The Solution

7:00

Level 6: Mapping

1. Maps

8:00

2. Formatting maps

5:00

3. 8g. Adding Data Categories

7:00

4. Filled Maps,Conditional Formatting, and color blindness

10:00

5. Creating hierarchies

7:00

6. ArcGIS Maps for Power BI

12:00

7. Practice Activity Number 6 - The Solution

12:00

Level 7: 6. Measure performance by using KPIs, gauges and…Section 8: Level 7: 6. Measure performance by using KPIs, gauges and cards

1. Gauges

6:00

2. Cards and Multi-row cards

5:00

3. More conditional formatting

8:00

4. KPIs

4:00

5. Practice Activity Number 7 - The Solution

16:00

Part 1 Level 8: Other Visualization Items for the DA-100 exam

1. Define quick measures

7:00

2. Export report data

4:00

3. Create reference lines by using Analytics pane

10:00

4. Design and configure for accessibility

6:00

5. Identify outliers

3:00

6. Use groupings and binnings

7:00

7. Use the Key Influencers to explore dimensional variances

9:00

8. Use the decomposition tree visual to break down a measure

6:00

9. R and Python Visualizations

4:00

10. End of Part 1

1:00

Part 2 Get and Transform Data: Level 1 - Home Part 1

1. Welcome to Part 2: Get and Transform Data

2:00

2. Introduction - let's Get some more Data

5:00

3. Exploring the Power Query Editor interface

9:00

4. Introducing the M language

9:00

5. Let's start look at the Home tab

4:00

6. Home menu - Manage Columns

6:00

7. Home menu - Reduce Rows and Use First Row as Headers

7:00

8. Practice Activity Number 8 - The Solution

7:00

Part 2 Level 1 - Get Data - Home

1. Sort and Filter

6:00

2. Split Column

7:00

3. Other Transform activities

10:00

4. Practice Activity Number 9

1:00

Part 2 Level 2 - Getting Multiple files

1. Merge Queries and Expand Table

6:00

2. Merge Queries with Group By, and different types of Joins

7:00

3. Appending two queries together

5:00

4. Appending three or more queries together + resolving a problem with data types

7:00

5. Combine Files (getting information from a folder)

9:00

6. Practice Activity Number 10 - The Solution

16:00

Part 2 Level 3 - Transform Menu

1. Transform - Table and Any Column

5:00

2. Pivot Column

10:00

3. Unpivot

11:00

4. Practice Activity 11 - The Solution

7:00

5. Unpivot in conjunction with other Transform features

10:00

6. Practice Activity 12 - The Solution

6:00

Part 2 Level 4 - Transform - Text and Numbers

1. Transform/Add Column - Text - Format

6:00

2. Transform/Add Column - Text - Merge Columns

8:00

3. Transform/Add Column - Text - Extract

7:00

4. Transform/Add Column - Text - Parse

11:00

5. Transform/Add Column - Number Column - Statistics and Standard

6:00

6. Transform/Add Column - Other Number Column functions

5:00

7. Practice Activity Number 13 - The Solution

13:00

Part 2 Level 5 - Transform - Dates and Time

1. Creating a list of dates

8:00

2. Transform/Add Column - Date

9:00

3. Transform/Add Column - Dates in other cultures/languages

9:00

4. Transform/Add Column - Time

6:00

5. Transform/Add column - Duration

3:00

6. Practice Activity Number 14 - The Solution

7:00

Part 2 Level 6- Add Columns, View and Help Menus

1. Column from examples

13:00

2. Conditional Column

10:00

3. Resolving Errors from Conditional Columns

4:00

4. Index Column and Duplicate Column

4:00

5. Custom Column - If Then Else

9:00

6. Practice Activity Number 15 - The Solution

10:00

Part 2 Level 7 - View and Help menus and advanced functionality

1. Other M Functions

6:00

2. View and Help menus, including Column Properties

5:00

3. Profile the data

2:00

4. Advanced Editor

4:00

5. Functions and Parameters

12:00

6. DateTimeZone date type and Functions

5:00

7. Worked Practice Activity 16 - Dividing Annual data into Months

11:00

Part 2 Level 8 - Get other types of data

1. Introduction to SQL Server

6:00

2. Importing database data into Power BI, and Query Folding

6:00

3. Select a storage mode

5:00

4. Expanding multiple tables in SQL Server

7:00

5. Importing data from SQL Server Analysis Services (SSAS)

6:00

6. Setting up Azure SQL Database

7:00

7. Using Azure SQL Database in Power BI

6:00

8. Using Big Data

6:00

9. Use the Common Data Service (CDS)

3:00

Part 2 Level 9 - Other Get and Transform Topics for the DA-100 exam

1. Resolve problems

5:00

2. Configure data loading

4:00

3. Identify query performance issues

5:00

4. Apply AI Insights

5:00

5. End of Part 2

2:00

Part 3 Level 1 - An introduction to DAX functions, includin…Section 20: Part 3 Level 1 - An introduction to DAX functions, including Logical functions

1. Welcome to Part 3 - Modeling and DAX functions

2:00

2. Get multiple data sets, and connecting them together

7:00

3. The problems with direction of relationships between data sets

11:00

4. DAX functions - A useful Resource

2:00

5. Calculated columns - an introduction

4:00

6. Basic operators

5:00

7. IF, BLANK and ISBLANK

9:00

8. AND, OR and NOT

4:00

9. SWITCH

4:00

10. Other functions

3:00

Part 3 Level 2 - Statistical functions

1. Measures - an introduction, with standard aggregations including Countblank

9:00

2. Aggregation of calculations

6:00

3. Other statistical functions

6:00

Part 3 Level 3 - Mathematical functions

1. Rounding functions

8:00

2. Division functions - MOD and QUOTIENT

3:00

3. SIGN (and use with SWITCH) and ABS

6:00

4. Exponential functions

3:00

5. Other functions

3:00

Part 3 Level 4 - Text functions

1. Text searching

8:00

2. Text extraction and substitution

7:00

3. Text conversion

8:00

4. Other functions

2:00

Part 3 Level 5 - Information Functions

1. ISERROR and LOOKUPVALUE

5:00

2. Other functions

2:00

Part 3 Level 6 - Filter and Value Functions

1. RELATED

5:00

2. RELATEDTABLE and COUNTROWS

7:00

3. Context

4:00

4. ALL

6:00

5. FILTER

3:00

6. CALCULATE

3:00

7. ALLEXCEPT

6:00

8. ALLSELECTED

9:00

9. Other functions

2:00

Part 3 Level 7 - Time Intelligence Functions

1. Date and Time Functions

3:00

2. FIRSTDATE, LASTDATE

3:00

3. Start of... and End of...

6:00

4. Previous... and Next...

6:00

5. DATESINPERIOD

4:00

6. DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD

3:00

7. Opening Balance and Closing Balance

2:00

8. Semi-additive Measures

3:00

9. SAMEPERIODLASTYEAR and PARALLELPERIOD

3:00

10. Other Time Intelligence Functions

2:00

Part 3 Level 8 - Other Modeling and DAX Topics for the DA-1…Section 27: Part 3 Level 8 - Other Modeling and DAX Topics for the DA-100 exam

1. Create calculated tables

6:00

2. Create a common date table

7:00

3. Define role-playing dimensions

7:00

4. Resolve many-to-many relationships - Joint Bank Accounts

6:00

5. Resolve many-to-many relationships - Different types of granularity

6:00

6. Improve cardinality levels through summarization and by changing data types

9:00

7. Identify poorly performing measures, relationships, and visuals

6:00

8. End of Part 3

1:00

Part 4 Section 1 - An Introduction to the Power BI Service

1. Welcome to Part 4: The Power BI Service

2:00

2. Introducing The Power BI Service

4:00

3. Logging into Power BI Service and a quick look around

5:00

4. Power BI Terminology

11:00

5. Datasets and Reports in the Power BI Service

10:00

6. Get Data - Other People's Data

5:00

7. Get Data - Your Data

12:00

8. The Navigation Pane, including Add a Quick Insights result to a report

8:00

Part 4 Section 2 - Power BI Pro and adding users

1. Signing up for Power BI Pro

6:00

2. Adding new users

8:00

3. Creating a new report

8:00

4. Sharing my new report

5:00

Part 4 Section 3 - Row Level Security

1. Adding role-based Row Level Security

8:00

2. Adding Dynamic Row Level Security

10:00

3. Testing Dynamic Row Level Security in the Power BI Service

7:00

Part 4 Section 4 - Dashboards

1. Differences between dashboards and reports

5:00

2. Manage Tiles on a Dashboard, Set Mobile View, and other Tiles options

5:00

3. Dashboards: Options

4:00

4. Pin a Live Report Page to a Dashboard

4:00

5. Use the Q&A Feature

3:00

6. Add a Dashboard Theme

6:00

7. Dashboard Data Classifications

5:00

8. Configure Data Alerts

5:00

Part 4 Section 5 - Manage datasets

1. Analyze in Excel

6:00

2. Promote or Certify (Endorse) a Dataset

6:00

3. Manually Refreshing data in the Power BI Service

4:00

4. Data Gateways; Providing Access to Datasets

10:00

5. Configure a Dataset Scheduled Refresh

7:00

6. Configure Incremental Refresh Settings - Step 1

7:00

7. Configure Incremental Refresh Settings - Step 2

8:00

Part 4 Section 6 - Create and manage workspaces

1. Create and Configure a Workspace

5:00

2. Assign Workspace Roles

5:00

3. Providing Access to Datasets

5:00

4. Configure and Update a Workspace App

13:00

5. Publish, Import or Update Assets in a Workspace - Publish securely

6:00

6. Publish reports on the web, so the public can see

7:00