Portfolio

Build + Assemble

A store manager should be able to answer a normal question without SQL - and without us.

I built custom BI for the team. It answers the easy questions, so managers keep their time for the ones that matter.

Build a view

Question

Answer

Explore / Build
Date
Last 30d
Compare
unsaved

Chart

Sort & rank
Color
Shape
Labels & numbers
Axes & gridlines

Save it once, then add it to a report in Assemble.

Inherits the dashboard scope unless you lock it, and opens for the next person exactly where you left it.

Explore / Assemble
Dashboard slicers Date: Last 30d Location: all stores + Add slicer

Buying BI would have given us charts. That was not the hard part.

Employees actively using the BI tools their company already bought

BARC and Eckerson Group, 2022. Survey of 214 data and analytics leaders.

A rule change ships the same afternoon.

A wrong rule is one change, live that afternoon. Bought, you write to another company, wait in their queue, then wait again for whatever release they put it in.

No per-seat cost, so everyone gets a seat.

Everyone who is measured on a number can open the view that makes it. No license to request, no analyst to wait for.

It refuses the question before it becomes a wrong answer.

Drag a ratio into a place that would make the math lie and the shelf will not take it. Average units per transaction across the stores and you get 2.6; the right answer is 2.3. Exports carry the raw numbers, so a spreadsheet cannot average an average either.