Most beginners get stuck because everyone tells them something different: learn Python first, learn SQL, buy five certificates.
This playbook gives you one clear path, in the order that makes you useful fastest. It's written by a working Senior BI Developer, based on what the job actually asks for.
What's inside (17 pages + practice data)
- What data analysts really do: the workflow, the roles and the skills employers want
- Excel for analysis: cleaning, SUMIFS, XLOOKUP and PivotTables, step by step
- SQL that gets used: real business questions with checked answers (joins, CTEs, window functions)
- Power BI dashboards: data model, DAX measures and a one-page dashboard layout
- Business intelligence concepts: KPIs, grain, star schema, data quality
- Portfolio projects: 3 projects, a project template and a LinkedIn post template
- AI tools, used properly: prompts that work and a routine for checking AI output
- Resume and interview prep: strong bullets, STAR stories, 10 questions to practise, and tips for applying outside Nigeria
- Plus a 12-week plan, a glossary and sample data.
You also get the practice files: setup.sql, customers.csv, orders.csv and tickets.csv. The examples use naira, so they feel real.
Who it's for: beginners, career switchers, graduates and anyone preparing for a data analyst role.
Please note: this builds skills and gives you a plan.