CubeServ Blog
Bleiben Sie auf dem neuesten Stand, rund um das Data Driven Business mit Tools für Analytics von SAP & Co. und verpassen Sie keine Neuigkeiten, Downloads & Veranstaltungen.

Navigating in the current situation – Scenario-based Forecasting – SAP Analytics Cloud

Navigation Kieler Woche

Who could have guessed the unprecedented global impact and disruption of COVID-19 when the first news appeared in early January 2020? 

Companies with exposure in China were hit early and fast but even then, nobody did foresee and most probably did not forecast a global disruption, nor did they run scenario based forecasting on that, nor did they have tools in place like SAP Analytics Cloud.

All that changed in early March when COVID-19 arrived in Europe. Governments were doing their best to control the spread with different phases of Lockdowns. 

At the same time, the management boards were faced with an unseen array of challenges which were unique to their business, their global footprint and even down to different business units. There were so many questions to answer without having a clear view into the future and so little time. What about the Supply Chain, Liquidity, Sales numbers etc. as well and most important, the well-being of the own Employees? 

As these would not have been enough to manage, ever changing government regulations were put into place without any lead time. 

On the right you see the Swiss Government’s plan to reopen the country (26.05.2020)

I trust that today (Mid June 2020); most companies are in some sort of rebound scenario or likely in a combination of various scenarios:

  • V– Fast but limited impact, almost back to normal
  • U– Fast impact and slowly but steadily recovering
  • W – Fast impact and hopefully not a second wave either Corona or e.g. GDP decline in some of your main markets
  • L – Fast impact but slow, continuous improvement

As mentioned before, companies are likely still facing lots of uncertainties and the FP&A Teams need to deliver and live up to the expectation of their management.

When I talked to our clients, there was, not surprisingly, a varied picture. Bottom line however is, that companies who invested into Business Partnering, agile processes and appropriate Software are better at managing the current crisis and feel more confident with their planning results.

Let’s look exemplary at Forecasting and Scenario-Planning:

In the traditional way, these are two separate topics. They are very likely run by different Teams with different background and knowledge. Forecasting is run at regular intervals and Scenario-Planning rather on-demand. While there is a Software solution in place for Planning/Budgeting/Forecasting, Scenario-planning might be an Excel solution.

However, there is an urgent need to move from Yesterday to Today. 

The circumstances or basis for the Forecast changes so fast that it is basically impossible to come up with a solid Forecast based on historical data. As well, the scenario plans undergo fast changes and they must be adapted fast. 

In other words, Forecasting and Scenario Planning are melting for the time being but maybe also in future.

Time for Changes

There is a need for a change to address this. Switch from a granular bottom-up to a high level top down approach and run the forecast more frequently. To accommodate this, internal processes need to change. The Teams need to change as well from a pure FP&A or Business Team to a Team with Senior, cross-functional experts who focus on a few but the right business drivers and KPI’s. 

This Team acts swiftly and frequently runs the Forecast and has the Market and Business knowledge to run appropriate Scenarios.
Additional dedicated teams are still needed for deep dive analysis and forecasting on a granular level.
All above needs to be supported by an agile Software solution which can be run and operated independently by the business. 

Just take a moment and try to reflect this to your current situation

  • Are you able to put together such a Team at short notice?
  • Do you know the few but important and right business drivers?
  • Can you measure them?
  • Do you have a software solution which does support you in finding the right drivers?
  • Does this solution support Predictive topics, Scenario-based planning, and the usual Forecast? And in such a way does it take out a certain Human-Bias in the analysis?
  • Are you able to make use of it in a way of Self-Service or do you need to launch IT Projects / Change Requests first?

Obviously there would be many more questions. If you cannot answer all of them with a clear YES, there is a Call to Action

Only about one fifth of large multinational companies were ready to respond to the management expectations.

I am not talking about a lengthy project with lots of people involved, hardware purchase etc. I am talking about a lean and fast project with the SAP ANALYTICS CLOUD (SAC).

You only need a Laptop, an internet connection, a browser, a license and the appropriate data set and there you go. Either you connect live to your ERP and/or Datawarehouse Systems or just import the data via Excel file into the Cloud.

For more information about the SAP Analytics Cloud, visit our SAC homepage and watch our Webinar for a first introduction:  Challenging Times for Finance & Controlling Dashboards, Augmented Analytics and Planning

Once you have the data, you can start building your own Stories (Dashboards) which you populate with Reports, Analysis, KPI’s, interactive Forecasts and Scenarios. All these, you can build on your own without relying on strained IT-Resources and avoid the hassle of lengthy change requests. 

The Augmented Analytics features (see my Blog and Webinar to this topic) supports your efforts in an easy way to get more insights into your data and to get a solid Scenario-based forecasting which you can adjust and run anytime based on real time data. 

We will demo all this during our forthcoming Webinar on 18th June 2020 and gladly invite you to participate. Should the time not fit your schedule, just get in touch with us for a 1:1 session.

