Alexander Allan Portfolio

Aspiring Data Analyst skilled in SQL, Tableau, Python, R and DBT. I help bridge the gap between businesses and their data.

Restaurant Sales Forecasting

In this project, I review and improve upon a previous project to analyze a restaurant's sales and inventory data to forecast the upcoming year's sales and profit. Using pandas to store, clean, extract data, create a time series and test models to see which forecasting method is the most accurate.

HelloFresh Subscription Analysis

In this project, I analyze and forecast net profits, subscription signup and cancellation rates. Use SQL to perform subqueries, JOINS, CASE and Date Time extraction. Tableau performs accurate forecasting models, visualizations and identifies KPIs through calculated fields.

Hearthstone Web scraping

Web scraping project where I gather card statistics for the newest expansion of Hearthstone from two websites. Data Exploration and gathering in Python, Cleaning and formatting in Excel and creation of an interactable dashboard in Tableau.

Data Visualizations

Collection of Interactable Data Visualization Dashboards in Tableau.

Cyclistic Case Study Analysis

In this project, I performed an end-to-end analysis of a Chicago-based bike-sharing company. Involving but not limited to data cleaning, JOINS and aggregation of large data sets in SQL and Data Visualizations in Tableau.

What I do

As a data analyst, I am constantly learning and pursuing new knowledge! Below are the foundations of an ever-expanding skill set.

SQL

Proficient in SQL queries. Including but not limited to JOINS, subqueries, temp tables, table management and creation.

Tableau

Tableau is the main tool I use for data visualization and storytelling. Please see my Data Visualizations project tab for a more detailed look.

Excel and Google Sheets

Skilled in both Excel and Sheets functions such as VLOOKUP and pivot tables.

Python

Experienced in Python programming language. Examples include web scraping, object-oriented programing, pandas and machine learning.

R Stuido

Well-versed in the R programming language. Tidyverse and ggpoint libraries for data exploration and visualization.

Putting it all together

Ultizing my skills I perfrom data exploration, clean data and find actionable insights within to solve business problems.

Get in touch

Please feel free to reach out and contact me! As well as add me on LinkedIn!