Certification training

DA-100DA-100: Analyzing Data with Microsoft Power BI

Prepare for your Microsoft exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

217Lectures
23h 3mDuration
MicrosoftVendor
DA-100: Analyzing Data with Microsoft Power BI course cover Best seller
Microsoft certification training DA-100 217 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

32 sections, 217 lessons, and lecture-level duration details.

01 Welcome to Part 1: Visualizations 3m
02 1b 5m
03 Viewing data 6m
04 Focus mode and Different visualizations 3m
05 Why do I need a Work email address? And how can I get one, if I don't have it? 7m
06 10b 5m
07 Practice Activity Number 1 - The Solution 7m

01 Formatting font and font size 5m
02 Formatting colors 5m
03 Stylistic options 7m
04 8g 6m
06 8f 10m
07 8i 7m
08 Practice Activity Number 2 - The Solution 8m

01 Matrix 7m
02 Drill down data, see data and records, and export data 8m
03 Stacked bar charts and 8j 7m
04 Bar Chart formatting 5m
05 8c 9m
06 Clustered and 100% Stacked bar charts 6m
07 Line and area charts, including 8b 5m
08 Combo charts (Line and column charts) 6m
09 Practice Activity Number 3 - The Solution 8m

01 11a 7m
02 11b 7m
03 Advanced Filtering 11m
04 Filter Top N Items 5m
05 Slicer 11m
06 Slicer Warning 3m
07 8g 7m
08 8j 6m
09 Drillthrough 11m
10 Buttons and Actions 14m
11 11e 8m
12 Tooltip Pages 9m
13 Practice Activity Number 4 - The Solution 11m

01 Ribbon charts 6m
02 Waterfall charts 8m
03 Scatter, bubble and dot charts 10m
04 Pie charts and donut charts 4m
05 Treemaps 2m
06 Funnel charts 3m
07 Adding Marketplace visualizations (Import a Custom Visual) 3m
08 Practice Activity Number 5 - The Solution 7m

01 Maps 8m
02 Formatting maps 5m
03 8g 7m
04 Filled Maps,Conditional Formatting, and color blindness 10m
05 Creating hierarchies 7m
06 ArcGIS Maps for Power BI 12m
07 Practice Activity Number 6 - The Solution 12m

01 Gauges 6m
02 Cards and Multi-row cards 5m
03 More conditional formatting 8m
04 KPIs 4m
05 Practice Activity Number 7 - The Solution 16m

01 Define quick measures 7m
02 Export report data 4m
03 Create reference lines by using Analytics pane 10m
04 Design and configure for accessibility 6m
05 Identify outliers 3m
06 Use groupings and binnings 7m
07 Use the Key Influencers to explore dimensional variances 9m
08 Use the decomposition tree visual to break down a measure 6m
09 R and Python Visualizations 4m
10 End of Part 1 1m

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

01 Sort and Filter 6m
02 Split Column 7m
03 Other Transform activities 10m
04 Practice Activity Number 9 1m

01 Merge Queries and Expand Table 6m
02 Merge Queries with Group By, and different types of Joins 7m
03 Appending two queries together 5m
04 Appending three or more queries together + resolving a problem with data types 7m
05 Combine Files (getting information from a folder) 9m
06 Practice Activity Number 10 - The Solution 16m

01 Transform - Table and Any Column 5m
02 Pivot Column 10m
03 Unpivot 11m
04 Practice Activity 11 - The Solution 7m
05 Unpivot in conjunction with other Transform features 10m
06 Practice Activity 12 - The Solution 6m

01 Transform/Add Column - Text - Format 6m
02 Transform/Add Column - Text - Merge Columns 8m
03 Transform/Add Column - Text - Extract 7m
04 Transform/Add Column - Text - Parse 11m
05 Transform/Add Column - Number Column - Statistics and Standard 6m
06 Transform/Add Column - Other Number Column functions 5m
07 Practice Activity Number 13 - The Solution 13m

01 Creating a list of dates 8m
02 Transform/Add Column - Date 9m
03 Transform/Add Column - Dates in other cultures/languages 9m
04 Transform/Add Column - Time 6m
05 Transform/Add column - Duration 3m
06 Practice Activity Number 14 - The Solution 7m

01 Column from examples 13m
02 Conditional Column 10m
03 Resolving Errors from Conditional Columns 4m
04 Index Column and Duplicate Column 4m
05 Custom Column - If Then Else 9m
06 Practice Activity Number 15 - The Solution 10m

