I’m Brian Mackenzie, a data analyst and content creator with a background in information science, I strive to use data to solve problems, whether that be performing SEO analysis to help content find its audience or building tools to make data more digestible for others. I believe that through data, businesses can make informed, and excellent decisions that will improve their content and products. I want to be a part of that!

You can see examples of my work below. Thank you for visiting, and I hope you enjoy browsing the projects!

Work Samples

Major League Soccer Database/Dashboard

As it’s a fairly young league, there’s no easily accessible API or database with statistics for MLS data. With that in mind, I used web scraping to pull this year’s stats and stored them in a SQLITE database.

I then used Dash to create a simple Dashboard for seeing league leaders in important statistical categories, and for viewing the stats of your favorite players.

Skills Used

SQL, Python, Web Scraping, Data Visualization, Database Management, Data Cleaning

Links

NHL Trends Dashboard

In order to more easily observe trends in the NHL, I used the official NHL API to build a dataset of historical stats for each NHL team back to 2001. I used this dataset to create a Dashboard that can be used to see 5 year snapshots of stats trends for each team.

Skills Used

API Data Collection, Data Visualization, Data Manipulation

Links

Titanic Survival Classification

Using a dataset containing information about titanic passengers, I used Random Forest and Logistic Regression to predict whether a passenger survived or not. To prepare the data for modeling it was necessary to explore and clean the data and engineer new features.

Skills Used

Python, Data Cleaning, Data Visualization, Data Analysis, Classification Modeling, Feature Engineering

Links

Airline Satisfaction Classification

Using a dataset containing flight data and flight satisfaction data, I used Random Forest and Logistic Regression to predict whether a passenger was satisfied, or dissatisfied with their flight. To prepare the data for modeling it was necessary to explore and clean the data, as well as produce visualizations for each relevant feature.

Skills Used

Python, Data Cleaning, Data Visualization, Data Analysis, Classification Modeling

Links

Work History

 Data Analyst, 09/2021 to Current

Informa Tech. – Austin, TX

  • Created Looker, Tableau, and Dash based dashboards to present data findings

  • Presented visualizations and findings to non-technical professionals

  • Automated previously manual spreadsheet-based reports using Python

  • Wrote complex SQL queries to pull data relevant to business questions

  • Used Python to clean large datasets and assess data quality

  • Created Classification models to predict event attendees and advise marketing

Technical Research Analyst, 01/2020 to 09/2021

TrustRadius Inc. – Austin, TX

  • Doubled product review analysis speed by automating manual processes through R scripting

  • Produced $100,000+ worth of marketing assets for clients

  • Increased traffic by prototyping and implementing new content that appears on 100+ pages

  • Managed YouTube channel and produced and published over 100 marketing videos

  • Trained and managed teams of 3-6 contractors for text and video content creation

Web Development Specialist, 06/2018 to 12/2019

Middlesex County Government – New Brunswick, NJ

·    Managed 2 SharePoint sites for internal and public use

·    Acted as technical lead of a team to select a new CRM

·    Trained office personnel and contractors on technologies including SharePoint and Brightcove

Education and Certifications

Master of Science: Information Science with Data Science Concentration, 05/2021

Rutgers University - New Brunswick, NJ

 

Bachelor of Science: Library and Information Science, 05/2018

University of South Carolina - Columbia, SC

US Department of Labor Data Analyst Certification: Issued 12/2022

IBM Data Analyst Certification: Issued 10/2021