Business Toys



Business Analyst

This is fast-track certification program which will enable you to learn Business Analytics, using in-demand software tools like R, Advance Excel, SQL and Tableau. Any professional or student with no prior knowledge in Analytics can easily take up this course and can make career transition to entry level Analytics Profiles.

Next-batch will start on Feb 20 Register Now

SKILLS & TOOLS COVERED

no-img

JOB OPPORTUNITIES

Business Analyst, Pricing Analyst, Social Media Analyst, Data Analyst, Market Research, Research Analyst, Financial Analyst.

POTENTIAL RECRUITERS

no-img

Business Analyst

This is fast-track certification program which will enable you to learn Business Analytics, using in-demand software tools like R, Advance Excel, SQL and Tableau. Any professional or student with no prior knowledge in Analytics can easily take up this course and can make career transition to entry level Analytics Profiles.

Next-batch will start on Feb 20 Register Now

SKILLS & TOOLS COVERED

no-img

JOB OPPORTUNITIES

Business Analyst, Pricing Analyst, Social Media Analyst, Data Analyst, Market Research, Research Analyst, Financial Analyst.

POTENTIAL RECRUITERS

  • Total Duration65+ Hours
  • Teaching ModeClass RoomOnline
  • LevelBeginners & Intermediate
  • Course Fees30,000 + 18% GST
  • Registration Fees10,000/-

Recommended Professional Program
  • Total Duration65+ Hours
  • Teaching ModeClass RoomOnline
  • LevelBeginners & Intermediate
  • Course Fees30,000 + 18% GST
  • Registration Fees10,000/-

65+ Hours of Hybrid Learning

Learn premium content through live classes and offline bootcamps

Access to Employment Opportunities

Apply for available industry internships and live projects

1:1 In Person Mentoring

Get personalized career coaching from 700+ Coaches

₹6 - 6 Lakhs Average Salary Package

Land your dream job with right salary in the right company

  • Data handling and extraction using SQL and Excel.
  • Data Definition and Manipulation in SQL.
  • Importing large data sets into SQL server.
  • Data Manipulation and Cleaning function of R and Excel.
  • Data lookup functions in Excel.
  • Working around large datasets in R.
  • Statistics in Data Science.
  • Predictive modeling in R and Excel.
  • Understanding types of problem and building respective models.
  • Understanding and Validating models.
  • Regression Statistics in R, Excel.
  • Data visualization on tableau.

Get yourself enrolled for the most specialized analytics learning program in India, This Certificate Program in Business Analytics is offering by Business Toys Pvt. Ltd. which is a specialized analytics training company with presence across India & also partnering with NASSCOM. You will learn about the different challenges that businesses face and have the opportunity to explore data driven methods and techniques available to address these challenges.
The course will take a hands-on & problem driven approach that will help you understand and put into day to day business practices which concepts you to learn. At the end of the course, you will be able to make better decisions at every step of the business processes. We have designed this course to suit dedicated students who are looking for career in Business Analytics.


  • Analytics overview
  • Statistical framework
  • Taking business decisions based on statistics
  • Project: Xiaomi India case study
  • Data management using Excel
  • Pivot tables & pivot charts
  • V-lookup, H-lookup & Index-match for performance appraisal
  • Filters, advanced filters, sorting and conditional formatting.
  • Data analytics tool pack in Excel or building business intelligence dashboards
  • Enterprise data discovery
  • Data classification
  • Data gathering and management
  • Data quality investigation
  • Probability Theory and Statistics
  • Trend analysis
  • Data Visualization for Data Quality
  • Business Model Analysis and Linear Modeling
  • Project: Dominos Business Model case
  • Analytics Pricing Model using multiple regression.
  • Project: Apple Pricing Case
  • Customer Behavior Analysis Using Logistic Regression
  • Project: KTM Case
  • Introduction to R/ R Studio GUI.
  • Importing and connecting to Datasets, Viewing Data.
  • Exploratory Data Analysis – Introduction to Descriptive Statistics, Reading Frequency Distribution and Histogram.
  • Creating Graphs – Bar/Pie/Line chart/histogram/Boxplot etc.
  • R packages for graphical analysis – ggplot, base.
  • Inferential Statistics – T-test, Z-test, ANNOVA, Chi- Square test, Correlation.
  • Predictive modelling- Linear Regression and Logistic Regression.
  • Understanding standard model metrics and interpretation of regression result.
  • R - text mining – Pattern analysis in text, Text as a graph.
  • Text Classification.
  • Introduction to Database
  • Database Schema
  • Data based objects creation
  • Creating, Modifying & Deleting Databases and Tables
  • Drop & Alter Table & Alter Column statements
  • Import and Export wizard to get the data in SQL server from excel files or delimited files
  • Data Manipulation
  • Insert, Update, Delete statements, Select statements
  • Grouping and aggregations etc
  • Where, Group By, Order by & Having clauses
  • SQL Operators
  • Relational, Logical (and, or, not), Use of wildcard operators
  • Assessing data from multiple tables using select
  • Append and Joins – Use & constraints
  • Intersect and Except statements
  • Table Joins
  • inner join, left join, right join, full join
  • Cross joins, self joins, natural joins etc
  • Sub-queries
  • Tableau environment walk through and connecting to databases format.
  • Iterative and interactive data exploration using Tableau
  • Advanced Charting techniques using Calculated fields.
  • Using Parameters, Sets.
  • Data Visualization, mapping, graphics.
  • Data Dashboarding, Storytelling.
  • Project: OYO Case Study


