DA-100: Analyzing Data with Microsoft Power BI

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

What’s included

217 : Lectures
23h 3m : Duration

$14.99/24.99

Level 1: Creating and formatting a table visualization

Lectures	Duration
1. Welcome to Part 1: Visualizations- 3m	3m
2. 1b- 5m	5m
3. Viewing data- 6m	6m
4. Focus mode and Different visualizations- 3m	3m
5. Why do I need a Work email address? And how can I get one, if I don't have it?- 7m	7m
6. 10b- 5m	5m
7. Practice Activity Number 1 - The Solution- 7m	7m

Level 2: Formatting our first visualization

Lectures	Duration
1. Formatting font and font size- 5m	5m
2. Formatting colors- 5m	5m
3. Stylistic options- 7m	7m
4. 8g- 6m	6m
6. 8f- 10m	10m
7. 8i- 7m	7m
8. Practice Activity Number 2 - The Solution- 8m	8m

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

Lectures	Duration
1. Matrix- 7m	7m
2. Drill down data, see data and records, and export data- 8m	8m
3. Stacked bar charts and 8j- 7m	7m
4. Bar Chart formatting- 5m	5m
5. 8c- 9m	9m
6. Clustered and 100% Stacked bar charts- 6m	6m
7. Line and area charts, including 8b- 5m	5m
8. Combo charts (Line and column charts)- 6m	6m
9. Practice Activity Number 3 - The Solution- 8m	8m

Level 4: Adding more control to your visualizations

Lectures	Duration
1. 11a- 7m	7m
2. 11b- 7m	7m
3. Advanced Filtering- 11m	11m
4. Filter Top N Items- 5m	5m
5. Slicer- 11m	11m
6. Slicer Warning- 3m	3m
7. 8g- 7m	7m
8. 8j- 6m	6m
9. Drillthrough- 11m	11m
10. Buttons and Actions- 14m	14m
11. 11e- 8m	8m
12. Tooltip Pages- 9m	9m
13. Practice Activity Number 4 - The Solution- 11m	11m

Level 5: 8a. Other visualizations

Lectures	Duration
1. Ribbon charts- 6m	6m
2. Waterfall charts- 8m	8m
3. Scatter, bubble and dot charts- 10m	10m
4. Pie charts and donut charts- 4m	4m
5. Treemaps- 2m	2m
6. Funnel charts- 3m	3m
7. Adding Marketplace visualizations (Import a Custom Visual)- 3m	3m
8. Practice Activity Number 5 - The Solution- 7m	7m

Level 6: Mapping

Lectures	Duration
1. Maps- 8m	8m
2. Formatting maps- 5m	5m
3. 8g- 7m	7m
4. Filled Maps,Conditional Formatting, and color blindness- 10m	10m
5. Creating hierarchies- 7m	7m
6. ArcGIS Maps for Power BI- 12m	12m
7. Practice Activity Number 6 - The Solution- 12m	12m

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

Lectures	Duration
1. Gauges- 6m	6m
2. Cards and Multi-row cards- 5m	5m
3. More conditional formatting- 8m	8m
4. KPIs- 4m	4m
5. Practice Activity Number 7 - The Solution- 16m	16m

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

Lectures	Duration
1. Define quick measures- 7m	7m
2. Export report data- 4m	4m
3. Create reference lines by using Analytics pane- 10m	10m
4. Design and configure for accessibility- 6m	6m
5. Identify outliers- 3m	3m
6. Use groupings and binnings- 7m	7m
7. Use the Key Influencers to explore dimensional variances- 9m	9m
8. Use the decomposition tree visual to break down a measure- 6m	6m
9. R and Python Visualizations- 4m	4m
10. End of Part 1- 1m	1m

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

Lectures	Duration
1. Welcome to Part 2: Get and Transform Data- 2m	2m
2. Introduction - let's Get some more Data- 5m	5m
3. Exploring the Power Query Editor interface- 9m	9m
4. Introducing the M language- 9m	9m
5. Let's start look at the Home tab- 4m	4m
6. Home menu - Manage Columns- 6m	6m
7. Home menu - Reduce Rows and Use First Row as Headers- 7m	7m
8. Practice Activity Number 8 - The Solution- 7m	7m

Part 2 Level 1 - Get Data - Home

Lectures	Duration
1. Sort and Filter- 6m	6m
2. Split Column- 7m	7m
3. Other Transform activities- 10m	10m
4. Practice Activity Number 9- 1m	1m

