Search: "dashboard"

#data-quality #dashboard #sanity-check

Sanity Check a Dashboard Number That Looks Too Good to Be True

A number on my dashboard looks too good to be true. Metric: [METRIC NAME]. Repor...

#data #dashboards #metrics

data Beginner

Data: Cut a Dashboard Down to the 5 Metrics Anyone Actually Uses

I have a dashboard that's grown to 30 charts and nobody knows where to look. Aud...

excel Advanced

Build a Weekly KPI Dashboard in Excel That Doesn't Break When Someone Renames a Tab

I'm building a weekly KPI dashboard in Excel for a small operations team. The so...

#excel #dashboard #kpi

#design #visual #hierarchy

design Intermediate

Improve a visual design that 'looks fine' but isn't doing any work

I have a design (landing page, dashboard, marketing email — pick what fits) that...

#excel #automation #power-query

excel Advanced

Schedule an Excel file refresh without setting up a server

I have an Excel workbook that pulls data from a CSV in OneDrive via Power Query....

Write a query that survives the source table being renamed in six months

I need to write a SQL query that pulls weekly metrics for a dashboard. The sourc...

#sql #data #query

#analytics #debugging #metrics

Diagnose Why a Dashboard Metric Suddenly Changed

You are a senior data analyst. Walk me through a structured investigation for: [...

excel Advanced

Turn a messy CRM CSV export into a clean Excel dashboard

I will paste a CRM export with inconsistent date formats, duplicate accounts und...

#excel #csv #lambda

#business #operations #meetings

business Intermediate

Build a weekly business review that the leadership team actually finds useful

Our weekly leadership meeting has become a parade of status updates. Nobody deci...

#data #reporting #dashboard

Turn a daily metrics email no one reads into one a busy exec will open

We send a daily metrics email to the leadership team. Nobody opens it. I want to...

#pivot tables #dashboard #monthly report

excel Beginner

Turn a flat sales export into a one-screen monthly summary

I have a sales export with columns: order_id, date, region, sales_rep, product_c...

#excel #runway #burn-rate

Build a cash runway calculator that updates from a bank statement paste

I am a founder. I want an Excel sheet where I paste my bank statement export int...

#excel #dashboard #pivottable

Build a Dynamic Excel Dashboard Summary

Act as an Excel analyst. I will paste a table of raw data with these columns: [L...

#finance #dashboard #founders

finance Intermediate

Build a finance dashboard that a non-finance founder will actually look at

I'm a non-finance founder. My accountant sends me a monthly P&L. I open it, feel...

#gantt #project-tracker #dashboard

Create a Self-Updating Excel Project Tracker with Gantt View

Act as a project management consultant. Build me a self-updating Excel project t...

#data #dashboards #metrics

Build a one-glance metrics dashboard for a non-technical CEO

Help me design a single-screen weekly metrics dashboard my CEO will actually rea...

Sanity-check a dataset in 30 minutes before you build anything on top of it

I just got handed a dataset I'm going to use for [analysis / model / dashboard]....

#data #sanity-check #eda

#excel #formulas #dynamic-arrays

Build a Dynamic Array Dashboard Formula

You are an Excel power user. I will describe a dataset and a reporting goal, and...

👁 5 views