Portfolio
Featured Consulting Experience
Health In Harmony & TIL+
On this project, I consulted with Health in Harmony, an international non-profit dedicated to reversing global heating and recognizing the critical role rainforests play in humanity's survival. Using the innovative process of Radical Listening, Health in Harmony collaborates with experts to create impactful change on the planet.
This project was carried out as a part of TIL+, an initiative from The Information Lab to help NGOs and nonprofits make sense of their data.
I assisted in three main areas:
Organizing and Improving Efficiency of Tableau Cloud Subscription: I optimized their Tableau Cloud subscription, organized data sources, and streamlined the storage of dashboards.
Creating Dashboards: I developed several dashboards to visualize their data clearly, focusing on various programs in Madagascar and Indonesia. These dashboards provided valuable insights into their operations and outcomes.
Training End Users: I trained end users to understand and utilize Tableau effectively, enabling them to gain insights from their data.
Data Analytics & Visualization
Data Analysis Skills
View my projects:
Tableau Projects:
Click here to see all my Tableau Visualizations: Tableau Public
Tableau Viz:
Superstore - Sales Volume Variance
Tableau Viz:
2024 New York Income Tax Calculator
Tableau Viz:
The Julian Assange Saga: A Timeline of Legal Battles
Tableau Viz:
West Coast Telecom - Churn Report & Analysis
Tableau Viz:
Northwind Traders - Annual Performance Review
Tableau Viz:
Executive Expense Report
Tableau Viz:
MLB Player Salaries: 2003 to 2023 #B2VB
Tableau Viz:
Are My Devices Watching Me?
Tableau Viz:
Black Friday - Average Discounts By US Retailers (2015 - 2023)
Tableau Viz:
New York School Cafeteria Inspections (2020 to 2023)
Tableau Viz:
And the Best Picture goes to... (Data + Movies Challenge)
Tableau Viz:
Daily Sales Tracker
Tableau Viz:
US Mortgage Rates: 2013 to 2023
#B2VB 2023/Week 1 - Build an Area Chart
Tableau Viz:
Alcohol Consumption in OECD Countries (1 hour viz)
Tableau Viz:
US Stock History 2013 to 2018
Tableau Viz: US State Government Tax Revenue (2007 - 2021)
Tableau Viz:
Best region for Series-A funding in the USA?
Tableau Prep Builder:
SQL Projects:
Click here to see all my SQL projects: Github
Business Problem
LetsMeet is an online network for professionals and enthusiasts to meet up in real life with groups that share common interests.
LetsMeet has hired me on a temporary contract as a Data Analyst to support the growth LetsMeet has been experiencing in the past six months by providing insights into who LetsMeet members are and how they use the platform.
Tools used
MySQL
Tasks & Processes
Data Impressions
- Examining the Entity Relationship Diagram (ERD)
Ad Hoc Reporting
- DDL & DML SQL queries
Database Normalization
- Carrying out normalization
- Reverse engineering of the Entity Relationship Diagram (ERD)
Impact & Results
Wrote SQL scripts, and authored Ad Hoc reports and a summarized report that directly answered stakeholder questions.
Normalized the LetsMeet database, and developed a strategy to split tables to save storage space and time.
Improved the structure of a database and reverse-engineered the Entity Relationship Diagram (ERD).
Other Projects:
Listings123 - Exploratory Data Analysis & Presentation
Business Problem
Listings123 is an up-and-coming home-sharing service (similar to Airbnb). The company provides an online marketplace that connects people looking to rent their homes or rooms (hosts) with people who are looking for temporary accommodations (guests).
The CEO wants to expand to new cities but has a problem with raising money for the marketing campaign. The investors and VCs will not fund the campaign until they are presented with data-based evidence on what traits (qualities and actions) make a successful host specifically for Listings123.
Tools used
Google Sheets
Google Slides
Exploratory Data Analysis Process
The business problem was framed, Data Exploration was carried out, Data Wraggling was completed, Data Visualizations were created and Descriptive Statistics were examined. Based on the above, inferences and ultimately business insights were developed to solve the problem.
The process included summarizing data using Pivot Tables. Cleaning of inconsistent, invalid, duplicate, and missing data including the use of ISNUMBER/SEARCH, COUNT/COUNTIF/COUNTA/COUNTUNIQUE, and split text to columns functions. Using INDEX/MATCH formulas to merge tables. As well as using VLOOKUP to identify specific items in the tables.
Insights & Results
The top three traits identified that make a host successful for Listings123 are:
Strict - Cancellation Policy,
Listing an Entire Home/Apartment, and
Listing in cities with characteristics similar to those of San Francisco.
These data-based recommendations were provided to secure funding for the company’s nationwide marketing campaign.