A global retail home improvement and appliance company operating over 1,800 stores in the U.S., Canada, Australia, and Mexico required integrated reporting to track store and district sales and distribution in the U.S. Because of the large number of chain stores and varying customer demand, the managers needed reports that quickly enabled them to obtain a view of product sales and track distribution. Decisions had to be driven by accurate data showing sales by store, by month, and by district manager. Access to the data also had to be seamless and user friendly.
Capgemini implemented a Power BI solution that handled data on-premise and in the Cloud, integrated with Hortonworks’ Hadoop, and allowed users to get detailed information down to the sales per unit. Cortana analytics solved the user friendly issue by providing data anywhere at any time. Employees simply asked the personal assistant ad-hoc business questions and received results on their desktops. The Power BI solution resulted in the retailer meeting store and customer demand for their products across the nation.