Data Analytics Training

  • 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, Access 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.
    Course duration: 50 hours (50 hours live training + Practice and Self-study)

Who Should do this course?
Candidates from various quantitative backgrounds, like Engineering, Finance, Maths, Statistics, Business Management who want to head start their career in Data Visualization and Analytics.

Course Outline

Visualization and Automation Using Excel VBA

  • Explanation about 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

  • Understaing 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 Dahsboards
  • 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

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
  • Understaing 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

Introduction to MS Access

  • What are Databases
  • Create and Modify Tables
  • Develop and Use of Queries
  • Working with Tables
  • Form Designing
  • Report Designing

DBMS – SQL

  • 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

Data 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

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

 

 Data Science Using Python

  • Anaconda Installation & Setup
  • Jupyter Notebook Overview
  • Python Basics
  • NumPy, Pandas, MatPlotLib
  • Data Visualization: Seaborn, Plotly, Cufflinks
  • Machine Learning Introduction – SciKit
  • Preprocessing Data
  • Classification: Naive Bayes, Random Forest, Logistic Regression, KNN, SVM
  • Regression: Linear Regression, SVR, Random Forest, Decision Tree
  • Clustering: K-Means, Hierarchical, Dendrograms
  • Natural Language Processing ( NLP )

 

11 responses on "Data Analytics Training"

  1. Haridarshan Singh RawatAugust 29, 2013 at 9:09 pmReply

    Hi Lokesh
    This is Haridarshan working with a leading KPO in gurgaon, as data analyst. I am in search of advanced excel and VBA training to enchance my data analysis skills. I am based out of Dwarka, Sector 24, New Delhi.
    Could you please let me know when is your next batch starting.

    • Hi Haridarshan, thanks for contacting excel crazy.
      Send me your email id and contact details at lokesh[at]excelcrazy[dot]com. I will forward to you the curriculum and next batch starting details.

  2. Dear Lokesh
    I am VBA working with American Express, Gurgaon and i am looking Course we are 4-5 friends who are looking for this training.
    kinldy let me know class timings and fee with details of Course.
    you can get in-touch with me on +91-880213XXXX
    Regard’s
    Pankaj Gupta
    Mobile-+91-880213XXXX
    Email- [email protected]

  3. Hi,
    Myself Shashikant Shukla. I am working one of leading organisation. Now I am looking for VBA training program. I want know batches time and fee structure. If possible please send me all details on my given mail ID [email protected]
    Thanks!
    Shashikant

  4. i want to create address book..
    please help me
    how to create simple address book in VBA/exl with useful buttons

  5. hi,
    I am vinod and looking for advance excel training & VBA. Could you please get me some time table & fee structure.
    Can I pay a visit to your place?
    please reply
    thanks

  6. Excellent website and demonstrations!

  7. I want to do excel and VBA macros training.

  8. I want data of “Sheet1” to be copied in “Sheet3”, manner of the copy is mentioned below. Please help
    1. Cells of “Sheet1” (B2, C2, D2, E2, F2, G2, H2) should be copied in “Sheet3”
    2. There should be a delay of 3 seconds.
    3. Increment the Row by 1 and now copy cells “sheet1” (B3, C3, D3, E3, F3, G3, H3) and then past it to next row of “Sheet3”.
    Note: – I don’t want to copy row of “sheet1” to “sheet3” . I want to copy cell.
    I want to past the all data Cell wise of “sheet1” to Cell wise of “sheet3” with delay of 3 seconds in between of two rows.
    Example of Data in “Sheet1” which need to be copied to “sheet3” cell wise is mentioned below. These record can go on up to 2500 or 3000. or may be 700 or 1500.
    980.26 979 8/5/2014 826.727 155472 202180 30790000
    980.25 978.4 8/5/2014 831.114 156734 203501 30798750
    980.24 979 8/5/2014 837.743 160128 203220 30798750

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

Address:

NM 23, SECTOR 14, OLD DLF COLONY,
GURGAON (HARYANA)
0124- 4601426

ABOUT EC ANALYTICS CONSULTING

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