-
- Simple calculations & formulas (SUM / MAX / MIN / MEAN / MULTIPLY)
- Dates format modyfications
- Conditional formatting
- VLOOKUP / MATCH / INDEX / MAXIFS / MINIFS formulas
- Visualisations (charts, pivot tables)
- Data Lifcycle
-
- Business Requirements
- Blueprint & Mockup
- Simple calculations & numbers formatting
- Filters & sliders
- Dashboard for internal stakeholders
- Dashboard for external stakeholders
-
- Business Requirements
- Data Quality
- Data source, sensitvity & ownership
- Pandas (loading 3 different data files; functions : READ / HEAD / SHAPE / COLUMNS / DTYPES /VALUE_COUNT / DESCRIBE / UNIQUE)
- Identify if data is qualitative(binary, nominal or ordinal) or quantitative(discrete, continuous)
- Identify data types
- Identify zero & nulls values
- Identify outliers with boxplot
- Identify duplicates
- Identify issues, remove 0 & nulls and plot map
- Identify unmached data within data files
-
SQL (Sqlite3, NumPy, Pandas, Google Colab)
- Business Requirements
- Creating ERD
- Creating Sqlite Database
- Loading data into tables
- Identify & drop duplicates
- Review data with HEAD & COLUMNS
- Creating tables with referential integrity (Primary/Foreign Keys)
- Create Single Table Queries & test it with Pandas
- GROUP BY, ORDER BY, WHERE, LIKE, LIMIT, DISTINCT, COUNT, STRFTIME
- Create Cross Table Queries(JOIN) & test it with Pandas
- Insert queries into Queries Tables in case future analysis & Test it with Pandas
