Problem Statement
Client were in dire need to provide a self-service analytics platform for dealers within the country to monitor & track its performance and KPIs. They wanted us to provide a solution to the dealers who are not in the client domain and have easy access of the analytics platform.
Solution Overview
AdfarTech implemented MSBI solution consisting of SQL Server 2017 database, integration services, analysis service and portal with embedded PowerBI for the users to do self-service analysis.
- Design architecture consisting of MSBI stack
- Performance report with 5 years of data, database size of 3 TB
- Analytics platform is built on SSAS Tabular model in SQL
- The solution also included 200+ SSRS standard reports
Outcomes
- Direct access to analytics platform by dealers.
- Analytical cubes with an SLA of less 30 secs average for any kind of self-service analytics.
- Dealer can monitor near real time performance of sales, inventory, parts movement, customer satisfaction, order management and backlog in receivables and payables leading to significant reduction in leakage and enhanced sales.
