Advanced Business Analytics using Excel
Data is the new oil and a workshop on Business Analytics using Excel will help you extract the best of it.
This workshop will show you how to analyse any data and derive insights from it. You will learn basic and advanced business analytics techniques which will provide you with the best foundation to enter into the big, bad world of data analytics.
This is a great course for students who are pursuing Graduation/Post-Graduation and experienced professionals as well. This course is especially beneficial for students of B.E, B.Tech, B.Com, BBA, MBA & PGDM; IT developers & testers; data analysts; junior Data scientists; analytics professionals; BI and reporting professionals; project managers and professionals working with data in any industry.
Who is it for
Students Pursuing B.E , B.Tech,B.Com, BBA, MBA & PGDM
IT developers & testers
Junior Data scientists
BI and reporting professionals
Professionals working with data in any industry
What does it cover
Basic Excel Techniques: What-if analysis, Vlookup, Index, Match, List, Conditional Formatting & Mean, Advanced Pivot Table
Advanced Excel Techniques: Descriptive Analysis, Histogram & Charting, Correlation Matrix, Standard Deviation, Variance
Basic Analytics Using Excel: Regression, Hypothesis Testing, Normal Distribution, Forecasting, Net Present Value, Future Value, EMI
Business Analytics Using Excel: RFM Analysis, Customer Lifetime Value Analysis, Customer Profitability Analysis
What will be the takeaway
Career benefits :
The use of Business Analytics is widespread across all industries and functions, including Information Technology, Web/E-commerce, Healthcare, Law Enforcement, Banking and Insurance, Biotechnology, Human Resource Management. Some of the application areas include critical product analysis, target marketing, customer life-cycle management, customer service, social media behavior and link analysis, fraud detection, genetic research, inventory management, etc.Below a list of a few Business Analytics roles across industries:
Marketing Analytics Manager
Supply Chain Analyst
Retail Sales Analyst