Skip to content

orvpagadua/Jollibee-locations

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Jollibee-locations

An analysis of Jollibee Store Locator Data using PowerBi

Jollibee

Author: Orville Pagaduan

link to dashboard

Overview

Jollibee is a fast-food chain known for its signature Filipino-style fried chicken and other Filipino-inspired dishes. Founded in the Philippines in 1978, Jollibee has since expanded globally, with over 1,400 stores in various countries. The goal is to perform an EDA with the given dataset using PowerBI for visualization.

About the Dataset:

Data is scrapped from Jollibee store locator. Link to the dataset can be found here.

EDA and Vizualizations

MAPHeatmap

Heatmap of the Jollibee stores location from the given dataset

FranchisesFranchises

Out of the total Jollibee stores, Jollibee owns 161 of them (109 by Jollibee Foods Corp and 62 by Freemont Foods Corp) while 218 are owned by franchisees, which means franchised stores make up 57.2%.

Locations

Most Jollibee restaurants in the dataset are located in the National Capital Region, which includes Quezon City and Manila - the two biggest cities in the Philippines. City

State

MISC

Out of the 379 Jollibee locations in the dataset, a mere 17 of them serve breakfast, which accounts for only 4.5% of the total number. Additionally, a total of 167 Jollibee locations offer drive-through service, which makes up 44.1% of all Jollibees in the dataset. Interestingly, only three of the Jollibee locations, which is less than 1% of the total number, operate 24-hours a day.

24 hours Drive Thru Breakfast

Final Dashboard

Dashboard

Repository Structure

├── README.md                                     <- The top-level README for reviewers of this project
├── Jollibee Locations.pbix                       <- final report.
├── Jollibee.pdf                                  <- PDF version of project presentation
└── images                                        <- Both sourced externally and generated from PowerBI

About

An EDA using PowerBI.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published