scribus01/e-commerce-conversion-funnel-analysis-powerbi-sql — explained in plain English
Analysis updated 2026-05-18
Explore how users move through an e-commerce buying funnel
Compare conversion rates across traffic sources and device types
Use the SQL script as a template for your own funnel analysis
Study the Power BI file as an example of interactive KPI reporting
| scribus01/e-commerce-conversion-funnel-analysis-powerbi-sql | 00kaku/gallery-slider-block | 04amanrajj/netwatch | |
|---|---|---|---|
| Stars | 0 | — | 0 |
| Language | — | JavaScript | Rust |
| Last pushed | — | 2021-05-19 | — |
| Maintenance | — | Dormant | — |
| Setup difficulty | easy | easy | moderate |
| Complexity | 2/5 | 2/5 | 3/5 |
| Audience | data | general | ops devops |
Figures from each repo's GitHub metadata at analysis time.
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.
A portfolio project analyzing an e-commerce buying funnel with SQL queries and an interactive Power BI dashboard.
Setup difficulty is rated easy, with roughly 30min to a first successful run.
Mainly data.
This repo across BitVibe Labs
Verify against the repo before relying on details.