Advanced Business Analytics Using Excel

Advanced Business Analytics Using Excel

 

  • Early Bird

    Sale Date Ended

    INR 6000
    Sold Out
  • Normal

    Sale Date Ended

    INR 7500
    Sold Out

Invite friends

Contact Us

Page Views : 33

About The Event

 

Workshop Content would be as follow:

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 Calculation

Business Analytics Using Excel: RFM Analysis, Customer Lifetime Value Analysis, Customer Profitability Analysis 

 

Tenure: 
1) Workshop would be conducted for 2 Days
2) There would be 4 sessions of 3 Hours each
 
Certification:  Course Certificate in Basic and Advanced Business Analytics

 

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 lifecycle 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:

  • Data Analyst
  • Business Analyst
  • Financial Analyst
  • Marketing Analytics Manager
  • Pricing Analyst
  • Supply Chain Analyst
  • Website Analyst
  • Fraud Analyst
  • Retail Sales Analyst
  • Clinical Analyst

 

Venue Map