coke bottlers convention

1
R.O.I
Dashboard Analytics Reports
2 0 0 9
T E A M C OM P U T E R S P V T. L T D.
1
2

Operational Dashboards

• To measure improve productivity
• To control resources efficiently
• Identify reduce leakages
• Single version of truth

2 0 0 9
T E A M C OM P U T E R S P V T. L T D.
2
3
Results _at_ glance
Users CEO/ CFO
Update Frequency Weekly
BEFORE
AFTER

• No Dashboard
• P L delivered on
• 6th/ 7th of every month

• Results at a glance
• P L delivered on 2nd of
• every month
• ROI Rs.3500/month
• (CTC Rs.4.80 lacs/annum)

4
Banks _at_ glance
Users CFO
Department Finance Frequency Weekly
AFTER
BEFORE

• Live position of all the accounts
• Better control of PDC movement
• ROI Rs.4000/month
• (CTC Rs.3.0lacs/annum)

• Data maintained in excel sheet
• Each bank had a different sheet

5
VAT/ CST Report
Users Account Executive
Department Taxation
Frequency Monthly
AFTER
BEFORE

• Publish _at_ 1 click / slicing

• Difficult collation of data
• Calculations were manual

ROI Rs.5000/month (CTC Rs.4.0
lacs/annum)
6
Sales/ Products Dashboard
Users Department Heads
Department All
Frequency Once Daily
BEFORE
AFTER

• Performance measurement
• Projections easily available
• ROI Rs.4000/month
• (CTC Rs.6.0 lacs/annum)

• No dashboard for these figures
• MIS a pain area

7
Customer Outstanding Details
User Managers Department
Infrastructure Solutions
Frequency Daily
BEFORE
AFTER

• Process captured
• in excel-sheets
• No co-ordination
• between resources

• Real time capturing of
• every step in the process

ROI Rs.30,000/month
(CTC Rs.3.60 lacs/ annum)
8
Order to Delivery Dashboard
User Sr. Manager
Department IBS Frequency
Daily
BEFORE
AFTER

• Manual tracking of
• documents/ materials
• Zero Analytics

• Full Analytics
• Documents/ materials/ cash tracking

ROIRs.6000/ month
(CTCRs.7.20lacs/ annum)
9
Engineer Productivity Analysis
User Resource Manager
Department IMS
Frequency Bi-monthly
BEFORE
AFTER

• No analysis possible
• Complexity in getting trends

• Productivity calculation
• made easy
• Analysis possible

ROIRs.5000/month
(CTCRs.7.20lacs/ annum)
10
HR Dashboard
Users HR executive
Department HR Frequency Weekly
BEFORE
AFTER

• Separate excel sheet
• for each GM/ TL
• Data collection/ collation a pain area
• Had to follow multiple excel sheets
• for follow up

• Current trend is easily available
• Follow up is easily done
• Pending status is easily available

• ROIRs.3000/month

• (CTCRs.2.40lacs/annum)

11

• Thank You