Projects
Bike Buyers: Cleaning, Analysis and Visualization
This Excel project focuses on cleaning data using filter tools such as removing duplicate's and Find & Replace function, along with formulas and functions such as =IF(logic test,value if true,value if false). The Excel file contains the raw data, a working sheet (clean data), Pivot Table, and Dashboard.
See the link below.
Bike Buyers Pivot table and Dashboard.xlsx
​
SQL
I have completed numerous projects where I have meticulously cleaned data and created insightful pivot tables. My data analytics has brought clarity and informed decisions for businesses across different industries. Check out our recent projects below to learn more.
US Presidents: Data Cleaning
-
Formatting & Standardizing (PROPER, UPPER, ETC.)
-
Treat the duplicates
-
Filtering & TRIM
-
Formatting dates & numbers
-
Find & Replace
-
Drop unneeded columns
​
See the link below.
​
​
Coffee Orders Data
Coffee Orders Data which includes building tables, graphs, and interactive dashboard.
