ivy dataanalyticsconsulting for mba students final
DESCRIPTION
data analyticsTRANSCRIPT
![Page 1: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/1.jpg)
O SS O SC OOIVY PROFESSIONAL SCHOOL
“Data Analytics Consulting Industry For MBA Students”By Career Centre Team @ Ivy
1
![Page 2: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/2.jpg)
Outline
Introduction – Agenda Overview
Industry Outlook yo What is Analytics Consulting?o Steps in Executing Analytics Project
Career Mapping Career Mapping o Who is it for?o Important Skills Required o Career Opportunities for MBA Studentso Various Profiles & Expected Salary
Information on SASo What is SAS?o What is SAS?o Application of SASo Role of SAS in Various Industry
O Di i Q&A
2
Open Discussion – Q&A
![Page 3: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/3.jpg)
Industry OutlookIndustry Outlook
3
![Page 4: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/4.jpg)
What is Analytics Consulting?
• It involves extracting Information from Data
pertaining to a business problem to un-earth
underlying patterns that can help solve the problemunderlying patterns that can help solve the problem
or to make various business decisions.
• For ex – Product Marketing companies use Analytics
to forecast the success or failure of a new product
launch.
4
![Page 5: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/5.jpg)
Data to Information Intelligence Lifecycle
5
Source: www.sas.com
![Page 6: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/6.jpg)
Steps to Execute Analytics Project
1. Business Problem1. Business Problem
2 A l ti P bl2. Analytics Problem
3. Analytics Solution
4. Business Solution
6
![Page 7: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/7.jpg)
Career MappingCareer Mapping
7
![Page 8: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/8.jpg)
Who is it for?
• It’s a great career for people with good g p p g
business sense and who enjoy working
with numbers to unearth patterns to
solve business problemssolve business problems.
8
![Page 9: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/9.jpg)
Important Skills Required
• Strong Analytical and Problem Solving Skills
• Business Statistics Application Knowledge
• Hands-on knowledge on Analytics Tools g y
• Advanced MS-Excel Analysis & Reporting Skills
• Excellent Interpersonal Skills
• Strong Oral and Written Communication Skills
• Ability to work in a Team and LeadStrong Business Sense is Mandatory!!
9
Strong Business Sense is Mandatory!!
![Page 10: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/10.jpg)
Career Opportunities for MBA Students!
• Have background in quantitative field• Use SAS for performing simple to complex statistical
analysis on relevant dataCan work in any industry
Eco/Statistics/Maths• Can work in any industry
• Have management or finance background• Use SAS for financial decision making purposesBusiness/Finance • Lot of opportunities in Risk & Fraud Analytics• Hiring Companies: HSBC, Citi Bank, Nomura, etc.
Business/Finance
• Have programming background• Can work as Data Manager/Developer/ProgrammerEngineers/Comp. Sc.
• Can work as subject matter expert in healthcare analytics
Doctors/Pharma./Life Sc.
10
![Page 11: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/11.jpg)
Various Analytics Profiles
• Business Interpreter– Ability to relate analytics solution to business– Ability to relate analytics solution to business– Basic knowledge of statistics– Ability to handle software programsy p g– Ideal for the MBA students
• Statistical Analyst– Background in Maths, Stats, Eco or Computer Science
• Extract-Transform-Load (ETL) Programming– Good knowledge of database & database
programmingBE/ M Sc in any quantitative field– BE/ M.Sc. in any quantitative field
11
![Page 12: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/12.jpg)
Expected Salary
P fil F h Mid L l S i L lProfile Fresher Mid-Level Senior Level
ETL Programmer 3 to 5 Lakh 5 to 10 Lakh Above 10 LakhETL Programmer 3 to 5 Lakh 5 to 10 Lakh Above 10 Lakh
Statistical Analyst 4 to 6 Lakh 6 to 12 Lakh Above 12 Lakh
Business Interpreter 5 to 7 Lakh 7 to 15 Lakh Above 15 Lakh
Source: Telegraph August 2012
12
![Page 13: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/13.jpg)
What is SAS?What is SAS?
13
![Page 14: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/14.jpg)
What is SAS?
• SAS stands for “Statistical Analytical System”
• Developed in early 70’s at the North Carolina State Un.
• SAS Institute Inc., formed in 1976, owns SAS
• World leader in Business Intelligence & AnalyticsWorld leader in Business Intelligence & Analytics
• 90% of fortune 500 use SAS“The industry leader in information delivery – the complete process of converting raw data… into meaningful information that is required to support decision making.” – SAS Publishing 1999
14
![Page 15: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/15.jpg)
SAS, a leader in BI Tools Industry
Statistical Analysis Win Cross
Predictive ModelingPredictive Modeling
Decision Trees &Decision Trees & Knowledge Decision Trees &Segmentation
Forecasting &
Knowledge Seeker CART
Forecasting &Simulation
Optimization Evolver Risk OptimizerOptimization
Campaign Unica
Evolver Risk Optimizer
15
ManagementUnica
![Page 16: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/16.jpg)
SAS is an End to end Data Mgmt and Analytical Tool
•Data Entry, Retrieval and Management•Report WritingSt ti ti l d M th ti l A l i
•Data Entry, Retrieval and Management•Report WritingSt ti ti l d M th ti l A l i
Applications of SAS
Applications of SAS
•Statistical and Mathematical Analysis•Business planning, Forecasting and Decision Support•Operations ResearchQ lit I t
•Statistical and Mathematical Analysis•Business planning, Forecasting and Decision Support•Operations ResearchQ lit I t
B SAS D t M t d B i P dB SAS D t M t d B i P d
•Quality Improvement•Applications Development•Quality Improvement•Applications Development
SAS P d tSAS P d t
•Base SAS – Data Management and Basic Procedures•SAS/SQL – Structured Query Language•SAS/STAT – Statistical AnalysisSAS/GRAPH P t ti Q lit G hi
•Base SAS – Data Management and Basic Procedures•SAS/SQL – Structured Query Language•SAS/STAT – Statistical AnalysisSAS/GRAPH P t ti Q lit G hiSAS ProductsSAS Products •SAS/GRAPH – Presentation Quality Graphics
•SAS/OR – Operations Research•SAS/ETS – Econometrics and Time Series AnalysisSAS/IML I t ti M t i L
•SAS/GRAPH – Presentation Quality Graphics•SAS/OR – Operations Research•SAS/ETS – Econometrics and Time Series AnalysisSAS/IML I t ti M t i L
16
•SAS/IML – Interactive Matrix Language•SAS/IML – Interactive Matrix Language
![Page 17: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/17.jpg)
Role of SAS In VariousIndustries
17
![Page 18: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/18.jpg)
Role of SAS in Various Industries
Financial Services Retail Life Science &Financial Services• Areas used in
• Banking• Capital Market• Credit Unions
Retail• Areas used in
• Customer Intelligence• Operational
Intelligence
Life Science & Pharmaceuticals• Areas used in
• Clinical Data IntegrationC ed U o s
• Lenders• SAS used for
• Reporting• Data Mining
Forecasting
Intelligence• Performance
Management Solutions• SAS used for
• Reporting• Forecasting
Integration• Drug Development• Patient Safety• Sales & Marketing
• SAS used forSt ti ti l A l i• Forecasting
• Financial Research• Predictive Modeling
• Forecasting• Market Analysis• Data Mining
• Statistical Analysis• Clinical Research• Reporting• Forecasting• Data Mining
18
g
![Page 19: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/19.jpg)
Role of SAS in Various Industries
M diTravel & Transportation• Areas used in
• Dynamic PricingRevenue Optimization
Media• Areas used in
• Audience Insight• Advertising Yield• Media Mix Modeling
Manufacturing & Supply Chain Management• Areas used in
• Spend Analysis• Revenue Optimization• Asset & Operation
Optimization• Demand Forecasting• Customer intelligenceSAS d f
• Media Mix Modeling• Subscriber Acquisition
& Retention• Content Analytics
• SAS used for
• Spend Analysis• Sales & Operation
Planning• Demand Forecasting• Cost & Profitability
O ti i ti• SAS used for• Forecasting• Reporting• Analysis
• Market Analysis• Reporting• Forecasting• Data Mining
Optimization• Commodity
Classification• SAS used for
• Forecasting
19
• Market Analysis
![Page 20: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/20.jpg)
Ivy’s Credentials & Open Discussion
20
![Page 21: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/21.jpg)
Ivy Has Been Trusted By
Students from Professionals fromIIT Kharagpur HSBC AnalyticsIIM Calcutta Genpact AnalyticsISI, Kolkata Frost & SullivanPresidency College NeilsonSt. Xavier’s College Zacks ResearchC l tt U i it C i iCalcutta University CapgeminiJadavpur University TCSIISWBM EbayIISWBM EbayBITS, Pilani ICICINIT, Trichy, and many more.. PwC, and many more..
21
NIT, Trichy, and many more.. PwC, and many more..
![Page 22: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/22.jpg)
Ivy Alumni Are Working At..TCS A l ti S A l tiTCS Analytics Spencer AnalyticsGenpact Analytics Accenture AnalyticsICRA Analytics CognizantICRA Analytics CognizantHSBC Analytics Ogilvy and MatherFractal Analytics AmazonFractal Analytics AmazonHP Analytics Mu Sigma AnalyticsDELL Analytics Neural TechsoftWipro Analytics IpsosMcKinsey ExperiaDunnhumby Cytel AnalyticsGE Money Analytics Mercados Consulting
and many more22
and many more..
![Page 23: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/23.jpg)
Ivy is the Official Learning Business Partner of..
23
![Page 24: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/24.jpg)
Questions
• Raise hand, and ask questions.
• Have un-answered or personal profile related questions?related questions?– Email at [email protected] (Sub:
‘Analytics Consulting Seminar Questions’)Analytics Consulting Seminar Questions )
24
![Page 25: IVY DataAnalyticsConsulting for MBA Students Final](https://reader038.vdocuments.us/reader038/viewer/2022103104/577cc7991a28aba711a1706a/html5/thumbnails/25.jpg)
Visit Ivy’s Blog for Career Tips, Latest Info, Job Alerts -www ivyproschool com/blogwww.ivyproschool.com/blog
Interact with us at -
Ivy Professional School
14 B | Camac Street | Kolkata – 17 www.ivyproschool.com | [email protected]
25
www.ivyproschool.com | [email protected]: 033 400 11221 | SMS: 9748 441111