This project required the analysis of one years worth of transactional data for in-hour dining at a pizza restaurant in New York. The main objective was to find operational opportunities to increase efficiency and drive more sales.
There was a general interest in busiest periods, peak sales, best/worst selling pizzas, order values and seating utilisation.
The overall concept was to provide a clean, direct report with actionable recommendations. This was in consideration of the end user, a restaurant owner, who may have limited interested in detailed analysis or complex visuals, but would rather "cut to the chase".
Therefore, it was quite purposeful in laying out some high level summary numbers, along with an indication of the recommendations to be made.
I split the report into three sections, focussing on seating utilisation, peak timing, and inventory usage.
In each section, I created a header to highlight the recommended action that could be taken to improve operations. Below this, I then used the technique of providing an introductory summary for each visual, then used the visual to reinforce the message, to create a balance between text and visual mediums.
There were a number of analytical techniques used in calculating ingredient usage and seating capacity, and I have created a separate tutorial in creating this on my Youtube channel.
I am in the process of creating a full walkthrough for this report, so watch this space!