Interview in two weeks? Don't start a new course. Revise what the JD asks for, in this order.
SQL first, then Excel and Power BI. Then prove it with your project and timed mocks.
Start Day 1 today.
Day 1-5: SQL first
- D1-3
SQL core
- SELECT, WHERE, ORDER BY
- INNER and LEFT JOIN
- GROUP BY + HAVING
- 15 queries on one dataset
- D4-5
SQL that filters people out
- CASE WHEN
- ROW_NUMBER, RANK, DENSE_RANK
- Subqueries and CTEs
- Running total with SUM() OVER
Do these in the free SQL playground. 50 questions, checked instantly.
Day 6-9: Excel + Power BI
- D6-7
Excel
- XLOOKUP, SUMIFS, COUNTIFS
- Pivot table with slicers
- IF + IFERROR
- One messy sheet, cleaned in 30 min
- D8-9
Power BI
- Power Query cleaning
- CALCULATE, DIVIDE, time intelligence
- Star schema + date table
- One-page dashboard
Day 10-14: prove it
- D10-11
Python + stats basics
- pandas: read_csv, groupby, merge
- Fill or drop missing values
- Mean vs median, percentiles
- D12-14
Project + mocks
- Pick your best project
- 2-minute walkthrough, out loud
- 3 findings, each with a number
- 2 timed SQL mocks
Your daily 3 hours
| Block | What you do |
|---|---|
| Hour 1 | Revise the day's topic from your notes |
| Hour 2 | Solve 10 questions without looking |
| Hour 3 | Explain 3 answers out loud, like the interview |
| Night | Write every mistake in one sheet |
| Day 14 | Read only that mistakes sheet |
Same dataset all 14 days. You learn the questions, not the data.
How to revise
Wastes the 14 days
- Starting a new course
- Watching answers, not typing them
- Learning Tableau, ML and Spark too
Gets you ready
- Only what the JD lists
- Typing every query yourself
- Timed practice from Day 12
Not sure what the JD means? Decode it: SQL, Excel, Power BI, MIS.