Can a Housewife Become a Business Analyst Without a Degree?

Home skills that map to BA work

Planning weekly household tasks  -> breaking work into steps
Comparing products before buying -> evaluating options
Managing the family budget       -> numbers and trade-offs
Coordinating with schools/repairs -> stakeholder communication
Solving daily problems calmly    -> problem analysis
Explaining things to elders/kids -> clear communication

Write one real story for each.
Use them in interviews with the STAR format.

If you later want a degree too

- Distance or open university bachelor's programmes
- Part-time programmes alongside work
- Recognised certifications in business analysis
  (check eligibility and experience requirements)

A degree is not required to START learning
or to apply for many entry-level analyst roles.
Decide based on the jobs you are targeting.

User stories for a neighbourhood grocery app (practice)

1. As a customer, I want to repeat my last order
   so that I can reorder weekly items quickly.
   Acceptance:
   - "Reorder" button on past orders
   - Out-of-stock items clearly marked

2. As a shop owner, I want to see today's pending orders
   so that I can pack them on time.
   Acceptance:
   - List sorted by delivery time
   - Shows customer name, items and address

3. As a delivery person, I want the customer's location on a map
   so that I can deliver without calling repeatedly.

Excel skills to learn first
- SUM, AVERAGE, COUNTIF, SUMIF
- XLOOKUP / VLOOKUP
- Pivot tables and simple charts
- Data cleaning: TRIM, remove duplicates, filters

Basic SQL to learn next
SELECT category, SUM(amount) AS total
FROM expenses
GROUP BY category
ORDER BY total DESC;

Practise on your own household expense sheet:
which category grew the most over three months?

Process map: Home tiffin service - order to delivery

[Customer]  Sends order on WhatsApp by 9 AM
     |
[Owner]     Notes order in a notebook       <- pain: orders missed
     |
[Kitchen]   Cooks based on notebook count   <- pain: wrong counts
     |
[Delivery]  Delivers by 1 PM
     |
[Owner]     Collects payment weekly         <- pain: unpaid dues

Improvement idea:
- Shared order sheet with a daily cut-off
- Auto count of meals per type
- Weekly payment reminder message

Case Study Outline (1-2 pages)

1. Business and problem
2. People involved (stakeholders)
3. Questions I asked and what I learnt
4. Current process (map) and pain points
5. Requirements as user stories
6. Recommendation and expected benefit
7. What I would check after the change

Keep it simple, visual and honest.

Requirement Sheet

ID     Requirement                          Priority   Stakeholder
R-01   Orders close at 9 AM cut-off         Must       Owner
R-02   Daily meal count by type             Must       Kitchen
R-03   Weekly payment reminder              Should     Owner
R-04   Customer can pause orders            Could      Customer

Stakeholder Interview Guide

1. What is your role in this process?
2. What does a normal day look like?
3. What goes wrong most often?
4. How do you handle it today?
5. If you could change one thing, what would it be?
6. How would you know the change worked?

Notes: _______________

STAR Answer Planner

Question: "Tell me about a problem you solved."
Situation: _______________
Task: _______________
Action: _______________
Result: _______________

Prepare 5 stories: planning, conflict, budget,
learning something new, improving a process.