Can a Housewife Become a Data Analyst Without a Degree?

-- Business question: which region has the
-- highest revenue per customer this quarter?

SELECT
  region,
  COUNT(DISTINCT customer_id) AS customers,
  SUM(revenue) AS total_revenue,
  ROUND(SUM(revenue) / COUNT(DISTINCT customer_id), 2) AS rev_per_customer
FROM orders
WHERE order_date >= '2026-01-01'
GROUP BY region
ORDER BY rev_per_customer DESC;

# Business question: are customers in the
# North region churning over the last 6 months?

import pandas as pd

df = pd.read_csv("customers.csv", parse_dates=["signup_date"])
df["month"] = df["signup_date"].dt.to_period("M")

monthly = (
    df.groupby(["month", "region"])
      .agg(active=("customer_id", "nunique"))
      .reset_index()
)

north = monthly[monthly["region"] == "North"]
print(north.tail(6))

# The numbers mean nothing without a business
# recommendation. That comes next.

Realistic weekly schedule (total ~10 hrs/week):

Mon — 1 hr learning (concepts)
Tue — 1 hr practice (SQL)
Wed — 1 hr project work
Thu — 1 hr practice (Power BI)
Fri — 30 min review + notes
Sat — 3 hrs deep project work
Sun — Rest (do NOT skip this)

That is enough to be job-ready in 6 months.

Study habits that actually work for housewives:

1. Study at the same time every day — habit
   matters more than duration.

2. Use short sessions (30–45 min) — easier
   to fit around family needs than 3-hour blocks.

3. Keep a "stuck log" — write down every problem
   you solve so you can review it on hard days.

4. One project at a time — do not start a second
   before finishing the first.

5. Tell one family member — accountability
   makes a huge difference.

6. Use free time (waiting at school, doctor
   appointments) for revision — a phone is enough.

7. Skip guilt. Missing a day is not failure.
   Missing a week is — resume the next day.

Project 1: Sales dashboard for a small retail
business (fictional data is fine)

Business question:
"Which product categories drive the most
margin per store?"

What you build:
- SQL queries joining sales, products, stores
- Power BI dashboard with 3 views
- A one-page written recommendation

What it proves:
- You can pull data (SQL)
- You can visualise it (Power BI)
- You can connect numbers to a business decision

Project 2: Customer churn analysis

Business question:
"Why are customers leaving in the last 6 months?"

What you build:
- Python notebook with pandas analysis
- Visualisations of churn by region and plan
- Hypothesis + recommendation

What it proves:
- You can work in Python (pandas)
- You understand basic business metrics
- You can communicate an insight

Two solid projects beat 10 half-finished ones.

README template for each project:

# Project name

## Business question
One sentence — what decision is this helping?

## Dataset
Where it came from, what it contains.

## Approach
Steps: cleaning, querying, visualising.

## Insights
3–5 bullet points with numbers.

## Recommendation
What you would do if you were the manager.

## Tools used
SQL, Power BI, Python.

One portfolio like this beats a formal degree
for most junior analyst roles.