This project dives deep into the Shopify App Store to uncover the secrets to app success. By analyzing data scraped from Shopify websites, we'll explore factors influencing app performance, from user reviews and developer responsiveness to app categories and overall landscape trends. Using Power BI, we'll visualize key metrics, identify patterns, and ultimately provide insights to help developers optimize their apps for the Shopify platform.
This project transforms raw event logs from an e-commerce website into meaningful business metrics. By analyzing user activity data, I built a conversion funnel to understand how effectively the website turns product views into purchases. Additionally, I conduct a cohort analysis to track user retention over time, providing insights into customer engagement and loyalty. Through advanced spreadsheet techniques in Google Sheets, I prepare and analyze the data, ultimately delivering a comprehensive report with actionable insights for the executive team.