Recommended Resource: ‘Practical Time Series Forecasting: A Hands-On Guide’, by Galit Schmueli

The Smart Forecaster

Pursuing best practices in demand planning,

forecasting and inventory optimization

A readable, well-organized textbook could be invaluable to “help corporate forecasters-in-training understand the basics of time series forecasting,” as Tom Willemain notes in the conclusion to this review, originally published in Foresight: The International Journal of Applied Forecasting. Principally written for an academic audience, the review also serves inexperienced demand planning professionals by pointing them to an in-depth resource.

This neat little book aims to “introduce the reader to quantitative forecasting of time series in a practical, hands-on fashion.” For a certain kind of reader, it will doubtless succeed, and do so in a stylish way.

The author, Dr. Galit Shmueli, is the SRITNE Chaired Professor of Data Analytics and Associate Professor of Statistics and Information Systems at the Indian School of Business, Hyderabad. She has authored or coauthored several other books on applied statistics and business analytics.

The book is meant to be a text for a “mini-semester” course for graduate or upper-level undergraduate students. I think it would be a stretch to believe there is enough technical material here to serve as the basis for a graduate course, but I could see it working well for undergraduates in industrial engineering or management who have had a prior statistics course (and therefore will indeed be able to “recall that a 95% prediction interval for normally distributed errors is…”).

There are end-of-chapter exercises of appropriate size and even setups for three real-world semester projects, so instructors could use the book as envisioned by the author. The book illustrates its points using XLMiner, an Excel add-in, and students can use the free demo version for almost all the exercises. Text datasets are available from the book’s web site, which also provides a free time series analysis “dashboard” application. The author notes that other software can be used in place of XLMiner and mentions Minitab, JMP, and Rob Hyndman’s forecast library in R.

While reading this book, I was delighted by its clarity. Having spent time recently correcting the technical prose of two otherwise good graduate students, I found the writing in this book to be a refreshing contrast, making technical concepts understandable.

Another virtue of this book is its selection of topics. The technical ones are reasonably standard (smoothing methods, regression using polynomial trends, and dummy variables) but also range a bit toward the more exotic (logistic regression, neural nets, a bit of ARIMA). More impressive is the inclusion of what might be called “meta-topics” relevant to forecasting: performance assessment, an overview of alternative technical approaches, and one on the forecasting process, from definition of goals to ways to gear reports differently for managerial and technical audiences. This is the kind of forecasting wisdom we find in Chris Chatfield’s book (2004), though presented rather less tartly and with less mathematical exposition. I typically recommend Chatfield’s introductory book for more technical readers interested in getting into time series; I would recommend Shmueli’s book for a more general audience.

No review is complete without quibbles. Here are a few—too few to undo my very positive view of this impressive little book:

• The text makes a good case for “well formatted and easily readable” charts (p. 179). But I found many of the screen shots to be poorly printed and difficult to see. The book is otherwise so visually pleasing that these defects seem very out of character. It uses luxurious amounts of white space and whimsical marginal art to great effect, producing a very “light” feel that must surely help comprehension.

• The author claims (p. 115) that smoothing methods (e.g., moving averages, exponential smoothing) cannot be fully automated because “the user must specify smoothing constants.” Of course, this is not so, since there are several software packages that do this, and the text later contradicts itself on this point on page 127.

• The otherwise good discussion of autocorrelation misleads when it claims (p. 88) that negative lag-1 autocorrelation means that “high values are immediately followed by low values and vice versa.” Well, usually, but not always.

When I finished reading this book, I realized immediately that there is another target audience outside the classroom. My company often conducts training sessions on the use of our software, and these include some general background on forecasting methods and processes. If we could excise the material on XLMiner, and even if we couldn’t, this text would make a wonderful “leave behind” to help corporate forecasters-in-training understand the basics of time series forecasting. The book is so well written, well organized and well designed that it might even be read. We can certainly use it to help our new programmers understand the applications they are developing. And this book might even serve as guilty reading for a graduate student who wants to really “get” what’s going on in Box, Jenkins and Reinsel (2008).

Thomas Willemain, PhD, co-founded Smart Software and currently serves as Senior Vice President for Research. Dr. Willemain also serves as Professor Emeritus of Industrial and Systems Engineering at Rensselaer Polytechnic Institute and as a member of the research staff at the Center for Computing Sciences, Institute for Defense Analyses.

Leave a Comment

Related Posts

You Need to Team up with the Algorithms

You Need to Team up with the Algorithms

This article is about the real power that comes from the collaboration between you and our software that happens at your fingertips. We often write about the software itself and what goes on “under the hood”. This time, the subject is how you should best team up with the software.

Rethinking forecast accuracy: A shift from accuracy to error metrics

Rethinking forecast accuracy: A shift from accuracy to error metrics

Measuring the accuracy of forecasts is an undeniably important part of the demand planning process. This forecasting scorecard could be built based on one of two contrasting viewpoints for computing metrics. The error viewpoint asks, “how far was the forecast from the actual?” The accuracy viewpoint asks, “how close was the forecast to the actual?” Both are valid, but error metrics provide more information.

