Last Few Seat Left In Nov BA360 Batch (Both Gurgaon and Bangalore). Register Now to Grab A Seat.
 

Analytics Training - Analytics Edge with R, Excel & Tableau

Analytics certification training a power packed course for analytics beginners and certification aspirants.

This Analytics training is for beginners who want to learn Data Mining, Statstical & Predictive Modelling skills to target job profiles related to RExcel-VBA, SQL or Tableau based Data Analyst profiles. In this program candidates will also learn Tableau, one of the most popular data visualization and rapid BI tool. Evolved from our post popular course, this Data Analyst training is specially curated for candidates who have no prior knowledge about any BI or data analytics tools.


This power-packed program is best Data Analyst training in Delhi NCR and Bangalore, with flexibility of attending live online Analytics training and through self-paced video based mode as well. 


'Analytics Edge' with Excel, Tableau and R course duration: 180 hours (At least 72 hours live training + 12 hours video based training + Practice and Self-study, with ~8hrs of weekly self-study)

Who Should do this course?

Beginner candidates from various quantitative backgrounds, like Engineering, Finance, Maths, Business Management who want to target job profiles based on R programming and statistical analysis skills or Excel-VBA or Tableau based MIS/BI analyst profiles.

SELECT THE COURSE
ENROLL NOW

Combo Deals!

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

Course Duration 180 hours
Classes 24
Tools R, Excel, VBA, Tableau
Learning Mode Live Training
Next Batch17th November, 2019 (Gurgaon)

Introduction to Excel data handling

  • Introduction to Excel Environment
  • Formatting and Conditional Formatting
  • Data Sorting, Filtering and Data Validation
  • Understanding Name Ranges

Data manipulation using functions

  • Descriptive functions: sum, count, min, max, average, counta, countblank
  • Logical functions: IF, and, or, not
  • Relational operators > >= < <= = !=
  • Nesting of functions
  • Date and Time functions: today, now, month, year, day, weekday, networkdays, weeknum, time, minute, hour
  • Text functions: left, right, mid, find, length, replace, substitute, trim, rank, rank.avg, upper, lower, proper
  • Array functions: sumif, sumifs, countif, countifs, sumproduct
  • Use and application of lookup functions in excel: Vlookup, Hlookup
  • Limitations of lookup functions
  • Using Index, Match, Offset, concept of reverse vlookup

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

Data Visualization in Excel

  • Overview of chart types - column and bar charts, line and area charts, pie charts, doughnut charts, scatter plots
  • How to select right chart for your data
  • Chart formatting
  • Creating and customizing advance charts - thermometer charts, waterfall charts, population pyramids

Overview of Dashboards

  • What is dashboard & Excel dashboard
  • Adding icons and images to dashboards
  • Making dashboards dynamic

Create dashboards in Excel - Using Pivot Controls

  • Concept of pivot cache and its use in creating interactive dashboards in Excel
  • Pivot table design elements - concept of slicers and timelines
  • Designing sample dashboard using Pivot Controls
  • Design principles for including charts in dashboards - do's and don’t's

Business Dashboard Creation

  • Complete Management Dashboard for Sales & Services
  • Best practices - Tips and Tricks to enhance dashboard designing

SQL: Understanding RDBMS

  • Schema – Meta Data – ER Diagram
  • Looking at an example of Database design
  • Data Integrity Constraints & types of Relationships (Primary and foreign key)
  • Basic concepts – Queries, Data types & NULL Values, Operators and Comments in SQL

SQL: Utilising the Object Explorer

  • What is SQL – A Quick Introduction
  • Installing MS SQL Server for windows OS
  • Introduction to SQL Server Management Studio
  • Understanding basic database concepts

SQL: Data based objects creation (DDL Commands)

  • Insert, Update & Delete statements
  • Select statement – Subsetting, Filters, Sorting. Removing Duplicates, grouping and aggregations etc
  • Where, Group By, Order by & Having clauses
  • SQL Functions – Number, Text, Date, etc
  • SQL Keywords – Top, Distinct, Null, etc
  • SQL Operators -  Relational (single valued and multi valued), Logical (and, or, not), Use of wildcard operators and wildcard characters, etc

SQL: Data manipulation (DML Commands)

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

SQL: Accessing data from Multiple Tables using SELECT

  • Append and JoinsUnion and Union All – Use & constraints
  • Intersect and Except statements
  • Table Joins - inner join, left join, right join, full join
  • Cross joins/cartesian products, self joins, natural joins etc
  • Inline views and sub-queries
  • Optimizing your work

Tableau: Getting started

  • What is Tableau? What does the Tableau product suite comprise of? How Does Tableau Work?
  • Tableau Architecture
  • 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
  • Saving and Sharing your work-overview

Tableau: Data handling & summaries

  • 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
  • Parts of Views
  • Sorting
  • Trend lines/ Forecasting
  • Reference Lines
  • 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 Advanced Reports/ Maps

  • Explain latitude and longitude
  • Default location/Edit locations
  • Building geographical maps
  • Using Map layers

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
  • Introduction to LOD (Level of Detail) Expressions
  • User applications of Table calculations

