Data and Data types
Data summary and frequency table
Fundamentals of statistics – central tendency and dispersion
Fundamentals of statistics – Skewness and Kurtosis
Fundamentals of statistics – Correlation
Working with data tables and finding
frequency distribution – box and whisker,histogram
Mathematical functions
Handling Time as a dimension – trend, seasonality, cyclicality
Permutation – Combination – Brush up
Sequence and Series – Brush Up
Concepts of Probability
Conditional probability
Probability Distribution of Discrete
variable, probability mass function
Binomial & Poison distribution
Probability Distribution of Continuous variable, probability density function
Normal Distribution and examples, central limit theorem
Hypothesis Testing
Contingency Table and Types of error
Probability of randomness – P value and
Alpha (level of significance)
Sampling techniques – Probability
sampling – Random, Stratified, systematic, Cluster
Sampling techniques – Non-probability
sampling – Convenience, Purposive, Snowball, Quota
Statistical Quality Control

Structured and unstructured data
What to look for in a dataset
Data in the analytics industry
How data changes across domains
Data tables and their differences from matrices
Missing values in a dataset and how it impacts
Handling multiple datasets
Practical Data Manipulation requirements while working with multiple datasets

• Excel Table and Formulae
  Most frequently used Excel formulae
  Evaluate formulae – troubleshooting
  Useful Excel features for effective data presentation
  Excel Charts
  Pivot Tables
  Useful Excel Shortcuts
  Excel Recap and Summary

You will be given access to many real time project case studies where you will learn how the Business Analyst carried the project successfully and what are all the techniques which one should practice to be able to become an efficient Business Analyst.

Retrieving data with SELECT
Combining queries with set operators
(Union, union all, intersect, except)
Joins and concepts related to join
Similarity/dissimilarities with Excel lookups
Regular expressions
Applying conditions with WHERE and HAVING
If Else
Case when
The OVER clause
RANK and DENSE_RANK
ROW_NUMBER with ordered sets
Computing running total

Partitioning in multiple levels
LAG and LEAD
For loop, While loop, cursor FOR loop
User-Defined Function
SQL recap and Summary
SQL QnA

Introduction to open source programming languages
How is R different – from working with libraries
Dataset handling in R
Using SQL way of coding in R
R functionalities

Getting started with python – evolution and versions
Basics of Python language
Important libraries
Data Visualization in python – Part 1
Machine Learning Libraries overview
Important python concepts
Data analytics essentials
Data Visualization in python – Part 2
Python recap, Summary and QnA

We will help you with all the activities which will lead you towards getting a Business Analyst Job.

• Resume Preparation
• Mock Interviews
• Work Assignments
• Online Exams
• Real time project exposure
• Assistance after joining a company
• Email and Phone support by trainers

Speak to stakeholders and define the problem statement clearly
Start with end result in mind – create a design of charts and a dashboard
Look for input data and clean it
Build your charts and make the dashboard
Automate the pipeline for regular data refresh
Recap, Summary, QnA

• Competency Proficiency
• BA Necessary Competencies
• Analytical thinking and problem-solving
• Behavioral characteristics
• Business knowledge
• Communication skills
• Interaction skills
• Software application knowledge
• Best Practices
• Use iterative analysis
• Focus on process improvement
• Apply progressive elaboration
• Check as you go
• Use the investigative approach
• Adopt traceability
• Formalize business analysis through standardization
• Improve communication through modeling

You will be assigned to a real time project as a Jr.BA who will be assisting in all the activities a Business Analyst should be doing when he got assigned to a project. With this you will get a hands on experience working on a real time project.

This is a one-to-one mentorship program. Here, our experienced in-house Business Analytics practitioners will guide our program participants throughout the course and even after joining a company. You will learn the Do’s and Don’t s of Business Analytics.