Microsoft
Microsoft Logo

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 External Link Icon

Credential

Certificate

Details Icon

Visualize import and export Microsoft Dataverse data
 at 
Microsoft 
Course details

Skills you will learn
What are the course deliverables?
  • 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
More about this course
  • 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

Visualize import and export Microsoft Dataverse data
 at 
Microsoft 
Entry Requirements

Eligibility criteriaUp Arrow Icon
Conditional OfferUp Arrow Icon
  • Not mentioned

Other courses offered by Microsoft

Free
2 hours
Intermediate
Free
4 hours
Intermediate
Free
5 hours
Beginner
Free
1 hours
Beginner
View Other 1171 CoursesRight Arrow Icon
qna

Visualize import and export Microsoft Dataverse data
 at 
Microsoft 

Student Forum

chatAnything you would want to ask experts?
Write here...