Embedded Files
Course Overview
Course Overview
This track teaches students how to process raw corporate data into Data-driven Insights critical for corporate execution. Starting from statistical principles, it progresses to Advanced Excel, SQL, Power BI / Tableau, and Data Storytelling with deep hands-on labs.
Course Summary
Course Summary
Course Duration : (5) Months
Learning Method : LMS + Discussion + Final Exam + Project
Course Fees : Free ( Tuition Free )
Detailed Course Modules
Detailed Course Modules
Module 1: Data Analytics Foundations & Advanced Excel
Module 1: Data Analytics Foundations & Advanced Excel
Data Ecosystem, Data Lifecycle, and Role of a Data Analyst.
Statistical Foundations: Mean, Median, Mode, Variance, Standard Deviation.
Advanced Excel Formulas (XLOOKUP, INDEX/MATCH, Nested IFs) & Data Cleaning.
Pivot Tables, Charts, and Interactive Dashboard Design in Excel.
Module 2: Relational Databases & SQL for Data Extraction
Module 2: Relational Databases & SQL for Data Extraction
Database Concepts: Relational Databases, Schemas, Primary/Foreign Keys.
SQL Basics: SELECT, WHERE, GROUP BY, ORDER BY, Aggregations.
Intermediate SQL: JOINS (Inner, Left, Right), Subqueries, Common Table Expressions (CTEs).
Database Data Extraction, Modification & SQL Optimization for Reports.
Module 3: Data Visualization with Power BI
Module 3: Data Visualization with Power BI
Introduction to Business Intelligence (BI)
Data Modelling: Star Schema, Snowflake Schema, Relationships Setup.
DAX (Data Analysis Expressions) Basics for Power BI Calculated Columns/Measures.
Building Interactive Executive Dashboards & Designing User Flows.
Module 4: Business Intelligence & Data Storytelling
Module 4: Business Intelligence & Data Storytelling
Exploratory Data Analysis (EDA) Techniques.
Data Storytelling: Presenting Insights to Non-Technical Executives (HBR Style).
Key Performance Indicators (KPIs) Alignment with Business Goals.
Data Governance, Data Ethics, and Privacy Best Practices.
Module 5: Capstone Data Project & Portfolio
Module 5: Capstone Data Project & Portfolio
Capstone Brief: Analyzing a Massive Open-Source Business Dataset.
End-to-End Execution: SQL ETL Pipeline to BI Dashboard.
Portfolio Optimization (GitHub/NovyPro Layout) & Case Study Writing.
Final Presentation, Peer Insights Review, and Grading.
Career Pathways
Career Pathways
Data Analyst / Business Data Analyst
BI (Business Intelligence) Developer
Operations Analyst
Marketing Analytics Specialist
Page updated
Google Sites
Report abuse