
$30.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 |
Get 100% Latest Exam Questions, Accurate & Verified Answers!
30 Days Free Updates, Instant Download!
Download 23 Sample Questions that you WILL see in your Microsoft DA-100 exam.
OR
Guarantee your success by buying the full version which covers the full latest pool of questions.
(133 Questions, Last Updated on May 11, 2022)
Free DA-100 Exam Questions & Microsoft DA-100 Dumps | ||
Microsoft.real-exams.da-100.v2022-03-16.by.clara.78q.ete |
Size: 4.54 MB
Downloads: 72
|
|
Microsoft.testkings.da-100.v2021-08-31.by.joshua.76q.ete |
Size: 4.99 MB
Downloads: 264
|
|
Microsoft.pass4sures.da-100.v2021-04-30.by.albie.56q.ete |
Size: 1.17 MB
Downloads: 413
|
|
Microsoft.passguide.da-100.v2021-02-19.by.holly.54q.ete |
Size: 1.86 MB
Downloads: 463
|
|
Microsoft.testkings.da-100.v2021-01-16.by.ethan.52q.ete |
Size: 1.86 MB
Downloads: 504
|
|
Microsoft.certkiller.da-100.v2020-11-10.by.rose.34q.ete |
Size: 1.32 MB
Downloads: 564
|
|
Microsoft.certkiller.da-100.v2020-08-29.by.lacey.25q.ete |
Size: 958.13 KB
Downloads: 640
|
Only Registered Members
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.. Registration is Free and Easy, You Simply need to provide an email address.
Log into your Prepaway Account
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register