Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Cool way to create Data Models and Relationships in Excel
Introduction
Introduction (3:26)
Publishing Excel Spreadsheets using SharePoint
Publishing Excel Spreadsheets using SharePoint (10:13)
Study the existing ER diagram, metadata of the existing database schema
Study the existing ER diagram metadata of the existing database schema-HD (8:38)
Identify cardinality and design a layout for Excel based data model
Identify cardinality and design a layout for Excel based (19:15)
Using Power Query to create data models
Using Power Query to create data models (13:20)
Using Power Pivot, design and manage the newly built data model
Using Power Pivot, design and manage the newly built (8:04)
Define entity relationships and check cardinality
Define entity relationships and check cardinality (9:20)
Develop Interactive Dashboards using Power Views
Develop Interactive Dashboards using Power Views (9:42)
Using Timelines and Tab views for Dashboards
Using timelines Part 1 (16:16)
Using timelines Part 2 (12:13)
Mock Test
Mock Test
Using Power Pivot, design and manage the newly built
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock