Learn everything about Analytics

Data Modeling with Excel Power Pivot – Lynda

0-6 Month Online
Intermediate Contact Institute
India Business Analytics
Online Self Paced 2226


[su_tab title = “Description”]

Aggregating and analyzing data from different sources is made easy with Excel’s Power Pivot plugin. But before you can glean insights from your data, you’ll need to know how to build an effective data model, or collection of tables. In this course, Ron Davis covers all the steps for data modeling with Excel: adding data sources, setting up relationships between tables, and configuring hierarchies. Additionally, he explores the power of DAX, the language behind the calculated columns and calculated fields that make for powerful PivotTables.


[su_tab title = “Program Structure”]

Course Program:

  • Data modeling concepts and terminology
  • Exploring the Power Pivot interface
  • Adding data sources
  • Working with date tables
  • Understanding perspectives and key performance indicators (KPIs)
  • Getting started with DAX syntax
  • Understanding evaluation context


INR 1,500 (assuming $ = INR 60)


1hour 15 minutes

Start On: 

Contact Institute


[su_tab title = “Tools”]

  • Excel


[su_tab title = “Faculty”]

  • Ron Davis


[su_tab title = “Contact”]

Name :
Email :
Contact Number :
Message :
Code :



This article is quite old and you might not get a prompt response from the author. We request you to post this comment on Analytics Vidhya's Discussion portal to get your queries resolved