Data Translation Project Submission

Macro Analysis of the Month of July

Visit Distribution Over the Month

In general, we see that location visits tend to decrease on holy days such as Sundays and Saturdays. The highest amount of location visits tend to take place on Fridays. On average we can expect up to 155 visits at any given location per day and at least 84 visits per day to any given location. Notably there is a peak on a non-Friday, July 15, which could most likely indicate an important event after July 4th such a big holiday or sale day.

Neighborhood Visits in the Month of July

In general we can see that there relatively little fluctuation in number of visits by neighborhood. There is a fairly consistent flow through of individuals visiting the top big name location and neighborhoods. The brand is consistent in number of visit per neighborhood, however the number of visits by each brand varies daily.

Average Weekly Visit Analysis

There tends to be a fairly normal distribution of visist per day of the week with a focal point of Friday to big name brands. Over the month of July we see around 667,000 through cellphone data alone. What’s interesting is that there seems to be more of a uniform distribution when looking at average visits per day, rather than total visits per day of the week.

Friday Visits Breakdown

Big Name Brands and NIACS Code Breakdown

In general, we can see that the top brand possesses a large margin between itself and the other brands. When looking at the NIAC Codes, the top brand does not belong to the top NIACs Industry patronized on Fridays. Moreover, the top two big brand names switch places in reference to their industry types.

Brands visits tends to be larger than industry visits in neighborhood locations.

Small Brand Visits on Friday

In general we see the same trends as seen with the big name brands. The normal distribution over weekdays appears far stronger. Unlike the the top 15 big brands, we see a strong that the top three industry types lead the rest by a significant margin. It is no surprise that we see recreational fun activities increase in popularity through the increased number of vists to bars and restaurants. It is also worth noting that several industries maintain their positions such as the airport and non-alcoholic bars.