Executive Overview

Revenue, profitability and service level across the global network

— orders Static data

Monthly revenue & gross profit

USD

Revenue by region

USD · click a bar to filter

Revenue by product category

USD · click a bar to filter

Customer segment mix

share of revenue · click to filter

Revenue heatmap: region × category

USD · darker = more revenue · click a cell to drill in

On-time delivery by carrier

% of delivered orders · target 90%

Promised vs actual lead time by ship mode

days

On-time delivery trend

% per month

Freight cost as % of revenue

%

Warehouse performance

click a row to filter by warehouse

Top 10 products by revenue

USD

Gross margin by category

% of revenue

Top customers

ranked by revenue

Orders

Automated insights

Generated from the filtered data.

Looker Studio report

live, interactive BI report on the same dataset

Built in Google Looker Studio (now called Data Studio) from data/looker_sales.csv, which a Google Sheet pulls live from this GitHub repo. It includes a Google Maps bubble map of revenue by country, KPI scorecards with sparklines, a category donut, a monthly trend, on-time % by carrier and a warehouse heatmap table. Use its date, region, carrier and category controls, or click any chart to cross-filter.

Power BI kit

for Power BI Desktop

The repo's powerbi/ folder holds a star-schema model (FactSales + 5 dimensions), DAX measures that match this portal's KPIs, a matching theme and a step-by-step build guide. Power BI's Publish to web needs a work or school account, so the live embed above uses Looker Studio instead.