Recently, we helped a leasing client streamline their information and drastically decrease processing time so they could make more informed decisions faster. Our client was capturing data through ERP, CRM, and ancillary systems but was using separate spreadsheets to manage the information from each. Data gathering was time consuming and created only for one purpose and then discarded. This was a systemic problem within all departments of the organization.
We helped the client systemize their data by ensuring the proper sets of data were being collected, extracted, transformed, and loaded into a data warehouse. We then worked with each department to create a series of analytics and visualizations that could be designed, built, and supported on an ongoing basis. The analytics were generally operational in nature and the visualizations for the executives fulfilled strategic objectives.