How did sales at IHOP Change when they offered free pancakes? Find out, using SafeGraph!
HTML-код
- Опубликовано: 13 сен 2024
- This is a video about How did sales at IHOP Change when they offered free pancakes? Find out, using SafeGraph!
Done in Partnership with SafeGraph! #sponsored
TimeStamps
01:22 The SafeGraph Products
06:35 shop.safegraph...
16:41 Data Parser
20:47 Open in Tableau
SafeGraph Shop: bit.ly/3iptNkm
USE CODE: JULIANA50 for $50 off your first purchase!
Data Parser: parser.safegra...
Fields that you need:
- Lat/ Long
-Street Address
-City
-Post Code
-Date Range_Start
-Raw Visit Counts
-Visits by Day (Adds 7 Columns)
-Bucked Dwell Times (Adds 7 Columns)
Tableau Calc
IF DATEPART('day',[Date Range Start]) = 28 THEN 'Week 2'
ELSEIF DATEPART('day',[Date Range Start]) = 21 THEN 'Week 1'
ELSE NULL
END
DIFFERENCE
SUM([Visits By Day 2]) - LOOKUP(ZN(SUM([Visits By Day 2])), -1)
Thanks so much for watching this video! I’m Juliana McMillan-Wilhoit and I am the owner of Tabulae Spatial Services (www.tabulaespa...) I work with GIS professionals and mission-driven organizations to do GIS Analysis. I am just so thankful that you are making me part of your GIS and Geospatial Career Journey. I am here to cheer you on! Below you can find some links to connect with me!
📍Free Networking Events: www.themappyhou... (join our mailing list!)
📍Wait-List for Our Portfolio Workshop + Challenge: www.tabulaespa...
📍Career Coaching for GIS Professionals: www.tabulaespat...
📍GIS Training and Speaking: tabulaespatial...
SafeGraph Shop: bit.ly/3iptNkm
CONNECT WITH ME!
/ julianamapper
/ julianamapper
/ julianamapper
www.tabulaespa...
Great Analysis and video, I used the code and downloaded the data for my own local zipcode to understand what businesses are the most popular.
This seems like a great project!