Back to all courses8 weeks40 lessonsSelf-paced + weekly SQL clinic
DataBeginner4.9 (129 reviews)
Applied Data Analytics with SQL, Python & BI
Turn raw operational databases into automated insights, cohort analyses, and crisp executive dashboards.
ZF
Zainab Farooq
Lead Data Engineer
TuitionRs 32,000
Enroll NowLearning Outcomes
What you'll learn
- Write confident analytical SQL with CTEs, window functions, and joins
- Clean, reshape, and analyze messy datasets using Python and pandas
- Build retention cohorts, revenue waterfalls, and funnel metrics
- Design executive BI dashboards that answer business questions fast
- Spot data quality anomalies before they reach leadership
- Communicate clear written recommendations backed by evidence
Syllabus Breakdown
Course curriculum
4 structured modules • 40 lessons • 8 weeks
01
12 lessons • 2.5 weeksModule 1: Analytical SQL Mastery
- Filtering, grouping, and multi-table joins on real schemas
- Window functions for running totals and period-over-period growth
- Writing readable CTE pipelines for recurring questions
02
10 lessons • 2 weeksModule 2: Python & Pandas for Business Data
- Cleaning inconsistent dates, currencies, and missing records
- Exploratory analysis and automated summary scripts
- Working with CSV, JSON, and SQL extracts
03
9 lessons • 2 weeksModule 3: Product & Revenue Analytics
- Cohort retention tables and churn diagnostics
- A/B test sizing and avoiding false positives
- Building executive KPI trees
04
9 lessons • 1.5 weeksModule 4: BI Dashboards & Capstone Case
- Visual hierarchy and chart selection principles
- Interactive filtering and drill-down workflows
- Presenting an executive business memo
Student Feedback
Reviews from Xoksis graduates
“Zainab teaches analytics the way real product teams work. The window-function drills completely transformed how quickly I answer leadership queries.”
Daniyal Raza
Business Analyst, Lahore
“Using local e-commerce and fintech style datasets made everything immediately relatable. Best structured LMS experience I have used.”
Mahnoor Aslam
Junior Data Analyst, Karachi