Cool way to create Data Models and Relationships in Excel

Rapid Skillz

Price on request

Important information

  • Short course
  • Beginner
  • Online
  • Duration:
    1 Year
  • When:

Power BI is a suite of business analytics tools to analyze data and share insights. Power BI dashboards provide a 360-degree view for business users with their most important metrics in one place, updated in real time, and available on all of their devices. 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.

Important information
What are the course objectives?

The Objective of this course is to enable understudies to understand and 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.

Requirements: Some knowledge about basic data warehousing and data modelling concepts would be an added advantage. Working knowledge with Excel is mandatory.


Where and when

Starts Location

What you'll learn on the course

MS Excel

Course programme

This Course Consists of the following contents- 1.Publishing Excel Spreadsheets using SharePoint, 2.Study the existing ER diagram, metadata of the existing database schema, 3.Identify cardinality and design a layout for Excel based data model, 4.Using Power Query to create data models, 5.Using Power Pivot, design and manage the newly built data model, 6.Define entity relationships and check cardinality, 7.Develop Interactive Dashboards using Power Views, 8.Using Timelines and Tab views for Dashboards. With these topics and subjects and our delivery method, you will be able to understand and fulfil your position’s responsibilities. We deliver our courses with an online methodology in order to adapt ourselves to busy and professional lifestyles. Combine your professional life, your work, your personal time with this distance-learning course. If you have any doubts, do not hesitate to ask for more information through Emagister’s website.

Additional information

This Course is made for Students and they are Able to develop your own data models to gather accurate, complete and timely reports from your enterprise system, Better career oppurtunities and growth.