CASE · DATA VIZ + PRODUCT UI · PIPELINEDEALS

Reporting that turned a wall of CRM data into answers.

As Lead UX Designer at PipelineDeals, I designed a reporting system for sales managers: three linked visualization modes — a regional map, stacked pipeline bars, and period-over-period comparison — sitting on top of a selectable, comparable deal table. One shell, one mental model, from big picture to individual deal.

Role
Lead UX Designer
Organization
PipelineDeals
Product
Reporting
Focus
Data Visualization · Table UI · Interaction Design
3 → 1
Three report types unified in a single reporting shell and mental model
Drill-down
Every chart is an entry point: map region, bar segment, or donut slice to deal table
8 trends
Positive / negative movement on key factors, scannable in one glance
Share + CSV
Reports travel: share to any PipelineDeals user or export the underlying data
S Situation

Sales managers had the data, but not the assessment.

PipelineDeals is a CRM built for small and mid-size sales teams. The pipeline data was all there — deals, owners, stages, territories — but reporting surfaced it as flat lists. A sales manager who asked “how is my team actually doing, and why?” had to reconstruct the answer by hand. Working from a sales-manager persona hierarchy, I mapped the gap between what managers needed for quantitative team assessment and what the product gave them.

Gap A
No quantitative read on the team

Managers wanted highly-valued reports with real data visualization — not row-by-row tables — to assess performance at a glance.

Gap B
No comparison over time

There was no way to hold the current quarter against a similar previous timeframe and see what moved, or which direction.

Gap C
Insight died in the app

Findings couldn't travel — no clean way to share a report with another PipelineDeals user or export the data to .csv for the rest of the business.

T Task

Design a reporting system a manager can trust for team assessment — and act on.

As lead designer I owned the concept end to end: translate the persona's requirements into an interaction model, design the visualizations and the table UI beneath them, and spec the whole thing so engineering could build it on an interactive charting stack (D3 / Angular). Five requirements anchored every screen:

Every chart is a question a manager already asks. Every click is the next question.

The interaction principle behind the reporting system
A Action

One shell, three lenses on the same pipeline, and a table that does the math.

I designed a persistent reporting shell — report picker, timeframe control, view switcher, share and save — so every report feels like the same tool. Inside it, three visualization modes answer the manager's questions at different altitudes. Each one keeps the same three-band anatomy: summary rail, visualization, trend strip, with the comparable deal table anchoring the bottom.

A

Where: revenue by region

  • Territory as the entry point. A choropleth of nine sales regions makes territory performance the first read; selecting a region drills into its deals — geography becomes a filter, not a label.
  • Summary rail. Total pipeline decomposed into wins, losses, and remaining deals — color-coded consistently across every report mode.
  • Trend strip. Per-region movement with sparklines and up/down deltas — the “positive/negative movement” requirement satisfied in a single scan line.
PipelineDeals reporting: revenue by region map with regional value legend, trend strip, and comparable deal table
Fig. 1 Revenue by region map, with view switcher to pivot the same data into donut or bar form.
B

Who & when: pipeline by stage

  • Stacked by salesperson. Stage totals segment per salesperson, so one chart answers both “where is the pipeline stuck?” and “whose deals are stuck there?” — the quantitative team assessment the persona asked for.
  • Time slider. A scrubber from account start to today replays the pipeline's shape over time — comparison as a direct manipulation, not a form field.
  • People-level trends. The trend strip pivots with the view: close rates per rep, revenue per salesperson, value per deal.
PipelineDeals reporting: stacked bar chart of pipeline deals per stage segmented per salesperson, with time slider
Fig. 2 Pipeline deals per stage, segmented per salesperson, with the time slider for replaying history.
C

Versus: compare deal closings

  • Side-by-side periods. Q1 2014 next to Q1 2015 as twin donuts — won / lost / pipeline share readable in the ring, exact percentages in the center. Slices drag out for drill-down.
  • Story points. The chart explains its own delta: 34 new deals, +12% revenue, 10 fewer days to close, 7 sales staff — the narrative a manager would otherwise write by hand.
  • Shown with its brief. This artifact carries the persona requirements at the top; the design and its evidence were presented together to stakeholders.
PipelineDeals reporting: side-by-side donut charts comparing Q1 2014 to Q1 2015 deal closings, with story points and design brief
Fig. 3 Compare deal closings, Q1 2014 vs Q1 2015, annotated with the sales-manager requirements it answers.
D

The floor: a table built for comparison

Under every visualization sits the same deal table — the qualitative half of the assessment. I designed it to be compared, not just read: checkbox selection per row, a “Compare selected” action, an inline sparkline of each deal's status trend, and a totals band that live-sums whatever is selected. Nine columns cover deal, owner, revenue, account size, and service tier, so the drill-down from any chart lands somewhere that can carry the full weight of the question. I spec’d the interaction model for D3 / Angular and documented a future track: predictive analysis with Monte Carlo simulation charts, and a report builder that recommends the right visualization for the comparison a user designs.

R Result

A reporting language the whole product could grow into.

Persona requirements met
5 / 5
Assessment, comparison, drill-down, directional signal, and share/export — every sales-manager requirement traceable to a screen element
System coherence
Data Viz pattern
Summary rail → visualization → trend strip → deal table, held constant across map, bar, and donut modes — learn one report, know them all
Buildable spec
D3 / Angular interaction model

Every chart interaction — region select, bar segment, slice drag, time scrub — spec’d against the charting stack engineering had committed to.

Table as product UI
Compare-first data table

Selection, live totals, and inline sparklines made the table an analysis surface rather than a data dump — a pattern reusable beyond reporting.

Forward roadmap
Predictive + guided viz

Monte Carlo simulation of pipeline trends, and a system that recommends the right chart for the comparison a user builds.

Why it mattered

Designing from a persona's questions rather than the database's schema gave PipelineDeals a reporting language — not just three reports. Any future report type could inherit the shell, the anatomy, and the drill-down contract, and feel instantly familiar to the manager using it.