Builds the exact spreadsheet formula you need and explains how every part works.
Produces an ordered, reproducible plan to clean and standardize a messy dataset.
Recommends the best chart for your data and message, with a setup spec for each.
Turns a plain-language question into a correct, readable SQL query against your schema.
Designs a pivot table layout from your fields and the question you need answered.
Defines a KPI precisely with formula, inputs, segments, and reporting guidance.
Drafts a clear dashboard spec: audience, metrics, layout, and data sources.
Analyzes an A/B test for significance and gives a clear, honest recommendation.
Turns a described spreadsheet goal into a working formula plus a breakdown of each part.
Converts a business question and table schema into a tested, readable SQL query.
Audits a dirty dataset and returns a prioritized, repeatable cleaning workflow.
Defines a business KPI rigorously so everyone calculates it the same way.
Recommends the right chart and styling for the message you want the data to convey.
Lays out the exact rows, columns, values, and filters for a pivot table answering one question.
Plans a focused dashboard with the right metrics, layout, and refresh logic for an audience.
Generates a structured first-pass analysis plan before you draw any conclusions.
Diagnoses why a formula returns an error or wrong result and proposes a corrected version.
Writes dialect-aware window-function SQL for cohort retention and rolling metrics.
Diagnoses fragile spreadsheet formulas and rewrites them as robust dynamic-array versions.
Produces a reproducible, column-by-column cleaning plan with validation checks.
Maps a north-star metric into a driver tree with precise, audit-ready definitions.
Recommends chart types and layout hierarchy for a stakeholder-specific dashboard.
Builds a tiered method to detect, classify, and act on anomalies in a metric.
Designs a clean source-to-pivot model with relationships and measures.
Reviews a slow or expensive SQL query and returns a prioritized tuning plan.