The Webinars audience are the Finance and Controlling teams but, of course,  everyone is welcome to join. It will always include Live Demos and be held in English. 

Duration: approx. 60min, all times are CEST.

We are looking forward to get in touch with you. 

Newsletter abonnieren

Bleiben Sie auf dem neuesten Stand, rund um das Data Driven Business mit Tools für Analytics von SAP & Co. und verpassen Sie keine Neuigkeiten, Downloads & Veranstaltungen. 

Autor
Expert Team
Benedikt Bleyer
Adrian Bourcevet
Frederic Braukmann
Leopold Dumancic
Florian Gudermann
Aneeque Hassan
Johannes Kumpf
Roland J. Merz
Michael Meusel
Urs Mock
Drazen Pavlovic
Julian Rudack
Samuel Sarac
Thorsten Stossmeister
Aginthan Thavarajasingam
Jan Wiesemann

Blog Artikel unserer Experten

blank

openSAP Podcast – Die intelligente Personalplanung im Krankenhaus

Podcast der SAP mit Johannes Kumpf, Business Development Manager HR Solutions & Daniel Schneider, Management Consultant und Healthcare-Experte – beide bei der CubeServ GmbH. Eine detaillierte und zuverlässige Personalplanung ist in Zeiten von personellen Engpässen wichtiger denn je. Hierbei spielen Business Intelligence und Data Warehousing

blank

CubeServ INSIDE LOOK 08/21

In der Situation einer komplexen Krise benötigen Unternehmen Sicherheit um ihre Ziele zu erreichen und die Fähigkeit sich schnell anzupassen.

circular-barplot-with-groups

Advanced Analytics mit SAP und R

Warum sich mit der SAP R-Integration beschäftigen? Die überwiegende Mehrheit der Unternehmen nutzt fortschrittliche Analysen mit R- und SAP-Tools, um zukünftige Ereignisse zu prognostizieren und datengestützte, fundierte Entscheidungen zu treffen. Mit diesem Blogbeitrag zeige ich die Vorteile und wesentlich Zusammenhänge auf.

blank

Wenn ich nur wüsste….

Schön, dass Sie weiterlesen.  Aristoteles hat Neugier als Tugend verstanden. Im Privaten kennt man oft die intimsten Details über seine besten Freunde.  Aber wie sieht es im Geschäftsleben aus? Schauen wir uns ein Unternehmen an: Kennen Sie deren Strategie? Marktpositionierung? Eigentümer? aktuellen Herausforderungen? Und jetzt

blank

Cloud – Fluch oder Segen?

Die Cloud wird sehr kontrovers diskutiert. Die Vorteile stehen für mich in dem Vordergrund. Mit diesem Blogpost zeige ich Ihnen warum.

Auf dem Weg in die AWS

Auf dem Weg in die AWS

AWS Cloud: Wir migrierten in 100 Tagen unseren 50 Systemen. Ich gebe Ihnen hier einen Einstieg, so lernen Sie die AWS Cloud kennen.

We need to talk

We need to talk!

First of all, a Happy and successful New Year to everyone.  I know, you are all busy with Year End Closing but “We need to talk!” and I will keep it short. Well, quite some of you will connect this expression with something negative.  I

blank

Rapid changes in HR needed

COVID-19 is a typical Black Swan event. Nobody could foresee the global impact on our business and daily life. Rapid changes happened in HR but also other areas. We all struggle to get a clear picture about the future. Optimism helps and let us hope

blank

Best Practice Dashboard with SAP Analytics Cloud (SAC)

My colleagues and myself have talked a lot about Data Warehousing, Analytics, Reporting, Predictive and Planning in previous blogs and in several Webinars so far this year. However, we have not touched Best Practice in Dashboarding with SAP Analytics Cloud (SAC). Regardless of the solution,

blank

Integration von Machine Learning Pipelines in die SAP Systemlandschaft

Wie kann eine Machine Learning Pipeline mit einer graphischen Benutzeroberfläche in Ihrer SAP Systemlandschaft erstellt und voll-integriert angewendet werden? In diesem Blog-Beitrag zeige ich Ihnen wie es geht. Die Screenshots wurden im Rahmen eines Workshops bei der Swiss Data Science Conference 2020 mit SAP Data

blank

SAP Data Warehouse Cloud – Erfahrungen beim Aufbau eines Datenmodells

Sie verwenden Einkaufsdaten in Ihrem Reporting?  Profitieren Sie von unserem kostenlosen Template!Sie benötigen weitere Daten?  Profitieren Sie von unserer Erfahrung!SAP Data Warehouse Cloud ermöglicht zentrale Datenbestände leicht und intuitiv zu erweitern. Einführung in die SAP Data Warehouse Cloud (DWC) Die SAP Datawarehouse Cloud Lösung ist

Advanced Analytics

Wie Business Analytics erfolgreich gestalten?

Business Analytics einfacher ✅ und effektiver ✅ zu gestalten, ist herausfordernd. Ich stelle mit dieser Blog(serie) meine Lösungsansätze zur Diskussion. ✌