Cleaning, Manipulating, Analyzing and Visualizing Data with SQL, Excel, & Tableau
Investing in Health: IDA and COVID-19
SQL: Data Cleansing | Common Table Expressions | CASE Statements | Subqueries | Window Functions
Investigated IDA World Bank loans using SQL to gain insights into their pandemic response using a pre-post analysis.
Sushi and Ramen and Curry, Oh My!
SQL: Common Table Expressions | Group By Aggregates | Window Functions | Ranking | Table Joins
Built SQL queries to give insights into customer patterns, spending, and favorites for a better, more personalized customer experience.
The Most Powerful Weapon
Tableau: Parameters | Charts | KPIs | Dashboard
Created a Tableau dashboard for the superintendent, delivering insights about student success.
So Who’s Dining on Delivery?
Google Sheets: Data Cleaning | Filters | Functions | Formulas | Pivot Tables | Data Visualization | VLOOKUP
Found business opportunities and proposed actions to optimize campaigns for the Brazilian equivalent of DoorDash using Google Sheets.
Unraveling the Top 50 Yarns of 2022
Google Sheets: Data Collection | Data Cleaning | Filters | VLOOKUP | Nested IF Statements | Pivot Tables | Data Visualization
Created a slide deck delivering insights from the top 50 Ravelry project yarns. The data was collected, cleaned, and visualized in Google Sheets.