Part 2 Level 2 - Getting Multiple files

Lectures	Duration
1. Merge Queries and Expand Table- 6m	6m
2. Merge Queries with Group By, and different types of Joins- 7m	7m
3. Appending two queries together- 5m	5m
4. Appending three or more queries together + resolving a problem with data types- 7m	7m
5. Combine Files (getting information from a folder)- 9m	9m
6. Practice Activity Number 10 - The Solution- 16m	16m

Part 2 Level 3 - Transform Menu

Lectures	Duration
1. Transform - Table and Any Column- 5m	5m
2. Pivot Column- 10m	10m
3. Unpivot- 11m	11m
4. Practice Activity 11 - The Solution- 7m	7m
5. Unpivot in conjunction with other Transform features- 10m	10m
6. Practice Activity 12 - The Solution- 6m	6m

Part 2 Level 4 - Transform - Text and Numbers

Lectures	Duration
1. Transform/Add Column - Text - Format- 6m	6m
2. Transform/Add Column - Text - Merge Columns- 8m	8m
3. Transform/Add Column - Text - Extract- 7m	7m
4. Transform/Add Column - Text - Parse- 11m	11m
5. Transform/Add Column - Number Column - Statistics and Standard- 6m	6m
6. Transform/Add Column - Other Number Column functions- 5m	5m
7. Practice Activity Number 13 - The Solution- 13m	13m

Part 2 Level 5 - Transform - Dates and Time

Lectures	Duration
1. Creating a list of dates- 8m	8m
2. Transform/Add Column - Date- 9m	9m
3. Transform/Add Column - Dates in other cultures/languages- 9m	9m
4. Transform/Add Column - Time- 6m	6m
5. Transform/Add column - Duration- 3m	3m
6. Practice Activity Number 14 - The Solution- 7m	7m

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

Lectures	Duration
1. Column from examples- 13m	13m
2. Conditional Column- 10m	10m
3. Resolving Errors from Conditional Columns- 4m	4m
4. Index Column and Duplicate Column- 4m	4m
5. Custom Column - If Then Else- 9m	9m
6. Practice Activity Number 15 - The Solution- 10m	10m

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

Lectures	Duration
1. Other M Functions- 6m	6m
2. View and Help menus, including Column Properties- 5m	5m
3. Profile the data- 2m	2m
4. Advanced Editor- 4m	4m
5. Functions and Parameters- 12m	12m
6. DateTimeZone date type and Functions- 5m	5m
7. Worked Practice Activity 16 - Dividing Annual data into Months- 11m	11m

Part 2 Level 8 - Get other types of data

Lectures	Duration
1. Introduction to SQL Server- 6m	6m
2. Importing database data into Power BI, and Query Folding- 6m	6m
3. Select a storage mode- 5m	5m
4. Expanding multiple tables in SQL Server- 7m	7m
5. Importing data from SQL Server Analysis Services (SSAS)- 6m	6m
6. Setting up Azure SQL Database- 7m	7m
7. Using Azure SQL Database in Power BI- 6m	6m
8. Using Big Data- 6m	6m
9. Use the Common Data Service (CDS)- 3m	3m

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

Lectures	Duration
1. Resolve problems- 5m	5m
2. Configure data loading- 4m	4m
3. Identify query performance issues- 5m	5m
4. Apply AI Insights- 5m	5m
5. End of Part 2- 2m	2m

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

Lectures	Duration
1. Welcome to Part 3 - Modeling and DAX functions- 2m	2m
2. Get multiple data sets, and connecting them together- 7m	7m
3. The problems with direction of relationships between data sets- 11m	11m
4. DAX functions - A useful Resource- 2m	2m
5. Calculated columns - an introduction- 4m	4m
6. Basic operators- 5m	5m
7. IF, BLANK and ISBLANK- 9m	9m
8. AND, OR and NOT- 4m	4m
9. SWITCH- 4m	4m
10. Other functions- 3m	3m

Part 3 Level 2 - Statistical functions

Lectures	Duration
1. Measures - an introduction, with standard aggregations including Countblank- 9m	9m
2. Aggregation of calculations- 6m	6m
3. Other statistical functions- 6m	6m

Part 3 Level 3 - Mathematical functions

Lectures	Duration
1. Rounding functions- 8m	8m
2. Division functions - MOD and QUOTIENT- 3m	3m
3. SIGN (and use with SWITCH) and ABS- 6m	6m
4. Exponential functions- 3m	3m
5. Other functions- 3m	3m

