Buy Template
Design
4.8 / 5.0
overall rating
Data Analytics
Turn raw data into clear insights that drive smarter business decisions
Intermediate
8 Weeks
2026 Edition
About this course
Turn raw, unstructured datasets into clear visual dashboards that drive smarter, high-level business decisions. Master essential data cleaning, SQL database querying, and executive reporting in PowerBI and Python.
What will you learn
Clean, transform, and analyze complex datasets using SQL and Python
Build interactive executive dashboards in Tableau and PowerBI
Derive actionable business intelligence from quantitative raw data
Your requirements
Basic understanding of spreadsheets (Excel / Google Sheets)
Computer with permission to install open-source software
Course curriculum
Chapter 1:
SQL & Database Querying
Lessons:
5
Duration:
50 mins
Relational Databases & Schema Design
Understand tables, primary/foreign keys, and relational schema structures.
Filtering & Aggregating with SQL
Write SELECT, WHERE, GROUP BY, and HAVING queries to isolate key metrics.
Multi-Table Joins & Subqueries
Combine complex datasets using INNER, LEFT, RIGHT, and FULL OUTER joins.
Window Functions & CTEs
Calculate running totals, ranks, and moving averages using window functions.
Data Cleaning with SQL
Handle null values, remove duplicate records, and standardize messy strings.
Chapter 2:
Python for Data Analysis
Lessons:
5
Duration:
60 mins
Python & Jupyter Notebook Setup
Configure an analytical environment using Anaconda, Jupyter, and Pandas.
Data Wrangling with Pandas
Filter DataFrames, handle missing records, and transform raw series data.
Statistical Analysis & Correlation
Calculate mean, median, variance, and standard deviation across variables.
Exploratory Data Analysis (EDA)
Detect outliers, anomalies, and seasonal patterns in quantitative data.
Data Visualization with Seaborn
Generate heatmaps, scatter plots, and distribution charts programmatically.
Chapter 3:
BI Dashboards & Business Insights
Lessons:
5
Duration:
55 mins
Data Modeling in PowerBI / Tableau
Import multi-source data and build robust star schema data relationships.
DAX Calculations & Custom Metrics
Write DAX measures to calculate Year-over-Year growth, churn, and margins.
Designing Executive Dashboards
Structure clean, scannable dashboard views that highlight core KPIs instantly.
Storytelling with Data
Translate complex analytical findings into actionable executive presentations.
Full Analytics Project
Take a messy raw dataset and produce an executive-ready business report.
Dr. Aris
Principal Data Scientist
Expert in quantitative data modeling, business intelligence analytics, and predictive algorithmic frameworks.