Year-Over-Year Growth Analysis of Restaurant Sales Patterns and Visualization

Factors in the success of a fast food franchise involve products and marketing targeted at brand consistency, low start-up costs, franchise support, and consumer convenience (Aquino, 2023). Sales fluctuations of a restaurant depend on operational strategies and location characteristics, resulting in business failure. This study explored the sales pattern of Kenny Rogers over eight years and focused on the seasonal shift in the Trece Martires branch's financial direction. The methods applied the Microsoft Power BI Data Visualization, such as Year-Over-Year and Seasonal Analysis, to recognize patterns and contrast trends in separate years. The revenue increases every December due to consumer spending and drops every January after the holiday season. It rose yearly in three years since its first establishment and experienced a 54.93% sales drop in 2020. The profit recovered after a year and multiplied the yearly growth to 134.10% in 2022, while the sales pattern moved slowly until 2024. The researchers suggested upgrading the marketing strategy every first quarter of the year and adapting the holiday season advertising.