Principles of Load Forecasting in Google Sheets

Offered By
Coursera Project Network
In this Guided Project, you will:

Identify use cases for forecasting energy trends with moving averages (MA).

Build two load forecasting models in Google Sheets.

Visualize the forecast output and test the load forecast models for accuracy.

Clock2 hours
IntermediateIntermediate
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

By the end of this project, you will understand the principles of load forecasting used by power companies to balance the supply and load demand of energy. You will also be able to conduct a load forecast in Google Sheets. To do this, you will work in the free-to-use software Google Sheets while exploring how load forecasting provides the building block for planning efforts decades into the future. You will also understand how load forecasting influences more than energy planning efforts because it also informs financial and operational planning and rate setting by governments through weather normalization techniques. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Skills you will develop

Resource PlanningEnergy DemandMachine LearningBusiness IntelligenceLoad Forecasting

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Review how forecasting supports decision-making and access Google Sheets.

  2. Identify use cases for forecasting energy trends and import data into Google Sheets.

  3. Create two load forecasting models in Google Sheets.

  4. Create and visualize the load forecast output and test the models for accuracy.

  5. Evaluate the test statistics and choose the winning model.

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.