We use cookies, including third-party cookies from Google to serve personalized ads through AdSense, to operate this site and understand how it is used. By continuing to browse, you accept this use. See our Privacy Policy and Terms of Use for details, including how to opt out of personalized advertising.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    Flat editorial illustration: The article is about joining public web signals with internal business metrics so BI teams can inter
    Alternative Data in BI: Bringing Public Web Data Into Your Dashboards
    23 Min Read
    Flat editorial illustration: The article is about automating the collection, preparation, and delivery of marketing data across p
    From Data to Dashboards: 5 Marketing Reporting Automation Software Picks
    12 Min Read
    Flat editorial illustration: The article contrasts passive follower totals with a behavioral path from attention and trust to cli
    Creator Analytics Beyond Follower Count: Seven Metrics That Measure Audience Behavior
    11 Min Read
    Flat editorial illustration: The article connects AI and marketing analytics with managerial judgment grounded in consumer behavi
    How an Online MBA in Marketing Connects AI and Data Analytics
    11 Min Read
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers -- AI-generated illustration
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: How to Solve a Difficult Forecasting Problem
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Uncategorized > How to Solve a Difficult Forecasting Problem
Uncategorized

How to Solve a Difficult Forecasting Problem

mvgilliland
mvgilliland
5 Min Read
How to Solve a Difficult Forecasting Problem
Illustration generated with Qwen Image.
SHARE

The Boulder, The Cliff, and The Baby

Imagine you are faced with this very urgent problem: A large boulder is teetering on the edge of a cliff, at the bottom of which sits a baby, at risk of being crushed. How do you solve this problem?

Contents
  • The Boulder, The Cliff, and The Baby
  • The Boulder, The Cliff, and The Baby
  • An Example from Forecasting

One solution for the teetering boulder is this:

The Boulder, The Cliff, and The Baby

Imagine you are faced with this very urgent problem: A large boulder is teetering on the edge of a cliff, at the bottom of which sits a baby, at risk of being crushed. How do you solve this problem?

One solution for the teetering boulder is this:

More Read

Business Case for Predictive Analytics Is Simpler Than You Think
Business Case for Predictive Analytics Is Simpler Than You Think
Is it a tech bubble?
How to succeed in the enterprise without really trying: Apple’s crunch
Making Ads More Interesting…for Users or for Google?
Being Smart About Public Wi-Fi Networks

Use large ropes and cables to fasten the boulder to the top of the cliff, buying some time while you build a large infrastructure of concrete and metal to support the boulder from below.

Sounds great — the boulder is secured and the baby is now safe. But is this really such a great solution? What if instead we just did this:

Remove the baby from the bottom of the cliff.

While this does not solve the issue of the teetering boulder, it has done something better. It has made the teetering boulder irrelevant — no longer a problem that needs to be solved! (Once the baby is in a safe spot, who cares if the boulder falls?)

An Example from Forecasting

Too often, in dealing with our urgent business forecasting problems, we go for the first type of costly and time-consuming solution. Sometimes it may not be obvious that there are alternative approaches. Or sometimes we may have hired an unscrupulous consultant who will (of course) suggest a costly and time-consuming answer.

Consider the apparent problem of generating highly granular forecasts, such as by customer/item for a manufacturer, or store/item for a retailer. There can be millions of time series at this most granular level. It may appear that we need to forecast all of them. So we buy terabytes of storage and the fastest processors to be able to model and forecast each of these millions of series. But did we really have to do all this? Is this approach really going to give us the best answer to the ultimate business problem, which is meeting customer demand in a cost effective manner?

A manufacturer who fulfills customer demand out of network of distribution centers (DCs), probably doesn’t have to care about the individual demands of individual customers. As long as forecasts at the DC/item level are accurate enough to keep an appropriate level of inventory in each DC, who cares what individual customers are demanding? Unless a customer dominates the demand for an item at the DC (consuming a high percentage of the DC volume in that item), there may be no good reason to try to forecast that customer/item combination.

You could make a similar argument for replenishable items in retail, where multiple stores are supplied from a central warehouse. Instead of forecasting each store/item combination every week, just forecast the total demand for each item at the warehouse level, and use inventory policies (min/max, 2-bin, etc.) to replenish the store shelves. As long as you have forecasted well enough at the warehouse/item level, you should not have to worry about store/item forecasting.

The point it, don’t waste time solving a difficult problem (like customer/item or store/item forecasts) if it doesn’t need to be solved. Not only are highly granular forecasts going to be less accurate than forecasts at an aggregated intermediate level (like DC/item), they take considerably more time and resources to generate.

So make your life easy. Whenever possible, eliminate the need to do forecasting.

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

Flat editorial illustration: The article connects downstream report failures, data-quality gaps, and conflicting metric definitio
Signs Your Data Architecture Needs an Outside Review
Big Data Exclusive
Data-Driven Pultrusion: Best GFRP Rebar Machines & ROI
Data-Driven Pultrusion: Best GFRP Rebar Machines & ROI
Big Data Exclusive
Flat editorial illustration: The article contrasts tools for gathering fresh interviews with tools for analyzing existing qualita
10 AI Market Research Tools That Turn Qualitative Data into Insights
Artificial Intelligence Big Data Exclusive
Flat editorial illustration: The article compares proxy MCP servers by what an AI agent can do through them: manage proxy account
Proxy MCP Servers: 7 Options and What Each Lets an AI Agent Do
Artificial Intelligence Big Data Data Collection

Stay Connected

1.2KFollowersLike
33.7KFollowersFollow
222FollowersPin

You Might also Like

Analogue Business with a Digital Facade
Uncategorized

Analogue Business with a Digital Facade

8 Min Read
Big Data May Ease California Drought and Other Real-World Problems
Uncategorized

Big Data May Ease California Drought and Other Real-World Problems

3 Min Read
Implementing Enterprise 2.0 at Intuit, Part Three: Cultural and Organizational Shifts
Uncategorized

Implementing Enterprise 2.0 at Intuit, Part Three: Cultural and Organizational Shifts

7 Min Read
Use TubeMogul to Distribute and Track Your Videos Online
Uncategorized

Use TubeMogul to Distribute and Track Your Videos Online

4 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
5 Great Tips for Using Data Analytics for Website UX
5 Great Tips for Using Data Analytics for Website UX
Big Data

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-26 SmartData Collective. All Rights Reserved.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?