Learn everything about Analytics

Data Modeling with Excel Power Pivot – Lynda

Lynda
0-6 Month Online
Intermediate Contact Institute
India Business Analytics
Online Self Paced 1044
Rate this post
DescriptionProgram StructureToolsFacultyContact

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.

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

Fees:

INR 1,500 (assuming $ = INR 60)

Duration:

1hour 15 minutes

Start On: 

Contact Institute

  • Excel
  • Ron Davis
Name :
Email :
Contact Number :
Message :
Code :

Leave A Reply

Your email address will not be published.

Join 100000+ Data Scientists in our Community

Receive awesome tips, guides, infographics and become expert at:




 P.S. We only publish awesome content. We will never share your information with anyone.

Subscribe!