Developing a Custom Business Intelligence Solution for Enterprise Challenges

Abstract

The study is focused on the development and implementation of a bespoke BI solution within the hospitality sector, specifically focusing on Shahrzad Restaurant in Jeddah. It addresses the critical need to transition from manual, intuition-based decision-making to data-driven decision-making. To achieve this, a solution was developed using a normalized database to centralize and unify the data, and Power BI was used to create interactive dashboards. The research prioritizes a dynamic analytical approach, utilizing DAX measures to track customer loyalty and "what-if" simulations to optimize labor costs and profit margins. Key operational metrics such as Menu Items Performance, Average Order Value (AOV) per server, and customer average visits and spending were calculated to provide actionable strategic insights. . Ultimately, the project illustrates how an integrated BI framework serves as a vital bridge between daily restaurant transactions and long-term organizational strategy.