Cool way to create Data Models and Relationships in Excel
1.9 (4 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.
442 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Cool way to create Data Models and Relationships in Excel to your Wishlist.

Add to Wishlist

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
1.9 (4 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.
442 students enrolled
Last updated 1/2016
English
Current price: $10 Original price: $30 Discount: 67% off
6 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 5 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
Requirements
  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 15 Lectures Collapse All 15 Lectures 01:51:47
+
Course Introduction
1 Lecture 03:26
+
Publishing Excel Spreadsheets using SharePoint
1 Lecture 10:13
+
Study the existing ER diagram, metadata of the existing database schema
1 Lecture 08:38
Study the existing ER diagram, metadata of the existing database schema
08:38
+
Identify cardinality and design a layout for Excel based data model
1 Lecture 19:15
Identify cardinality and design a layout for Excel based data model
19:15
+
Using Power Query to create data models
1 Lecture 13:20
Using Power Query to create data models
13:20
+
Using Power Pivot, design and manage the newly built data model
1 Lecture 08:04
Using Power Pivot, design and manage the newly built data model
08:04
+
Define entity relationships and check cardinality
1 Lecture 09:20
+
Develop Interactive Dashboards using Power Views
1 Lecture 09:42
Develop Interactive Dashboards using Power Views
09:42
+
Using Timelines and Tab views for Dashboards
2 Lectures 28:29

Using Timelines and Tab views for Dashboards Part 2
12:13
+
Additional Material and Dataset
2 Lectures 00:07
Additional Material
00:02

Dataset
00:04
3 More Sections
About the Instructor
GreyCampus Inc.
4.1 Average rating
1,625 Reviews
19,322 Students
37 Courses
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.