Financial performance analysis of the more than 600 stores in the US was a grueling data-crunching exercise conducted using desktop database and basic spreadsheet software. The data collection and sorting processes used to compile reports for each store, and for all stores within a territory, required days and weeks to coordinate and complete. Invariably, this methodology lacked the timely and impactful means to communicate performance ranking and assessment to produce actionable corrections. In addition, these tools and processes lacked the spatial analytic means to simply and effectively assess consumer and market characteristics in a truly integrated way.
Using Alteryx to integrate POS, consumer, market and historical data for each store's trade area in a fraction of the time the previous processes ran, financial analysts have been able to regularly deliver current snapshots and trending insights not available before to the company's management. The time savings and speed in processing more data with accurate precision down to each store trade area has also allowed financial analysts to broaden the range of performance analyses they can provide to management. Such historical perspectives by store can now include seasonality trends, ensuring that each store has the insight it needs to provide the right products to the right customers at the right time in its community.
- Dana Pickup, Senior Manager, Strategy & Analysis at Walmart
Financial analysts and management report that Alteryx has made a significant impact on effecting improvements in store performance. This performance impact has been achieved by applying fast, flexible, and transparent processing of Alteryx analytics applications on a far greater diversity of data, from both external and internal sources, integrating timely as well as historical and predictive data dimensions.