Data Analytics & BI Academy
SQL · Python · BI · Engineering
Structured learning with practice questions, guides, and preparation material.
👤 Who This Is For
📋 Prerequisites
🎯 What You'll Be Able to Do
📚 Explore Topics
Data Analysis
Analyse and interpret data effectively
Business Intelligence
BI tools, dashboards, and reporting
Microsoft BI — DAX, data modelling, star schema, RLS, publish
Tableau Desktop and Server — calculated fields, LOD expressions, dashboards
Visualization principles — choosing the right chart, avoiding misleading graphs, storytelling with data
Designing effective dashboards — KPI selection, layout, drill-downs, refresh strategy across BI tools
Data Engineering
Pipelines, warehouses, and big data
SQL from SELECT to window functions, CTEs, performance tuning
Analytics engineering with dbt — models, tests, macros, incremental builds, documentation
Workflow orchestration — DAGs, operators, scheduling, sensors, production pipeline patterns
Distributed data processing — RDDs, DataFrames, partitioning, cluster tuning basics
Cloud data warehousing across vendors — BigQuery, Redshift, Synapse, Snowflake compared, not one vendor only