Projects
Google Data Analytics Capstone Project:
This project analyzed Cyclistic historical bike trip data to identify trends to identify how annual members and casual riders use Cyclistic bikes differently.
I analyzed the data from April 2020 — Mar 2021. I analyzed and visualized the data using excel
EDUCATION FOR ALL CHARITY DONOR ANALYSIS
As a Data Analyst working for a fictitious charity company named Education for All. I have been asked by the Head of Fundraising to present the data on donor insights and donation rates. Within the Fundraising team, my objectives are to:
• Increase the number of donors in the database
• Increase the donation frequency of the donors.
• Increase the value of donations in the database.
I made use of the Root Cause Analysis to get a deeper insight into the ‘why’ of the
business problem.
After analyzing the data, I visualized my insights using Tableau and presented them
to my team.
%20(1).webp)
Airline Passenger Satisfaction Survey Analysis
​This project is to analyze an airline passenger satisfaction survey from Kaggle. I cleaned, analyzed, and visualized the data using Powerbi Desktop.
Data Analysis Challenge: Impact of Weather Conditions on Air Quality
This purpose of this project is to assess the impact of weather conditions on air quality. I used
Statement Problem
-
What weather factors greatly influence the PM 2.5 value?
-
Which month and year recorded the highest and lowest PM 2.5 value?
-
What is the forecast projection of the pm2.5 value in the next 4 years?
Skills/ Concepts Demonstrated
The following Power BI features were incorporated into this project:
-
DAX,
-
Bookmarking
-
Drillthrough filtering
