Welcome to Data Analytics

01 Course Orientation

Welcome to Data Analytics Video
Introduction to Data Analysis Locked
Data Analysis Basics Locked

02 Module 1 — Data Analytics Fundamentals

Roles and Responsibilities of a Data Analyst Locked
Types of Data (Structured, Semi-Structured, Unstructured) Locked
Sources of Data in Business Locked
Data Analytics Lifecycle Locked
Activity 1: Exploring Real-World Data Sources Locked
Module 1 — Data Analytics Fundamentals — Knowledge Check Locked

03 Module 2 — Data Collection and Data Preparation

Data Collection Methods Locked
Introduction to Google Forms Locked
Data Quality Concepts Locked
Data Cleaning Techniques Locked
Data Formatting Standards Locked
Data Privacy and Confidentiality Locked
Activity 2: Collect and Clean Survey Data Locked
Module 2 — Data Collection and Data Preparation — Knowledge Check Locked

04 Module 3 — Microsoft Excel for Data Analytics

Excel Interface and Navigation Locked
Working with Tables Locked
Sorting and Filtering Data Locked
Conditional Formatting Locked
Data Validation Locked
Named Ranges Locked
Activity 3: Organizing Business Data in Excel Locked
Module 3 — Microsoft Excel for Data Analytics — Knowledge Check Locked

05 Module 4 — Excel Formulas and Functions

Mathematical Functions Locked
Logical Functions (IF, IFS) Locked
Lookup Functions (XLOOKUP, VLOOKUP) Locked
Text Functions Locked
Date and Time Functions Locked
Error Handling Functions Locked
Activity 4: Solving Business Problems Using Formulas Locked
Module 4 — Excel Formulas and Functions — Knowledge Check Locked

06 Module 5 — Data Analysis Techniques

Descriptive Statistics Locked
Mean, Median, and Mode Locked
Trend Analysis Locked
Pivot Tables Locked
Pivot Charts Locked
Business Data Interpretation Locked
Activity 5: Sales Performance Analysis Locked
Module 5 — Data Analysis Techniques — Knowledge Check Locked

07 Module 6 — Google Sheets for Collaborative Analytics

Google Sheets Fundamentals Locked
Sharing and Collaboration Locked
Data Validation Locked
Functions in Google Sheets Locked
Real-Time Reporting Locked
Activity 6: Team-Based Analytics Project Locked
Module 6 — Google Sheets for Collaborative Analytics — Knowledge Check Locked

08 Module 7 — Data Visualization Principles

Introduction to Data Visualization Locked
Choosing the Right Chart Locked
Data Storytelling Locked
Dashboard Design Principles Locked
Visualization Best Practices Locked
Activity 7: Create Business Charts and Graphs Locked
Module 7 — Data Visualization Principles — Knowledge Check Locked

09 Module 8 — Power BI Fundamentals

Introduction to Power BI Locked
Connecting Data Sources Locked
Data Transformation Locked
Data Modeling Basics Locked
Creating Visualizations Locked
Publishing Reports Locked
Activity 8: Build Your First Dashboard Locked
Module 8 — Power BI Fundamentals — Knowledge Check Locked

10 Module 9 — Dashboard Development

KPI Development Locked
Interactive Reports Locked
Slicers and Filters Locked
Drill-Down Analysis Locked
Executive Dashboards Locked
Activity 9: Develop a Management Dashboard Locked
Module 9 — Dashboard Development — Knowledge Check Locked

11 Module 10 — Reporting and Presentation

Report Writing Standards Locked
Presenting Analytical Results Locked
Communicating Insights Locked
Business Recommendations Locked
Professional Documentation Locked
Activity 10: Analytics Presentation Locked
Module 10 — Reporting and Presentation — Knowledge Check Locked

12 Module 11 — Data Management and Security

File Organization Standards Locked
Cloud Storage Solutions Locked
Backup Procedures Locked
Data Security Practices Locked
Documentation Standards Locked
Activity 11: Create a Data Management Plan Locked
Module 11 — Data Management and Security — Knowledge Check Locked

13 Module 12 — Capstone Project

Project Briefing Locked
Data Collection Locked
Data Cleaning Locked
Data Analysis Locked
Dashboard Development Locked
Final Report Preparation Locked
Final Project: End-to-End Business Intelligence Dashboard Locked
Module 12 — Capstone Project — Knowledge Check Locked