Skip to content

This is a repository demonstrating my various data analysis projects, utilizing Python, SQL, Excel ad Power BI.

Notifications You must be signed in to change notification settings

TafadzwaMC/Exploratory-Data-Analysis-Projects

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Exploratory Data Analysis Projects

This repository is dedicated to showcasing various data analysis projects, demonstrating not only the implementation of different analytical techniques but also the methodologies employed, data preprocessing steps, exploratory data analysis, and visualization.

Skillset & Tools

Tools Utilized

  • Google CoLab
  • Jupyter Notebook
  • Microsoft Excel
  • Microsoft Power BI
  • Microsoft SQL Server

Skills Acquired in Analyzing Datasets

SQL

  • MySQL
  • Aggregate Functions (SUM, AVG, COUNT, etc.)
  • Joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN)
  • Subqueries
  • Group By and Having Clauses
  • Window Functions
  • Indexing and Performance Optimization

Python

  • Data Preparation and Cleaning (Handling Missing Values, Data Transformation)
  • Data Analysis (Descriptive Statistics, Hypothesis Testing)
  • Data Visualizations (Charts, Histograms, Heatmaps)
  • Libraries; NumPy, Pandas, Matplotlib, Seaborn, Folium, Plotly (Interactive Graphs)
  • Time Series Analysis
  • Correlation and Regression Analysis
  • Advanced Visualization Techniques (Pair Plots, Facet Grids)

About

This is a repository demonstrating my various data analysis projects, utilizing Python, SQL, Excel ad Power BI.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published