Complex ETL and Automation for Electrical Use Analysis

Category: Cloud Hosting, Process Automation, Web Portals




DAS collaborated with SAS to help design, build and implement a data driven application that estimated long term (two years) electrical usage of commercial facilities to establish appropriate levels of pricing and electrical generation. Commercial facilities are assigned to a cohort according to the patterns of their historical energy usage. Future energy usage is estimated by projecting the associated pattern into the future while adjusting for reactions to long-term weather forecasts. DAS was responsible for the development and automation of extensive ETL processes for long term estimation of commercial electrical usage, system development, system automations and risk modeling.