Hi — I’m Seershika. I love turning data into decisions. My background mixes community outreach and analytics.
The projects show actionable insights from clean raw data, & interactive dashboards that make complex metrics easy to explore.
Data Analyst skilled in Tableau, Power BI, Excel, and SQL LinkedIN.
Compared product return behavior by exploring patterns within 10,000+ data logs, such as return rates shifting over time, varying geographically, and responding to shipping methods and promotional cycles. A lagged relationship between sales and returns also emerges, offering insight into post-purchase dynamics.
Analyzed 4,845+ e-commerce event logs to build a 3-stage conversion funnel and cohort retention analysis, identifying three primary bottlenecks: low traffic to product pages, weak on-page engagement, and high checkout abandonment. Tracked retention for 6 monthly cohorts across 4 months, and to improve engagement and conversion.
Cleaned raw data and built pivot tables to analyze Manhattan short‑term rental performance across 2,400+ calendar records and 30-day booking listings to rank neighborhoods and unit types by demand and revenue potential.
SQL analysis of over 85,000 rows of global COVID-19 data to uncover patterns in cases, deaths, and vaccinations across countries and continents. Delivered insights suitable for public health reporting and executive summaries.
Transformed 4,800+ superstore records to build a profit‑aware Tableau Story to identify 3 high‑ROI state/month ad windows, uncover profit/loss centers, and recommend targeted ad reallocations and product actions for measurable profit recovery.
Sacramento, California