Case Study

CPG Enterprise Successfully Implements Power BI Premium and Improves Reporting

The Customer’s Challenge

A major CPG company was looking to invest deeper into Power BI Premium and improve its reporting capabilities but needed some help setting up the infrastructure to support all of its enterprise reporting needs. Additionally, they needed help seamlessly integrating Power BI with their Snowflake Data Cloud environment so that viewers of their dashboards could leverage single sign-on (SSO).

phData’s Solution

phData worked closely with the client to implement Power BI Desktop and Power BI Service across four critical business groups spanning two continents. Equipped with a more robust Power BI Premium Capacity, the client now can view business-critical dashboards and build their own ad hoc reporting.

The Full Story

As one of the largest food and beverage companies in the world, the client relied heavily on accurate reporting to make data-driven decisions for its eight ($1 billion+) brands. 

Historically, they were using Power BI Pro licenses for development and sharing content, a method that does not scale as efficiently and is not as cost-effective as leveraging Premium Capacity. 

Because the client is a global organization, they have several business groups that require their own Power BI Premium Capacity and need assistance setting up the infrastructure within Power BI to support all of their reporting needs. 

In addition to setting up the Premium Capacity, another challenge was seamlessly integrating with their Snowflake environment so that viewers of the dashboards could leverage single sign-on (SSO).

Why phData?

phData was chosen for this project due to our expertise in both Power BI from a development and administrative perspective as well as our deep institutional knowledge of Snowflake.

Selecting the right SKU for Power BI Premium

After advising the client to utilize Power BI Premium (Gen2) over Azure Analysis Services, phData began by assisting in selecting the appropriate SKU for their Power BI Premium Capacity. 

Different SKUs allow for different levels of storage capacities, therefore selecting the right SKU for the use case after holding capacity planning sessions with the business groups was a critical step. 

Since Azure SSO for Snowflake was a requirement, hosting Power BI Gateways on virtual machines (VMs) is necessary. phData made recommendations for the correct size VMs that could handle the workload. 

After the VMs were selected and gateways installed, phData deployed a Power BI workspace architecture strategy to three business groups that allow their developers and admins to seamlessly develop Power BI content while offering self-service capabilities to end users. 

Self-service in this context refers to the ability for users to use the dashboards pertinent to them and access the underlying data to those dashboards. To manage the promotion of content through a standard development lifecycle, phData built Power BI Deployment Pipelines. 

Finally, phData held enablement sessions on Power BI development and management best practices to ensure the client team was self-sufficient. 

Results

The client now has a Power BI Premium Capacity for four strategic business groups with dozens of developers and several hundred end users. Users not only can view business-critical dashboards but can also access the underlying dataset when building their own ad hoc reporting. 

In addition to this, comprehensive guides were provided so that the processes performed could be replicated for other groups throughout the organization. Before the project finished, open office hours and enablement sessions were held for developers to get fully up to speed on how to appropriately and most efficiently leverage Power BI.

A diagram titled, "Power BI Premium Capacity" that shows the work phData did for the customer

Take the next step
with phData.

Learn how phData can help you succeed with Power BI today!

Data Coach is our premium analytics training program with one-on-one coaching from renowned experts.

Accelerate and automate your data projects with the phData Toolkit