All work
01 / BUSINESS INTELLIGENCE

The story behind the shopping cart.

From raw retail transactions to a clearer view of customers, subscriptions, and purchase behavior.

Customer Behavior Dashboard showing customer count, average purchase amount, review rating, subscriptions, and sales by category and age group.
3,900purchase records
18original fields
37ratings imputed
01 / THE QUESTION

What makes a customer come back?

Purchase records contain plenty of activity, but the useful questions are about behavior: who returns, what they value, and how subscriptions and discounts relate to spending.

Connect customer demographics, purchase history, and product information in an analysis that supports practical marketing and retention decisions.

02 / THE APPROACH
01

Make the data dependable

Inspected 3,900 purchases across 18 fields. Imputed 37 missing review ratings with each product category’s median, standardized column names, and checked redundant promotion fields.

02

Ask business questions in SQL

Loaded the prepared data into SQL Server using Python and pyodbc. Used aggregate queries, CTEs, and window functions to compare shipping types, subscription status, revenue by age group, highly rated products, and New, Returning, and Loyal customer segments.

03

Build a readable decision surface

Created an interactive Power BI dashboard with customer, spending, review, and product-category views, then translated the analysis into recommendations for loyalty, subscriptions, discount policy, and product positioning.

EXPLORE THE ANALYTICAL LENSES
27%subscribers in the project dashboard

Who subscribes—and who might?

The dashboard records 27% subscribers and 73% non-subscribers. The analysis compared spending and repeat purchases across those groups, then proposed clearer subscription benefits.

Subscription status is an observed attribute. This comparison does not prove that subscribing causes loyalty.
Original Customer Behavior Dashboard showing 3.9K customers, 59.76 dollars average purchase, 3.75 average rating, and a 27 percent subscriber share.
Original Power BI dashboard from the supplied project screenshot. Filters cover subscription status, gender, product category, and shipping type.
03 / THE OUTCOME

What the work delivers.

A complete Python-to-SQL-to-Power BI workflow, with a documented report and recommendations that connect customer behavior to business decisions.

THE TAKEAWAY

A useful dashboard starts with well-defined business questions and reliable fields. Category-level imputation retained the purchase records while accounting for differences in product ratings.

Project scopeThis is an analytical portfolio project. Recommendations were proposed; revenue growth or retention improvements were not measured. Associations do not establish causation.

KEEP EXPLORING

Customer Churn Prediction