Prompt I used:

<aside> 💡

I run a small online food business. Attached in csv file that contains all the orders, Invoice value and profit details of customer purchases. I would like to improve my data analytics skills. Act as an expert data head and ask me 3 business questions and answer them with SQL. Explain the results in plain english and and write a blog post with the SQL queries, business insights and results.

</aside>

all_invoices.csv

From Data to Decisions: How I Used SQL to Unlock Hidden Insights in My Food Business

A practical guide to analyzing e-commerce data with SQL and making data-driven business decisions

Introduction: Why Every Small Business Owner Needs SQL

When I started my online food business selling traditional Indian health foods, I did what most entrepreneurs do—I focused on making great products and getting them to customers. But after a few months, I had a problem: I was sitting on a goldmine of data and had no idea what it was telling me.

I had 103 invoices in a CSV file. I knew my revenue number. But I didn't know:

That's when I decided to learn SQL (Structured Query Language). In this blog post, I'll share exactly how I analyzed my business data using three simple SQL queries and the surprising insights I discovered. If you run a small business, this is for you.

My Business Snapshot

Before diving into the analysis, here's what I was working with: