Visualize import and export Microsoft Dataverse data
- Offered byMicrosoft
Visualize import and export Microsoft Dataverse data at Microsoft Overview
Duration | 2 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course |
Credential | Certificate |
Visualize import and export Microsoft Dataverse data at Microsoft Course details
- Visualize data with Dataverse views
- Use Power Query to load data in Dataverse
- Use Microsoft Word and Excel templates with Dataverse
- Export data from Dataverse and use Microsoft Excel to edit records
- Use Azure and external tools to manipulate data
- This learning path will show you how to use various Dataverse views, explore how Power Query can load data into Dataverse tables, and how to use Dataverse with third-party tools
- In this module, you?ll explore how to take advantage of Dataverse views to visualize data by using only the required columns, records, and applicable sorting
Visualize import and export Microsoft Dataverse data at Microsoft Curriculum
Visualize data with Dataverse views
Introduction
Create and edit views in Power Apps maker portal
Exercise - Add columns to a view
Filter and sort data for Dataverse views
Exercise - List your accounts
Check your knowledge
Summary
Use Power Query to load data in Dataverse
Introduction
Import static data by using Power Query
Exercise – Add new accounts from a text file
Import dynamic data by using Power Query
Exercise – Transfer an attendee list to a contact table
Check your knowledge
Summary
Use Microsoft Word and Excel templates with Dataverse
Introduction
Create a dynamic Word template
Exercise – Create a work order template
Create a dynamic Excel template
Exercise – Create a sales forecasting template
Check your knowledge
Summary
Export data from Dataverse and use Microsoft Excel to edit records
Introduction
Export data to Excel
Exercise - Create an editable Excel file for bulk validation
Edit and update data in Excel
Exercise - Edit account information in Excel and visualize updates in Dataverse
Check your knowledge
Summary
Use Azure and external tools to manipulate data
Introduction
Use Dataverse community tools for data manipulation
Review Power BI integration with Dataverse
Check your knowledge
Summary