Heading
Introduction
The Cement company is in the business for 40+ years. With a total capacity of 8 MTPA, they serve Maharashtra, Telangana, Andhra Pradesh, Karnataka and parts of Madhya Pradesh, Tamil Nādu, Kerala, Gujarat and Chhattisgarh.
Challenges
The company had astatic and very basic reporting system. Adoption of the Data was not increasing beyond certain teams i.e., sales and finance. Below points can summarize the overall challenges faced by the cement giant:
- Static Reports with basic set of filters and limited data access.
- Discrepancy in analysis made on excel sheets were being circulated in the company with no clear single source of truth.
- Siloed reports for each team couldn’t enable them to look at the overall picture.
- They couldn’t use their CRM data with the rest of the reports due to a different database.
- Manual refresh/update of Excel was done on a monthly basis for 1 region filter applied, Analyst couldn’t compare whole data at the same time.
The archaic ways of data analytics caused inaccurate sales reports lacking real-time analysis of the distributors and dealers across India resulting in loss of business.
Company Profile
Industry:
Infrastructure
About Qlik
Industry:
Qlik is a leader in data discovery delivering intuitive solutions for self-service data visualization and guided analytics. Over 34,000 customers rely on Qlik solutions to gain meaning out of information from varied sources, exploring the hidden relationships within data that lead to insights that ignite good ideas.
The Solution
Like every other cement company, our client is also expanding their product portfolio and production capacity to meet the escalating cement demand due to the development of mega infrastructure projects. To cope up with the increasing business, application of an advanced and innovative data analytical system was the need of the hour and Qlik emerged as the savior. After understanding the challenges faced by them, the following solutions were provided by Diagonal:
- Integration of CRM data in sync with other reports.
- Seamless and automated report that was previously reloaded manually with only 1 filter.
- A Customer 360° view dashboard which included data from SAP ECC and their own CRM software shares the comparative analysis of the Region vs Zone vs Sales Office vs Customer name vs Product category vs Time Period.
- User training has been provided about all the dashboard capabilities, this led to an increase in user participation and higher adoption of Qlik.
- Daily reporting on Channel Dealer and Retailer Bulletin showing analysis based on Product, Quantity and Sales with time period comparison. Further drilling the data from Division -> Region -> Zone -> Sales Office. The HOD and Managers were able to dynamically compare YTD & MTD reports with previous years
- Dealer performance based on quantity procured, No. Of visits to the stores, new stores/retailersonboarded etc. further classifies them into grown or degrown category.
The efficient data analytical system helped the company to look at the market trends and innovations in abright light and be a competition in this growing market.
You have a business case?
Talk to us
.svg){kind=small}