DA-100: Analyzing Data with Microsoft Power BI

Name: DA-100: Analyzing Data with Microsoft Power BI Training Course
Brand: DumpsArena
SKU: DA-100: Analyzing Data with Microsoft Power BI
Availability: InStock
Rating: 5.0 (227 reviews)

7 lectures 36m

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

7 lectures 48m

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

9 lectures 1h 1m

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

13 lectures 1h 50m

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

8 lectures 43m

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

7 lectures 1h 1m

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

5 lectures 39m

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

10 lectures 57m

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

8 lectures 49m

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

4 lectures 24m

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

6 lectures 50m

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

6 lectures 49m

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

7 lectures 56m

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

6 lectures 42m

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

6 lectures 50m

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

7 lectures 45m

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

9 lectures 52m

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

5 lectures 21m

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

10 lectures 51m

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

3 lectures 21m

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

5 lectures 23m

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

4 lectures 25m

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

2 lectures 7m

1. ISERROR and LOOKUPVALUE
5m
2. Other functions
2m

9 lectures 45m

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

10 lectures 35m

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

8 lectures 48m

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

8 lectures 57m

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

4 lectures 27m

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

3 lectures 25m

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

8 lectures 37m

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

7 lectures 48m

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

6 lectures 41m

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

Curriculum For This Course

VTSimu Exam Simulator

Hot Exams

Satisfaction Guaranteed

Why Choose DumpsBoss?

Secure Experience

Need Help?

DA-100: Analyzing Data with Microsoft Power BI

Curriculum For This Course

1. Level 1: Creating and formatting a table visualization

2. Level 2: Formatting our first visualization

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

4. Level 4: Adding more control to your visualizations

5. Level 5: 8a. Other visualizations

6. Level 6: Mapping

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

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

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

10. Part 2 Level 1 - Get Data - Home

11. Part 2 Level 2 - Getting Multiple files

12. Part 2 Level 3 - Transform Menu

13. Part 2 Level 4 - Transform - Text and Numbers

14. Part 2 Level 5 - Transform - Dates and Time

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

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

17. Part 2 Level 8 - Get other types of data

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

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

20. Part 3 Level 2 - Statistical functions

21. Part 3 Level 3 - Mathematical functions

22. Part 3 Level 4 - Text functions

23. Part 3 Level 5 - Information Functions

24. Part 3 Level 6 - Filter and Value Functions

25. Part 3 Level 7 - Time Intelligence Functions

26. 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

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

28. Part 4 Section 2 - Power BI Pro and adding users

29. Part 4 Section 3 - Row Level Security

30. Part 4 Section 4 - Dashboards

31. Part 4 Section 5 - Manage datasets

32. Part 4 Section 6 - Create and manage workspaces