Every Forecasting Model is Good for What it is Designed for

Every Forecasting Model is Good for What it is Designed for

With so much hype around new Machine Learning (ML) and probabilistic forecasting methods, the traditional “extrapolative” or “time series” statistical forecasting methods seem to be getting the cold shoulder. However, it is worth remembering that these traditional techniques (such as single and double exponential smoothing, linear and simple moving averaging, and Winters models for seasonal items) often work quite well for higher volume data. Every method is good for what it was designed to do. Just apply each appropriately, as in don’t bring a knife to a gunfight and don’t use a jackhammer when a simple hand hammer will do.

Recent Posts

  • Direct to the Brain of the Boss- Inventory AnalysisDirect to the Brain of the Boss – Inventory Analytics and Reporting
    In this blog, the spotlight is cast on the software that creates reports for management, the silent hero that translates the beauty of furious calculations into actionable reports. Watch as the calculations, intricately guided by planners utilizing our software, seamlessly converge into Smart Operational Analytics (SOA) reports, dividing five key areas: inventory analysis, inventory performance, inventory trending, supplier performance, and demand anomalies. […]
  • You need to team up with the algorithms for Inventory ManagementYou Need to Team up with the Algorithms
    This article is about the real power that comes from the collaboration between you and our software that happens at your fingertips. We often write about the software itself and what goes on “under the hood”. This time, the subject is how you should best team up with the software. […]
  • Rethinking forecast accuracy, A shift from accuracy to error metricsRethinking forecast accuracy: A shift from accuracy to error metrics
    Measuring the accuracy of forecasts is an undeniably important part of the demand planning process. This forecasting scorecard could be built based on one of two contrasting viewpoints for computing metrics. The error viewpoint asks, “how far was the forecast from the actual?” The accuracy viewpoint asks, “how close was the forecast to the actual?” Both are valid, but error metrics provide more information. […]
  • Using Key Performance Predictions to Plan Stocking Policies
    I can't imagine being an inventory planner in spare parts, distribution, or manufacturing and having to create safety stock levels, reorder points, and order suggestions without using key performance predictions of service levels, fill rates, and inventory costs. […]
  • Every forecasting model is good for what it is designed forEvery Forecasting Model is Good for What it is Designed for
    With so much hype around new Machine Learning (ML) and probabilistic forecasting methods, the traditional “extrapolative” or “time series” statistical forecasting methods seem to be getting the cold shoulder. However, it is worth remembering that these traditional techniques (such as single and double exponential smoothing, linear and simple moving averaging, and Winters models for seasonal items) often work quite well for higher volume data. Every method is good for what it was designed to do. Just apply each appropriately, as in don’t bring a knife to a gunfight and don’t use a jackhammer when a simple hand hammer will do. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Top Differences between Inventory Planning for Finished Goods and for MRO and Spare PartsTop Differences Between Inventory Planning for Finished Goods and for MRO and Spare Parts
      In today’s competitive business landscape, companies are constantly seeking ways to improve their operational efficiency and drive increased revenue. Optimizing service parts management is an often-overlooked aspect that can have a significant financial impact. Companies can improve overall efficiency and generate significant financial returns by effectively managing spare parts inventory. This article will explore the economic implications of optimized service parts management and how investing in Inventory Optimization and Demand Planning Software can provide a competitive advantage. […]
    • Centering Act Spare Parts Timing Pricing and ReliabilityCentering Act: Spare Parts Timing, Pricing, and Reliability
      In this article, we'll walk you through the process of crafting a spare parts inventory plan that prioritizes availability metrics such as service levels and fill rates while ensuring cost efficiency. We'll focus on an approach to inventory planning called Service Level-Driven Inventory Optimization. Next, we'll discuss how to determine what parts you should include in your inventory and those that might not be necessary. Lastly, we'll explore ways to enhance your service-level-driven inventory plan consistently. […]
    • 5 Steps to Improve the Financial Impact of Spare Parts Planning5 Steps to Improve the Financial Impact of Spare Parts Planning
      In today’s competitive business landscape, companies are constantly seeking ways to improve their operational efficiency and drive increased revenue. Optimizing service parts management is an often-overlooked aspect that can have a significant financial impact. Companies can improve overall efficiency and generate significant financial returns by effectively managing spare parts inventory. This article will explore the economic implications of optimized service parts management and how investing in Inventory Optimization and Demand Planning Software can provide a competitive advantage. […]
    • Bottom Line strategies for Spare Parts Planning SoftwareBottom Line Strategies for Spare Parts Planning
      Managing spare parts presents numerous challenges, such as unexpected breakdowns, changing schedules, and inconsistent demand patterns. Traditional forecasting methods and manual approaches are ineffective in dealing with these complexities. To overcome these challenges, this blog outlines key strategies that prioritize service levels, utilize probabilistic methods to calculate reorder points, regularly adjust stocking policies, and implement a dedicated planning process to avoid excessive inventory. Explore these strategies to optimize spare parts inventory and improve operational efficiency. […]