Global events and services provider discovers valuable financial insights

Companies who do not have a solid grasp on their fiscal place within the market are susceptible to a cash-flow squeeze at the most inopportune times.


Financial health and awareness are fundamental.
It enables organizations to behave relative to their current monetary standing and focus on future growth with a more practical eye. Companies that do not have a solid grasp on their fiscal place within the market are susceptible to a cash-flow squeeze at the most inopportune times.
Our client, a global events and services provider, wanted to understand their current financial position within the industry through the use of business intelligence and advanced analytics. The goal of upper management was to capture key accounting insights, improve their budgeting estimations, and strengthen their decision-making process for future event projects.
With this objective in mind, OneSix was able to offer an array of analytical expertise and build a series of interactive and informative reports that met all management’s goals.


events provider

Our solution

Create visually appealing and actionable reports

Prior to architecting a process for building structured reports, our client had difficulty analyzing and understanding their financial data across their global events and clientele. The goal was to design a methodical and repeatable process for creating reports in Power BI using relational data from SQL Server. Once implemented, developers would be able to build, publish, and share reports across departments and offices using near real-time data from their data warehouse.

The OneSix team was crucial in every phase of the project. The team worked closely with the lead data architect to model source data and transform the tables to support working reports inside Power BI. After the data had been conditioned for reporting and analysis, OneSix designed user templates and built the initial in-depth financial report for all incoming events and orders.

The reporting platform tracked key financial metrics, and standard KPIs, and recorded performance levels across multiple lines of business. On top of the platform, the team built filters using complex DAX formulas to slice numerical data by date, location, venue, and account executive. Power BI Desktop and Service provided the user-friendly data visualizations, reports, and dashboard capabilities needed to reveal and share analytics insights with key decision-makers and other business users.

Technologies implemented


Thanks to the newly created reporting platform, our client can now analyze event profitability across multiple locations and refocus their efforts on more fiscally rewarding endeavors.
The company has begun to look at its strengths and concentrate its efforts on events with higher returns and increased profits.

My experience was fantastic with OneSix. They listen to your query carefully and then are able to solve your issues within the correct time frame and reasonable price. Super knowledgeable team!

Ayush J.
SEP 28 2022

One of my favorite things about One Six is their willingness to work with us on whatever we need. Early on in the project, we determined we needed an additional tactical resource instead of an advisory one, and One Six happily switched out resources for us, ensuring we had what we needed to complete the project.

Pamela E.
NOV 8 2021

They dig in and help understand the problem, how to think about it, provide the best technical options of how to solve it, then execute as quickly as possible. This is by far the best way to help me make sure we're successful, and that I know what's being done and how to support it once they're finished.

Brandon H.
OCT 20 2020

Transform your data org

Schedule a free consultation with the team.