We take pride in delivering quality solutions...

Data Analytics

Construction and Program Management Firms Analytics Platform

What was the problem?

Our client is a construction and program management organization who helps multi-site retailers manage and track information required to stay on top of their capital construction projects.  Their clients are some of the largest multi-site retailers in the world.

How we helped?

The One Six Solutions team assisted our client with the data collection, integration and automation required to create visually rich and highly interactive dashboards.  This interactive data platform served as a differentiator in the market for our clients to their customers.  One Six Solutions worked with the organization’s executive leadership team to define requirements, create a standard set of KPI’s and build out the technology foundation to support our client’s multi-tenant data platform of the future.

What were some of the tools used?

The solution was built using Microsoft’s Power BI, leveraging Power Query and Power Pivot to build multiple external client facing dashboards and reports.  Development was done using Power BI Desktop and deployed to the Power BI service on PowerBI.com for end user consumption.  Data was sourced from multiple flat files, Excel and SQL Server to create a consolidated data discovery platform.

What were the results?

Our client was new to the Microsoft Analytics environment and needed One Six Solutions to provide architecture, development and design expertise in order to create a world class data visualization platform that could then be leveraged by their end customers.  The new Analytics platform allowed senior level managers and on-site construction management team members to have access to KPIs and detailed scoring data associated to their multi-site engagements.  Data driven decision making was now possible and easily shared across regional managers for each retailer.