Semantic Layer Data Modeling for a Beverage Company

Adding a semantic layer to a data model provides a unified and consolidated view of a company’s overall data.

Category: Data Science


The client is a large-scale retailer and distributer in the beverages industry based in mid west USA. It operates in multiple cities and supplies different beverages to multiple major retail outlets


Client had a set of reports and dashboards which were created on demand for its management and contain all important KPIs. But whenever there was a need for new report or a new metric which even though was essentially on same data source as the present reports- it was a big effort and getting the report in hands of management would become a week’s job. They needed something faster.

It was also needed that same report when seen by zonal management person should only reflect data from their zones and global managers must be able to see all data across the zones. The reports even when shared with others must not show data to user which they did not have access on.

Solution-Semantic Layer Data Modeling

Contata understood their problem and created a Semantic Layer Data Modeling on their existing reports data model and enabled question and answer feature on the power bi reports and dashboards.


  • 80% backlog cleared-about 80% backlog of pending report demands from management was cleared within hours of going live. This is more than 1 year worth of report development work.
  • 245% increase-Increase in user engagement on the Q&A reports compared to all older reports.


Interested to know more? Get in touch!