Coming soon
Data Analytics: Excel, SQL and Power BI
Turn raw data into the reports and dashboards companies use every day.
- 3 months
- Beginner, no coding needed to start
- 4 parts · 32 topics
Send us one message on WhatsApp, and we will tell you the launch date.
Planned syllabus
The full roadmap, basic to advanced
Every part builds on the one before it. You finish each part with a real project.
- Parts
- 4
- Duration
- 3 months
- Topics
- 32
- Projects
- 4
Part 1Month 1: Excel for analysis
- Cleaning data in Excel
- Formulas: IF, SUMIFS, COUNTIFS
- XLOOKUP and INDEX MATCH
- Text and date functions
- Pivot tables and pivot charts
- Conditional formatting
- Power Query basics
- An Excel sales dashboard
Project A monthly sales report built from raw data.
Part 2Month 2: SQL
- Databases, tables and keys
- SELECT, WHERE, ORDER BY
- GROUP BY and HAVING
- JOINs: inner, left, right, full
- Subqueries and CTEs
- Window functions: ROW_NUMBER, RANK, running totals
- Date functions and CASE WHEN
- Solving real business questions with SQL
Project Answer 25 business questions from an e-commerce database.
Part 3Month 3: Power BI
- Power BI Desktop and loading data
- Power Query transformations
- Data modelling: star schema and relationships
- DAX basics: measures and calculated columns
- Time intelligence: MTD, YTD, last year
- Charts, slicers and drill-through
- Designing a clean dashboard
- Publishing and sharing reports
Project A business dashboard with filters, shared online.
Part 4Career
- An end-to-end analytics project
- Python with pandas for analysts (intro)
- Presenting insights to managers
- Portfolio on GitHub and LinkedIn
- Resume for data analyst roles
- SQL and Excel interview questions
- Case study rounds
- Freelancing as a data analyst
Project A portfolio page with your 3 best dashboards.
This is the planned syllabus. Small changes are possible before launch.
Want this course? Tell us.
Send one message on WhatsApp, and we will tell you as soon as the launch date is fixed.