Case Study on
Multinational Pharmaceutical Company
Data problem:
Being the largest distributor of pharmaceutical products in the state of Tamil Nadu with over 22,000+ products and over 1300+ outlets (customers), the client wanted to start data analysis projects in their organization with the goal of streamlining operations and reducing costs across the company.
Main Objectives:
- Understand sale of products across categories, branches, regions and salesman
- Revenue vs. Margins vs. Expenses reports to understand revenue flow and fund allocation
- Goals and targets to be set for branches, salesman and product categories
Impact Created :
- Viewing reports periodically brought uniformity in data consumption across the company Scheduled reporting/ ad hoc reports every month that captured the overall performance of the company reviewed during weekly/ monthly meetings with board/ upper management and employees
- Important metrics captured and standardized across all branches: Quantity, revenues & margins earned across categories, margin per product, margins per salesman, new customers acquired and so on
- Targets set for branches, salesman, customers and reviewed on a weekly basis and at the beginning of every month
- Seven-day working week shifted to 6 day working week (Sunday was made holiday) after analysis showed that 6 day working week was most efficient for the company as a whole (margins vs. expenses analysis)
- Helped reverse faulty and erroneous data capturing on the company cloud-based software to help facilitate reporting and data analysis
- Trained in-house team on MS Office and on statistical methods to enable team to operate efficiently and error free
Other Case Studies
Montessori School, Chennai
Case Study on Montessori School, Chennai Data problem :The client had recently revamped their website and had integrated Google Analytics.However, they were skeptical about using the
International Software Development Company
Case Study on International Software Development Company Data problem : Client’s website witnessed a 3x increase in online traffic at the beginning of the lockdown due
Grain And Oilseed Milling Products Manufacturer
Case Study on Grain And Oilseed Milling Products Manufacturer Data problem : Manufacturer of Rice Bran oil wanted to solve the problem of purchasing raw material