CLASSROOM AND ONLINE CLASSES

This is the most comprehensive Data Analytics course available, covering all steps of the Data Analytics process from Data Integration, Data Manipulation, Descriptive Analytics and Visualization to Statistical Analysis, using the most in-demand tools like Excel, VBA, SQL SERVER, and Tableau. It will enable you to master all the elements of Data Analytics and Visualization.

Next Batch
12th May’19 (SUNDAY) |  10:00 AM – 1:00 PM | CLASSROOM (GURGAON) + LIVE ONLINE

 

70+ Assignments

Start Learning

 

Real-life Case Studies
Lifetime Access
300 plus Interview Questions

 

TOOLS & CURRICULUM COVERED

EXCEL | VBA | SQL SERVER | TABLEAU | PYTHON

Course Curriculum

SECTION 1: DATA FORMATTING
Custom Formatting – Part 1FREE 00:09:00
Custom Formatting – Part2FREE 00:15:00
Conditional Formatting – Part 1 00:16:00
Conditional Formatting – Part2 00:16:00
SECTION 2: FORMULAS AND FUNCTIONS
Dollar Use and IF Formula 00:11:00
Data Validation 00:18:00
SECTION 3: WHATIF ANALYSIS AND GOAL SEEK
Goal Seek in Excel 00:04:00
SECTION 4: ADVANCED FORMULAS
Text Functions in Excel 00:09:00
Offset, Index and Match Formulas 00:08:00
VLOOKUP and HLOOKUP Formulas 00:07:00
SECTION 5: PIVOT TABLES
Pivot Table Designing 00:11:00
Pivot Table Designing Part2 00:16:00
Pivot Table-Part 2 (Show Values As and Group By) 00:16:00
Calculated Fields 00:15:00
Pivot Charts 00:11:00
Pivot Slicer and Dashboard 00:17:00
SECTION 6: CHARTING
Chart Creation in Excel 00:08:00
SECTION 7: CUSTOM CHARTS
Custom Indicators in Excel Charts 00:09:00
Bullet Graph in Excel 00:12:00
Step Chart in Excel 00:07:00
Progress Chart in Excel 00:06:00
Pareto Chart in Excel 00:10:00
Bump Chart in Excel 00:17:00
Waterfall Chart in Excel 00:06:00
SECTION 8: INTERACTIVE CHARTS
Name Ranges in Excel 00:07:00
Interactive Chart Using Combobox 00:06:00
Interactive Chart Using Radio Button 00:16:00
SECTION 9: DASHBOARDING
SALES DASHBOARD: Introduction 00:03:00
Sales Dashboard: Section1 Introduction 00:05:00
Sales Dashboard: Section 1 00:21:00
Sales Dashboard: Section2 00:17:00
Sales Dashboard: Section3 00:17:00
Sales Dashboard: Section 4 00:00:00
Sales Dashboard: Section 5 00:16:00
Sales Dashboard: Final Formatting 00:12:00
SECTION 10: CALL CENTER DASHBOARD
Call Center – Dashboard Understanding 00:04:00
Call Center: Section 1 Part 1 00:23:00
Call Center: Section1 Part 2 00:19:00
Call Center: Section 2 – Part 1 00:20:00
Call Center – Section 2 – Part 2 00:10:00
Call Center – Section 3 00:11:00
Call Center: Final Formatting 00:06:00
VBA
SECTION 1: COURSE INTRODUCTION AND OVERVIEW
SECTION 2: VBA AND VBE UNDERSTANDING
SECTION 3: LOGICAL STATEMENTS
SECTION 4: LOOPS
SECTION 5: USERFORM
SECTION 6: ERROR HANDLING
SECTION 7 : BUILT IN AND USER DEFINED FUNCTIONS
SECTION 8: EVENTS
SECTION 9: CHARTS AND PIVOT TABLE CREATION
SECTION 10: ADO
SQL SERVER
SECTION 1: COURSE AND PRODUCT INTRODUCTION
SECTION 1: INTRODUCTION TO SQL SERVER
SECTION 2: USER AND AUTHENTICATIONS
SECTION 3: TABLES, PRIMARY KEY AND FOREIGN KEY
SECTION 4: SELECT STATMENTS
SECTION 5: FUNCTIONS
SECTION 6: JOINS AND VIEWS
SECTION 7: STORED PROCEDURES
SECTION 8: TEMPORARY TABLES
SECTION 9: TRANSACTIONS
TABLEAU
SECTION 2: DATA IMPORT
SECTION 3: JOINS, UNION AND DATA CONNECTIONS
SECTION 4: WORKSHEET OVERVIEW
SECTION 5: PERCENTAGE CALCULATIONS
SECTION 6: CHARTING
How to perform Cohort Analysis in TableauFREE 00:08:00
The cohort is a subset of users who are grouped by shared characteristics. Learn how to perform cohort analysis in tableau.
SECTION 7: CALCULATED FIELD & PARAMETERS
SECTION 8: FILTERS & SETS
SECTION 9: ACTIONS
SECTION 10: DASHBOARDING
SECTION 11: STORIES
SECTION 12: TABLEAU SERVER
LIVE CLASS RECORDINGS
Recordings – Excel Charting Day1 01:20:00
Recording – Excel Chart Day 2 00:42:00
Excel Chart Day3 00:54:00
Excel Pivot Table Day1 00:50:00
Recording – Pivot Table Day 2 01:12:00
Recording – Sales Dashboard 01:03:00
Recording – VBA Day 1 01:10:00
Recording – VBA Day 2 01:26:00
Recording VBA Day 3 00:00:00
Recording VBA Day 4 00:00:00
Recording VBA Day 5 00:00:00
Recording VBA DAY 6 00:00:00
ADO – Part 1 00:00:00
ADO – Part 2 00:00:00
SQL Day1 01:34:00
SQL Day2 01:33:00
SQL Day3 01:41:00
Tableau Day1 01:04:00
Tableau Day2 02:00:00
Recording – Tableau Day 3 01:43:00
Recording – Tableau Day 4 01:36:00
Recording Tableau Day 5 01:30:00
Live Recordings - Mar'19
Day1 – Data Analysis and Visualization – Mar’19FREE 00:00:00
Day2 – Data Analysis and Visualization – Mar’19 00:00:00
Day3- March’19 00:00:00
Day4 – March’19 00:00:00
Day5 – March’19 00:00:00
Day6 – March’19 00:00:00
Day7-March’19 00:00:00
Day8-March’19 00:00:00
Day9-Mar’19 (VBA Consolidation) 00:00:00

Course Reviews

5

5
55 ratings
  • 5 stars1
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. A Non-Tech Professional Moves to Analytics

    5

    The quality of course content is really good and neatly explained by Lokesh Paliwal with real time examples, Case studies , assignments , projects work helped a lot to be perfect whatever I learnt during the training sessions,he is very well versed with domain knowledge and having corporate experience in respective field .. Thank you Lokesh Paliwal .

5024 STUDENTS ENROLLED

Testimonials

I’d received very good feedback about Lokesh even before I signed up for his course. Few of my last organisation colleague have done “Data Analytics for Essentials” program from him and are now...Read more

Data Analysis Training Feedback

Kartika Saraswat

Report Analyst (WNS)

Recent Posts

Tableau Training in Delhi

All Rights Reserved. EC Analytics Consulting 2014 - 2019.

NM 23, Sector 14, OLD DLF Colony - Gurgaon (Haryana) India. 886547882