keepcalculator

06 Numbers and Powers

Turn Data into Better Decisions: A Small Business Guide

Card No. 06·84577 · Updated · Standard formula, shown below

This guide shows small business owners how to turn raw data—sales figures, customer feedback, website traffic—into practical decisions that improve profitability and efficiency. You’ll learn a simple, repeatable process to collect, analyze, and act on data, even if you have no technical background. No special software is required; a spreadsheet and a clear question are enough to start.

What You’ll Need

  • A spreadsheet program (Excel, Google Sheets, or similar)
  • Access to your business data: sales records, customer emails, website analytics, or social media insights
  • A clear question you want to answer (e.g., “Which product sells best on weekends?”)
  • 30–60 minutes of uninterrupted time per week

Step-by-Step

  1. Start with a specific question. Vague questions lead to vague answers. Instead of “How are we doing?” ask “Which of our two most popular menu items has the higher profit margin?” or “What time of day do most online orders come in?” Write the question down—it guides everything else.
  2. Identify the data that answers that question. For the profit margin question, you need the selling price and the cost of ingredients for each item. For the order timing question, you need timestamps from your online ordering system. If the data doesn’t exist, decide how to start collecting it (e.g., add a question to your order form).
  3. Collect the data in one place. Export your sales report, copy the relevant columns into a spreadsheet, or manually enter numbers from receipts. Keep it simple: one row per transaction or item, with clear column headers like “Date,” “Product,” “Quantity,” “Price,” “Cost.” Clean the data by removing duplicates and fixing typos.
  4. Summarize the data with simple math. Use spreadsheet formulas to calculate totals, averages, or counts. For the profit margin example, add a column for profit (Price – Cost) and then divide total profit by total sales for each item. For order timing, group orders by hour using a formula like =HOUR(A2) and then count how many fall in each hour.
  5. Look for patterns and outliers. Compare the numbers. Which product has the higher margin? Are there any unusual spikes or drops? For example, you might see that sales of a specific item triple on Fridays—that’s a pattern worth acting on. Outliers (like a single huge order) might be a data entry error or a real anomaly; verify before deciding.
  6. Make one small decision based on the finding. Choose the simplest action. If one menu item has a much higher margin, you might feature it in a promotion. If orders peak at 6 PM, you could schedule an extra staff member for that hour. Avoid trying to change everything at once.
  7. Track the outcome. After implementing the change, continue collecting the same data for a set period (e.g., two weeks). Compare the new numbers to the baseline you recorded earlier. Did the decision lead to the expected improvement? If not, adjust and try again.
  8. Review and repeat. Set a regular cadence—weekly or monthly—to go through this process with a new question. Over time, you’ll build a habit of evidence-based decision making.

Common Mistakes

  • Using data to confirm a pre-existing belief. If you’ve already decided the answer, you’ll unconsciously filter the data to support it. Instead, let the data speak, even if it contradicts your intuition.
  • Comparing apples to oranges. Make sure you’re comparing like-for-like. For example, comparing total revenue from a month with a holiday to a normal month can mislead you. Adjust for the number of business days or seasonal factors.
  • Ignoring sample size. A decision based on three customer complaints may not reflect your entire customer base. Look for patterns across many data points before acting.
  • Overcomplicating the analysis. You don’t need regression analysis or machine learning to run a small business. Simple totals, averages, and percentages are often enough.
  • Forgetting to clean the data. A missing decimal point or a duplicate row can skew your results. Always scan for obvious errors first.

Tips

  • Start with one key metric that directly relates to your question—don’t try to track everything at once.
  • Use free tools like Google Sheets; they have built-in charts that make patterns visible instantly.
  • If you’re not comfortable with formulas, use the “Explore” feature in Sheets or the “Analyze” feature in Excel to get automatic insights.
  • Share your findings with a trusted employee or mentor. Explaining the data out loud often reveals gaps in your logic.
  • Keep a simple log of decisions you’ve made from data and their outcomes. This builds your own playbook over time.

Troubleshooting

Problem: The data doesn’t show a clear pattern.
Try changing the time frame. If weekly totals look random, look at daily or monthly totals. Also consider whether you’re asking the right question—maybe the data you have can’t answer it, and you need to collect different data.

Problem: The spreadsheet formulas return errors.
Check for text in numeric cells (like “$10” instead of 10). Use =VALUE() to convert text to numbers, or remove currency symbols. Also ensure you’re using the correct cell references.

Problem: You find a pattern but it’s not actionable.
If you discover that sales are higher on sunny days but you can’t control the weather, look for a related factor you can influence—like promoting indoor services on rainy days. Turn the insight into something you can act on.

Problem: You don’t have enough data.
If you have fewer than 10 data points, treat the finding as a hypothesis, not a conclusion. Collect more data over the next few weeks before making a significant change.

Problem: The data contradicts your gut feeling.
Trust the data but verify it. Double-check your calculations and make sure the data source is reliable. If it still contradicts, consider that your assumption may be outdated—and that’s a valuable discovery.

Frequently Asked Questions

Q: How much data do I need to make a decision?
A: Enough to see a consistent pattern. For most small business decisions, 20–30 data points (transactions, customers, days) give a reasonable baseline. More is better, but don’t wait for perfection—start with what you have.

Q: What if I don’t have any data yet?
A: Start collecting it today. Add a simple form to your website, use free analytics tools, or keep a daily log of key numbers. Even two weeks of data is better than guessing.

Q: Do I need to hire a data analyst?
A: Usually not. Most small business decisions can be supported with basic spreadsheet skills. Only consider outside help if you’re dealing with very large datasets or complex statistical methods, which is rare for a typical small business.

Q: What’s the most important metric to track?
A: It depends on your goal. For profitability, track gross profit margin. For customer satisfaction, track repeat purchase rate or net promoter score. Start with one metric that directly relates to your biggest current challenge.

Q: How often should I review my data?
A: Weekly is a good rhythm for most operational decisions (staffing, inventory). Monthly works for broader strategy. The key is consistency—schedule it in your calendar and stick to it.

Q: Can I use data to predict future sales?
A: Yes, to a limited extent. Simple trend analysis (e.g., comparing this month to the same month last year) can give you a rough forecast. For more accuracy, you’d need seasonal adjustments, but even a basic projection helps with planning.

Related

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.

More cards in this drawer

The whole Numbers and Powers drawer →