Tableau: Parameters

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

Tableau: Formatting

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

Tableau: Working with Data

  • Multiple Table Joins
  • Data Blending
  • Difference between joining and blending data, and when we should do each
  • Toggle between to Direct Connection and Extracts

MS VBA (video-based)

  • Introducing VBA
  • What is Logic?
  • What Is VBA?
  • Introduction to Macro Recordings, IDE
  • How VBA Works with Excel
  • Working In the Visual Basic Editor
  • Introducing the Excel Object Model
  • Using the Excel Macro Recorder
  • VBA Sub and Function Procedures
  • Key Components of  Programming  language
  • Essential VBA Language Elements
  • Keywords & Syntax
  • Programming statements
  • Variables & Data types
  • Comments
  • Operators
  • Working with Range Objects
  • A look at some commonly used code snippets
  • Programming constructs in VBA
  • Control Structures
  • Looping Structures
  • The With- End with Block
  • Functions & Procedures in VBA – Modularizing your programs
  • Worksheet & workbook functions
  • Automatic Procedures and Events
  • Arrays
  • Objects & Memory Management in VBA
  • The NEW and SET Key words
  • Destroying Objects – The Nothing Keyword
  • Error Handling
  • Controlling accessibility of your code – Access specifiers
  • Code Reusability – Adding references and components to your code
  • Communicating with Your Users
  • Simple Dialog Boxes
  • User Form Basics
  • Using User Form Controls
  • Add-ins
  • Accessing Your Macros through the User Interface
  • Retrieve information through Excel from Access Database using VBA

R: Exploratory Data Analysis - Introduction to Data Science

  • What is analytics & Data Science?
  • Common Terms in Analytics
  • Analytics vs. Data warehousing, OLAP, MIS Reporting
  • Relevance in industry and need of the hour
  • Types of problems and business objectives in various industries
  • How leading companies are harnessing the power of analytics?
  • Critical success drivers
  • Overview of analytics tools & their popularity
  • Analytics Methodology & problem solving framework
  • List of steps in Analytics projects
  • Identify the most appropriate solution design for the given problem statement
  • Project plan for Analytics project & key milestones based on effort estimates
  • Build Resource plan for analytics project
  • Why R for data science?

R: Exploratory Data Analysis - Data Importing/Exporting

  • Introduction R/R-Studio - GUI
  • Concept of Packages - Useful Packages (Base & Other packages)
  • Data Structure & Data Types (Vectors, Matrices, factors, Data frames,  and Lists)
  • Importing Data from various sources (txt, dlm, excel, sas7bdata, db, etc.)
  • Database Input (Connecting to database)
  • Exporting Data to various  formats)
  • Viewing Data (Viewing partial data and full data)
  • Variable & Value Labels –  Date Values

R: Exploratory Data Analysis - Data Manipulation

  • Data Manipulation steps
    • Creating New Variables (calculations & Binning)
    • Dummy variable creation
    • Applying transformations
    • Handling duplicates
    • Handling missings
    • Sorting and Filtering
    • Subsetting (Rows/Columns)
    • Appending (Row appending/column appending)
    • Merging/Joining (Left, right, inner, full, outer etc)
    • Data type conversions
    • Renaming
    • Formatting
    • Reshaping data
    • Sampling
  • Data manipulation tools
    • Operators
    • Functions
    • Control Structures (if, if else)
    • Loops (Conditional, iterative loops, apply functions)
    • Arrays
  • R Built-in Functions (Text, Numeric, Date, utility)
    • Numerical Functions
    • Text Functions
    • Date Functions
    • Utilities Functions
    • R User Defined Functions
  • R Packages for data manipulation (base, dplyr, plyr, data.table, reshape, car, sqldf, etc)

R: Exploratory Data Analysis - Data Visualization

  • Introduction exploratory data analysis
  • Descriptive statistics, Frequency Tables and summarization
  • Univariate Analysis (Distribution of data & Graphical Analysis)
  • Bivariate Analysis (Cross Tabs, Distributions & Relationships, Graphical Analysis)
  • Creating Graphs- Bar/pie/line chart/histogram/boxplot/scatter/density etc)

 

  • R Packages for Exploratory Data Analysis(dplyr, plyr, car, Hmisc, psych, etc)
  • R Packages for Graphical Analysis (base, ggplot, etc)

R: Predictive Modeling - Introduction to Statistics

  • Basic Statistics - Measures of Central Tendencies and Variance
  • Building blocks - Probability Distributions - Normal distribution - Central Limit Theorem
  • Inferential Statistics -Sampling - Concept of Hypothesis Testing
  • Statistical Methods - Z/t-tests( One sample, independent, paired), Anova, Correlations and Chi-square

R: Predictive Modeling - Introduction to Predictive Modeling

  • Concept of model in analytics and how it is used?
  • Common terminology used in analytics & modeling process
  • Popular modeling algorithms
  • Types of Business problems - Mapping of Techniques
  • Different Phases of Predictive Modeling

