Curriculum
Data Analytics
Module 1: Foundation of Data & Spreadsheet
0/32
-
Module 1 Intro: Foundations of Data & Spreadsheets
Preview -
Welcome to Week 1: The Data Analyst Mindset
Preview
-
Week 1.1: Defining the Raw Material: What is Data?
-
Week 1.2: The Analytical Blueprint: The Data Lifecycle
-
Week 1.3: The Professional Landscape: Roles, Responsibilities, and Tools
-
Week 1.4: The Analyst Mindset: Learning How to Learn
-
Week 1 Assessment: Introduction to Data Analytics Fundamentals
-
Week 1 Assignment: Introduction to Data Analytics Fundamentals
-
Week 1 Module Completion and Next Steps
-
Welcome to Week 2: Spreadsheet Basics
Preview
-
Week 2.1: Getting Started with Excel: The Foundation
-
Week 2.2: Understanding and Formatting Data Types
-
Week 2.3: Data Quality: Filtering, Cleaning, and Validation
-
Week 2 Assessment: Spreadsheet Basics
-
Week 2 Assignment: Introduction to Data Analytics Fundamentals
-
Week 2 Module Completion and Next Steps
-
Welcome to Week 3: Calculations, Logic, and Lookups
Preview
-
Week 3.1: The Formulas Tab: Your Calculation Command Center
-
Week 3.2: Mathematics & Conditional Logic: Making Data Decisions
-
Week 3.3: Data Transformation and Formatting of Time and Text
-
Week 3.4: Data Transformation and Formatting of Time and Text
-
Week 3 Assessment: Calculations, Logic, and Lookups
-
Week 3 Assignment: Comprehensive Sales Analysis & Reporting
-
Week 3 Module Completion and Next Steps
-
Welcome to Week 4: Pivot Tables & Visual Storytelling
Preview
-
Week 4.1: Pivot Tables: Summarization on Demand
-
Week 4.2: Data Visualization with Charts
-
Week 4.3: Building Interactive Dashboards
-
Week 4.4: Excel is a powerful tool: you’ve only scratched the surface
-
Week 4 Assessment: Pivot Tables & Visual Storytelling Fundamentals
-
Week 4 Final Portfolio Project: Sales Performance Dashboard
-
Week 4 Module Completion and Next Steps
Module 2: Data Management With SQL
0/36
Module 3: Data Visualisation with Power BI
0/33
Module 4: Business Problem Solving & Communications
0/29
Module 5: Capstone Project
0/5
Mock Exam
0/2
Welcome to Week 4: Pivot Tables & Visual Storytelling
Learning Objectives
By the end of this week, you will be able to:
-
Create and manipulate Pivot Tables to quickly group, aggregate, and analyze large datasets.
-
Understand the purpose and application of the most common chart types (Bar, Line, Pie).
-
Design and format professional charts that adhere to best practices in data visualization.
-
Combine aggregation and visualization techniques to create simple, insightful dashboards.
Expected Outcomes
Your final deliverables will demonstrate your mastery of the complete data analysis process:
-
Your Excel skill set will suffice for entry-level roles, allowing you to analyze and visualize important metrics for businesses.
-
You will be able to efficiently summarize large datasets to answer specific business questions (e.g., “What is the sales amount for Product X across all Regions?”).
-
You will create clear, compelling charts and use Pivot Tables and Dashboards to visualize trends and anomalies.
Get ready to build your first portfolio-ready dashboard!