Tableau

In this project, I generated insights specifically tailored for a web team within a prominent political advocacy organization. The queries cover various aspects such as user engagement, revenue analysis, and page views over time. Additionally, I designed visualizations in Tableau and provided recommendations based on my findings. Exploratory Data Analysis (EDA) Summary This section outlines the steps taken to explore and analyze web analytics data using SQL queries. The analysis provides insights into user engagement, popular pages, device segmentation, and referral sources....

Context From 2020 to 2021, I volunteered at the COVID Tracking Project, where our efforts significantly enhanced the accuracy of data collection in the USA. By auditing, compiling, and analyzing sub-national, daily data sources, we delivered accurate, real-time insights to government officials. Our team built over 50 collaborative datasets and corrected inconsistencies in more than 40,000 data points, informing life-saving national testing and immunization strategies to combat COVID-19. Dashboard This dashboard, inspired by Alex the Analyst, exemplifies the impact of our work in providing reliable data that informed public health decisions worldwide, playing a crucial role in creating transparent and globally accessible COVID-19 statistics....

Cohort tables offer valuable insights into customer behavior by grouping them based on shared attributes, in this case, acquisition date or date of first purchase. They are fantastic for identifying whether you have a retention problem or a user acquisition problem and can allow marketers to understand user behavior through experiments. Learning to read these tables can be tricky at first but effectively empowers you to analyze customer engagement, retention, and acquisition trends....

King County, WA Housing Insights Line Chart: The line chart displays daily prices from May 1, 2014, to May 1, 2015, illustrating a general upward trend over the year with some fluctuations. Housing prices rise from an average of $0.5M to $1M by November 2014, peaking at $1.3M in May 2015. The zip codes with the highest average price, ranging from $0.9M to $1M, include 98109, 98105, 98004, and 98040....