{"id":205,"date":"2018-02-15T15:07:41","date_gmt":"2018-02-15T15:07:41","guid":{"rendered":"http:\/\/eipsoftware.com\/musings\/?p=205"},"modified":"2024-04-14T15:57:06","modified_gmt":"2024-04-14T15:57:06","slug":"blazin-burger-business-performance-metrics","status":"publish","type":"post","link":"https:\/\/eipsoftware.com\/musings\/blazin-burger-business-performance-metrics\/","title":{"rendered":"Blazin&#8217; Burger Business Performance Metrics"},"content":{"rendered":"<h3>Blazin&#8217; Burger Business Performance Metrics<\/h3>\n<p>Over the last year, the three New York locations of fast-food restaurant Blazin\u2019 Burger have<br \/>\nproduced mixed financial results.<\/p>\n<p>Below is a presentation-ready dashboard that will show<\/p>\n<ul>\n<li>KPI&#8217;s that show performance data from each location<\/li>\n<li>External data from NYC board of health<\/li>\n<\/ul>\n<p>Below are dashboards created using <a href=\"https:\/\/www.microstrategy.com\">MicroStrategy<\/a>.<\/p>\n\n\t\t<style type=\"text\/css\">\n\t\t\t#gallery-1 {\n\t\t\t\tmargin: auto;\n\t\t\t}\n\t\t\t#gallery-1 .gallery-item {\n\t\t\t\tfloat: left;\n\t\t\t\tmargin-top: 10px;\n\t\t\t\ttext-align: center;\n\t\t\t\twidth: 33%;\n\t\t\t}\n\t\t\t#gallery-1 img {\n\t\t\t\tborder: 2px solid #cfcfcf;\n\t\t\t}\n\t\t\t#gallery-1 .gallery-caption {\n\t\t\t\tmargin-left: 0;\n\t\t\t}\n\t\t\t\/* see gallery_shortcode() in wp-includes\/media.php *\/\n\t\t<\/style>\n\t\t<div id='gallery-1' class='gallery galleryid-205 gallery-columns-3 gallery-size-thumbnail'><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/eipsoftware.com\/musings\/blazin-burger-business-performance-metrics\/michael_m_restaurant_location_analysis_10\/'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"kpi_one\" srcset=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10-150x150.png 150w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10-88x88.png 88w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt><\/dl><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/eipsoftware.com\/musings\/blazin-burger-business-performance-metrics\/michael_m_restaurant_location_analysis_10_map\/'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10_map-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10_map-150x150.png 150w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10_map-88x88.png 88w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt><\/dl>\n\t\t\t<br style='clear: both' \/>\n\t\t<\/div>\n\n<p><!--more--><\/p>\n<h4>Dashboard KPI&#8217;s show the following:<\/h4>\n<p>The top chart shows the plotting of the daily revenue, bottom left is a heat map of average order count, and bottom right correlation between order and item counts.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-206 size-large\" src=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10-1024x566.png\" alt=\"kpi_one\" width=\"629\" height=\"348\" srcset=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10-1024x566.png 1024w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10-300x166.png 300w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10-768x424.png 768w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10-900x497.png 900w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10-1280x707.png 1280w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10.png 1920w\" sizes=\"auto, (max-width: 629px) 100vw, 629px\" \/><\/p>\n<p class=\"western\">Plotting of the daily revenue shows consistency; especially considering the same day of the week, i.e. revenue for each Monday were similar. The exception was the lower Manhattan location where in beginning of February the revenue started to plummet.<\/p>\n<p class=\"western\">The heat map shows the average order count by the average revenue for each location based on the day of the week for the specified time period.\u00a0The lower Manhattan location has the lowest order count and least amount of revenue; indicated by light blue.<\/p>\n<p class=\"western\">Next looking at the correlation between order and item counts, we can see confirmation that the lower Manhattan location is clustered at the lower rate than the the other two locations. The over all trend line is about a 45 degree line. The upper West Side location trends significantly higher than the lower Manhattan location.<\/p>\n<h4>NYC Public Health External Data<\/h4>\n<p>Left figure shows the NYC health inspections average restaurant score by zip code, top right compares Blazin&#8217; Burgers health inspection score against average revenue, and bottom right is average scores by cuisine type and borough.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-207\" src=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10_map-1024x566.png\" alt=\"\" width=\"629\" height=\"348\" srcset=\"https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10_map-1024x566.png 1024w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10_map-300x166.png 300w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10_map-768x424.png 768w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10_map-900x497.png 900w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10_map-1280x707.png 1280w, https:\/\/eipsoftware.com\/musings\/wp-content\/uploads\/2018\/02\/michael_m_restaurant_location_analysis_10_map.png 1920w\" sizes=\"auto, (max-width: 629px) 100vw, 629px\" \/><\/p>\n<p class=\"western\">The NYC health inspections data set has the scores for each business. The score is indicative of the number of health code infractions for the location. The lower the score the lower amount of infractions. Lower scores are indicated by green; higher scores are indicated by red.\u00a0The map below shows the average score by zip code. It will allow us to compare the Blazin\u2019 Burgers locations against the average score for their location zip code.<\/p>\n<p class=\"western\">Looking at each locations Revenue and Health Inspection score, we can see an inverse relationship. As the Lower Manhattan\u2019s health inspection score increased, performing worse, the daily revenue decreased. It is in alignment with what was shown in first two visualizations.<\/p>\n<p class=\"western\">Lastly looking at the average scores by Borough and Cuisine Type; we can investigate how Blazin\u2019 Burgers is performing against similar cuisines.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Blazin&#8217; Burger Business Performance Metrics Over the last year, the three New York locations of fast-food restaurant Blazin\u2019 Burger have produced mixed financial results. Below is a presentation-ready dashboard that will show KPI&#8217;s that show performance data from each location External data from NYC board of health Below are dashboards created using MicroStrategy.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[42,7],"tags":[39,46,47],"series":[],"class_list":["post-205","post","type-post","status-publish","format-standard","hentry","category-visualization-dashboard","category-visualization","tag-visualization","tag-dashboard","tag-microstrategy"],"_links":{"self":[{"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/posts\/205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/comments?post=205"}],"version-history":[{"count":4,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/posts\/205\/revisions"}],"predecessor-version":[{"id":626,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/posts\/205\/revisions\/626"}],"wp:attachment":[{"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/media?parent=205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/categories?post=205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/tags?post=205"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/series?post=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}