scribus01/e-commerce-conversion-funnel-analysis-powerbi-sql

This repository is a data analytics project that studies how online shoppers move through the buying process, from first visiting a website to completing a purchase. The goal is to track each stage of that journey, sometimes called a conversion funnel, and figure out where customers drop off or move forward. The project uses SQL to pull and analyze data about user sessions and events, and Power BI to turn that analysis into an interactive dashboard. The data itself covers user interaction events with fields like user ID, session ID, event type, product category, device type, traffic source, and the time of each event. The dashboard includes KPI cards showing totals for users, sessions, visitors, product viewers, cart users, purchasers, and the overall conversion rate. It also includes charts covering the conversion funnel itself, how users break down by device type (mobile, desktop, tablet), which traffic sources bring in visitors, which product categories get the most attention, how user activity changes over time, and how conversion rates differ by traffic source. Filters let a viewer narrow the dashboard by device type, traffic source, product category, or date. According to the README, the project surfaces insights such as which traffic sources convert best, how behavior differs across device types, and how different product categories perform. The stated business value is helping a company improve conversion rates, understand customer behavior, optimize marketing spend, and make decisions based on data rather than guesswork. The repository includes a Power BI dashboard file, a SQL script for the funnel analysis, a CSV dataset, and preview images of the dashboard. This looks like a portfolio style project meant to demonstrate data analysis and business intelligence skills using real world e-commerce style data, rather than a piece of software you would install and run.