← All courses
Professional Skills Program
AI-Integrated Curriculum
ICT-DA-301
Data Analytics & Business Intelligence
From Raw Data to Confident, Data-Driven Decisions
About this course
Equips learners with the complete, in-demand data analytics workflow — from collecting and cleaning data to analyzing, visualizing, and communicating insights that drive business decisions. Starting with spreadsheets and progressing to SQL, Python, and BI dashboards, students build a portfolio-ready capstone, supercharged by AI-assisted analysis tools. No prior coding experience required.
Prerequisites
Basic computer literacy and familiarity with spreadsheets. No programming background needed — we start from the fundamentals.
Methodology
Hands-on labs with real datasets, project-based learning, AI-assisted analysis, and a guided portfolio capstone.
The curriculum
What you'll learn
- The analytics lifecycle & workflow
- Descriptive to prescriptive analytics
- Data types, sources & quality
- Toolkit setup (Sheets, SQL, Python)
- Intro to AI data assistants
- Advanced formulas & lookups
- Data cleaning & standardization
- Pivot tables & summaries
- Power Query for ETL basics
- AI-assisted formula building
- Relational databases & schemas
- SELECT, filtering & sorting
- Joins, aggregations & GROUP BY
- Subqueries & CTEs for insight
- pandas & NumPy essentials
- Data wrangling & merging
- Exploratory Data Analysis (EDA)
- Charts with Matplotlib/Seaborn
- Power BI / Looker Studio
- KPIs, measures & DAX basics
- Interactive dashboard design
- Storytelling with data
- Descriptive & inferential statistics
- Correlation & A/B testing fundamentals
- AI for insights & narratives
- Capstone: end-to-end dashboard from a real dataset
Outcomes
You'll walk away able to…
- Clean, analyze, and visualize real-world datasets
- Write SQL and Python to answer business questions
- Build interactive BI dashboards in Power BI / Looker Studio
- Present a portfolio-ready capstone project