R: Predictive Modeling - Data Exploration for modeling

  • Need for structured exploratory data
  • EDA framework for exploring the data and identifying any problems with the data (Data Audit Report)
  • Identify missing data
  • Identify outliers data
  • Visualize the data trends and patterns

R: Predictive Modeling - Data Preparation

  • Need of Data preparation
  • Consolidation/Aggregation - Outlier treatment - Flat Liners - Missing values- Dummy creation - Variable Reduction

R: Predictive Modeling - Linear Regression: Solving regression problems

  • Introduction - Applications
  • Assumptions of Linear Regression
  • Building Linear Regression Model
  • Understanding standard metrics (Variable significance, R-square/Adjusted R-square, Global hypothesis ,etc)
  • Assess the overall effectiveness of the model
  • Validation of Models (Re running Vs. Scoring)
  • Standard Business Outputs (Decile Analysis, Error distribution (histogram), Model equation, drivers etc.)
  • Interpretation of Results - Business Validation - Implementation on new data

R: Predictive Modeling - Logistic Regression: Solving classification problems

  • Introduction - Applications
  • Linear Regression Vs. Logistic Regression Vs. Generalized Linear Models
  • Building Logistic Regression Model (Binary Logistic Model)
  • Understanding standard model metrics (Concordance, Variable significance, Hosmer Lemeshov Test, Gini, KS, Misclassification, ROC Curve etc)
  • Validation of Logistic Regression Models (Re running Vs. Scoring)
  • Standard Business Outputs (Decile Analysis, ROC Curve, Probability Cut-offs, Lift charts, Model equation, Drivers or variable importance, etc)
  • Interpretation of Results - Business Validation - Implementation on new data

Case Study on Gantt Charting using Conditional Formatting and Logical Function

Exercise workbooks on Basic & Advanced Excel Functions, Pivot tables etc

Sample Sales Dashboard

2 Case studies on consolidating data from different workbooks into Excel

Access to 72 hours instructor led live classes of 24x3 hours each, spread over 12 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

Specially curated study material and sample question for SAS Global Certification

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

What if I miss a class?

Don’t worry. You will always get a recording for the class in your Learning Management System (LMS) account. 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 LMS. 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. Batch change policies will however, apply in this case.

Please note that incase you are not able to complete your course within one year of course validity, due to reasons at your end, limited support might be available post the completion of one year.

For how long are the recordings available to me?

1 year post your course completion. 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. 

Can I download the recordings?

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.

What if I share my LMS login details with a friend?

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.

Will I get a certificate in the end?

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 well, the certificate shall be awarded.

Please note that incase you are not able to complete the course within the one year validity, AnalytixLabs might hold a mock interview/viva, apart from your submissions, before issuing the certificate.

Do you help in placements?

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). Support from our side is continuous and encompasses help in profile building, CV referrals (as and when applicable) through our ex-students, HR consultants and companies directly reaching out to us.

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. The placement process for us doesn’t end at a definite time post your course completion, but is a long relationship that we will like to build.

To avoid any kind of ambiguity, we strongly suggest that you go through our course brochures.

Please also note that incase you are unable to complete the course in the one year course validity period, we might not be able to assist with placements. The discussion you would have had with our counsellors/faculty at the time of registration is also basis the profile you hold at that time. Incase your course has got delayed due to reasons at your end, this might effect the profile, in which case it might be difficult for us to assist in placements.

Do you guarantee placements?

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.

Do you have a classroom option?

Yes we have classroom option for Delhi-NCR candidates. However, most of our students end up doing instructor led live online classes, including those who join classroom in the beginning. Based on the student feedback, the learning experience is same both in classroom and instructor led live online fully interactive mode.

How do I attend the online classes? Are they interactive or self-paced?

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.

What do I need to attend the online classes?

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.

How can I reach out to someone if I have doubts post class?

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.

What is your refund policy?

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

Can I pay in installments?

Yes. While making the fee payment, most of the courses have the installment option.

I am having difficulty coping up with my classes. What can I do?

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.

What are the system requirements for the software?

There is no particular system requirement for this course since the tools required for this course (Excel, SAS and Tableau) can easily be installed on almost every laptop with basic configuration available these days. However, if possible, it is recommended to have 64-bit operating system.

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

AnalytixLabs is undoubtedly the best institute to gain knowledge. The courses are well crafted and are designed in such a way that it makes it easy to understand even the most difficult of the concepts. Rather than just feeding you with theoretical knowledge and providing you with study Material, AnalytixLabs stands out and is well ahead of others as the course heavily focuses on Assignments and Case Studies which gives the student a good idea on how to implement the tools learnt during the course. The faculty is not only knowledgeable and experienced but is also very helpful and doesn’t disowns the student once the course is completed rather guides the student during and well after the course. I being a fresher and one who was changing his field was very apprehensive about my career transition but I am glad for the support that AnalytixLabs provided me with.


Archish Rai Kapil
(Analyst, Air India)

Change the course of your career

Over 6000 learners and hundreds making right choice every month!
Course Brochure
Student Reviews
Upcoming Batches