Microsoft Dataverse is the sophisticated and secure backbone that powers Dynamics 365 and Power Platform. This low-code data platform is rapidly changing the way organizations around the world build apps and innovate business processes. Dataverse lets you securely store and manage data that’s used by business applications. Data within Dataverse is stored within a set of tables. Dataverse includes a base set of standard tables that cover typical scenarios, but you can also create custom tables specific to your organization and populate them with data by using Power Query.
Overview
COURSE DIFFICULTY
COURSE DURATION
7h 30m
Skills Learned
After completing this online training course, students will be able to:
Create and analyze data with PivotTables
Create charts and visualizations for data presentation
Transform data using Power Query in Excel
Design interactive Excel dashboards
Excel Power Users, Business Analysts, Data Analysts
None
01. The Value of Pivot Tables (The Business Intelligence Life Cycle)
02. The Value of Pivot Tables (Why You Care About Pivot Tables)
03. The Value of Pivot Tables (Creating Your First Pivot Table)
04. Pivot Compliant Data Sets (Required Data Layout)
05. Pivot Compliant Data Sets (Connecting to your Source Data)
06. Pivot Compliant Data Sets (Using Data Direct from Databases)
07. Modifying Pivot Table Look & Feel (Value Field Formats)
08. Modifying Pivot Table Look & Feel (Report Layout)
09. Modifying Pivot Table Look & Feel (Grouping Data)
10. Modifying Pivot Table Look & Feel (PivotTable Styles)
11. Modifying Pivot Table Look & Feel (Sorting PivotTables)
12. Sourcing Data (Using Power Query to Get & Transform your Data)
13. Sourcing Data (Appending Data Tables)
14. Sourcing Data (Consolidating Excel Data)
15. Sourcing Data (Un-pivoting Data)
16. Sourcing Data (Flattening Datasets)
17. Changing Pivot Table Aggregations (SUM, COUNT and Others)
18. Changing Pivot Table Aggregations (Show Values As)
19. Changing Pivot Table Aggregations (Calculated Fields)
20. Slicing and Filtering (Filtering with Classic Controls)
21. Slicing and Filtering (Filtering with Slicers)
22. Slicing and Filtering (Timelines)
23. Slicing and Filtering (The Show Details Feature)
24. Slicing and Filtering (Keeping Your Pivots Looking Nice)
25. Building Pivot Based Dashboards (Conditional Formatting on Pivots)
26. Building Pivot Based Dashboards (Keeping Pivots in Sync)
27. Building Pivot Based Dashboards (Tricks for Extracting Key Info)
28. Building Pivot Based Dashboards (Working with Pivot Charts)
29. Data Refresh & Security (Driving Pivot Table Refresh)
30. Data Refresh & Security (How Secure is Your Data)
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Create and analyze data with PivotTables
Create charts and visualizations for data presentation
Transform data using Power Query in Excel
Design interactive Excel dashboards
WHO SHOULD ATTEND
Excel Power Users, Business Analysts, Data Analysts
PREREQUISITES
None
COURSE OUTLINE
01. The Value of Pivot Tables (The Business Intelligence Life Cycle)
02. The Value of Pivot Tables (Why You Care About Pivot Tables)
03. The Value of Pivot Tables (Creating Your First Pivot Table)
04. Pivot Compliant Data Sets (Required Data Layout)
05. Pivot Compliant Data Sets (Connecting to your Source Data)
06. Pivot Compliant Data Sets (Using Data Direct from Databases)
07. Modifying Pivot Table Look & Feel (Value Field Formats)
08. Modifying Pivot Table Look & Feel (Report Layout)
09. Modifying Pivot Table Look & Feel (Grouping Data)
10. Modifying Pivot Table Look & Feel (PivotTable Styles)
11. Modifying Pivot Table Look & Feel (Sorting PivotTables)
12. Sourcing Data (Using Power Query to Get & Transform your Data)
13. Sourcing Data (Appending Data Tables)
14. Sourcing Data (Consolidating Excel Data)
15. Sourcing Data (Un-pivoting Data)
16. Sourcing Data (Flattening Datasets)
17. Changing Pivot Table Aggregations (SUM, COUNT and Others)
18. Changing Pivot Table Aggregations (Show Values As)
19. Changing Pivot Table Aggregations (Calculated Fields)
20. Slicing and Filtering (Filtering with Classic Controls)
21. Slicing and Filtering (Filtering with Slicers)
22. Slicing and Filtering (Timelines)
23. Slicing and Filtering (The Show Details Feature)
24. Slicing and Filtering (Keeping Your Pivots Looking Nice)
25. Building Pivot Based Dashboards (Conditional Formatting on Pivots)
26. Building Pivot Based Dashboards (Keeping Pivots in Sync)
27. Building Pivot Based Dashboards (Tricks for Extracting Key Info)
28. Building Pivot Based Dashboards (Working with Pivot Charts)
29. Data Refresh & Security (Driving Pivot Table Refresh)
30. Data Refresh & Security (How Secure is Your Data)
