How swapping a live dashboard for an email address fixed the one problem Tableau and Power BI couldn't: getting insight into a Business leader's hands when the store's own WiFi and BI servers can't be trusted.
Facility Services, like most of Walmart, had hundreds of dashboards. Most of them followed the same arc: a big launch, a burst of use, and then a slow fade as fewer and fewer people opened them. Nobody killed them on purpose — they just stopped being useful at the exact moment leadership needed them most.
Talking through it with several stakeholders — including Senior Vice President Hunter Hart — surfaced the actual root cause, and it had nothing to do with the dashboards' content. The dashboards were fine. The problem was where and when leaders needed them: while physically touring a store.
A leader walking a sales floor to have an informed conversation with the store manager was fighting three things at once, and any one of them alone was enough to kill the interaction:
The dashboard didn't need to be live in the store. It needed to already be in their pocket before they walked in the door.
The Store Summary Report sidesteps the live-connection problem entirely by removing the live connection. A leader emails a generic inbox with a store number in the subject line; a Power Automate flow does the rest, and a finished PDF lands back in the leader's inbox before they've even walked in the front door — no server session required once it arrives.
Leader emails "Store Summary 540" — a plain subject line, nothing else required
Power Automate flow triggers on the new message in the shared inbox
Flow parses "540" out of the subject line
Filters the master Power BI dataset down to just that store
Renders the filtered view + open work orders as a PDF/Excel pair
Emails both files back to the leader's own inbox
From there, the leader has a finished PDF sitting in their inbox — readable offline, on any phone, regardless of what the store's WiFi or the BI server happen to be doing at that moment.
Below is a recreation of the real report layout so the shape of it is concrete, not just described.
| Role | Contact |
|---|---|
| HVAC Manager | D. Whitfield |
| GM Manager | R. Castillo |
| Regional Manager | L. Fenwick |
The PDF is paired with a second attachment: every open work order for that store, sorted with the longest-open items at the top — so the leader can pair "here's what the dashboard says" with "here's the specific thing that's been sitting for 3 days" in the same conversation.
| Tracking # | Age | Trade | Description |
|---|---|---|---|
| WO–4471982 | 3 days | Pest Management | Ants reported at a front-end register; inside/outside treatment requested (ants, beetles, spiders, moths). |
| WO–4482310 | 1 day | FM – HVAC | Rooftop HVAC unit not cooling over the sales floor; several other RTUs flagged not-cooling / comm-loss on the same call. |
Store-level facility work rarely lives in one system. The report pulls a rollup across the three project pipelines that actually touch a store, so the leader isn't blindsided by a capital project mid-tour.
| Type | Year | Status |
|---|---|---|
| ST (Restripe) | 2022 | Active |
| ST (Restripe) | 2021 | Canceled |
| Type | Year | Status |
|---|---|---|
| Smart Bundle | 2022 | Active |
| Smart Bundle | 2021 | Complete |
| Type | Year | Status |
|---|---|---|
| HVAC Setpoint Adjustments | 2021 | Complete |
| HVAC Capital Upgrade | 2022 | Complete |
| Electrical Switchgear EOL | 2023 | Pending |
| Live Tableau / Power BI mobile app | Store Summary Report | |
|---|---|---|
| Needs a live server session | Yes — fails if the server happens to be down | No — PDF is fully rendered before it's sent |
| Needs strong in-store WiFi | Yes — store WiFi is often the weakest in the building | No — already in the inbox, readable offline |
| Getting to the right store's data | Navigate filters/prompts in a dashboard UI | Send one email with a store number in it |
| Training required | Yes — how to find, filter, and read it | No — it's an email attachment |
| What happens when the server hiccups | Leader gets nothing, mid-tour | Leader already has the PDF regardless |
The bigger shift wasn't technical — it was recognizing that "make the dashboard better" was the wrong problem to solve. The dashboard was never going to reliably load on a store's WiFi. The fix was to stop asking the store to serve the data live at all, and instead deliver a finished artifact ahead of time, in the one format that survives bad WiFi and shaky servers equally well: an email already sitting in someone's inbox.