DA-100: Analyzing Data with Microsoft Power BI Exam – Complete Certification Training Course & Exam Dumps

Curriculum For This Course

Level 1: Creating and formatting a table visualization

7Lectures

Time 00:36:00

Level 2: Formatting our first visualization

8Lectures

Time 00:53:00

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

9Lectures

Time 01:01:00

Level 4: Adding more control to your visualizations

13Lectures

Time 01:50:00

Level 5: 8a. Other visualizations

8Lectures

Time 00:43:00

Level 6: Mapping

7Lectures

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

5Lectures

Time 00:39:00

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

10Lectures

Time 00:57:00

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

8Lectures

Time 00:49:00

Part 2 Level 1 - Get Data - Home

4Lectures

Time 00:24:00

Part 2 Level 2 - Getting Multiple files

6Lectures

Time 00:50:00

Part 2 Level 3 - Transform Menu

6Lectures

Time 00:49:00

Part 2 Level 4 - Transform - Text and Numbers

7Lectures

Time 00:56:00

Part 2 Level 5 - Transform - Dates and Time

6Lectures

Time 00:42:00

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

6Lectures

Time 00:50:00

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

7Lectures

Time 00:45:00

Part 2 Level 8 - Get other types of data

9Lectures

Time 00:52:00

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

5Lectures

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

10Lectures

Time 00:51:00

Part 3 Level 2 - Statistical functions

3Lectures

Time 00:21:00

Part 3 Level 3 - Mathematical functions

5Lectures

Time 00:23:00

Part 3 Level 4 - Text functions

4Lectures

Time 00:25:00

Part 3 Level 5 - Information Functions

2Lectures

Time 00:07:00

Part 3 Level 6 - Filter and Value Functions

9Lectures

Time 00:45:00

Part 3 Level 7 - Time Intelligence Functions

10Lectures

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

8Lectures

Time 00:48:00

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

8Lectures

Time 00:57:00

Part 4 Section 2 - Power BI Pro and adding users

4Lectures

Time 00:27:00

Part 4 Section 3 - Row Level Security

3Lectures

Time 00:25:00

Part 4 Section 4 - Dashboards

8Lectures

Time 00:37:00

Part 4 Section 5 - Manage datasets

7Lectures

Time 00:48:00

Part 4 Section 6 - Create and manage workspaces

6Lectures

Time 00:41:00

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