Practice Exams:

View All

DA-100: Analyzing Data with Microsoft Power BI

PDFs and exam guides are not so efficient, right? Prepare for your Microsoft examination with our training course. The DA-100 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft DA-100 test with flying colors.

Rating

4.47

Students

Duration

23:08:00 h

$16.49

$14.99

Curriculum for DA-100 Video Course

Level 1: Creating and formatting a table visualization

7 Lectures

Time 00:36:00

Level 2: Formatting our first visualization

8 Lectures

Time 00:53:00

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

9 Lectures

Time 01:01:00

Level 4: Adding more control to your visualizations

13 Lectures

Time 01:50:00

Level 5: 8a. Other visualizations

8 Lectures

Time 00:43:00

Level 6: Mapping

7 Lectures

Time 01:01:00

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

5 Lectures

Time 00:39:00

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

10 Lectures

Time 00:57:00

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

8 Lectures

Time 00:49:00

Part 2 Level 1 - Get Data - Home

4 Lectures

Time 00:24:00

Part 2 Level 2 - Getting Multiple files

6 Lectures

Time 00:50:00

Part 2 Level 3 - Transform Menu

6 Lectures

Time 00:49:00

Part 2 Level 4 - Transform - Text and Numbers

7 Lectures

Time 00:56:00

Part 2 Level 5 - Transform - Dates and Time

6 Lectures

Time 00:42:00

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

6 Lectures

Time 00:50:00

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

7 Lectures

Time 00:45:00

Part 2 Level 8 - Get other types of data

9 Lectures

Time 00:52:00

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

5 Lectures

Time 00:21: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

10 Lectures

Time 00:51:00

Part 3 Level 2 - Statistical functions

3 Lectures

Time 00:21:00

Part 3 Level 3 - Mathematical functions

5 Lectures

Time 00:23:00

Part 3 Level 4 - Text functions

4 Lectures

Time 00:25:00

Part 3 Level 5 - Information Functions

2 Lectures

Time 00:07:00

Part 3 Level 6 - Filter and Value Functions

9 Lectures

Time 00:45:00

Part 3 Level 7 - Time Intelligence Functions

10 Lectures

Time 00:35: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

8 Lectures

Time 00:48:00

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

8 Lectures

Time 00:57:00

Part 4 Section 2 - Power BI Pro and adding users

4 Lectures

Time 00:27:00

Part 4 Section 3 - Row Level Security

3 Lectures

Time 00:25:00

Part 4 Section 4 - Dashboards

8 Lectures

Time 00:37:00

Part 4 Section 5 - Manage datasets

7 Lectures

Time 00:48:00

Part 4 Section 6 - Create and manage workspaces

6 Lectures

Time 00:41:00

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
1. Sort and Filter	6:00
2. Split Column	7:00
3. Other Transform activities	10:00
4. Practice Activity Number 9	1:00

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
1. Measures - an introduction, with standard aggregations including Countblank	9:00
2. Aggregation of calculations	6:00
3. Other statistical functions	6:00

Name of Video	Time
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

Name of Video	Time
1. Text searching	8:00
2. Text extraction and substitution	7:00
3. Text conversion	8:00
4. Other functions	2:00

Name of Video	Time
1. ISERROR and LOOKUPVALUE	5:00
2. Other functions	2:00

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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