IBM Planning Analytics Tips & Tricks
How to Handle Outliers in IBM Planning Analytics Predictive Modeling
Have you used Planning Analytics to generate a forecast and realized that your data might not be as clean as you wanted? Maybe the data is legitimately skewed, such as the massive swings that occurred during COVID. Or maybe the data has…
March 24, 2026
IBM Planning Analytics Tips & Tricks
Celebrating Pi Day with Excel’s =PI() Function
As you know from reading my previous blogs (The Hidden Structure of 1/7 and Exploring Consecutive Squares with 9/16/25), I am a big fan of combining math with dates. This week allowed us to celebrate another math date! Pi Day (March 14th) was just…
March 17, 2026
IBM Planning Analytics Tips & Tricks
Use the Planning Analytics AI Assistant for Smarter Data Analysis
Have you used Planning Analytics’ new AI functionality to analyze your existing models? Maybe you have a chart that you want to get insights on, or maybe you have a set of data where you want to define outliers. All this functionality…
March 10, 2026
IBM Planning Analytics Tips & Tricks
How to Remove Duplicate Elements from an Existing Subset in Planning Analytics Workspace
Managing large datasets in IBM Planning Analytics Workspace (PAW) often means dealing with complex lists of elements—from thousands of SKUs to extensive customer databases. In this edition of our IBM Planning Analytics Tips & Tricks series, Lee Lazarow, IBM Planning Analytics Practice…
February 3, 2026
IBM Planning Analytics Tips & Tricks
How to Create Picklists in Planning Analytics Workspace
Creating picklists in IBM Planning Analytics Workspace (PAW) is a simple yet powerful way to control user input and improve data consistency. In this edition of our IBM Planning Analytics Tips & Tricks series, Lee Lazarow, IBM Planning Analytics Practice Leader at…
January 20, 2026
IBM Planning Analytics Tips & Tricks
Performance Monitoring in Planning Analytics Workspace
Keeping your IBM Planning Analytics environment running efficiently is critical as models grow, data volumes increase, and user activity expands. In this edition of our IBM Planning Analytics Tips & Tricks series, Lee Lazarow, IBM Planning Analytics Practice Leader at Revelwood, walks…
January 6, 2026
IBM Planning Analytics Tips & Tricks
Exploring Consecutive Squares in Today’s Date: 9-16-25
Sheldon Cooper may like to have fun with flags, but I prefer a different approach: fun with dates! In my periodic (and made-up) series, I previously wrote blogs about the use of Excel’s DATE function and about July 1. Today is September…
September 16, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Focus Cell
As you all know, Excel performs subtle formatting when you click on a cell to graphically show you both the row and column of your cell. For example, if I click on cell B3 then Excel will highlight the headers in column…
August 12, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The Hidden Structure of 1/7: A Mathematical Perspective
Today is July 1. It’s the first day of the second half of the year and it’s also international chicken wing day. But for the purposes of today’s blog, none of that matters. What matters is that the reciprocal of 7/1 is 1/7, which…