65+ Hours of Hybrid Learning
Learn premium content through live classes and offline bootcamps
Access to Employment Opportunities
Apply for available industry internships and live projects

1:1 In Person Mentoring
Get personalized career coaching from 700+ Coaches
₹6 - 6 Lakhs Average Salary Package
Land your dream job with right salary in the right company
  • Data handling and extraction using SQL and Excel.
  • Data Definition and Manipulation in SQL.
  • Importing large data sets into SQL server.
  • Data Manipulation and Cleaning function of R and Excel.
  • Data lookup functions in Excel.
  • Working around large datasets in R.
  • Statistics in Data Science.
  • Predictive modeling in R and Excel.
  • Understanding types of problem and building respective models.
  • Understanding and Validating models.
  • Regression Statistics in R, Excel.
  • Data visualization on tableau.

Get yourself enrolled for the most specialized analytics learning program in India, This Certificate Program in Business Analytics is offering by Business Toys Pvt. Ltd. which is a specialized analytics training company with presence across India & also partnering with NASSCOM. You will learn about the different challenges that businesses face and have the opportunity to explore data driven methods and techniques available to address these challenges.
The course will take a hands-on & problem driven approach that will help you understand and put into day to day business practices which concepts you to learn. At the end of the course, you will be able to make better decisions at every step of the business processes. We have designed this course to suit dedicated students who are looking for career in Business Analytics.


  • Analytics overview
  • Statistical framework
  • Taking business decisions based on statistics
  • Project: Xiaomi India case study
  • Data management using Excel
  • Pivot tables & pivot charts
  • V-lookup, H-lookup & Index-match for performance appraisal
  • Filters, advanced filters, sorting and conditional formatting.
  • Data analytics tool pack in Excel or building business intelligence dashboards
  • Enterprise data discovery
  • Data classification
  • Data gathering and management
  • Data quality investigation
  • Probability Theory and Statistics
  • Trend analysis
  • Data Visualization for Data Quality
  • Business Model Analysis and Linear Modeling
  • Project: Dominos Business Model case
  • Analytics Pricing Model using multiple regression.
  • Project: Apple Pricing Case
  • Customer Behavior Analysis Using Logistic Regression
  • Project: KTM Case
  • Introduction to R/ R Studio GUI.
  • Importing and connecting to Datasets, Viewing Data.
  • Exploratory Data Analysis – Introduction to Descriptive Statistics, Reading Frequency Distribution and Histogram.
  • Creating Graphs – Bar/Pie/Line chart/histogram/Boxplot etc.
  • R packages for graphical analysis – ggplot, base.
  • Inferential Statistics – T-test, Z-test, ANNOVA, Chi- Square test, Correlation.
  • Predictive modelling- Linear Regression and Logistic Regression.
  • Understanding standard model metrics and interpretation of regression result.
  • R - text mining – Pattern analysis in text, Text as a graph.
  • Text Classification.
  • Introduction to Database
  • Database Schema
  • Data based objects creation
  • Creating, Modifying & Deleting Databases and Tables
  • Drop & Alter Table & Alter Column statements
  • Import and Export wizard to get the data in SQL server from excel files or delimited files
  • Data Manipulation
  • Insert, Update, Delete statements, Select statements
  • Grouping and aggregations etc
  • Where, Group By, Order by & Having clauses
  • SQL Operators
  • Relational, Logical (and, or, not), Use of wildcard operators
  • Assessing data from multiple tables using select
  • Append and Joins – Use & constraints
  • Intersect and Except statements
  • Table Joins
  • inner join, left join, right join, full join
  • Cross joins, self joins, natural joins etc
  • Sub-queries
  • Tableau environment walk through and connecting to databases format.
  • Iterative and interactive data exploration using Tableau
  • Advanced Charting techniques using Calculated fields.
  • Using Parameters, Sets.
  • Data Visualization, mapping, graphics.
  • Data Dashboarding, Storytelling.
  • Project: OYO Case Study