Data Analyst Portfolio

US Energy Usage and Price Dashboard (2024)

Dashboard built to compare energy price and usage data among US states.  The most interesting finding was that my home state of California pays the most for electricity of any state, even though Texas and Florida both use more electricity.  Click on your state and see how its average energy prices have changed over time!

Data from https://www.kaggle.com/datasets/alistairking/electricity-prices.

Forklift Driver Management Dashboard (2019)

Dashboard built for head of cooling operations in order to better understand workforce and compare employee output (orders loaded, staged, etc.).  Daily updating dashboard aided management in making workforce related decisions and better facilitate performance reviews with staff.

Dashboard was built with data pulled from Kronos time card data, MSSQL and Oracle EnterpriseOne, then modeled and visualized in QlikSense.


Harvest Crew Payroll Dashboard (2015)

Dashboard built to understand harvest labor costs for an agricultural company.   KPIs at the top display key metrics,  including Boxes per Hour,  Units Packed Total Man Hours and Effective Hourly Wage.  Tree Chart and Combo charts below are fully dynamic and when you select a paycode, department or harvested commodity, the KPIs and the other charts will adjust accordingly.

Daily updating dashboard was built based on a legacy excel report that could only be run every other month.  Data was pulled from MSSQL, JDE World and Oracle EnterpriseOne, then modeled and visualized in QlikSense.