Executive Training Program in

Business Analytics

Specialization in Finance, HR, Marketing & Supply Chain

5 months

150 hours

live

job oriented

pexels-mikhail-nilov-8296982.jpg

What is Business Analytics?

Business analytics is the use of a set of software applications to build statistical models. Leaders look at data on past business performance, understand the current situation, and predict future scenarios. 

Business analytics is the process of looking at the wealth of data of a company that already has at its disposal and using it to make data-driven decisions. It moves beyond just looking at numbers to see what happened. Instead, business analytics also endeavors to give insight into why things happened and suggests what steps to take next. 

What are the benefits of using business analytics?  

to identify deviations

Keeping you on budget.

Better decision making.

Staying in the know.

Building efficiency

Why Specializations are important?

As such Analytics itself is a not a domain. Learning only data analytics does not help the businesses. Businesses uses them to show improvement over current process. Depending upon the organization, the requirement for application may be Business development, finance, HR, Supply Chain, Manufacturing, Retailing, Software solutions etc.

One has to choose a domain in which they can apply, depends on their educational background, interest and availability of job in a particular domain.

Who Choose Thoughtware Analytics?

All the specialization topics are handled by Industry experts, qualified/certified, who have domain related work experience, applied the concepts in their work-place.

Away from tradition academic training by trainers, who have no professional experience, here you will get the first hand experience from the Industry experts

Program Eligibility

Graduates in any discipline with aptitude for Mathematics/Statistics

Basic computer and MS Office knowledge

Program is suitable for all levels, whether you are in final year, freshers looking for job, or at entry/middle level

Looking for change from current domain to Analytics domain

Program Content

PART I – Basic Data Analytics Tools(Common for all Specialization – 100hrs)

Module 1 – Data Science basics (2 hrs)

  • Data and its types

  • Data analysis and analytics

  • Analytical model frame work

  • Big data & its applications

  • Basics of coding

Module 2 – Python for data analytics (20 hrs)

  • Is Anaconda/Jupiter still relevant? How Google Collaboratory is replacing it?

  • Conditional & Loop statements

  • Functions

  • Exceptions handling, types of error

  • Modules

  • Tuples, lists, dictionaries

  • NumPy, Pandas

  • Matplotlib

  • Importing files in Python

  • Seaborn

  • Working on datasets (including preparation, modeling & analysis)

Module 3 – Applied Statistics (8 hrs)

  • Statistics foundations

  • Probability and statistical inferences

  • Hypothesis testing applications

  • Working with data sets

  • Predictive models using regression

Module 4 – MySQL (10 hrs)

  • Introduction

  • Fundamental statements

  • Refining selection (charts & graphs)

  • Database

  • Joins & string function

  • Functions

  • Projects & case studies

Module 5 – Advanced excel (10 hrs)

  • Excel functions

  • If, for, while statements

  • Charts & graphs

  • Pivot tables

  • Slicers

  • Macros

  • VB

  • Simple dash boards

Module 6 – Power BI (10 hrs)

  • Introduction

  • Query editor

  • Data Models& relationships

  • DAX (Data Analysis Expressions)

  • Reporting

Module 7 – R for data analytics (20 hrs)

  • Intro, syntax, comments, variables, datatypes

  • Numbers, Math, String, Boolean, Operators

  • If, Else, While, For, Functions

  • Data Structures

  • R Graphics

  • R Statistics

  • Project

Module 8 – Introduction to ML (20 hrs)

  • Introduction to machine learning

  • Regression

  • Classification

  • Clustering – K means

  • KNN

  • Advanced regression models

  • Decision trees

  • Ensemble techniques

  • Support Vector machines

  • Bayesian family algorithms

  • Time-series analysis

  • Pipeline & auto ML

  • Projects

Module 1 – Data Science basics (2 hrs)

  • What is coding?

  • Which tools and why?

  • Big Data understanding

  • Statistics/Mathematics basics

Module 2 – Python for data analytics (20 hrs)

  • Is Anaconda/Jupiter still relevant? How Google Collaboratory is replacing it?

  • Conditional & Loop statements

  • Functions

  • Exceptions handling, types of error

  • Modules

  • Tuples, lists, dictionaries

  • NumPy, Pandas

  • Matplotlib

  • Importing files in Python

  • Seaborn

  • Working on datasets(incl preparation, modeling & analysis)

Module 1 – Data Science basics (2 hrs)

  • What is coding?

  • Which tools and why?

  • Big Data understanding

  • Statistics/Mathematics basics

Module 2 – Python for data analytics (20 hrs)

  • Is Anaconda/Jupiter still relevant? How Google Collaboratory is replacing it?

  • Conditional & Loop statements

  • Functions

  • Exceptions handling, types of error

  • Modules

  • Tuples, lists, dictionaries

  • NumPy, Pandas

  • Matplotlib

  • Importing files in Python

  • Seaborn

  • Working on datasets(incl preparation, modeling & analysis)

Part II –Specialization (Choose any one)

FINANCE ANALYTICS

​Section A - 20 hrs

  • Brief over-view of concepts in Finance, Costing, Banking, Insurance, Compliance

  • Metrics and benchmarking

  • Digital Finance management

  • Challenges in today’s world

  • Applications of Financial Analytics

 

Section B - 30 hrs

