Investigating Airline Tickets Frequency with R
Applying Natural Language Processing to a Twitter Project
Using Advanced Excel to format and compute data
Excel is an essential tool for marketer. I used them to perform marketing metrics. I also used Excel for calculating A/B test and VLOOKUP for joining datasets.
Here are some key metrics I know by heart.
Cost per Mille
Cost per Click
Cost per Acquisition
Revenue per Click
Average Order Value
Return on Investment
Crime Report with Excel Pivot Tables and Government Proprietary Data
In my upper level Criminal Justice Honors class, I made a 5 month long analytical project investigated crimes in the Northern Philadelphia area utilizing government data, Excel pivot tables, and Simply Analytics. The project also entailed field study and observation. I created graphs, charts, and was able to see the patterns of crimes and explain the elements of crimes using demographics data such as high school drop-out rate, income, male to female ratio. Full report ( 22 pages ) click here.
Result: I received a 99.5/100 score on the final presentation of the findings of this project from the professor.