Nick Assuras - Portfolio

Aspiring data analyst who is well-versed in using Excel/Google Sheets, Google Data Studio, SQL, and Tableau. Familiar with R and Python - notably pandas, matplotlib, seaborn. A recent graduate of the Google Data Analytics Certificate program on Coursera. This site includes projects I've completed from work, from school, and on my own time.

Google Data Analytics Capstone Project

In this case study we explore data from a fictional bike-share company, Cyclistic. Using Excel and R - I cleaned, analyzed, and presented 2021 bike-sharing data to help Cyclistic derive insights to be used for an upcoming 2022 marketing campaign.

Budget Tracker

Custom, dynamic budget tracker that I built for the Arcane marketing teams to use. This tracker MUST be used with Google Sheets - uses the Query() function (unavailable in Excel).

NOTE: All client info and metrics have been randomly generated.

Data Studio - Objectives Dashboard

Google Data Studio dashboard template used for certain Arcane clients. The dashboard layout is focused around a client's main KPIs/objectives.

NOTE: Client name has been removed, campaign names have been changed, and client metrics have been randomized.

Group Project - Spotify Campaigh Pitch

Completed while at George Brown College - our group pitched a new marketing campaign for Spotify to target university students, specifically very physically active students referred to as 'Gym Rats'.

Location

London, ON

Phone

(519) 878-0055

Email

nickassuras@gmail.com

Social