After completing this course you will be able to analyse more complex data. You will learn the fundamentals of analyzing not only a single table (an Excel PivotTable limitation) but you will query more tables at the same time. You will also learn how to produce engaging reports, i.e. dashboards, that can easily integrate information coming from various sources.

Benefits to your Organization
Big data analytics is the process of evaluating large sets of data containing varying types of data. This is done in order to uncover hidden data patterns, market trends and customer preferences and behavior. Using big data will help you to make better informed decisions regarding many areas of your business. This data can be gathered from both traditional and digital sources.


Any person who has familiarity with Excel at intermediate level or who has completed the DMAE (Data management and Analysis with Advance Excel) course from I-Mind.

: 8 hrs

Introduction to Big Data Analytics What is Big Data Analytics. How Excel can help in Big Data Analysis.

Understanding Power Pivot
What is Power Pivot? Why use Power Pivot? Excel versus Power Pivot.

Installing Power Pivot
How to activate Power Pivot and Con-necting with data.

Working with Data
Working with an Excel Table, Cleaning up table and working with normalized tables.

Importing Data into Power Pivot
Adding and importing data in Power Pivot.

Creating the Relational Data Model
Creating a Data Model, Understanding Key fields & managing relationships.

Working with DAX Formulas
Understanding Data Analysis Expres-sions, how to create and use them. Creating calculated fields.

Data Analysis with Pivot Tables and Pivot Charts
Creating charts from Power Pivot data and analyzing the impact.

Setting up Hierarchies
Setting up hierarchies in Pivot Table to make navigation easier.

Slicer in Pivots
Adding slicer in Pivot tables to make data more accessible.

Creating Dashboards

Creating Dashboards with formulas that can read directly from the Data Model.

Creating KPI

Creating Key Performance Indicators in Power Pivot.

What Next
Having successfully completed the BIG DATA+ training. We assume that you would spend some time (at least a week) in implementing the learning in your work environment. After implementing the learning, you would then be eligible to join further training on RDBMS. Visit to know more.