Use AI to transform your spreadsheet into a next level solution with IBM Planning Analytics

In one of our previous blogs, we referred to the new IBM Planning Analytics “On Demand” solution that enables organisations to quickly start using the leading software from IBM for reporting, planning and forecasting, by installing a free trial or paying a small subscription fee of less than 50 euros a month to get started. In case you missed it, you can read our blog here and learn all about it.

This new solution offering has been set up for small and mid-sized organisations that want to evolve from a manual budgeting and forecasting processes to an automated, artificial intelligence (AI)-powered process. IBM Planning Analytics allows you to transform your existing spreadsheets into a professional model, including cubes, dimensions, metadata, data and reports.

Curious to learn more about this? In this blog we will guide you through the first steps.

How to get started? Create your own free trial account!

If you do not have a free trial account already, you can start by creating one and request a trial environment. This by easily click here and choose the button “Start Your Free Trial” to begin.

Once you have created your account, you can login and immediately see the welcome page including tutorials on how to begin. From this page, choose the starting point “Start from a spreadsheet”.

IBM Planning Analytics “On Demand” Welcome Page

Use IBM’s AI power to create your own planning model

Once you have logged into your account, you have two option to get started. You can upload your own Excel file, or if you are just curious about how it works, you can use a sample spreadsheet provided by IBM.

First, the wizard guides you through 3 steps to build your own model:

  1. Import spreadsheet
  2. Analyse spreadsheet using Artificial Intelligence
  3. Create the suggested model

In our case, we use a spreadsheet that includes sales figures per area and product.

IBM Planning Analytics automatically analyses the data structure and provides us the number of tables, populated cells, formulas found, etc… As you can see in the overview below.

IBM Planning Analytics using AI to analyse my spreadsheet

Then, IBM Planning Analytics shows us the suggested model for the application, including the multi-level structures:

  • countries roll up in areas and regions;
  • products are clustered in product segments;
  • product families and revenue are grouped per month and quarter.

Next, we can rename and expand the suggested model as we wish and move forward to the actual creation of our model. The ability of using as much dimensions as desired in our model is one of the key benefits of the powerful OLAP-engine that is included in IBM Planning Analytics. If you are not familiar with OLAP and the benefits for reporting and forecasting, we suggest you read our blog about “The Basics of OLAP data modelling”.

Suggested dimensions

Once the Spreadsheet Transformation Utility has automatically created our model, we see our cube(s) that have been created and can start exploring the data by using filters or slicing and dicing.

Automatically created revenue cube and data exploration

Via the guided wizard – supported by text and video – we can now easily create our own dashboard. As an example below, we see a dashboard which we have created in less than 15 minutes.

Create your own dashboard

To end with a great feature, IBM Planning Analytics provides the ability to not only read data, but also write-back data into the database. When we look at the planning workflow, we can add columns to enter data into the model for example for forecasting, including business rules to calculate KPI’s and grant access to colleagues to the model for collaboration purpose.

How to start with your own spreadsheets?

By walking through these steps, we are very impressed with the features offered and the user friendliness of the application. For us as a business user, it was easy to create a model in less than one hour, including an interactive dashboard to view the data.

This is truly a self-service application to easily build a planning, forecasting and reporting solution.

If you want to learn more about how to get started with your own spreadsheet?

Check out this short YouTube video (3 minutes), immediately start your own free trial or contact Aexis for more information on this topic. We are happy to help our customers benefit from the potential of this solution!

IBM Planning Analytics On-Demand — An introduction to what you can achieve

You may have read about “IBM Planning Analytics On-Demand”. It is the newest offered IBM solution for planning, reporting and forecasting, offered at a subscription starting at less than 50 Euros a month. 

What is included in the offer and what can you realize with the solution? 

IBM Planning Analytics? 

IBM Planning Analytics is the AI infused planning, forecasting and reporting solution offered by IBM. The heart of the solution is the “TM1 server”; the powerful calculation engine which has proven to be capable of working with large data sets and  perform fast real-time calculations. This makes IBM Planning Analytics a perfect tool for forecasting and scenario-analysis. This software has been available as both a SaaS and On-premise offering for years. 

What is Planning Analytics “On-Demand”?

IBM Planning Analytics On-Demand is the easiest way to start  with a  low-cost planning and reporting solution focussed on self-service for one single user of a smaller user group. 

IBM Planning Analytics On-Demand includes:

  • Web-based analysis, planning, reporting and modelling capabilities 
  • Start with one user and one data model; easily add capacity on-demand to support more users and applications
  • Pre-build templates to start and play around. Also, guided tutorials and training contents is included to allow a quick start

IBM Planning Analytics On-Demand overview

From a technical point of view this means you will get a cloud hosted multi-tenant environment with one or multiple containers, each including an individual database of 2 Gigabytes maximum. You can integrate your own data via CSV-files and you can use IBM Planning Analytics Workspace to build planning models, reports and dashboards.

You can create multiple applications by adding databases to your subscription at any time. However, you cannot exceed the 2 GB maximum database size. Very important is that databases cannot be cumulated because they exist in separated containers. Also, you cannot use the Excel Add-in but are restricted to work in the web based interface (IBM Planning Analytics Workspace of  “PAW”).

When would I need to upgrade to the‘full version’?

The IBM Planning Analytics On-Demand version is a great way to start for small user companies, departments or if you are just a single employee and just want to solve a spreadsheet problem.  The software comes with great functionalities, but is of course restricted. While you can invite your colleagues, larger applications and large user groups are not supported. The full version, usually referred to as “Enterprise” for instance allows you to host large planning applications with connections to various data sources.  Features that are included in the full version among others, are:

  • Large databases– e.g. 128 GB or even 2 TB(!)
  • Direct connections to source data via the REST API or ODBC enabling you to connect with multiple cloud and local data sources.
  • Interface to other IBM software products such as IBM Controller and IBM Cognos Analytics.
  • The powerful Excel Add-In to use the data in Planning Analytics directly in Ms Excel.
  • Advanced features to set up security and access control compliant with your organization’s policy

IBM Planning Analytics Enterprise Added value

How can you start?

New to IBM Planning Analytics? You can directly start with your IBM Planning Analytics On-Demand subscription.

If you have already started with a free trial before, you can also directly move forward from here to an On-Demand Subscription.




Want to know more?

Feel free to leave us a message via this website or just email me at

Also, make sure to check out our Events page and subscribe to our events and webinars. New webinars about IBM Planning Analytics and the benefits of integrating AI into your forecasting process will be published next week.

Want to start with your IBM Planning Analytics On-Demand right away? Fill in our form and we will help you!

    I agree to receive information from Aexis about their solutions.


    Loading page, please wait.