Copilot lists the data quality issues in a messy export, applies the minimum cleanup on a copy, builds the pivot with slicers, and tells you what the pivot is actually saying.

0.0(0)

Copy

Gemini

#data analysis

Clean up a messy column in Google Sheets

Paste in a messy Sheets column and get a single formula that fills a clean version, plus a flag column for the rows that need a human eye.

Suggest the right KPI formulas in Excel for my business

Copilot defines each KPI in plain English, writes the exact Excel formula or DAX measure, sanity-checks it on row one, and flags 2 ways the number could mislead you.

Clean an Excel date column with mixed formats

Copilot identifies every date format in a messy Excel column, converts each row to your target format, flags the rows it could not parse, and respects AU locale.

Build a Notion formula for a custom database calculation

Inside Notion AI, generates a Notion 2.0 formula with paste-ready code, a plain-English walkthrough, three test cases, and an alternative approach if a rollup would be simpler.

Workflow: weekly product analytics review

Reviews weekly product analytics + recommends product changes.

Design an A/B test

Designs an A/B test with hypothesis, variants, primary metric, and decision rules.

Build an executive dashboard spec

Specify the 8 numbers and layout for a weekly leadership dashboard — what the CEO actually wants to see at a glance.

Build a 'metric ownership' framework

Assigns clear ownership for every important metric — who's accountable for it.

Build a 'data trust' building protocol

Plans how a data team builds trust with stakeholders over time.

Build a 'data democratisation' program

Plans a program to spread data literacy + access across the company.

Build a 'how to read a chart' guide

Drafts a guide on reading charts critically — don't be fooled by misleading visualisations.

Build a 'dashboard request triage'

Triages dashboard requests from stakeholders to prevent dashboard sprawl.

Convert an Excel formula to Google Sheets (or vice versa)

Convert spreadsheet formulas between Excel and Google Sheets, with a callout of any function that doesn't exist in the target and the workaround used.

Build an LTV prediction model

Designs a customer LTV prediction model with features and validation.

Run a survival analysis

Plans a survival analysis for time-to-event data like churn or upgrade time.

Run causal inference (diff-in-diff)

Plans a difference-in-differences analysis to test the causal effect of an intervention.

Build a privacy-friendly analytics setup

Sets up analytics that respects privacy + reduces consent fatigue.

Build a metric anomaly alerting plan

Sets up alerting on metrics with thresholds, channels, and noise discipline.

Build a 'one number you stare at' practice

Picks the single number a team stares at every day — to focus action.

Build a self-serve analytics culture

Plans the shift from analyst-bottlenecked reporting to self-serve analytics.

Build a data observability plan

Plans data observability with monitoring of pipelines, freshness, and quality.

Build a 'metrics that matter' framework

Pick the 5 numbers that actually matter for your stage of business — and ignore the rest of the noise.

Build a 'data > opinion' culture protocol

Designs a protocol for shifting from opinion-driven to data-informed decisions.

Design a multi-armed bandit

Designs a multi-armed bandit experiment for ongoing optimisation rather than one-shot A/B.

Run funnel analysis

Designs a funnel analysis with stages, drop-off identification, and recommendations.

Build a data lineage doc

Documents data lineage from source to consumed metric for trust + debugging.

Build a data quality framework

Designs a data quality framework with checks, owners, and incident response.

Build a 'data product' brief

Briefs a data product (dashboard, model, dataset) like a real product with users + outcomes.

Build a data dictionary

Drafts a data dictionary for a database or warehouse — the human-readable schema.

Build an 'experiment ideas backlog' format

Drafts a format for collecting + prioritising experiment ideas across the team.

Run anomaly investigation

Investigates a metric anomaly with a structured root-cause approach.

Build a 'is this number weird' check

Provides a quick check for whether a metric is anomalous before acting on it.

Build an 'AB test results to action' protocol

Converts an A/B test result into a deployment + learning action plan.

Write a quarterly social media report

Drafts a quarterly social media performance report with insights and next-quarter recommendations.

Build a 'metric definitions diff' protocol

Catches when metric definitions silently drift over time and breaks comparisons.

How much each channel costs you per new customer (CAC by channel)

Work out how much each marketing channel is costing you per new customer — and where to put more or less budget.

Build an analytics review meeting agenda

Draft a recurring analytics review meeting agenda for the leadership team — what to walk through, in what order, and the questions worth asking.

Build a spreadsheet formula from plain English

Plain-English description in, paste-ready spreadsheet formula out — Excel or Google Sheets dialect. Includes the "when it breaks" caveats most AI prompts skip.

Build a metric review meeting

Designs a recurring metric review meeting that drives action, not status.

Build a 'data review meeting' for a team

Designs a recurring data review meeting for an individual team.

Run engagement analysis

Plans an engagement analysis to understand depth + frequency of product use.

Build a 'correlation vs causation' check

Provides a checklist for distinguishing correlation from causation before acting on data.

Build a 'metric definition' doc

Drafts a precise metric definition that prevents 'we're talking about different things' confusion.

Build an attribution model framework

Help a small marketing team pick an attribution model (how to credit which channel made the sale) that fits their tools and budget — without buying expensive software.

Write a marketing performance dashboard spec

Specifies the metrics, layout, and cadence for a weekly marketing performance dashboard.

Run cohort analysis

Designs a cohort analysis with segmentation and visualisation choices.

Build a churn forensics report

Diagnoses churn root causes with cohort, segment, and reason analysis.

Workflow: monthly metric review prep

Prepares the monthly leadership metric review with anomaly investigation + action prompts.

Run a multivariate test

Designs a multivariate test where multiple elements vary at once.

Build a cookieless attribution model

Designs an attribution model that works without third-party cookies.

Outcome measure analysis agent

Quarterly review: takes your full caseload's outcome scores, identifies what's working, what's not, where you're an outlier (pos or neg) vs published benchmarks.