This dashboard is built in R using the Shiny web application framework. It utilizes data downloaded from my personal account through the Pacific Gas and Electric company's website. The data consists of multiple comma-separated files of historical data containing energy usage and costs which are then merged together to create a single dataset with a nested data structure. It takes an iterative forecasting approach using tools from the modeltime forecasting suite to predict my home's energy usage and costs based on both daily and monthly data. The main idea behind iterative forecasting is to "nest" multiple time series groups into a single dataset and then fit multiple models to each group.
See it in action here: https://joon.shinyapps.io/pge_home_energy_forecaster
Built with R, Shiny, modeltime, timetk, tidyverse, and flexdashboard.