Data that helps youmake better decisions

Practical ways to understand sales, customer behavior, and weekly team performance using Power BI, Python, and Google Sheets.

Dashboards use synthetic data. Customer analysis uses a public historical retail dataset.

Customer analysis adapted from Online Retail II, Daqing Chen (2012), UCI Machine Learning Repository, CC BY 4.0. Transformed into segmentation and cohort visualizations.

Sales & Inventory Intelligence

Power BI dashboard with sales KPIs, margins and store performance.
Power BI dashboard with sales KPIs, margins and store performance.

Problem

Sales and stock are often reviewed in separate reports.

System

This Power BI dashboard shows sales, margins, and inventory together so teams can spot items that need attention.

  1. Net sales, margin and order value at a glance.
  2. Net sales by month, latest month highlighted.
  3. Category performance in one table.
Power BI inventory dashboard with stock measures and product performance.
Power BI inventory dashboard with stock measures and product performance.

Close-up

Net sales by month, each bar with its value; the latest month in green.
The stock position in one sentence, with the five figures behind it.

Output

A two-page Power BI report, commercial performance and inventory, each with month, store and category filters.

Customer Segmentation & Retention

Python RFM customer segmentation chart.
Python RFM customer segmentation chart.

Problem

Transaction records do not immediately show which customers come back.

System

Python groups customers by purchase habits and tracks repeat buying in historical data.

  1. Customer groups ranked by share of purchase value.
  2. Groups based on when, how often and how much customers bought.
Python cohort analysis of returning customers.
Python cohort analysis of returning customers.
Python analysis charts showing customer purchase behavior.
Python analysis charts showing customer purchase behavior.

Close-up

The first six monthly cohorts: the share of new buyers who came back in the next three months.
The last 400 days: each dot is a customer, by days since purchase and purchase value.

Output

A Python analysis that segments customers and tracks repeat purchases in historical data.

Operations KPI & Weekly Reporting

Google Sheets weekly operations KPI dashboard.
Google Sheets weekly operations KPI dashboard.

Problem

Weekly work updates can be scattered across teams.

System

This Google Sheets dashboard brings delivery, backlog, and follow-up actions into one view.

  1. The week’s status, written as a sentence.
  2. On-time delivery against the 90% goal.
  3. Work clearance: closed against received.
Google Sheets team review, backlog and action log.
Google Sheets team review, backlog and action log.

Close-up

Which team needs attention, with a named follow-up.
Weekly volume: received against completed.

Output

A weekly Google Sheets review: delivery, backlog and follow-up actions in one view.

Need a clearer view of your numbers?