Share Now

Data Analytics course is designed to help you become a successful Data Analyst, this course is for those just starting their career in Analytics. It will teach you how to make powerful dashboards, macros, and SQL along with a strong focus on case studies to ensure hands-on learning. Once armed with the analytics, you will also learn the powerful Data visualization tool Tableau to present your analysis. We also conduct Excel Corporate training across the globe.
Course duration: 50 hours (50 hours live training + Practice and Self-study)


Advanced Excel, Excel Macro’s(VBA), SQL, Statistics Essentials, and Tableau

[bscolumns class=”one_half”]

Report Visualization – Dashboard Designing

Advanced Excel

  • Explanation of data calculation in Excel
  • Use of Shortcuts
  • Formatting and Conditional Formatting
  • Working with Formulas – Logical and Text Functions
  • Understanding about Sorting, Filtering, and Data Validation
  • Data Analysis using Pivot Tables

Introduction to Charts and Functions

  • Understanding of Mathematical, Statistical Functions
  • Worksheet and Workbook Protection and Security
  • Understanding of Name Ranges
  • Introduction of Charts
  • Introduction of Form Controls
  • Understanding of Data Tools Panel
  • Basics of Macro Recording

Dashboard Designing

  • Overview of Dashboards
  • Deciding on Dashboards
  • Trends and Scenarios using charts
  • Advanced Charting Techniques using Thermometer, Doughnut, Pareto, Panel and Step Chart
  • Designing Sample Dashboard using Form Controls
  • Tips and Tricks to enhance dashboard designing

Statistics Essentials for Reporting

  • Scatter Plot
  • Quadrant Analysis
  • Histogram
  • Paret Chart
  • Normal Distribution
  • Calculation of Standard Deviation and Variance
  • Understanding of Least Square Error
  • Simple Linear Regression
  • Multi-Linear Regression
  • Logistic Regression
  • RFM Segmentation

[bscolumns class=”one_half”]

Report Automation Using VBA and SQL

Excel Macros ( Visual Basic for Applications)

  • Working with VBE (Visual Basic Editor)
  • Introduction to Excel Object Model
  • Understanding of Sub and Function Procedures
  • Key Component of Programming Language
  • Understanding of If, Select Case, With End With Statements
  • Looping with VBA
  • User Defined Function
  • Some Commonly Used Macro Examples
  • Error Handling
  • Object and Memory Management in VBA
  • User Form Controls
  • ActiveX Controls
  • Communicating with Database MS Access through ADO – Exporting/Importing Data


  • SQL Basics
  • Getting Started with SQL Management Studio
  • Understanding of RDBMS concept
  • Data Manipulation – Reading, Manipulating, and Functions
  • DDL,DML,DCL,DQL Commands
  • Data Aggregation & Summarization
  • Concept of Indexing
  • Partitioning, Decile creation, Reporting etc
  • Stored procedures
  • Work Optimization


[bscolumns class=”one_half”]

Datat Visualization Using Tableau

  • What is Tableau? What does the Tableau product suite comprise of? How Does Tableau Work?
  • Tableau Architecture
  • What is My Tableau Repository?
  • Connecting to Data & Introduction to data source concepts
  • Understanding the Tableau workspace
  • Dimensions and Measures
  • Data Types & Default Properties
  • Tour of Shelves & Marks Card
  • Using Show Me!
  • Building basic views
  • Saving and Sharing your work-overview

Tableau: Building Views (Reports) – Basics

  • Date Aggregations and Date parts
  • Cross tab & Tabular charts
  • Totals & Subtotals
  • Bar Charts & Stacked Bars
  • Line Graphs with Date & Without Date
  • Tree maps
  • Scatter Plots
  • Individual Axes, Blended Axes, Dual Axes & Combination chart
  • Edit axis
  • Parts of Views
  • Sorting
  • Trend lines
  • Reference Lines
  • Forecasting
  • Filters
  • Context filters
  • Sets
  • In/Out Sets
  • Combined Sets
  • Grouping
  • Bins/Histograms
  • Drilling up/down – drill through
  • Hierarchies
  • View data
  • Actions (across sheets)

Tableau: Building Views (Reports) – Advanced Maps

  • Explain latitude and longitude
  • Default location/Edit locations
  • Symbol Map & Filled Map
  • Custom Geo Coding

Tableau: Calculated Fields

  • Working with aggregate versus disaggregate data
  • Explain – #Number of Rows
  • Basic Functions (String, Date, Numbers etc)
  • Usage of Logical conditions

[bscolumns class=”one_half”]
Tableau: Table calculations

  • Explain scope and direction
  • Percent of Total, Running / Cumulative calculations

Tableau: Parameters

  • Create What-If analysis
  • Using Parameters in
  • Calculated fields
  • Bins
  • Reference Lines
  • Filters/Sets
  • Display Options (Dynamic Dimension/Measure Selection)

Tableau: Building Interactive Dashboards- (Building & Customizing)

  • Combining multiple visualizations into a dashboard (overview)
  • Making your worksheet interactive by using actions
  • Filter
  • URL
  • Highlight

Tableau: Formatting

  • Options in Formatting your Visualization
  • Working with Labels and Annotations
  • Effective Use of Titles and Captions

Tableau: Working with Data

  • Multiple Table Join
  • Data Blending
  • Difference between joining and blending data, and when we should do each
  • Working with the Data Engine / Extracts
  • Working with Custom SQL
  • Toggle between to Direct Connection and Extracts

Tableau: Working with Tableau Server – Accessing reports through web

  • Publishing to Tableau Server – Overview of publishing
  • Server Administration – Managing Users, Projects & Object level and Data Security as per Users
  • User Filters


Case Studies:

1: E-Commerce Sales Dashboard (Excel)
Visualize e-commerce data into an interactive dashboard for revenue, cost, quantities, and profit KPI’s, which will initiate stack holders to take actions.
2: HR Analytics Dashboard (Excel)
In this case study, you will design HR dashboard to keep the track of employee attendances, their leaves, late marks and much more.
2: Financial Statement Automation (VBA)
Tool to prepare financial data from raw files into multiple workbooks.
3: Pareto Analysis Customized Add-In (VBA)
A Customize tool to perform Pareto analysis on any data set.
4: Customer Attrition Analysis Report (VBA-SQL)
Look for the customers those are on attrition side from the huge SQL/Access database.

Tableau Case Studies

  • Online Superstore Sales Dashboard
  • Pizza Store Sales Dashboard
  • Customer Case Study
  • Pharma Case Study

Share Now
November 15, 2019


  1. Hi Lokesh,

    I live in Sector 14 gurgaon, do you provide training on weekends too?


  2. Rishi Sharma – AccentureMay 12, 2014 at 2:54 pmReply

    Classes on using charts, pivot tables, etc to create dashboard reporting. Very well presented and explain complex reporting issues in a simple way. It was clear and easy to understand and has helped me develop reporting dashboards. Excellent!

  3. Anshul Gupta – HSBCJune 9, 2014 at 2:54 pmReply

    I really love Lokesh Paliwal’s down to earth teaching style. I feel like I can relate to each examples what he’s saying and it makes me stay tuned for longer. I have learned a tremendous amount from his manner and style as well. Many Thanks Lokesh

Leave a Message

Your email address will not be published. Required fields are marked *

Social Media

facebook page EC Analytics Consulting   Linkedin Page EC Analytics Consulting   Youtube EC Analytics Consulting


0124- 4601426


EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED