Advertising & Design

Modern BI

Analytics Create Transparency for Flourishing Design Firm

When a leader in interactive exhibits decided a few years back that it needed an accurate way to gauge costs and revenue throughout the lifecycle of its often complex projects, it approached BlueGranite to help map a course.

This North American-based events specialist creates multimillion dollar displays and interactive customer experiences for some of the world’s biggest companies. The company is also a retail merchandising authority.


But the flourishing design firm struggled with dated project management procedures. Ensuring that commissions are on time and on budget are essential to this company’s success. Project managers had different methods of determining whether a job was meeting those goals. These inconsistencies made accurate revenue projections difficult.

When leaders here decided they wanted to streamline the oversight, they asked BlueGranite to help design and implement a plan. Executives and project managers wanted to know where they were at financially during each stage of a project, and what they could recognize as revenue.

We collaborated with stakeholders, helping create and define standard calculation methods. We used those methods combined with project information and Microsoft business intelligence (BI) software to overcome deficiencies in the company’s unique existing enterprise resource planning system and create a comprehensive overview of projects and revenue at all stages of the process.

In addition to creating transparency around the production process, the BI solution allows easy financial conclusions for an accounting department that once had to spend anywhere from hours to days creating monthly and quarterly closing statements.

As the company’s solution has matured, so has our relationship. The initial, successful BI collaboration has since evolved into a strong, multiyear advisory relationship. Because the company’s lean but stellar IT staff already has a lot on its plate, and its expertise lies elsewhere, BlueGranite now provides its comprehensive Center of Excellence services to support the exhibit manufacturer’s evolving BI needs.

We’d love to help your organization extract value from its data. Contact us today to discuss the many ways we can help.