Join us for our fully interactive live online classes as AnalytixLabs pledges Social Distancing!
 

Advance Excel Course - Data Visualization & Analytics

Learn most important Analytics & Reporting tools: MS-Excel, VBA and Access-SQL along with the hottest Data visualization tool - Tableau

This advance Excel training is designed to help you become a successful Data Analyst and is highly recommended for aspirants who are just starting their career in Analytics. This power packed advance Excel course will teach you how to make insightful dashboards, VBA macros and SQL through a strong focus on case studies to ensure hands-on learning. Once armed with the much needed skills with this advanced Excel course, you will also learn the powerful Data visualization tool Tableau to present your analysis. One of the best advanced Excel training available in Bangalore, Gurgaon and Delhi NCR, with flexibility of attending the live online sessions and self-paced video mode as well. 


Advance Excel for course "Data Visualization & Analytics' duration: 72 hours (Atleast 36 hours live excel training (including Tableau) + 12 hours video based training + Practice and Self-study, with ~6hrs of weekly self-study).

Who Should do this course?

Candidates from various quantitative backgrounds, who are not just looking for advance Excel training but also want to learn job oriented Analytics & Reporting skills using MS-Excel, VBA, MS-Access, SQL and Tableau.

SELECT THE COURSE
ENROLL NOW

Combo Deals!

Learn more, save more.
See our combo offers here.

Course Duration 72 hours
Classes 12
Tools Excel,VBA, SQL, Tableau
Learning Mode Live/Video Based
Next Batch02nd August, 2020 (Online)

What will you get



Access to 48 hours instructor led live classes of 3 hours each, spread over 8 weekends



Video recordings of the class sessions for self study purpose



Weekly assignment, reference codes and study material in PDF format



Module wise case studies/ projects



Career guidance and career support post the completion of some selected assignments and case studies

Course Outline

  • Introduction to Excel Environment
  • 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

  • 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

  • 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

  • What is SQL – A Quick Introduction
  • Getting started
    Understanding basic database concepts
    Introduction to MS SQL Server Management Studio
    Utilizing the Object Explorer
  • Understanding basic RDBMS concepts
    Schema –Meta Data –ER Diagram
    Looking at an example Database design
    Data Integrity Constraints & types of Relationships (Primary and foreign key)
    Basic concepts – Queries, Data types & NULL Values, Operators and Comments in SQL

  • Data based objects creation (DDL Commands)
    Creating, Modifying & Deleting Tables
    Drop & Truncate statements – Uses & Differences
    Alter Table & alter Column statements
  • Data manipulation (DML Commands)
    Insert, Update & Delete statements
    Select statement – Where, Group By, Order by & Having clauses
  • Working with Select statement
    Union and Union All – Use & constraints
    Intersect and Except statements
    Joins & Aliases
    Accessing data from Multiple Tables
    Inline and sub-queries
    SQL Functions – Number, Text, Date, etc
    SQL Keywords – Top, Distinct, Null, etc
    SQL Operators, Use of wildcards, etc
  • Optimizing your work
    Sub-queries vs. Temp Tables vs. Joins
    Optimizing for Composite keys & Non-numeric Primary keys

  • 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

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

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

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

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

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

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

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

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

  • 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

Case Studies

FAQS

Don’t worry. You will always get a recording for the class in your inbox. Have a look at that and reach out to the faculty in case of doubts. All our live classes are recorded for self-study purpose and future reference, and these can also be accessed through our Learning Management System. Hence, in case you miss a class, you can refer to the video recording and then reach out to the faculty during their doubts clearing time or ask your question in the beginning of the subsequent class.

You can also repeat any class you want in the next one year after your course completion.

1 year post your course commencement. If needed, you can also repeat any number of classes you want in the next one year after course completion. Batch change policies will however, apply in this case.

In case required because any genuine reasons, the recordings access can be extended further for upto 1 year post the completion of one year validity. Please note that given the constant changes in the Analytics industry, our courses continue to be upgraded and hence old courses might no longer hold relevance. Hence, we do not promise lifetime access just for marketing purposes. 

