Full-Stack Data Analytics

FREE LAPTOP

DATA ANALYSIS CURICULLUM

Learn the statistics & probability for Data Analytics & business Analysis:

Learn Tools +Skills Like: Python Programming | Microsoft Excel | Spreadsheet | Microsoft Power BI | SQL | Webscraping etc.

Become the most Sought After Data Analyst Expert in Nigeria & Abroad.

Week 1: Core understanding to Statistics plus Mathematics

·         Statistics

·         Probability

·         Data: pathways in the data field

·         Data: data sources

·         Introduction to ETL

·         Distributions

Week 2: Concept of Spreadsheet

·         Spreadsheet

·         Advanced excel

·         Formulas

·         Functions

·         Pivot table

Week 3: Charts & Data Visualization with Excel

·         Charts and visualization with excel

·         Advanced excel: statistics in excel

·         Dashboard

·         Project

Week 4: Essentaial to Business Intelligence with Power BI

·         Introduction to business intelligence

·         Introduction to Microsoft power BI

·         Power BI environment

·         Power query

·         Business intelligence data analytics

·         Data modeling

Week 5: Data Visualization

·         Dashboard in power BI

·         Data cleaning with power query

·         DAX

·         Project

Week 6: Essential to SQL

·         Introduction to RDBMS

·         Introduction to SQL

·         SQL dialects

·         MySQL environment

·         Syntaxes and queries

Week 7:

·         Joins and union

·         Filter syntaxes

·         Sub-queries

·         CTE -  Common Table Expression

·         Windows function

·         Project

Week 8: Essential to Python Programming

·         Introduction to python

·         Python IDEs for data analysis

·         Python basics

·         Data type and data structure

·         Control flow

·         functions

Week 9:

·         Python libraries

·         Numpy

·         Pandas

·         Matplotlib, seaborn, plotly and other visualization tools

·         Visualization in python

·         EDA: Exploratory Data Analysis

 

Week 10:

·         Webscraping

·         Data wrangling

·         Descriptive analysis

·         Project

Week 11:

·         Git and github 

·         Portfolio

Week 12: Final project