DWH CASE-LET - 18
Scenario
Industry : Banking
Company : ABC Bank Of India
Value chain focus : Loan Analysys
Sample business questions
What are the Top 3 loans opted by customers, over last 5 years?
What is the income range of customers going for vehicle loans, each year?
Revenue generated by each loan by year by quarter?
Interest earned against each loan
Top 10 defaulters in each loan category by year by geography
Build DWH Model with facts and dimensions.
DWH CASE-LET - 19
Scenario
Industry : Insurance
Company : ABC Insurances ltd
Value chain focus : Customer Analysys
Sample business questions
Premium collected by policy by geography by year by quater?
Number of claims made by policy by geography by year by quarter vs No. of claims settled?
Top three Insurance plans, where maximum defaulters are there by geograyhy by year by
quarter.
What are the top five plans sold by year by quarter in different income groups?
Top 1000 customers paying premium well before the due date in each year
Build DWH Model with facts and dimensions.
DWH CASE-LET - 20
Scenario
Industry : Real estata
Company : ABC Constructions
Value chain focus : Investment Analysys
Sample business questions
Top 10 investments by year by state by city.
Top 10 profit generated projects in each city by year.
Invertors categories ( Business man, Service man, employees etc) investing in the progects in
metros vs 2nd level cities.
Investments coming each year by city by investor category.
Total deviant paid to each investor by year by city.
Build DWH Model with facts and dimensions.
DWH CASE-LET - 21
Scenario
Industry : Pharmaceutical
Company : ABC Drugs
Value chain focus : Drugs Analysys
Sample business questions
Top 10 drugs sold by year by quarter by month.
Top 10 drugs returned from the market by year by quarter by month.
Top 10 drugs reached the expired date by state by city by druggist.
Top 10 drugs prescribed by the doctors .
Build DWH Model with facts and dimensions.
DWH CASE-LET - 22
Scenario
Industry : TV Madia
Company : ABC News
Value chain focus : Program and viewers Analysis
Sample business questions
Top 5 news programs watched by viewers by city by time.
What is best news program watched by youth .
Number of viewers for prime programs vs morning and day time programs .
Top 3 programs gaining maximum TRP every day.
Build DWH Model with facts and dimensions.
DWH CASE-LET - 23
Scenario
Industry : On-Line Shoping
Company : Best Deal
Value chain focus : Customer and Product Analysis
Sample business questions
Top 50 customers by stare by city by month.
Top 10 products liked by customers by city by gender by age group .
Total revenue generated by category by product by quarter by month.
What products are sold in the festive time by. City by age group
What products re returned by the customers by ciry.
Build DWH Model with facts and dimensions.
DWH CASE-LET - 24
Scenario
Industry : Advertising
Company : ABC Advertising
Value chain focus : Client Analysis
Sample business questions
Top 5 customers by state by city by industry.
Revenue generated throw different advertising medias in each year
Top medias giving best results for the lowest cost .
Clients attracted by different sales promotions.
Build DWH Model with facts and dimensions.
DWH CASE-LET - 25
Scenario
Industry : Transport
Company : ABC Cabs
Value chain focus : Route Analysis
Sample business questions
Top 10 busiest routs in each city in each state.
Revenue generated by route by city by state in each day.
Frequency of cabs by route by city .
Average number of customers travel in each route.
Build DWH Model with facts and dimensions.
DWH CASE-LET - 26
Scenario
Industry : Hotel
Company : ABC Hotels
Value chain focus : Customer Analysis
Sample business questions
Top 100 customers by branch by city by year.
Top 10 revenue generated branches by city by state in each quarter.
Room types most liked by customers by city by state .
Top customers by frequency of booking .
Top customers by duration of booking by quarter by year.
Build DWH Model with facts and dimensions.
DWH CASE-LET - 27
Scenario
Industry : Tea
Company : ABC Tea
Value chain focus : Product Analysis
Sample business questions
Top 5 brands by state by city by year by quarter.
Top flavors liked by customers by gender by age group .
Different products sold by brand by price range by customers in different age groups .
Total revenue generated by each product by brand by year by quarter .
Build DWH Model with facts and dimensions.
