Our client and its many vendors had useful case information siloed in separate production systems, making reporting difficult and analysis impossible. We designed and created a Data Warehouse that ingests and normalizes data from multiple sources and connected it to BI tools to produce interactive visualizations and dashboards. Now the client has instantaneous access to all of its data in a simplified format and can focus on analysis to increase its revenue.

Our client publishes industry reports that address issues of operational and strategic importance to industry members. Paste Group analyzed their data and developed statistical methods to allow them to produce data-driven insights and better serve their industry. The underlying data provided by our client was highly relational, fragmented, and of varying quality. We developed statistically sound methods to clean up the data and interpolate where data was missing. We made extensive use of prior research to identify additional independent variables for a multivariate regression analysis. We also brought together two disparate and previously unrelated datasets using geospatial/time-bound analysis.

Our client's mission is to reduce the toll of fire through prevention, preparedness, and response. Paste Group recognized that fire deaths rates shown in static and tabular displays were ineffective for analysis. Using data from both public data sources (e.g., Census, City/County data, ZIP code data, American Community Survey, and the client's own National Fire Incident Reporting System (NFIRS)) we created a web-based geographic decision tool that graphically displayed changes in fire death rates over time on an overlay on the US. As additional mortality data and demographic data becomes available, Paste Group incorporates it into the tool. Currently, program managers have access to 11 years of state-based deaths rates and 6 years of county-based death rates.

The Chief Architect of a Law Enforcement Agency turned to Paste Group to help them right-size their infrastructure and identify security vulnerabilities. Paste Group used IBM BigFix software to collect 2.2 million records detailing all of their computers. We developed an adjunct analysis and rules to cleanse the data. We developed an automated tool to segregate data, correct errors in names and formatting, and remove duplicates. We discovered that there were inconsistent deployments of the security software across the organization, and that many machines had out-of-date builds and lagging patch updates. We also analyzed application usage and determined that many machines and application were severely underutilized and that only 12% of users represented 80% of total application usage. We coupled our analysis with a cost model and determined that the client could save $275,000 per year.

The nation's leading emergency management agency responsible for collecting and reporting on fires in the United States turned to Paste Group to create an innovative data collection and data manipulation scheme to mine their database of first responder incidents. Paste Group analyzed the data and established causal relationships in the data. We developed a new methodology for creating incident estimates.  We also developed alternate solutions for issues that were identified during the estimation creation.

A national first responder agency turned to Paste Group to quantify the economic impact that firefighter injuries had on their departments, the insurance industry, and society. Paste Group integrated multiple data sources and methodologies to synthesize an approach suitable for the analysis of a broader more complex problems. We derived estimates using elements of other methods and calculated costs from original research as well. Paste Group' ground-breaking research was the first of its kind to relate injuries to financial cost.