Level 1 — Data Analysis Foundations

Understand data concepts and core data analysis principles using Excel, without programming, and build a data analyst mindset.

Data Foundations

* What is Data

* Structured vs Unstructured Data

* Data Lifecycle

* Databases Overview

* Tables / Rows / Columns

* Relational vs NoSQL

* Primary vs Foreign Key

* ERD Concepts

* Relationships & Cardinality

Excel for Data Analysis (Core)

* IF / Nested IF

* AND / OR

* SUMIF / COUNTIF

* VLOOKUP / XLOOKUP

* INDEX + MATCH

* Date & Text Functions

Pivot Tables

* Rows / Columns / Values / Filters

* Grouping

* Pivot Charts

🎯 Outcome

* Junior Data Analyst (Excel-based)

* Understand data structure & logic.