FP&A Today - Episode 17 - John King: Inside the Success of FP&A at Walmart

Show Notes

John King, Senior Manager, Analytics & Insights, Private Brands at Walmart reveals how the largest US retailer makes use of a “firehose” of data. This amounts (according to some estimates) to 2.5 petabytes of unstructured data from 1 million customers every hour.

Walmart’s FP&A unit ensures this potentially limitless information provide instant business decisions for the US retail giant.

First John explains his path to being an FP&A leader, starting as a Geographic Information Systems (GIS analyst) at Tradewind Energy in Kansas.

Here his love and appreciation for technology - which plays a central role at Walmart- was born. John's passion for technology saw him thrive at his roles at two of Walmart’s FP&A divisions: Realty Market Strategy, and now Private Brands. Private brands - a good that is manufactured for and sold by Walmart competing with brand-name products is a huge source of data and revenue. In fact,18 of Walmart’s private brands do more than $1 billion in sales and its largest name, Great Value does more than $27 billion a year globally.

In this interview John speaks about the intersection of FP&A and business-decisions at Walmart and his career.

  • His passion for technology and the tech stack used at Walmart

  • The core metrics which Walmart judges FP&A on and what other retailers can learn

  • How to get insights for the business “today or tomorrow” through dimensional modeling

  • How to keep focus on the most important data in the face of potentially limitless consumer data

  • As both a Python and Excel expert, whether FP&A leaders need to know Python, Excel or both?

  • The importance of taking logic and analysis to the data - rather than the other way around

  • The most important advice for anyone starting in FP&A to succeed

Follow John King on LinkedIn

Follow Paul Barnhurst on LinkedIn

Follow Datarails on LinkedIn

FP&A Today is brought to you by Datarails.

Datarails is the financial planning and analysis platform that automates data consolidation, reporting and planning, while enabling finance teams to continue using their own Excel spreadsheets and financial models.

YouTube Video

Video Clip: Keeping Your FP&A Team Focused

Previous
Previous

FP&A Today - Episode 18 - What Gen Z Wants in FP&A

Next
Next

FP&A Today - Episode 16 - Jamie Genge: Winning Big with Monte Carlo analysis in FP&A