Cool way to create Data Models and Relationships in Excel

Develop your skills and knowledge on how to create a data models for your enterprise

This course enables you to develop your own data models to gather accurate, complete and timely reports from your enterprise system. Whether you are new to Excel or an advanced user, Grey Campus Power course will cover what you need to know to become a Power BI User.
In this course, we will cover the various topics about the power BI which includes:

• How to publish Excel Spreadsheets using SharePoint
• ER diagrams
• Designing a layout for Excel based data model
• How to use a Power Query to create data models
• Power Pivot, design and manage the newly built data model
• Develop Interactive Dashboards using Power Views

Each and every topic mentioned above are explained in detail in the Hands-on videos. Excercises and datasets included in this course are useful to practice and implement the concepts learned in this course.
This course is is intended for the analysts and business users who are willing to explore the Power BI tools present in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.

What are the requirements?

• Some knowledge of basic word processing, computing, and spreadsheets
• Familiarity with the Microsoft Office work environment

What am I going to get from this course?

• Over 14 lectures and 2 hours of content!
• Build a report using Power View
• Hide columns, sort, change data types, and filter
• Create calculated fields and calculated columns
• Add a calculated field from the pivot table
• Develop Interactive Dashboards using Power Views
• Manage data sources and queries

What is the target audience?

• Anyone who uses MS Excel as part of their job or profession can choose this course
• There is no eligibility Criteria

Curriculum
Section 1: Course Introduction
Lecture 1 Course Introduction 03:26
Section 2: Publishing Excel Spreadsheets using SharePoint
Lecture 2 Publishing Excel Spreadsheets using SharePoint 10:13
Section 3: Study the existing ER diagram, metadata of the existing database schema
Lecture 3 Study the existing ER diagram, metadata of the existing database schema 08:38
Section 4: Identify cardinality and design a layout for Excel based data model
Lecture 4 Identify cardinality and design a layout for Excel based data model 19:15
Section 5: Using Power Query to create data models
Lecture 5 Using Power Query to create data models 13:20
Section 6: Using Power Pivot, design and manage the newly built data model
Lecture 6 Using Power Pivot, design and manage the newly built data model 08:04
Section 7: Define entity relationships and check cardinality
Lecture 7 Define entity relationships and check cardinality 09:20
Section 8: Develop Interactive Dashboards using Power Views
Lecture 8 Develop Interactive Dashboards using Power Views 09:42
Section 9: Using Timelines and Tab views for Dashboards
Lecture 9 Using Timelines and Tab views for Dashboards Part 1 16:16
Lecture 10 Using Timelines and Tab views for Dashboards Part 2 12:13
Section 10: Additional Material
Lecture 11 Additional Material Text
Section 11: Exercises
Lecture 12 Exercises Text
Section 12: Mock Test
Quiz 1 Mock Test 20 questions
Section 13: Course Conclusion
Lecture 13 Review Appreciated Text
Lecture 14 Quick Bonus for You! Text







For More Rare Movies Check out my blog!

No Mirrors Please