Projects

Queen's University

Data Analysis, Application & Enrollment across programs

Created a dynamic application dashboard using Tableau for all the programs across Faculty of Arts and Science to compare the Applications, Offers and Acceptances for 6 years (2014 -2019)
Extracted data using queries through PeopleSoft. OUAC data was available in excel sheets. Collated data using Tableau Prep and MS-Excel
Built & expanded report to study the enrollment and application data across programs offered
Automated the system for measuring enrollment using Tableau Desktop & Tableau Prep

Marketing Strategy

Consolidated Google Analytics and Facebook Ad Manager data to design customer personas and marketing strategy. Insights were derived for building a cohesive brand
The project objective was to increase footfall and increase awareness
Presented the findings to the maintainence volunteers of Frontenac Biosphere. They found the insights really helpful

Data Interpretation

Performed statistical data analysis on the data collected during a pilot study.
A profit model was developed using R programming language. Price elasticity of the product was assessed.

Analysis of Ad Sense data

Gathered data from Google Analytics and analysed website traffic using key metrics and KPI’s. Tableau was used as a tool for data analysis
Developed a recommendation report to increase revenue.