"I have sales data… but I don’ know what it's telling me."
That’s what a small business owner told me last month.
So I sat down with my students and we built a BI dashboard from real sales data.
Here’s what we learned and why it matters for your business.
The numbers at first glance:
→ $5M revenue
→ 55 orders
→ 3 sales reps
Looks fine, right?
But the story was hiding underneath.
🔍 We asked simple questions:
❓ Why do we have 23 furniture orders but only 17 electronics orders yet electronics brought in almost the same revenue?
→ Maybe furniture sells in lower value per order. That changes how you train your sales team.
❓ Three reps made almost the same revenue ($1.7M each) but did they sell the same things?
→ One might be selling high-volume low-margin items. Another might be selling fewer but bigger deals. Different coaching needs.
❓ Subcategories like "Writing" and "Consumables" are at the bottom should we drop them or market them better?
→ Data doesn't shout the answer, but it points to the question.
What we built:
A simple dashboard that turns messy spreadsheets into clear answers without needing a data science degree.
And the biggest lesson for small business owners:
You don't need more data. You need the right view of the data you already have.
I’m sharing this because:
I help small business owners and beginners learn how to use BI tools (like Power BI, even Excel) to stop guessing and start growing.
✅ Open for 1-on-1 coaching
✅ Open for small group workshops
✅ Also available for consulting, let me look at your data and build you a dashboard that actually helps you decide.
📩 DM me "DATA" and I’ll send you a simple template to get started.
No jargon. No fluff. Just practical help.
#SmallBusiness#DataForBeginners#BusinessIntelligence#BIcoaching#SalesDashboard
• Tracked monthly performance
• Summarized yearly trends
. Pulled out top trading volume days
Your data girl is not playing😌
Might not be perfect yet, but I’m learning and getting better one step at a time.
#SQLProject#DataForBeginners#BlackTechTwitter