Skip to content
Edison YuzonAI Developer
All work
04Data & BI

Business Analytics & Reporting Systems

Attribution, margin and operational reporting built on top of live business data, plus success metrics locked in SQL.

Context
Built inside the operations portal and a product experiment
Role
Sole developer
Year
2026
Status
In production
reports / attribution

Booked sales · last 12 months

Ad-influenced vs organic

AdsOrganicUntagged

Ad-influenced

52%

Organic

41%

Untagged

7%

Pre-order margin

31.4%

Quoted cost₱61,200
Actual cost₱59,850
Variance−₱1,350

Data quality

9 orders still untagged this month

Mockup with sample data. Client screens and figures are withheld.

The problem

Management couldn't see which sales came from advertising, what each pre-order actually earned, or what needed attention across branches without asking someone to compile it by hand.

The solution

Reporting that sits on the same live data staff already enter, so the numbers are never a separate spreadsheet to maintain.

  • Ad attribution report

    Ad-influenced, organic and untagged sales with share of revenue, per-channel breakdown, a 12-month stacked trend, and a nudge counting orders nobody tagged.

  • Margin tracking

    Per-item cost from two USD supply streams plus itemized fees, giving profit and margin, and quoted-versus-actual variance once real costs arrive.

  • Operational dashboard

    Live summary strips for open and overdue repairs, layaways due and incoming branch transfers, each deep-linking to the filtered list.

  • Supplier data processing

    Three suppliers' differently formatted Excel exports normalized by a header-matching parser, filtered by grading rules and priced in bulk.

  • Metrics that can't be bent

    For a product experiment, activation and carry-over go/no-go metrics are defined in SQL before launch, so the denominator can't be redefined after the fact.

My responsibilities

  • Metric definitions with management
  • SQL aggregation and report queries
  • Report UI and dashboard widgets with role-gated access
  • Data ingestion and normalization pipelines

Results

  • ✓Attribution, margin and operational reporting in daily use alongside the operations portal
  • ✓Go/no-go product metrics frozen in SQL ahead of launch

Next case study

Retail Service Operations Portal

View Case Study