Welcome to my data analytics portfolio! This repository showcases my skills in data cleaning, data analysis, and visualization using MySQL and Excel. It currently consists of three MySQL data cleaning and analysis projects and Excel dashboards. More projects to come including visualizations in Tableau and PowerBI.
This portfolio contains the following projects: MySQL Data Cleaning and Analysis Projects: Three projects focusing on data cleaning, transformation, and analysis using MySQL. Excel Dashboards: Two projects demonstrating the use of Excel functions and visualizations to create dashboards.
MySQL: Used for data cleaning, transformation, and analysis.
Excel: Utilized for creating dynamic dashboards derived from functions, formulas, and charts.
-
Objective: Clean the business data to ensure consistency and explore various aspects of businesses in New York City.
-
Tasks: Standardizing data formats, removing duplicates, fixing inconsistencies, and performing exploratory analysis on industry types, license type and status, and other characteristics of the business.
-
Objective: Analyze genetic and lifestyle factors contributing to cancer diagnosis.
-
Tasks: Comparing patients with cancer diagnoses to those without, examining genetic markers, and analyzing lifestyle risk factors.
-
Objective: Clean a large dataset on childcare.
-
Tasks: Removing duplicates,identifying and correcting misspelled words, standardizing data entries, and resolving inconsistencies between multiple childcare locations, business names, and addresses.
-
Description: This dashboard provides a comprehensive view of sales performance, including revenue trends, sales by product category, store rankings, and revenue by payment method.
-
Key Features: Interactive charts, data validation lists for filtering, and dynamic charts.
-
Description: Focuses on customer demographics, purchasing behavior, and satisfaction ratings.
-
Key Features: Visualizations for customer count by branch, gender monthly revenue comparison, and average customer rating by product line.
-
Functions and Formulas: The Excel projects utilize a range of functions and formulas, such as VLOOKUP, SUMIFS, COUNTIFS, IF, AVERAGEIFS, and others, to create dynamic tables and charts.
-
Charts and Visualizations: The dashboards include various types of charts, such as KPIs, bar charts, line charts, tables, and heatmaps, to present data effectively.
-
Pivot Tables - Along with manually created tables, this projects also shows a pivot table version of the tables used to create the visualization on the dashboards.