Decision-makers needed a clearer way to trend KPI performance.
Brasfield & Gorrie wanted a graphical visualization to help decision-makers analyze key performance indicators across categories.
The team needed a Band Scatter Chart that could display KPI values by category, show high, mid, and low value ranges, and support trend analysis across multiple data sources.
The business problem was not simply, “Can we create a chart?”
It was: How do we give construction leaders a faster, clearer way to compare KPI performance across categories and data sources without manually querying disconnected information?
Brasfield & Gorrie did not need another static report. They needed a visual analytics tool that helped leaders understand KPI movement, compare performance bands, and make faster decisions.
Construction leaders need fast visibility into performance trends.
For a large construction company, KPI visibility helps leaders understand what is changing, where performance is strong, and where attention may be needed.
When information lives across multiple data sources, analysis can slow down. Decision-makers need a way to see trends and comparisons quickly without waiting on manual queries or separate reports.
A custom Power BI visualization gave Brasfield & Gorrie a more useful way to turn performance data into decision support.
A custom Band Scatter Chart built on Power BI and TypeScript
KEYSYS extended the functionality of an existing Microsoft Power BI Scatter Chart by adding requested KPI value ranges for trending multiple data sources in one aggregate view.
The Band Scatter Chart highlights data categories to show high, mid, and low values for comparison. It also displays various metrics specific to each record, giving decision-makers a richer visual context for analysis.
The technical stack included Power BI and TypeScript.
Instead of forcing leaders to compare scattered reports or query separate data sets manually, KEYSYS helped create a custom visualization that brought KPI trends into one interactive view.
- → Custom Power BI visual extension
- → Band Scatter Chart for KPI trend analysis
- → TypeScript-based visualization development
- → KPI values displayed by category
- → High, mid, and low value bands for comparison
- → Multiple data sources represented in one aggregate view
- → Record-specific metrics displayed for deeper analysis
- → Reduced time spent querying disparate data sets
From disparate KPI data to one visual decision-making view
The visualization supports multiple data sources in one Power BI view.
Data points are organized by category so decision-makers can compare performance more clearly.
High, mid, and low value ranges make it easier to understand where each record sits.
Leaders can evaluate KPI movement and record-specific metrics without manually querying separate data sets.
What once required more manual comparison across data sets now appears in one custom Power BI visualization built for faster KPI analysis.
Brasfield & Gorrie gained clearer KPI visibility for decision-making
The custom Band Scatter Chart helped Brasfield & Gorrie visualize KPI values by category, compare performance bands, and trend multiple data sources in a single aggregate view.
The result was a more efficient way for decision-makers to analyze performance and reduce the time spent querying disparate sets of data.
- Multiple data sources can be reviewed in one aggregate visual
- Decision-makers spend less time querying separate data sets
- High, mid, and low bands provide immediate visual context
- Categories help leaders compare KPI values more easily
- Record-specific metrics add depth to the visualization
- Trend analysis becomes easier to interpret and act on
- Decision-makers needed better KPI trend visibility
- Multiple data sources required separate queries or manual comparison
- Existing scatter chart functionality did not include requested value bands
- High, mid, and low ranges were harder to compare visually
- Record-specific metrics needed clearer presentation
- KEYSYS extended a Microsoft Power BI Scatter Chart
- KPI value ranges were added for trend analysis
- High, mid, and low categories are highlighted visually
- Multiple data sources appear in one aggregate view
- Decision-makers can analyze KPI trends faster and more clearly