Custom Business Analytics Platform

Custom Business Analytics Platform, Unified Merch Revenue Dashboard

Touring, ecommerce, and finance revenue now roll into one login-gated analytics platform. It unifies 5 income types across 3 source systems, refreshes touring and ecommerce data...

5 income types across 3 systems
Revenue streams unified
Every 30 minutes
Touring data refresh
Every 15 minutes
Ecommerce data refresh
15 with export
Drill-down ecommerce reports
MTD and YTD vs prior year
Executive comparison views
The problem

Touring sales, ecommerce sales, and retail/licensing/supply income lived in three different places. Answering 'how is this artist doing this month versus last year?' meant pulling from the live-show platform, logging into each storefront, and hand-stitching spreadsheet figures, repeated across ~20 bands. Reports were a manual chore and out of date as soon as they were assembled.

System designed

Defined a business analytics view that gives each stakeholder the revenue picture they need: touring performance, ecommerce performance, finance rollups, current-period comparisons, prior-year context, and top-artist visibility. The system turns scattered revenue sources into a shared operating view with scheduled refreshes and controlled access by role.

Outcome

Touring, ecommerce, and finance revenue now roll into one login-gated analytics platform. It unifies 5 income types across 3 source systems, refreshes touring and ecommerce data on scheduled cadences, provides 15 drill-down ecommerce reports with export, compares MTD and YTD performance against the prior year, and surfaces a top-5 artist revenue leaderboard.

Proof to show

Redacted business analytics dashboard and tour-report preview, showing cross-channel revenue in one view.