Next, treat “being good at data” as four small skills you can practice, not a personality trait. You are trying to make one clear decision in 10 to 20 minutes, not build a perfect reporting system.
If you do one thing, do this: start every data moment with a decision you need to make (price change, staffing, channel spend, product fix). The skills below keep you from getting stuck in spreadsheets, dashboards, or AI prompts.
Also, assume your data will be messy. Names will be inconsistent, dates will be missing, and one person will type “CA” while another types “California”. The goal is not to clean the whole dataset, it is to clean only what you need for the next decision.
A practical approach:
Expect issues: missing values, duplicates, mixed formats, unclear labels
Normalize what matters: pick one format for dates, currencies, and categories you will compare
Clean only the slice you need: if you are deciding next week’s schedule, you may only need the last 30 to 60 days of bookings
Keep a “notes” column: write what you changed so you can repeat it next month
Common mistake: trying to reconcile every field before you ask a single question. Fix: choose one question, then clean only the columns that affect that answer.
That said, vague prompts create vague answers. “How are we doing?” usually leads to a dashboard you never open again. A better habit is to write one question that has a time window, a segment, and a metric.
Try these patterns:
What changed in the last 7, 30, or 90 days
Which channel, product, or customer segment is driving the change
Which number will decide the next action (conversion rate, refund rate, average order value, on-time delivery)
For example:
Owner: “In the last 30 days, did returns increase for one product category?”
Team lead: “Which shift has the highest error rate this week?”
Marketer: “Are paid search leads converting within 14 days, or stalling?”
Here’s why: dashboards feel hard when they show everything at once. Summarizing first means you reduce the noise before you ever choose a chart.
A simple sequence that works in most tools:
Summarize: totals, averages, counts, and changes versus last period
Compare: one segment at a time (channel, product, region), not five at once
Visualize: pick one chart that answers the question
Tradeoff: charts are great for spotting patterns, but they can hide small sample sizes. If the number of orders is tiny, use a short table and add the count next to the rate so you do not overreact.
In practice, AI is most useful after you have a clear question and a summary, because it can help you explain what the numbers suggest and what to check next. Think of it as an intern who drafts, while you verify.
How to use it safely:
Ask it to restate your question and list the exact metrics it will use
Paste a small summary (5 to 15 rows or a short pivot), not your entire database
Ask for 3 possible explanations and 3 checks to confirm them
Keep the final call yours, especially when money, hiring, or customer promises are involved
Constraint tip: if you are short on time, skip fancy visuals. Do a two-line summary (this period vs last period) and ask AI to draft the next step you will take if the number holds.