IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Explorations – Row & Column Headers
Visualizations are used to provide an easy understanding of large data sets. After all, a picture is worth a thousand words. However, what happens when you want to see the intricate details of your numbers? This is where IBM Planning Analytics Workspace (PAW) explorations come…
September 7, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Allocations
P&L planning models consist of a variety of inputs, including revenue planning and various forms of expense planning. In addition to these standard models, we are often asked to develop other planning components. One of these components entails an allocation process, which leads…
August 31, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Columns and Sections of Stacked Columns
Today’s IBM Planning Analytics Tips & Tricks post is a new video demonstrating how to define the columns and the sections of a stacked column chart. You will learn an approach that allows you to quickly view your data in different formats…
August 24, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel DATE Function Updated
Some of you may remember an Excel feature that I posted about last year which explained how the DATE function will convert invalid dates into real ones. For example, DATE(2020,7,35) will be converted to August 4, 2020 since there are not 35 days…
August 17, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Lines vs Area for Multiple Elements
A line chart is typically used to show values over time. This type of chart is great to see trends with your data. An area chart is also used to show values over time and is sometimes referenced as a line chart…
August 10, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Code Char
Have you ever written a TurboIntegrator script and wanted to check the first character of a value to see if it was a number or a letter? Have you ever needed to insert a single or double quote into a string without “breaking”…
August 3, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Depreciation
P&L planning models consist of a variety of inputs, including revenue planning and various forms of expense planning. In addition to these standards, we are often asked to develop other planning components. One of these components entails a depreciation process, which leads to…
July 27, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Scatter Chart vs Bubble Chart
A scatter chart is used to show relationships within your data. This type of chart is great to see patterns and groupings over a large set of values. A bubble chart is also used to show relationships and it also great to see patterns. So…
July 20, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAW) Marker Shape
A line chart can either be a simple line or it can include markers for each data point. Most people associate a marker as a simple dot, but did you know that IBM Planning Analytics Workspace (PAW) allows you to configure the shape…