Pizza Hut removes all barriers from business users who want Power BI and AI directly on Snowflake

Pizza Hut storefront

PROBLEM

Pizza Hut business users want to use Excel and Power BI on Snowflake

  • Customers want Power BI and Excel for ad-hoc analysis
  • Retail metrics must compute on Snowflake due to their complexity and data size
  • Power BI Direct Connection is limited, slow and unreliable

Microsoft Fabric is a costly silo

Moving data to Fabric to improve Power BI led to data duplication, added storage and compute costs, duplicate data engineering efforts, inconsistency of metrics and a high latency to data.

SOLUTION

Connect Power BI and Excel to Snowflake with a universal semantic layer native to Snowflake:

  • Business users have granular access to any data they need.
    Slice and dice 10+ years of data at any level using >100 standardized metrics.
  • Unified metrics in any self-service tool. Every metric from Snowflake is governed and consistent
  • No data duplication.
    Snowflake serves as the single source of truth for all enterprise data, without copies or additional data pipelines.

Results:

  • 50%faster development of reports and business insights
  • 30%reduction in costs and engineering effort by eliminating silos and duplicated pipelines
  • 4hours, saved daily in ETL, ensuring data availability at 6am for every user
  • AI-readyunified metrics across every tools, enabling to reliably add Cortex on the data

Pizza Hut democratizes BI and AI with a universal semantic layer native to Snowflake