Part 3 Level 4 - Text functions

Lectures	Duration
1. Text searching- 8m	8m
2. Text extraction and substitution- 7m	7m
3. Text conversion- 8m	8m
4. Other functions- 2m	2m

Part 3 Level 5 - Information Functions

Lectures	Duration
1. ISERROR and LOOKUPVALUE- 5m	5m
2. Other functions- 2m	2m

Part 3 Level 6 - Filter and Value Functions

Lectures	Duration
1. RELATED- 5m	5m
2. RELATEDTABLE and COUNTROWS- 7m	7m
3. Context- 4m	4m
4. ALL- 6m	6m
5. FILTER- 3m	3m
6. CALCULATE- 3m	3m
7. ALLEXCEPT- 6m	6m
8. ALLSELECTED- 9m	9m
9. Other functions- 2m	2m

Part 3 Level 7 - Time Intelligence Functions

Lectures	Duration
1. Date and Time Functions- 3m	3m
2. FIRSTDATE, LASTDATE- 3m	3m
3. Start of..- 6m	6m
4. Previous..- 6m	6m
5. DATESINPERIOD- 4m	4m
6. DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD- 3m	3m
7. Opening Balance and Closing Balance- 2m	2m
8. Semi-additive Measures- 3m	3m
9. SAMEPERIODLASTYEAR and PARALLELPERIOD- 3m	3m
10. Other Time Intelligence Functions- 2m	2m

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

Lectures	Duration
1. Create calculated tables- 6m	6m
2. Create a common date table- 7m	7m
3. Define role-playing dimensions- 7m	7m
4. Resolve many-to-many relationships - Joint Bank Accounts- 6m	6m
5. Resolve many-to-many relationships - Different types of granularity- 6m	6m
6. Improve cardinality levels through summarization and by changing data types- 9m	9m
7. Identify poorly performing measures, relationships, and visuals- 6m	6m
8. End of Part 3- 1m	1m

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

Lectures	Duration
1. Welcome to Part 4: The Power BI Service- 2m	2m
2. Introducing The Power BI Service- 4m	4m
3. Logging into Power BI Service and a quick look around- 5m	5m
4. Power BI Terminology- 11m	11m
5. Datasets and Reports in the Power BI Service- 10m	10m
6. Get Data - Other People's Data- 5m	5m
7. Get Data - Your Data- 12m	12m
8. The Navigation Pane, including Add a Quick Insights result to a report- 8m	8m

Part 4 Section 2 - Power BI Pro and adding users

Lectures	Duration
1. Signing up for Power BI Pro- 6m	6m
2. Adding new users- 8m	8m
3. Creating a new report- 8m	8m
4. Sharing my new report- 5m	5m

Part 4 Section 3 - Row Level Security

Lectures	Duration
1. Adding role-based Row Level Security- 8m	8m
2. Adding Dynamic Row Level Security- 10m	10m
3. Testing Dynamic Row Level Security in the Power BI Service- 7m	7m

Part 4 Section 4 - Dashboards

Lectures	Duration
1. Differences between dashboards and reports- 5m	5m
2. Manage Tiles on a Dashboard, Set Mobile View, and other Tiles options- 5m	5m
3. Dashboards: Options- 4m	4m
4. Pin a Live Report Page to a Dashboard- 4m	4m
5. Use the Q&A Feature- 3m	3m
6. Add a Dashboard Theme- 6m	6m
7. Dashboard Data Classifications- 5m	5m
8. Configure Data Alerts- 5m	5m

Part 4 Section 5 - Manage datasets

Lectures	Duration
1. Analyze in Excel- 6m	6m
2. Promote or Certify (Endorse) a Dataset- 6m	6m
3. Manually Refreshing data in the Power BI Service- 4m	4m
4. Data Gateways; Providing Access to Datasets- 10m	10m
5. Configure a Dataset Scheduled Refresh- 7m	7m
6. Configure Incremental Refresh Settings - Step 1- 7m	7m
7. Configure Incremental Refresh Settings - Step 2- 8m	8m

Part 4 Section 6 - Create and manage workspaces

Lectures	Duration
1. Create and Configure a Workspace- 5m	5m
2. Assign Workspace Roles- 5m	5m
3. Providing Access to Datasets- 5m	5m
4. Configure and Update a Workspace App- 13m	13m
5. Publish, Import or Update Assets in a Workspace - Publish securely- 6m	6m
6. Publish reports on the web, so the public can see- 7m	7m