Advaiya Solutions Inc. - Restaurant Retail Distribution Analysis

Dashboards are consolidating data from different stores and restaurant locations to summarize and analyze the sales across all the units. Easily measure key KPIs like sales per day, average check-ins versus sales and guest count by location to make impactful marketing decisions to boost profit.

파트너에 문의 비디오 보기

A major restaurant chain was managing data of its restaurants from different locations. Restaurants generate large amount of data daily, so it was a tedious task to fetch and analyze the data to enable the owner to see trends. The challenge was to first consolidate data from all the locations into a single place and then measure key KPIs like: 

  1. Sales and guest count for different locations
  2. Daily sales and average check amount for different locations
  3. Item comparison by day, item, and location
We developed a Power BI solution by extracting data from APIs and feeding them into Power BI for the analysis. Our solution summarized statistics on how all stores and restaurants were performing in sales, guest visits, and several other attributes.

After taking data from their APIs, we designed a hybrid Microsoft Azure-based database which consolidated all of their data, then imported all the data into Power BI desktop to create reports.

The analysis of Sales and Guest count by location uses a combination chart for each hour and can be filtered using a slicer at the top.  Power BI's bookmarking and buttons features allow easy navigation BACK to the previous page and the NEXT page, and a RESET button can be used to clear all filters applied to the tab.

Owners see a more granular view with the Total Sales by Weekday of Locations chart, and the overall status of lunch and dinner revenues, the values of Guest count and Total Sales are displayed using rotating tiles.

Top Selling items can be filtered using a slicer to measure which food item is providing the most revenue. which also shows lunch and dinner average check amount with just a click.

Finally, there is an analysis of Pizza and Burger orders.  The  column chart shows the percentage of Total Sales of Pizza v/s Burger in Dinner by each location.   The Tornado chart compares the percentage of Total Sales of Pizza v/s Burger in Lunch by location.  The Sankey chart displays  the distribution of sales for lunch and dinner from every location.

Power BI 파트너가 되고 싶으세요?

인증 파트너는 팀의 중요한 부분입니다. 새로운 비즈니스 기회를 찾고, 연결하고, 전 세계 Power BI 사용자와 귀사의 재능과 경험을 공유하세요.

등록

파트너가 되어야 하는 이유에 대해 알아보세요.