How tired are you of preparing dashboards, manually pushing through reams of data, and trying to get buy in from those who are making the decisions based on your analysis? You’re not alone. It was these moments of everyday fail, that led Sparkline to help a leading FMCG brand to change the way they were working and use cloud based solutions to better optimise their e-commerce
The goal was threefold. We wanted the FMCG to drive decision- making across e-commerce brands and geographies, reduce dashboard preparation time and make analysis more efficient through automation using Google Cloud Platform and Data Studio
How did we do that? The Sparkline way of course. Our team of specialists used scripts to automatically extract data from the data files, transform them into the appropriate data structure, and load the processed data into a BigQuery warehouse. The extracted data was then visualised in a Data Studio aligned to business objectives of the visualisation.
What happens when you take a fairly manual and time pushed company and revolutionise the way they use their data? Preparation time was reduce from 16 hours to under 1 hour. (Read that again until it sinks in) 15 hours saved. Real time data is now available for analysis and manual data analysis has all but disappeared. Why is this important? The less manual a process, the less error prone it is, making the data analysis more accurate. And the best thing? This solution is completely scalable.
Sparkline listens, finds the solutions and makes sure that the effect has an impact on your business.