INTRODUCTION TO DATA ANALYTICS & EXCEL
● Overview/manipulation of data

○ Discuss the history of data, data mining and analytics
○ Introduction to spreadsheets/excel
○ Excel basic functions & formulas
○ More advanced functions and formulas
○ Lookup tables and pivot tables
○ Sensitivity analysis
○ Excel visualizations

INTRODUCTION TO DATABASE FUNDAMENTALS
● Introduction to the data life cycle
● Databases and database users
● Intro to database modelling and design
○ conceptual/logical design
○ Crows foot/Chen's notation (differences & use)

INTRODUCTION TO SQL DATABASE MANAGEMENT SYSTEMS
● Intro to MySQL
● SQL basic queries, group by and aggregate functions
● SQL joins, sub-queries and views
● Working with MySQL/PostgreSQL

INTRODUCTION TO DATA VISUALIZATION WITH POWER BI
● Introduction to business intelligence
● Dashboard design basics
● Power BI for creating visualizations and Interactive dashboards

PROGRAMMING WITH PYTHON
● Introduction to programming for data analysis
● Introduction to Python IDE’s
○ Anaconda and jupyter notebooks
○ Google collab
○ Pycharm/Visual Studio code
● Variables and data frames
● For loops and conditional statements
● Built-in and user-defined functions in python
● Importing packages
○ Introduction to Numpy and Pandas

DATA ANALYTICS WITH PYTHON PROGRAMMING
● Manipulate data and summary statistics
● Introduction to matplotlib and seaborn
● Exploratory data analysis
● Extracting/collecting data from APIs

● Building dashboards in python (optional)
Overall Approach to Mastering:
 Complete daily assignments
 Group tasks
 Project at the end of each track