Mars Pet Nutrition – FMCG
Data Visualization
for a global FMCG
organisation
“If we want to be competitive, we must base our desicioning across all areas based on data, from supply chain to financing and marketing.”
THE CHALLENGE
DISCIPLINES
OUR APPROACH
Accurate data,
great Insights
Uptimal worked with Mars to create a set of dashboards which enabled internal teams to maximize their respective budgets and make optimization decisions through the insight and transparency that the dashboards
brought.
After aligning on the business critical KPIs and industry benchmarks with Mars’ internal teams we began with wireframing and ETL. Subsequently, we commenced the build of the dashboard in Salesforce Datorama,
iteratively working in sprints and updating based on feedback.
Data Integration
We used Salesforce Datorama for ETL processes to ensure data from multiple sources was relaible, accurate and fit for purpose.Wireframing and UI design
We collaborated with key business stakeholders to understand what data was important, but also how they wanted to see it expressed so that insights were apparent and actionable.Consultation
We advised on what metrics and dimensions should be included based on the business requirements, and trained different stakeholders on how to best use and derive insight from the
dashboard
“Finding a way to operate on a custom
basis considering the exact needs of
Mars and the integration of data
sources into a unique full fledge
vision has been the key to truly
have an impact on the improvement
of Mars business goals.”
Senior Data Engineer
RESULTS
Goals accomplished!
audiences and more.
700+
ad accounts integrated
$11.5M
of non optimzed media spend identified
300+
stakeholders using the dashboard
of non optimzed media spend identified
ad accounts integrated
stakeholders using the dashboard