Similar to below (min 4, Assignment 1)

  • Build a Credit Scorecard Model

  • Stock Price forecasting

  • Portfolio Optimization

  • Segmentation Modelling

  • Pricing financial products

  • Fraud model

MARKETING ANALYTICS

Section A - 20 hrs

  • Basic concepts in Sales, Marketing, content marketing, social media marketing, market research, Influencer marketing..

  • Marketing trends & CRM

  • Metrics & benchmarking

  • Why Marketing analytics is key to today’s survival?

 

Section B - 30 hrs, Similar to below Case studies (min 4, assignment 1)

  • Product analytics

  • Price and promotion analytics

  • Customer analytics

  • Sentiment and text analytics

  • Marketing spend optimization

  • Lead score generation

  • Co-branding analysis

  • Cohort analysis

HR /PEOPLE / WORKFORCE ANALYTICS

Section A - 20 hrs

  • Human resource planning & acquisition

  • Developing the leaders of tomorrow

  • Learning and development

  • Managing diversity with local in mind

  • Health and Safety

  • Creating a Quality Employee Experience

  • Learning organization

  • Retention of employees

  • Performance measurement, HR Metrics & Benchmarking

  • Analytical applications in HR

 

Section B - 30 hrs, Similar to below Case studies (min 4, assignment 1)

  • HR analytics

  • Workforce analytics

  • Recruitment analytics

  • Engagement and performance analytics

  • Recruitment Analytics (employee churn)

  • Absenteeism, incident rate, inactivity rate, severity rate

  • Analysis and visualization of HR data

SUPPLY CHAIN ANALYTICS

Section A - 20 hrs

  • Concepts of Supply Chain

  • Supply Planning, Demand Management, Capacity Planning, PPC

  • Purchasing, S&OP, MPS, MRP, Demand Forecasting

  • Supply Chain Metrics

  • Challenges in Supply Chain

  • How analytics can help improve Supply chain challenges

 

Section B - 30 hrs

  • Basic Forecasting models

  • Holtz Winter Forecasting using Solver

  • Regression in Forecasting using Solver

  • Warehouse location Optimization using solver

  • Distribution Optimization using Solver

  • Spend analytics

  • E-commerce Distribution – Supply Chain metrics evaluation using SQL

  • Inventory modelling, EOQ, Safety stock, Shortages, using Python, ML

  • Vehicle routing optimization, using Python, ML

Duration: 5 months, ~ 150 Hrs Program(live)

Day: Week-ends, IST. Enrollment under Progress

Mode: Online, Live and Inter-active

Platform: GoToMeeting and/ or similar

Certificate:

1.    Enrollment certificate - < 80% attendance

2.    Participation certificate - > 80 % attendance

3.    Completion certificate - > 80 % attendance + 60% score in final exam (1 attempt)

4.    Internship certificate - > 80 % attendance + 60% score in final exam (1 attempt) + one project under our guidance

 

The e-certificates are provided from “Thoughtware Analytics” (a unit of “Thoughtware Training Pvt Ltd”).

Validity-life time

Program Conducted by:

237860496_332794388768341_5045427919071572628_n.jpg
  • LinkedIn

Lead Trainer:
Mr. Pattabhi Raman, APICS – CPIM, CSCP, CLTD, DDI – DDPP, PMP

Globally recognized Supply Chain expert

Advisers & Consultants 

 

Training Materials:

All Excel/SQL/Python templates/solutions and video recordings link/login will be provided. Recommended books will be suggested

Notes:

1. Pl contact our team, for best prices (early-bird etc..).

 

2. Early bird discount is applicable, if payment is made within due date, in single instalment

3. Only e-certificate will be provided

4. This is special promotional price, no refund or adjustment possible.

5. This pricing is for individuals and request for quote, if you need for corporate training

6. Content of the program will be updated regularly, based on market developments and domain experts’ advice

7. Option to choose more than one specialization is possible at additional cost

8. Below Placement assistance will be provided to all candidates who have 80% attendance + > 60% score in final exam

*           Resume Review

*           Mock-interview

*           Job referrals

9. No refund or exchange is possible under any circumstances. Pl make sure you understand the content, scope and methodology, before you enroll

 

Payment:

Payment from multiple modes possible – UPI, Credit card, Debit card, Internet Banking and Pocket Wallet. Please reach out to us to get the payment link Thoughtware Training Pvt Ltd. www.exxpertscm.net

parameswar.PNG
gitap.PNG

Mr Parameswaran, CA        

Ex CFO – Blue Dart, Taj, Sri Lankan & Jet Airways

Dr PC Gita PhD

Ex- CIPLA, SCI, Protec

Marketing & HR Specialist

To enroll, or for more details
Send us a message
and we’ll get back to you shortly.

Thanks for submitting!

Note:

# All rights reserved. Program content, schedule maybe updated depending on requirements

# All video links, will be valid for limited period. For long term use, you are requested to download to your local system

# The candidate is expected to have latest version of software installed in the system and ready with the system during the program. We will not involve in software installation, during our programs. However, pre-assistance will be provided

# Though we provide placement assistance, we do not guarantee the job

# This Executive program is developed for skill development and are not recognized by any universities and government authorities

png-transparent-computer-icons-whatsapp-whatsapp-text-trademark-logo-removebg-preview.png