Custom Solutions, Endless Possibilities for Startups and Enterprises

Decision Making Via Data Analysis





    Approach

    1. Initiation

    2. ETL

    3. Business Intelligence

    4. Business Analytics

    5. Decision Making

    Initiation

    Business Model

    Business Goals

    Competition

    IT Infrastructure (from Data Collection point of view)

    Quantify Goals

    Data Collection

    Data Sampling

    Enquiries and Enrolments

    House Hold Income

    Gender

    Father/Mother’s Occupation

    Marketing, Advertising/

    Teaching, Support Staff

    IT, Physical Infra

    Course Material (Hard / Soft)

    Expectations

    Road Blocks / Constraints

    Risks

    Define Success / Failures

    ETL

    Deviations

    Data Distribution

    Characteristics of Data

    Distribution

    Data Relationships

    Data Dimensionality

    Business Intelligence

    Course-Geography

    Concentrations

    Potentials

    Expenses

    Geographical Analysis

    Demographical Analysis

    Data Relationships (continued)

    Trends

    Central Tendencies

    Confidence Intervals

    Goodness of Fit

    Business Analytics

    Response vs. Explanatory Variables

    Y as a function of x1, x2,…xn

    Simulations (Monte Carlo!)

    Generalized Linear Models

    Validation of Models

    Decision Making

    Predict

    Do What-If Analysis

    Pilot the Decision

    Tune and Implement

    BI / Analytics

    👉We provide a variety of descriptive and predictive analysis

    👉While majority of analysis is descriptive and dashboards based on slice and dice

    👉Some predictive analytics is also proposed

    👉Assumptions that market research data, CRM data, sales data are all available

    Descriptive Analytics Sliced by Region

    Summary of Historical Data

    Enrolment

    Scholarships

    Examination

    State

    Pin Code Range

    Rural vs Urban

    City

    By Location

    Channel Analysis

    Channel Source (Email, Web, Telecalling)

    State

    City

    Channel Source (Email, Web, Telecalling)

    State

    City

    Channel source

    CRM Effectiveness

    Stage Wise Dashboard

    State

    City

    Pin Code

    In some cases specific school based dimensions can be considered

    Attrition Analysis

    Channel

    State

    City

    School

    Course

    Channel

    Forms

    Partial Withdrawal

    Market Research Based Analysis

    By State

    By City

    By Zip

    By Analysis of Target Location Based Potential

    Projecting Sales Growth once opened

    By State

    By City

    By Zip

    Promotions/Offer Analysis

    Conversion to Spend

    Channel Wise Analysis

    Channel wise

    New Locations wise

    Course Wise

    Profit/Loss Analysis

    Course

    Grade

    State

    What If Analysis

    State

    City

    Course

    Conversion Ratio

    Profit/Loss