Career Anna
XAT Decision Making Course   CLICK HERE
XAT Mocks and Decision Making Course   CLICK HERE
3957 Learners taking this Package.

Certified Business Analyst With Excel

  • Gateway for career with Average Annual Salary of INR 25 lakh
  • Be a Certified Business Analyst with Excel
  • Recognised by more than 55 Companies for Jobs and Salary Hike
  • Add the Pro Degree Certificate to Your Resume and stay ahead
  • 20+ Hours of Video Content, followed by Case Study
  • Learn Data Sensitivity, Mining, Power Pivots, Market Basket Analysis, Tool Kits and more

Enrol Now Demo Videos

Course Content

8999 ₹ 9999 10% Off

Demo Videos


Our Students work in following Companies

Jobs in Business Analysis

  • Business analysis is increasingly required by companies that rely on data to plan the futuristic strategy for their growth
  •  Areas include government, finance, IT, HR, Supply Chain retail, risk management, marketing, manufacturing and more
  •  Number of Business Analyst jobs in various domains, such as market research and finance, is expected to grow by 18% until 2022
  •  Average annual salary is in the range of INR 25 lakh for professionals with 2+ years of industry experience (Indeed)

All About Business Analysis

Business analysis teaches requirements management – one of the core skills of business analysts. Developing technical solutions to business problems, or to advance a company's sales efforts, begins with defining, analyzing and documenting requirements.

With an average annual salary of a Certified Professional in Business Analysis, pegged at INR 25 lakh for a professional with 2 years of experience, this program will help you become a resourceful and independent data analyst who can help organizations reach their goals.

The course will engage you in real time business analysis challenges that simulate the complexity and challenges which data poses to the professionals like you in strategic decision making.

With our industry recognised Professional Certificate Credentials you will be able to demonstrate that you have mastered data processing and you can apply concepts like Data Sensitivity, Scenario Analysis, Forecasting, Mining, Power Pivots, Market Basket Analysis and Tool Kits. Moreover, the course will show that you know how to communicate your findings clearly to various stakeholders.


Who should take this course?

  • Working Professionals who want to become Business Analyst
  • MBA Professionals who need Data for Growth of their Business Function
  •  Sales and Marketing Professionals for Analytics oriented strategy
  • Finance Professionals working in Financial Modeling and Strategy roles
  •  IT Professionals working in Sales and Finance roles
  •  Operations Professionals working in Forecasting and Demand Management roles
  •  Business Analysts
  •  Investment Analysts
  •  Business Owners
  • Entrepreneurs

Course Content

  • Scenario Analysis

    Sensitivity Analysis – Intro

    Sensitivity Analysis

    BreakEven Analysis

    Scenario Analysis

    Solver – Intro

    Optimal Product Mix

    GRG – Optimal Warehouse Location

    Evolutionary Solver

  • Business Forecasting

    Forecasting – Intro

    Straight Line relationship

    Exponential Relationship

    Power Curve

    Time series

    Winters Method

    Demand Curve

  • Scenario Analysis
  • Business Forecasting
  • PowerPivot
  • PowerPivot

    Data Model

    PowerPivot – Intro

    Power Pivot – Case Study Intro

    Power Pivot – Data Loading

    PowerPivot – Building Relational Model

    Creating PowerPivot Table

    PowerPivot –DAX

    Variance Analysis

    Goal Seek

Who should take this course?

  • Working Professionals who want to become Business Analyst
  • MBA Professionals who need Data for Growth of their Business Function
  •  Sales and Marketing Professionals for Analytics oriented strategy
  • Finance Professionals working in Financial Modeling and Strategy roles
  •  IT Professionals working in Sales and Finance roles
  •  Operations Professionals working in Forecasting and Demand Management roles
  •  Business Analysts
  •  Investment Analysts
  •  Business Owners
  • Entrepreneurs


Course Instructor- Analytics_With_ABHI

  • BTech in Computer Science & Engineering and MBA from IIT Bombay
  • 6+ years of experience in the field of Business Analysis, Analytics and Business Visualization
  • Experience across multiple Analytics and Business Intelligence platforms
  • Previously worked with Wipro and is currently working with one of the largest IT organisations in Asia-Pacific Region
  •  Passionate about teaching and helping create a story out of data

Student Reviews and Ratings

4.9

Average Rating
  • 86%
  • 14%
  • 0%
  • 0%
  • 0%
  1. Profile photo of

    Shashank Jha

    01 August 2017
    5 stars

    I had worked on this before but this was something new. I used to do it in Python and Now I can do it on excel well.


  2. Profile photo of

    Chandan Sharma

    30 July 2017
    5 stars

    The instructor makes sure that you get the very basics of everything. Great work


  3. Profile photo of

    Tushar Patra

    28 July 2017
    4 stars

    Great work. Valid content and good instructor.


  4. Profile photo of

    Venkat S. Ravi

    25 July 2017
    5 stars

    Recommended by a friend. Glad I took it.


  5. Profile photo of

    Rahul Tiwari

    28 June 2017
    5 stars

    Loved the course. Will recommend every one to take it irrespective of their domain as data is the new king in all verticals


VIEW MORE

Not sure how to start?

No worries. We're here to help you at every stage of your
entrance preparation


Call us at +91-8340641081 (10 AM to 6 PM)
Whatsapp us at +91-8340641081