The Analyst Toolkit: Excel + SQL + Power BI on One Real Business Dataset

Learn the three tools every data analyst job asks for, the way analysts actually use them at work: on the same business, answering the same questions.

All three guides use UrbanCart, a realistic online store with 1,500 orders, 200 customers and 32 products. You’ll clean its data and build dashboards in Excel, query its database with SQL, then build an interactive Power BI dashboard on top of it. By the end, you’ll understand not just each tool, but how they fit together.

What’s inside:

• Excel for Data Professionals (2nd edition): a hands-on guide with a practice workbook, 38 practice questions with live answers, data cleaning, Pivot Tables and dashboards.
• SQL for Data Newbies (2nd edition): from your first query to joins and subqueries, with a practice database you can use in your browser, 26 practice questions and 3 business case studies.
• Power BI for Data Professionals: go from messy files to a two-page interactive dashboard, covering Power Query, data modelling, DAX and dashboard design, with 3 case studies.

Every chapter has practice questions with full solutions, so you always know you’re on track.

Who it’s for: beginners and aspiring data analysts who want job-ready skills in the three most requested tools.

Written by Esther C. Anagu, ML & AI Engineer and author of The Data Analyst Roadmap and Landing Your First Job as a Data Professional.

Instant download (ZIP). Power BI Desktop is free and runs on Windows.