Maven Monthly Challenge – Mexican Restaurant Scouting

It was that time of the month when Maven Analytics set their data playground challenge – #mavenrestaurantchallenge. This time it was using 5 separate csv data tables detailing consumer and restaurant data from cities across three states in Mexico during 2012.

The brief was to

• assume the role of a Lead Analyst that scopes out new restaurant opportunities abroad
• review and analyse the data provided for interesting patterns and trends
• develop a single page visual that gives potential investors a good understanding of the market to guide them in making investment decisions
• post your final proposal on LinkedIn for review by Maven and fellow challengers

My Plan

As the final product was going to be a single page (jpg) being viewed on LinkedIn, it makes sense to keep the visual:

• Simple and clean with a consistent palette
• Structured and flowing, telling a progressive story
• Clear in terms of visibility of graphics and legibility of any text

I landed on asking three simple questions:

• Who? – who were the key demographic to target in terms of age and smoking/drinking habits
• Where? – which city or location had the highest ratio of consumers to restaurants
• What? – what kind of cuisine should a restaurant serve based on popularity and levels of current availability

My Solution

I decided to use Tableau for this challenge to try out some newly acquired skills. The below was my final proposal posted on LinkedIn, as well as on my Tableau Public Account

I will share some tips on how I made a few of the visuals in a follow up blog. If anyone reading has any queries on any part of the visual or it’s development, drop me a comment, and I’ll be happy to provide further detail.

Happy Analysing!