Vasu Agarbathies : QlikView – BI for Sales

By deploying the BI and reporting solution from QlikView the organization is able to reduce the time in report generation by over 50%

Monday, June 01, 2009

Print

Comment

Email

Digg

Del.icio.us

Reddit

Twitter

Vasu Agarbathies didn't have an IT team who could decide on any BI solution. The top management was analyzing the data by doing this in the excel sheets earlier. The major challenge was to keep the multiple sets of Excel sheets / files in different systems and collating these Excel files from different users and locations and to create common reports. Apart from the Excel files they were using, tally and the data has to be exported in Excel again and again to prepare the reports manually by combining both the data. So, the requirement was to reduce the time taken in collating the Excel files and better analysis of data, and to give the top management a single truth of information. QlikView was deployed for the sales team to replace all the Excel files & Tally usage and create a common truth of information for all the users. The biggest challenge for the deployment was that the employees, being addicted to the old fashion of analyzing the data in Excel, the top management were not able to visualize the kind of Analysis that were required for improving the business performance. While creating the reports for the top management & to give them to the sales persons at specific locations, they have to circulate all their respective files to the head office in Mysore and would collate all the Excel sheets. The deployment has allowed the top management to analyze the data effectively to bring better performance. They improved business performance in terms of sales and reduce the cost incurred. This also allowed them to analyze what are the new locations where they can target the customers with respect to their Business. One of the key outcomes of the project was that it has reduced the involvement of business users for generation of reports to over 50%.

Page(s)   1