Client's Commercial Sales and Retail Sales organizations struggled to integrate point of sale (POS) data sets from their channel business partners. Also, because the data was scattered across many systems, client users had no single place to go for their analytic needs.
The client selected KPI over multiple vendors through a rigorous RFP process. KPI's expertise in Hadoop, Azure, Power BI, and data and analytics, in general, was the key differentiator for the client. Also, KPI's blended shore model minimized cost and risk for the client.
An Azure-based solution for the POS data coming from disparate source systems. This system reduced the ETL run time by over 80% from the client's prior system. It also reduced report execution time by over 90%.
Because Azure Synapse Analytics is a complete solution for blending data and reporting, it served as the perfect solution for the different personas across the organization. Because Synapse Studio was a new service, combining Spark and data warehousing capabilities, KPI delivered best practices and a re-usable architecture. KPI also held knowledge transfer workshops.