SmarTours- New York, New York: March 2021 – January 2022 - Data Analyst

o Create the Power BI Dashboards (E-Commerce, Paid Search Effort, Total bookings, Biggest Movers, Age Demographics,
Source/Medium, Guest summarization, etc.) for the Company totaling 500 bookings per day and visualize any acquisition trends.
o Develop a Propensity Model for the Direct Mail effort totaling 600,000 users.
o Develop daily and weekly summarizations of the E-commerce sector, the company’s financial standing through Google Analytics, and automatic
reports performed through Power BI.
o Develop and maintain the End of end-of-month price changes for ~600 departures encompassing ~70 different tours and model a predictive
analysis of the current bookings and future bookings.
o Develop an Attribution Model to accurately portray where bookings were being developed encompassing 5 different variables.
o Create a web scraping project to find out what the most popular destinations are around the world.