Wilson
a data Analyst
portfolio

Data Analyst proficient in SQL, Python, Tableau, Power BI, and Excel

Data Cleaning in SQL

This project is dedicated to the art of data cleansing within SQL, demonstrating not only the crucial step of refining data but also the subsequent data manipulation within a database. It sheds light on the extensive data cleaning tasks that often go underappreciated in the realm of data analysis.
Skills related: SQL, Microsoft SQL Server, Data Analysis

Childhood Immunization Analysis

In this project, I conducted an in-depth analysis on 2017 CDC data about childhood immunizations. The goal was to uncover key insights regarding immunization rates, vaccine effectiveness, and correlations between various factors.
Skills related: Python, Pandas,Numpy,Scipy,Data Analysis

Road Accident Dashboard

Create a Road Dashboard for year 2021 and 2022 with Power BI. The Dashboard will help audience gain information such as: Total casualties, accidents, and YOY growth; Casualties by accident severity and YOY change; Casualties by vehicle type for the current year; Monthly trends in casualties for current and previous years; Casualties by road type in the current year; Casualties by location and day/night for the current year; Total casualties and accidents by location.
Skills related: Power BI, Data Extration, Data Visualization, Data Analysis

Economic Analysis with Pandas

The primary objective of this project is to harness the robustness of the FRED API to fetch and analyze economic indicators that impact financial markets and the overall economy. Specifically, I aim to study the price trends of the S&P 500 index and the unemployment rates of individual states in the United States.
Skills related: Python, Pandas, API, Data Analysis