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
4.4 (7 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
437 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 15
  • Length 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English

Course Description

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?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

GreyCampus Inc., Professional Certification and Competitive Exam Trainings

GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.

Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.

Ready to start learning?
Take This Course