01 Other M Functions 6m
02 View and Help menus, including Column Properties 5m
03 Profile the data 2m
04 Advanced Editor 4m
05 Functions and Parameters 12m
06 DateTimeZone date type and Functions 5m
07 Worked Practice Activity 16 - Dividing Annual data into Months 11m

01 Introduction to SQL Server 6m
02 Importing database data into Power BI, and Query Folding 6m
03 Select a storage mode 5m
04 Expanding multiple tables in SQL Server 7m
05 Importing data from SQL Server Analysis Services (SSAS) 6m
06 Setting up Azure SQL Database 7m
07 Using Azure SQL Database in Power BI 6m
08 Using Big Data 6m
09 Use the Common Data Service (CDS) 3m

01 Resolve problems 5m
02 Configure data loading 4m
03 Identify query performance issues 5m
04 Apply AI Insights 5m
05 End of Part 2 2m

01 Welcome to Part 3 - Modeling and DAX functions 2m
02 Get multiple data sets, and connecting them together 7m
03 The problems with direction of relationships between data sets 11m
04 DAX functions - A useful Resource 2m
05 Calculated columns - an introduction 4m
06 Basic operators 5m
07 IF, BLANK and ISBLANK 9m
08 AND, OR and NOT 4m
09 SWITCH 4m
10 Other functions 3m

01 Measures - an introduction, with standard aggregations including Countblank 9m
02 Aggregation of calculations 6m
03 Other statistical functions 6m

01 Rounding functions 8m
02 Division functions - MOD and QUOTIENT 3m
03 SIGN (and use with SWITCH) and ABS 6m
04 Exponential functions 3m
05 Other functions 3m

01 Text searching 8m
02 Text extraction and substitution 7m
03 Text conversion 8m
04 Other functions 2m

01 ISERROR and LOOKUPVALUE 5m
02 Other functions 2m

01 RELATED 5m
02 RELATEDTABLE and COUNTROWS 7m
03 Context 4m
04 ALL 6m
05 FILTER 3m
06 CALCULATE 3m
07 ALLEXCEPT 6m
08 ALLSELECTED 9m
09 Other functions 2m

01 Date and Time Functions 3m
02 FIRSTDATE, LASTDATE 3m
03 Start of.. 6m
04 Previous.. 6m
05 DATESINPERIOD 4m
06 DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD 3m
07 Opening Balance and Closing Balance 2m
08 Semi-additive Measures 3m
09 SAMEPERIODLASTYEAR and PARALLELPERIOD 3m
10 Other Time Intelligence Functions 2m

01 Create calculated tables 6m
02 Create a common date table 7m
03 Define role-playing dimensions 7m
04 Resolve many-to-many relationships - Joint Bank Accounts 6m
05 Resolve many-to-many relationships - Different types of granularity 6m
06 Improve cardinality levels through summarization and by changing data types 9m
07 Identify poorly performing measures, relationships, and visuals 6m
08 End of Part 3 1m

01 Welcome to Part 4: The Power BI Service 2m
02 Introducing The Power BI Service 4m
03 Logging into Power BI Service and a quick look around 5m
04 Power BI Terminology 11m
05 Datasets and Reports in the Power BI Service 10m
06 Get Data - Other People's Data 5m
07 Get Data - Your Data 12m
08 The Navigation Pane, including Add a Quick Insights result to a report 8m

01 Signing up for Power BI Pro 6m
02 Adding new users 8m
03 Creating a new report 8m
04 Sharing my new report 5m

01 Adding role-based Row Level Security 8m
02 Adding Dynamic Row Level Security 10m
03 Testing Dynamic Row Level Security in the Power BI Service 7m

01 Differences between dashboards and reports 5m
02 Manage Tiles on a Dashboard, Set Mobile View, and other Tiles options 5m
03 Dashboards: Options 4m
04 Pin a Live Report Page to a Dashboard 4m
05 Use the Q&A Feature 3m
06 Add a Dashboard Theme 6m
07 Dashboard Data Classifications 5m
08 Configure Data Alerts 5m

01 Analyze in Excel 6m
02 Promote or Certify (Endorse) a Dataset 6m
03 Manually Refreshing data in the Power BI Service 4m
04 Data Gateways; Providing Access to Datasets 10m
05 Configure a Dataset Scheduled Refresh 7m
06 Configure Incremental Refresh Settings - Step 1 7m
07 Configure Incremental Refresh Settings - Step 2 8m

01 Create and Configure a Workspace 5m
02 Assign Workspace Roles 5m
03 Providing Access to Datasets 5m
04 Configure and Update a Workspace App 13m
05 Publish, Import or Update Assets in a Workspace - Publish securely 6m
06 Publish reports on the web, so the public can see 7m
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.