Client is one of the top FM radio channels having stations spread all across India and who has grown rapidly in last couple of years. One of the challenges of this growth has been managing systems and processes, and more importantly access to actionable and current business critical information. Management found it difficult to track and monitor Key Performance Indicators (KPI) which in turn restricted the business growth.
dMine Media Dashboards helped the media company to design, monitor and act on critical business parameters by collating information from diverse data sources like ERP, Advertising & Sales System, Competitor Analysis data etc. Management could now create their own Sales Dashboards as well as view and share them in multiple formats and thus monitor their business better.
The Problem
Client being a major player in the media and communication space has to constantly monitor entire operations of all their stations like Revenues from sponsors, Peak and Non-Peak time Inventory & Sales, Market Share & Channel Ranking, P&L, Forecasts and other critical information. Currently the client uses multiple Applications for supporting these business functions which capture data in different databases and sources.
MIS was created by extracting data from multiple sources in Excel sheets manually. These excel sheets are distributed among the management, with a turn around time of about 15 days.
Concern Areas
- Data was available, but in a distributed environment and in multiple systems without any consolidation.
- Users had to manually pull out data from multiple system and process this data and there was always a possibility of errors
- Information shared in Excel sheets which were not secure and could be tampered with
- Little actionable information in the MIS as it is days old, and in some cases months old. Data relevancy is very low
- MIS is identified and managed by IT and Operations teams. Any request by management takes inordinate time to be implemented
- MIS reports were used by Top Management, Operational Managers and Investors – but the reports going to all of them are exactly same
Solution Implementation
- Icicle has implemented dMine Media Dashboards in 17 days right from discussions with the management to go-live by using dMine Media Dashboard On-Premise edition on Client’s server
- dMine Media Dashboards collates information from multiple data sources like ERP and Sales systems. Some of the information is also uploaded in the form of Excel sheets
- The data was collated from different sources based on certain parameters, which are current and relevant
- More than 70 Metrics and Analytics are defined for the Client, management now has access to this information whenever they require
- Five Media Dashboards are identified as critical – Organizational KPI, Financial Dashboard, Sales Dashboard, Market Share & Metrics Dashboard and Operational Dashboard
- Access levels are defined for the information and are controlled in much more secure and transparent way. Managers across different stations now have access to these Media Dashboards with their own data
- Managers can also create their own Sales Dashboards and Metrics and share them on Email as PDF
Few Benefits
- dMine Media Dashboard product helped the Client in effective monitoring of business operations, KPIs, and organizational performance
- Information in the hands of Decision Makers and Operational Managers minimizing IT involvement in accessing business data
- Actionable and Real-time information for the management to take any critical business decisions
- Complete and Secure solution with access levels defined for business critical information
- Metrics which are parameterized and with drill-downs which allow the management to get the source of issue rapidly
- Very short implementation time lines allow Users to see the benefits quite quickly