Case Study: How Coca‑Cola’s Chief Digital Officer Role Changes Reporting Needs — Excel Checklist

Hook: Your dashboards are about to get a CDO-sized upgrade — are they ready?

Many small business owners and operations leaders tell us the same thing: spreadsheets that once tracked sales and costs now groan under new demands — digital channels, customer-first experiments, real-time campaign data and stricter privacy rules. Coca‑Cola’s January 2026 announcement creating a Chief Digital Officer (CDO) shows why. When a global brand consolidates digital strategy under a CDO, reporting needs shift fast. If your reports aren’t prepared, you’ll miss decisions, audits and opportunities.

Executive summary: What Coca‑Cola’s CDO means for reporting (TL;DR)

On 31 March 2026, Coca‑Cola centralised digital strategy under a new CDO role to speed decision-making, scale technology adoption and unify data across channels. For reporting teams this creates three immediate shifts:

1. New metrics tied to digital revenue, customer journeys and real-time performance.
2. Integrated data demands — marketing, e‑commerce, supply chain and CRM must feed unified views.
3. Stronger governance — lineage, access controls and audit trails must be versioned and repeatable.

Below is a practical, Excel-focused checklist and step-by-step approach to redesign dashboards and KPIs so your finance, operations and commercial teams can support — or emulate — a CDO-driven agenda.

The 2026 context: why this change matters now

Digital transformation in 2026 is different from earlier waves. Late 2025 and early 2026 trends show:

• Wider adoption of first‑party data strategies after cookie deprecation, increasing demand for CRM and CDP-fed KPIs.
• More use of lightweight AI for analytics: Excel users are experimenting with AI-assisted formulas, natural language queries and generative summaries.
• Real-time expectations: marketing and supply chain teams expect near‑real time dashboards for campaign and inventory decisions.
• Stricter governance and auditability requirements (UK GDPR and global standards) make traceable data transformations essential.

When a CDO like Sedef Salingan Sahin (named in Coca‑Cola’s restructure) takes responsibility for digital and data, they typically push for metrics and pipelines that support these trends. That puts more load on Excel-based teams — unless you standardise and automate.

Core reporting shifts a CDO introduces (and what they mean for Excel)

Below are the specific shifts you should expect and precise Excel actions to address each one.

1. From gross sales to digital contribution and channel blend

CDOs track digital revenue share, attribution-adjusted revenue and channel profitability.

• Excel action: Add a KPI mapping tab listing each revenue stream, data source (e.g., Shopify, SAP, Google Analytics 4), and transformation logic.
• Power Query: Connect to APIs or CSV exports and create a consolidated sales table.
• Sample formula: rolling 12 months digital revenue = =SUMIFS(Sales[Amount],Sales[Channel],"Digital",Sales[Date],">="&EDATE(TODAY(),-12))

2. From fiscal reporting cadence to experiment & campaign velocity

CDOs run frequent experiments. Dashboards must show short‑term signals (daily conversion rate, test lift) alongside long-term KPIs.

• Excel action: Add a time-level selector (day/week/month) with slicers and a Date table in Power Pivot.
• Power Pivot measure (DAX) for experiment lift: =DIVIDE([TestConversion]-[ControlConversion],[ControlConversion])
• Automation: Use Office Scripts + Power Automate to refresh and publish daily snapshots.

3. From siloed dashboards to a single source of truth & governance

A CDO demands traceability: who changed what, and where did the numbers come from?

• Excel action: Implement a Data Dictionary and a Change Log worksheet in every template.
• Best practice: Use Power Query steps as documented transformations; avoid manual edits in final dashboards.
• Security: Use OneDrive or SharePoint with versioning and permissioned access.

4. From descriptive to predictive & AI-augmented insights

CDOs want predictive signals — churn likelihood, next-best-action — not just last month’s numbers.

• Excel action: Add columns for model inputs and an output column for predicted score. Use exported scores from Python/Power BI or Excel’s new predictive functions in 2026.
• Tip: Keep the model inference step separate (in a ‘ModelOutputs’ table) so you can refresh without breaking formulas.

Excel checklist: Rework dashboards and KPIs for a CDO-led organisation

Use this actionable checklist as your project plan. Each item is mapped to an Excel task and a quick technical note.

1. Inventory current KPIs and owners
   • Task: Create a KPI Inventory tab with columns: KPI name, definition, formula, source table, owner, frequency, audience, sensitivity (P/PII).
   • Why: Eliminates ambiguity when the CDO asks for standard metrics across regions.
2. Define the CDO priority KPI set
   • Task: From inventory, tag 10 priority KPIs that feed executive decisions (e.g., Digital Revenue %, LTV/CAC, Digital Shelf Score, Experiment Velocity).
   • Why: Focuses efforts on metrics that matter for digital strategy and investment.
3. Centralise raw data with Power Query
   • Task: Build a "RawDataConnections" workbook using Power Query with documented steps for each source (e‑commerce, ad platforms, POS, ERP, CRM).
   • Technical note: Use parameterised queries to change environment (UAT/Prod) and store refresh credentials in Excel for Business (OneDrive).
4. Create a robust Date and Lookup model
   • Task: Add a Date table, product and channel lookup tables, and link using Power Pivot relationships.
   • Why: Enables reliable time intelligence and easy cross-filtering.
5. Author authoritative measures in Power Pivot / DAX
   • Task: Migrate complex calculations from cell formulas to DAX measures (e.g., Rolling 12 Revenue, YoY Growth, CAC).
   • Sample DAX: Total Digital Revenue = CALCULATE(SUM(Sales[Amount]),Sales[Channel]="Digital")
