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

Business Analyst Course - Analytics Edge

Comprehensive Business Analyst training to head start your career in Analytics!

With advent of information technology, demand for Business Intelligence and Business Analyst professionals have surged from the beginning of this century. Data explosion since 2010 has further increase the value of professionals with analytics skill by manifolds. It’s a well-known fact that data analysis has become indispensable component of overall business strategy as well as other functions, like marketing & sales, supply chain management, customer operations, accounting & finance etc. 

Analytics Edge is one of the best Business Analyst training course to learn Data Mining, Statistical & Predictive Modelling skills using in-demand analytics tool. This certification course would help you to target analytics job requiring hands-on skills in R, Excel-VBA, SQL and Tableau (most popular data visualization and rapid BI tool). 

This Business Analyst course is specially curated for candidates who have no prior knowledge about any BI or data analytics tools. Focussed coverage of key skills using the blend of in-demand Analytics tools, along with their applications, makes this data analytics certification course quite unique. 

Post certificate completion you will acquire professional competency in skills required for various type of Analytics related jobs, such as Business Analyst, Data Analyst, Marketing Analyst, CRM Analyst  etc. 

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)

Delivery Formats:

1. Bootcamps & classroom in Bangalore and Delhi NCR (Gurgaon & Noida)

2. Fully interactive live online training (Global access)

3. Self-paced e-learning modules (Global access)


Useful Blogs:

1. Why is Business Analytics a good career option? 

2. What does a Business Analyst Do?

3. The Complete Guide to Starting Your Career as a Business Analyst

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.


Combo Deals!

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

Course Duration 180 hours
Classes 24
Tools R, Excel, SQL, VBA, Tableau
Learning Mode Live/Video Based
Next Batch27th September, 2020 (Online)

What will you get

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 Global Certifications

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

Course Outline

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

  • 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

  • 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

  • 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

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

  • 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

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

  • 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

  • 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

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

  • 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

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

  • 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

  • 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

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


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

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

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

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

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

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

  • 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

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

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

  • 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

  • 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

  • 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

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

  • 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

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


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.

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. 

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 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.

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.

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.

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.

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

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

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, 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

I joined the Base and Advanced SAS course with a duration of 1.5 months. The course was quite comprehensive, and being from a non analytics background, I was still able to grasp the concepts easily. The teaching manner is quite interactive, and lucid. The instructors are very approachable, and ready to give individual assistance when required. I also found the class study material very helpful, and it gave me confidence to approach the problems independently, thanks to the assignments and case studies. Besides, the structured approach provided towards SAS Global certification preparation is quite good. Definitely a fruitful course!

Shubhi Agarwal
(Deputy Manager (Analytics) at Bajaj Allianz General Insurance)

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