CLIENT SUCCESS STORY
Sector: Wholesale Energy
Division: Energy Storage
Solution Technologies: Machine Learning, Decision Trees, Naïve Bayes,
k-nearest neighbors (knn)
Solution Products: Scikit, Power BI, Python
Solution Service Type: Project
I N T R O D U C T I O N
With the right data in hand, machine learning can provide powerful insights. For this wholesale energy client, we were tasked with creating a heat map based on nodal data on the electrical grid for DA/RT price points for the future development of an asset.
In our case we had to source some information from outside sources and use an API connection for energy prices across America’s states – this is what gave us a better understanding of how prices can
change drastically depending on which ISO we look at.
C H A L L E N G E
Prior to our engagement, the client was creating reports directly on excel and had no automation processes. They were looking for something more robust and time efficient. We had to work through a number of questions with them, such as:
Where to find data?
How can we forecast out for volatile ISOs?
Based on the forecast how long will it take for it to be profitable?
It was also noted that we would need an ML algorithm to continuously update for arbitrage opportunities
S O L U T I O N
We developed a forecast model that was created in Python (Pandas and Scikit) to use historical data from an API. This forecast model was able to use the time series data to create an error metric for outliers and data drift for unseen circumstances (power outage, grid blowout, congestion). It was also accurately able to predict the energy pricing forecast at a confidence interval of 1.64 (90%) when extrapolating out to a 12-month time period.
During our analysis, we created an error metric for the average value to confirm that our forecast is valid. After the nodal model was complete we then applied our data points to a heat map to visualize where the most optimal location would be to develop an asset.
R E S U L T
We were able to create a model that required less user input and did most of the work on its own by leveraging Machine Learning. The
resulting algorithm had an accuracy rate at or above desired confidence intervals, so it’s clear this model is going to be useful for future projects.
A B O U T P O M E R O L
Pomerol Partners creates and delivers meaningful data-driven business solutions and services. We’ve been operating in Data Analytics and Intelligence Reporting for over 9 years and our Partners have a cumulative 100 years in global experience. In 2013, Pomerol spun out of Deutsche Bank after a range of successful BI projects were delivered saving the bank over $3m. Ever since then we’ve been partnering with our clients (executives, managers, analysts, etc.) across all business verticals to optimize the intersect between changing business demands, technological progress and sustainable business growth.
Our consultants have helped hundreds of organizations, of all sizes and in all industries worldwide, make money. How do we do this? Leveraging your data to increase revenue, automate processes, decrease costs and understand your insights. Pomerol delivers value that helps you grow and change with better data-driven decisions and solutions that empower you as an Elite Qlik Partner as well as a Gold Data Platform, Silver Data Analytics and Silver Cloud Platform Microsoft Partner. Our professional consultants, that reside in three countries (United States, United Kingdom and Portugal), are experts that will partner with you for the technical as well as business-oriented solutions. Working with the same team in all capacities ensures you always know where we stand with our work and commitment to you.
Pomerol offers a comprehensive range of Power BI training options. For those new to Power BI, Dashboard-in-a-Day will provide give you the knowledge and confidence to build your own dashboards. For those looking to take their Power BI skills to the next level our advanced DAX and M courses will teach you the fundamentals of these two languages and to how to use them to build complex solutions. We also offer bespoke training workshops that can be tailored to your specific training needs.
DOWNLOAD FULL CASE STUDY PDF