This is a collection of data based projects.

The projects where completed using a variety of tools and technologies. Tools used include SQL, VBA and Python. Technologies used include Excel (pre-365), Excel, Power Query and Power BI.

Excel Dashboard

Excel 2010 based dashboard

Excel Power Query using M and REST

A spreadsheet updated using Power Query, M and RESTful APIs

Customer Sales Dashboard

Excel 2010 Dashboard showing Sales by Customer.

Charting Analysis

Using a chart to view changes over time

Python and RESTful APIs

Utilizing Python to access REST APIs