S&OP is about making decisions faster and with confidence. If you’re a demand or supply planner, the tool you use shapes how you prepare and present your numbers. Let’s break down where Excel Pivot Tables still work, and where Power BI changes the game with practical examples you can apply right away.
1. Demand Review: Don’t Drown in Versions
- The challenge in Excel: You’ve got at least three forecast versions: baseline, consensus, and latest. In Pivot Tables, comparing them means juggling side-by-side pivots or copy-pasting into another sheet. If Sales asks, “Where did this 5% jump come from?”, it’s challenging.
- Try this tomorrow: If you’re in Excel, set up a simple “bridge” view (Δ = Consensus – Baseline) so you can explain the gap in one click.
- In Power BI: Build a version comparison dashboard with bars. In that way in meetings, you can easily toggle between baseline, consensus, and in other forecasts you are asked for in seconds.
Immediate takeaway: Build a view (Excel bridge or Power BI slicer) that answers “what changed?” without prep-work mid-meeting.
2. Supply Review: Stop Wrestling with Formulas
- The challenge in Excel: You’re asked: “What’s the capacity risk if demand spikes next month?” You dig through a pivot with IFERROR and SUMPRODUCT everywhere. One broken formula and the whole model collapses.
- Try this tomorrow: In Excel, prepare a “Capacity Heatmap” using conditional formatting (red = overbooked, green = safe). It’s raw. But it gives leadership a visual.
- In Power BI: You can automate constrained vs unconstrained supply views. You can see exactly where capacity is at risk without touching formulas.
Immediate takeaway: If Excel is slowing you down, start by color-coding the risk zones. If you have Power BI, automate the supply/demand overlay so planners spend zero time fixing formulas.
3. Inventory Analysis: Go Beyond Static Ratios
- The challenge in Excel: You calculate turns or stock cover for the month. But when the VP asks, “Which SKUs are aging past 90 days?”, you don’t have that slice ready.
- Try this tomorrow: Add a simple filter in your pivot to highlight items with >90 days stock. Use conditional formatting to flag “slow movers.”
- In Power BI: Dashboards can classify inventory automatically: fast movers, slow movers, and obsolete. You can have a “traffic light dashboard”: green for healthy SKUs, yellow for risk, red for obsolete.
Immediate takeaway: Show your stakeholders which SKUs are the problem with either Excel filters or Power BI traffic lights.
4. Scenario Planning: Make “What-If” Simple
- The challenge in Excel: Marketing says, “What if the promo doubles demand in Q4?” That means copying workbooks, tweaking formulas, and re-running macros.
- Try this tomorrow: Build a simple multiplier cell in your Excel model (e.g., +10% demand). You can now answer “what if” questions without cloning files.
- In Power BI: Create slicers for demand or capacity shifts. One planner I know uses a slider, demand up 10%, capacity down 5% and the whole P&L impact updates instantly in the meeting.
Immediate takeaway: Always have at least one lever you can “pull live” (Excel multiplier or Power BI slicer) to keep the conversation moving.
5. Executive Review: Stop Exporting Slides
- The challenge in Excel: Every cycle, you export charts into PowerPoint, only for an executive to ask, “What’s behind this number?” The issue is that you don’t have the drill-down ready.
- Try this tomorrow: In Excel, hyperlink your deck slides back to the pivot tabs. That way, if challenged, you can click through without losing face.
- In Power BI: Live dashboards replace slides altogether. One company’s CFO started leading reviews directly in Power BI. Executives drill into regions, SKUs, or customers without waiting for planners to prep 20 backup slides.
Immediate takeaway: Whether Excel or Power BI, make sure you can drill down on the spot. Executives don’t want to hear excuses. They want answers in the room.
6. Cycle Time: Free Yourself from Prep Work
- The challenge in Excel: Half your S&OP cycle is data cleansing and pivot prep. By the time the meeting comes, you’re exhausted.
- Try this tomorrow: Automate one recurring step in Excel. Maybe a VBA macro that refreshes all pivots with one click.
- In Power BI: Data flows and scheduled refresh mean prep is near zero.
Immediate takeaway: Automate one step in Excel today. If you’re in Power BI, use that saved time to run more scenarios.
7. Financial Integration: Connect Ops to P&L
- The challenge in Excel: Linking inventory turns to working capital or demand changes to revenue means exporting into Finance’s files. Lots of reconciliation headaches.
- Try this tomorrow: Create a manual bridge in Excel. Add a tab that converts stock levels into dollars (average cost × units). It’s not perfect, but it gives Finance a starting point.
- In Power BI: Dashboards integrate demand, supply, and finance automatically. Set them up to show forecast vs actual revenue, EBITDA impact, and cash conversion side by side with supply metrics.
Immediate takeaway: If Finance is challenging you, give them a dollar view, even if it’s approximate.
Conclusion
Get better at S&OP today. Start by:
- Adding simple “bridges” in Excel (what changed, where the risk is, multipliers for scenarios).
- Building one step of automation (refresh all pivots, highlight aging stock).
- Translating at least one operational number into a financial view.
Power BI will take you further but the point is to spend less time preparing slides and more time driving decisions.
