Course Curriculum
A structured approach to Professional Program In Data Analytics
Introduction to Data Analytics - Data Analytics Overview
Introduction to Data
Data Lifecycle
Types of Analytics (Descriptive
Diagnostic
Predictive
Prescriptive)
Advanced Excel - Introduction to Excel
Data Cleaning & Preparation
Data Manipulation and Management
Pivot Tables & Lookups
Data Visualization
Advanced Excel Functions & Automation
SQL for Data Analytics - Introduction to SQL
Basic SQL Queries
Joins & Subqueries
Aggregations & Grouping
Conditional Logic
Window Functions
Complex Queries & Case Studies
Power BI - Introduction to Power BI
Data Import & Transformation
Creating Reports and Dashboards
DAX (Data Analysis Expressions)
Advanced Visualizations
Sharing & Collaboration
Tableau - Introduction to Tableau
Connecting to Data Sources
Creating Visualizations
Dashboard Design
Advanced Analytics in Tableau
Best Practices for Storytelling with Data
Python for Data Analytics - Basics of Python
Python Syntax & Data Types
Data Structures & Numpy
Data Manipulation with Pandas
Data Visualization with Matplotlib & Seaborn
Exploratory Data Analysis (EDA)
Statistics & Probability - Descriptive Statistics
Probability Basics
Hypothesis Testing
Correlation & Regression Analysis
Statistical Inference for Decision Making
Business Analytics Applications - Case Studies in Marketing Analytics
Sales & Financial Analytics
HR & Operations Analytics
Customer Behavior Analysis
Data-Driven Decision Making
+44