No. Our recordings can be accessed through your account on LMS or stream them live online at any point of time though.

Recordings are integral part of AnalytixLabs intellectual property by Suo Jure. The downloading/distribution of these recordings in anyway is strictly prohibited and illegal as they are protected under copyright act. Incase a student is found doing the same, it will lead to an immediate and permanent suspension in the services, access to all the learning resources will be blocked, course fee will be forfeited and the institute will have all the rights to take strict legal action against the individual.

The sharing of LMS login credentials is unauthorized, and as a security measure, if the LMS is accessed by multiple places, it will flag in the system and your access to LMS can be terminated.

Yes. All our course are certified. As part of the course, students get weekly assignments and module-wise case studies. Once all your submissions are received and evaluated, the certificate shall be awarded.

We follow a comprehensive and a self-sustaining system to help our students with placements. This is a win-win situation for our candidates and corporate clients. As a pre-requisite for learning validation, candidates are required to submit the case studies and project work provided as a part of the course (flexible deadline).

For this course, limited placement guidance will be available post your course completion. We will provide guidance to you in terms of what are the right profiles for you based on your education and experience, interview preparation and conducting mock interviews, if required.

No institute can guarantee placements, unless they are doing so as a marketing gimmick! It is on a best effort basis.

In professional environment, it is not feasible for any institute to do so, except for a marketing gimmick. For us, it is on a best effort basis but not time – bound – in some cases students reach out to us even after 3 years for career support.

Data Visualization and Analytics course is available only through a fully interactive live online and instructor-led mode. This is fully interactive and instructor-led. Hence, you will be able to hear the trainer, see what he does on his screen and can also talk to the trainer and ask questions in real time.

We provide both the options and for instructor led live online classes we use the gold standard platform used by the top universities across the globe. These video sessions are fully interactive and students can chat or even ask their questions verbally over the VoIP in real time to get their doubts cleared.

To attend the online classes, all you need is a laptop/PC with a basic internet connection. Students have often shared good feedback of attending these live classes through their data card or even their mobile 3G connection, though we recommend a basic broadband connection.

For best user experience, a mic-headphone is recommended to enhance the voice quality, though the laptop’s in-built mic works fine and you can ask your question over the chat as well.

Through the LMS, students can always connect with the trainer or even schedule one-to-one time over the phone or online. During the course we also schedule periodic doubts-clearing classes though students can also ask doubts of a class in the subsequent class.

LMS also has a discussion forum where a lot of your doubts might get easily answered.

Incase you are having a problem still, repeat the class and schedule one-to-one time with the trainer.

  • Instructor Led Live online or Classroom - Within 7 days of registartion date and latest 3 days before batch start
  • Video-based - 2 days

No. There is no option of paying in installments for short courses like this one.

For all the courses, we also provide the recordings of each class for their self-reference as well as revision in case you miss any concept in the class. In case you still have doubts after revising through the recordings, you can also take one-to-one time with the faculty outside classes during. Furthermore, if students want to break their courses in different modules, they get one year time to repeat any of the classes with other batches.

There is no particular system requirement for this course since the tools required for this course (Excel, Access and Tableau) can easily be installed on almost every laptop with basic configuration available these days.

For Tableau, please note that Tableau doesn't have a learning version. Hence, you can choose among the following versions to install:

  • Tableau Public - Free though it has constraints like not being able to connect to SQL servers etc Hence, it is useful, free and doesn't constraint your learning at all
  • Tableau Desktop - Only a 14 day trial version is available from Tableau's website. If you have a valid student id (graduate/postgraduated). then you can get a free key which is valid for one year

"Got professional level understanding on all of the topics related to business analytics and stats, so far best Institute in delhi ncr. They have best experts available having tons of industry experience. On top ankita and sumit will always be there for technical support and career guidance ."


Mohit Pandey
(Analyst, Quantiphi)

Change the course of your career

Over 6000 learners and hundreds making right choice every month!
Open chat
Got any questions? Get in touch with the course counsellor!
Course Brochure
Student Reviews
Upcoming Batches