A list of my software development and data analysis projects using a range of tools

Power Bi, Python, R, SQL, Excel, powerpoint, Google Sheets and Tableau


Software Development

  • CSV Compiler

    This is a python script I wrote to take 3 CSV files and generate a report.

  • CSV to StreetView Batch Converter

    This is a python script I wrote to take a CSV file with addresses and download all corresponding google street view images for those addresses.

  • Coinbase API Python Wrapper

    This is a python wrapper I made for the Coinbase API to better interact with it.

  • Fear and Greed Index Scraper

    I used python to make a scraper to extract the fear and greed index from cnn's website.

  • Alpaca Portfolio Asset Verification

    I have a portfolio manager program that trades every day for me on alpaca.markets. One thing I never implemented was to look out for some assets being held for longer than I intended, so I put this Python program together to help with that.

  • SCP Scraper Project

    In this project I scrape data from the SCP-Wiki using Python to later compile into SQL Server.

Data Analysis

  • HR Turnover Dashboard

    For this project I used python to generator the HR data of a pretend company, then created a dashboard on Tableau with my findings.

  • Power Bi Reporting

    For this project I was asked to review the data provided and build a two-tab report in Power Bi.

  • COVID 19 Data Analysis

    In this project I focused on using SQL to analyze COVID 19 global data.

  • Google Data Analytics Capstone Project - BELLABEAT

    This was the second available project for the Google data Analytics Course. For the data cleaning and analytics I used Python. Then I created my visualizations in Tableau. I summarized my results in a presentation for shareholders in Google Slides.

  • Google Data Analytics Capstone Project - CYCLISTIC

    In this project I used R for data cleaning and analysis. Tableau was used for the visuals at the end. Powerpoint was used to create the final presentation for shareholders.