6. Design dashboards for decision speed
   • Task: Create executive (monthly), operations (daily) and analyst (raw) views. Use slicers and timeline controls.
   • UX tip: Keep the executive sheet lean — top KPIs, trend sparkline, top 3 actions.
7. Implement governance and traceability
   • Task: Add a Data Lineage sheet that documents each Power Query source and transformation. Add a Change Log that records who refreshed or edited formulas.
   • Security note: Use workbook protection and SharePoint permissioning. Archive monthly snapshots to a "Snapshots" folder for audits.
8. Automate refresh & distribution
   • Task: Use Power Automate to run scheduled refreshes, generate PDF summaries and email to stakeholders.
   • Technical note: For heavy pulls, offload to Azure SQL or a data lake and keep Excel as a reporting layer.
9. Build monitoring and alerts
   • Task: Add conditional formatting and create an "Alerts" sheet that shows breached thresholds. Use Power Automate to push Slack/Teams alerts.
10. Train and document
    • Task: Produce 30–60 minute training videos and a one‑page Quick Start guide for each dashboard.
    • Why: Ensures experiment owners and commercial teams can interpret metrics correctly and reduces governance friction.

Practical examples: KPIs a CDO will request (and how to build them in Excel)

Here are concrete KPIs and compact recipes for each.

Digital Revenue Share

• Definition: Digital revenue / Total revenue (rolling 12 months).
• Excel build: Power Query consolidate Sales table; DAX measure: =DIVIDE([DigitalRevenue],[TotalRevenue])

Channel CAC and LTV

• Definition: Customer acquisition cost per channel; 12-month LTV per cohort.
• Excel build: Merge Ad spend table with customer acquisition events in Power Query; cohort tables by acquisition month; compute LTV with SUMIFS or DAX.

Experiment Velocity

• Definition: Number of experiments launched and validated per month; median time to decision.
• Excel build: Track experiments in a Project register sheet; calculate dates and outcomes with simple formulas; visualise with sparklines.

Digital Shelf Score

• Definition: Composite metric of completeness, content quality and availability on e‑commerce platforms.
• Excel build: Normalise submetrics (0–100), weight them, and compute weighted average in a Power Query/Power Pivot model for scalability.

Governance essentials: what auditors and a CDO will check

When digital leadership consolidates, expect audits focused on:

• Data lineage and transformation steps (Power Query step names become evidence).
• Access controls and version history.
• Reconciliation between Excel outputs and source systems (ERP, payment gateway).

Ensure you can answer: How was the metric calculated? When was data refreshed? Who approved the change?

Advanced Excel moves for 2026 (to impress your CDO)

If you want to demonstrate digital maturity, adopt these:

• Parameterised dataflows: Use Power Query parameters to switch between environments and reduce maintenance.
• Office Scripts + Power Automate: Auto‑publish snapshots, refresh data and send insights to Slack/Teams.
• Hybrid models: Use Azure SQL or Dataverse as the canonical store and Excel as a thin reporting layer.
• AI summaries: Use Excel’s native natural-language summaries (2026 features) to generate one‑line interpretations for executives.

Common pitfalls — and how to avoid them

• Keeping manual edits in final dashboards — enforce "no-touch" policy for transformed tables.
• Overloading executives with charts — create a one‑page executive sheet with 3 KPIs and 1 decision.
• Not versioning templates — keep a template registry and tag versions with semantic versioning (v1.0).
• Ignoring privacy: scrub or mask PII when sharing dashboards externally.

Real-world mini case: how a mid‑size retailer reworked dashboards in 8 weeks

One UK retailer we worked with (2025–26 cohort) had competing weekly reports from marketing and retail ops. They created a CDO-aligned plan and followed the checklist above:

1. Week 1–2: KPI inventory & priority set (reduced to 12 executive metrics).
2. Week 3–4: Power Query consolidation of POS and web sales; Date table and lookups added.
3. Week 5: DAX measures for rolling revenue and channel CAC; executive dashboard drafted.
4. Week 6–8: Automation and training; Power Automate scheduled daily snapshots and Teams alerts.

Outcome: time-to-insight dropped 60%, decision meetings shortened, and marketing ROI reporting became auditable and repeatable.

Checklist you can implement this week (quick wins)

• Build a simple KPI Inventory sheet (30 minutes).
• Connect one key data source to Power Query (1–2 hours).
• Create a Date table and one rolling 12 months measure (1 hour).
• Add a Change Log worksheet and start recording edits (15 minutes).

"When digital leadership is consolidated, reporting must move from art to reproducible science." — excels.uk

Next steps and resources

To help teams shift quickly, we provide:

• Downloadable Excel templates: KPI Inventory, Data Dictionary, Dashboard Template with Power Query links.
• Short video course: Power Query & Power Pivot for busy ops teams (3 x 20-min modules).
• Office hours: 1:1 template customisation for teams migrating to CDO-driven reporting.

Call to action

If your business is preparing for a CDO-driven agenda — or you want to future-proof reporting — start with the checklist above. Download our ready-made Excel template bundle, complete with a Governance sheet, Power Query examples and a one-page executive dashboard, and get a free 20-minute review from an expert at excels.uk.

Download the Excel checklist and templates now — and turn fragmented spreadsheets into trusted, CDO-ready reporting.

Related Reading

• Best 3-in-1 Wireless Chargers on Sale: Compare the UGREEN MagFlow and Alternatives
• Migrate from Horizon Workrooms: practical alternatives and an IT migration checklist
• From Smart Lamps to Skin Health: Can RGB Lighting Affect Collagen and Aging?
• How European Luxury-Property Trends Create Niche Roles for Real Estate Agents in Dubai
• Moderation Playbook: How Publishers Can Prepare for Fan Backlash Around Controversial Creative Choices