Showing posts with label Analytics. Show all posts
Showing posts with label Analytics. Show all posts

January 15, 2021

 


Scenario Planning: Pivoting from Pandemic to Proactive

On a scale of 1-10, how far off was your 2020 budget? Feel free to go as high as 14.

We started off 2020 with a great deal of promise: “the roaring 20’s 2.0” with perfect 2020 Vision. Two months in, the global economy got slapped in the face with the reality of being a global economy. And yet, we persevered. How? By reacting quickly.

Reactionary Scenario Planning

Once the pandemic became real, every company that’s still in business quickly came up with multiple scenarios for how the impacts of coronavirus would affect the lives of their employees, the lives of their customers, and the life of their business. We took the information they had (which back in March 2020 wasn’t very much) and created financial plans. Most people had three scenario plans ranging from “short-term recovery” to “multi-year recession” though we all hoped for the best.

We took those scenario plans and we compiled a set of actions: What we would do if that particular scenario came to be the right one. Short-term recovery? Minimize discretionary spending. Year-long economic hit? Stop our least profitable products and locations. Multi-year recession? Stop everything that isn’t making money, cut costs dramatically, and determine how long until the money runs out.

And then the data started coming in. The economic dip was deeper and faster than 90% of the predictions anyone made, so we revised our scenarios down. The economic recovery after the massive drop was faster than 99% of the predictions, so we revised our scenarios up. COVID-19 turned out to be more deadly, longer-lasting, with cases and deaths coming in multiple waves, so we extended our scenarios around recovery. The vaccines were developed and approved faster than any in history, so we allowed for scenarios with faster resumptions of more traditional spending and economic activity.

2020 was a year of – to coin a new term I hope doesn’t catch on – Reactionary Scenario Planning. The CFO of Coca-Cola called it “Scenario Management.” Yes, we were coming up with possible scenarios, but only in response to events. We were looking ahead by responding to what had already happened. We spent 2020 reacting to the world. Things happened to us; we did not happen to things.

Proactive Scenario Planning

You made it. You’re in 2021. And many companies made it through the year by Scenario Planning. Japheth Jev, CFO at Triumph Power and Gas in Nigeria said in an article on Financial Management News, “We let the management and the board understand that this crisis would definitely affect us, and it was going to affect our customers' businesses and destroy some of our revenue lines. We assessed the risk and ascertained the level of impact that we are going to suffer. And we also introduced scenario planning. To be frank, I never appreciated the importance of scenario planning until the advent of COVID-19.” [It’s a great article, by the way, and you should go to https://www.fm-magazine.com/news/2020/dec/japheth-jev-managing-cash-during-coronavirus-pandemic.html and read some of Jev’s wisdom on crisis planning.]

But now 2020 is over (and no offense, 2020, but good riddance). We’re planning our scenarios for 2021, and we need to pivot from being backward-looking about potential scenarios to being proactive about the scenarios we want to make happen. Take a pause, look ahead and say, “now that the end is in sight, what are the most plausible scenarios for 2021 to 2025.” It might be “Global Expansion” or “Delayed Expansion” or “Let’s Definitely Not Expand Ever.” It could be anything from “our new products launched well in 2021” to “well, that didn’t work.”

On that note, you probably should throw in a worst-case scenario, because in the words of a great Cylon prophet, “All this has happened before, and all of it will happen again.” There will be another catastrophic event, so take the time now to plan for how you’ll respond to it, so you’re not reacting in the moment.

You will find that there are too many possible scenarios for you to plan for, so group them together into broad categories that cover the 3-5 most likely general cases. Expand them – drive them off KPI’s, so they’re easy to revise – into full financial scenario plans. Then take those plans and come up with a set of actions to prepare for those scenarios and how to respond to those scenarios if it turns out to be reality.

Most importantly, make sure those scenario plans are circulated widely. If some of the plans are dire – otherwise known as the “start updating your resumes” scenarios – make sure everyone knows what to do to avoid those scenarios.

Make 2021 the year where things don’t happen to you; you go out and happen to things.

Next Steps in Making the Pivot

Each year, I conduct a global survey of Business Analytics. Last year, I asked over 250 companies how they were doing in the world of reporting, analysis, planning, and consolidation.  If you want to see where you should be planning before it happens and you find yourself reacting to it, I’m unveiling the results on a webcast the last Wednesday of January. You’ll learn how your Analytics & EPM (Enterprise Performance Management) stacks up against the rest of the world so you can get there before everyone else. To register, go to:

http://epm.bi/webcasts

If you have any questions, ask them in the comments or tweet them to me @ERoske.

November 29, 2017

The Biggest Change to Reporting & Analysis in 2018 Won’t Be the Cloud

Screenshot from https://www.oracle.com/solutions/business-analytics/day-by-day.html

Companies spent most of 2017 either preparing their journey to the Cloud, getting started on moving their applications to the Cloud, or hoping the whole Cloud thing would go away if we just ignored it long enough (like my late fees at Blockbuster). But in the end, the Cloud isn’t revolutionary: the Cloud just means someone else is managing your server for you. While it’s nice that your servers are now someone else’s problem, there is an actual revolution happening in reporting & analysis and it’s a technology that’s been around for decades.

The Future of Reporting & Analysis Can Also Take Selfies

Up to this point, mobile has been an afterthought in the world of reporting & analysis: we design for a laptop first and if something ends up mobile-enabled, that’s a nice-to-have. The commonly held belief is that mobile devices (phones, tablets) are too small of a footprint to show formatted reports or intricate dashboards. That belief is correct in the same way that Microsoft Outlook is way too complex of an application to make reading emails on a mobile device practical… except that most emails in the world are now read on a mobile device. They’re just not using Outlook. We had to rethink of a smaller, faster, easier, more intuitive (sorry, Microsoft) way of consuming information to take email mobile.

Reporting & analysis will also hit that tipping point in 2018 where we ask ourselves simply “what questions do I need answered to make better business decisions faster?” and then our phones will give us exactly that without all the detail a typical report or dashboard provides. Will mobile analytics kill off desktop applications? No more than the desktop killed off paper reports. They all have their place: paper reports are good for quickly looking at a large amount of formatted information, desktops will be good for details (Excel will live on for the foreseeable future), and mobile will take its rightful place as the dominant form of information consumption.

Forget the Past and Pay Attention to the Present

The greatest thing about mobile is that everyone has their phone less than six feet from them at all times [you just glanced over at yours to see if I’m right]. But would you ever look at your phone if your screen took a month to update? Traditional reports are very backwards-looking. Your typical Income Statement, for instance, tells you how you spent the last year, it sometimes tells you about the upcoming forecast, but it rarely tells you, “am I making money at this moment?” Just like the dashboard of a car would be awfully useless if it gave you last month’s average gas tank reading – hey, I was 75% full in December! – mobile reports won’t be for looking at historically dated information. Instead, we’ll look to mobile to give us just the information we need to take physical actions now.

But Why is 2018 the Year of Mobile Analytics?

Quite simply, we didn’t have the technology to support our decisions until now. While we could take reports or dashboards and interact with them on mobile devices, we don’t want to actually perform analytics on our phones. We want the computers doing the analysis for us. While we’ve had data mining for years, it was relegated to high-priced data scientists or not-so-highly-paid analysts.

We now have artificial intelligence that can look through our data 24/7 and with no guidance from us, determine what drivers correlate with which results. Machine learning can then determine which information it delivers do we truly find useful. And so we don’t have to dig through all the results to find out what the system is trying to tell us, the mobile analytics apps in 2018 will convert complex information into natural language. It will simply tell us in plain English (or your language of choice), “I looked through all your information and here are the things you need to be aware of right now.”

While that may seem like distant promises to many people, it’s here now. At Oracle’s OpenWorld 2017 conference, there was an amazing demonstration of everything I mentioned in the last paragraph. The audience was even more amazed when told that all that functionality would be in Oracle Analytics Cloud before OpenWorld 2018. I’m sure the employees of Microsoft, Tableau, QlikView, and others are either busy working on their own technological magic or they’re busier working on their resumés.

Am I Ready for the Future?

Start finding out at EPM.BI/Survey. Each year, I conduct a global survey of Business Analytics. Last year, I asked over 250 companies how they were doing in the world of reporting, analysis, planning, and consolidation.  To participate in this year’s survey, go to EPM.BI/Survey and spend 15 minutes answering questions about your State of Business Analytics that you maybe haven’t thought of in years. In exchange for filling in the survey, you’ll be invited to a webcast on January 31, 2018, at 1PM Eastern, where you’ll learn how your BI & EPM (Business Intelligence & Enterprise Performance Management) stacks up against the rest of the world.

If you have any questions, ask them in the comments or tweet them to me @ERoske.

June 15, 2014

Oracle Tours Africa and the Middle East

Happy Father's Day, everyone!  I got up early this morning to write about my recent experience traveling the world on Oracle's behalf.  I got to attend the first annual Oracle Technology Network tour of Africa and the Middle East.  It made 2 stops in North Africa (both in Tunisia), 2 stops in Saudi Arabia, and the final stop was in Dubai, UAE.

Tariq Farooq first mentioned the idea of doing a MENA (Middle East & North Africa) tour to me in Beijing last fall.  He asked if I'd be willing to travel half-way around the world to speak to people in English that primarily spoke French and Arabic, and I - of course - said "yes."  Here's Tariq being interviewed by Lillian Buziak at Collaborate 2014 (audio is a bit difficult to hear):


I had two reasons for wanting to go: I do love educating/evangelizing for Oracle EPM, BI, and Business Analytics.  The possibility of reaching new audiences for the first time was exciting. My other reason for going was that I wanted to experience totally different cultures than I ever have before.  I've spoken on 5 continents (now 6 after this tour and I'm anxiously awaiting the OTN Tour to Antarctica) before and have seen presented everywhere from a women's college in Mumbai that was 95F with no air conditioning in the presentation room to a ballroom in the Philippines that had 3 simultaneous English sessions going on (in one room!) all happily observed by smiling Filipinos.  From China to India to Australia to Germany, I have seen some amazing slices of life, but nothing prepared me for the differences I saw on this tour.

In each of the sections below, I have linked the header to a blog from my new best German friend, Bjoern Rost.  He blogged after every stop and unlike me, he actually understood all the Oracle RDBMS sessions on the tour.  Visit http://portrix-systems.de/blog/author/brost/ to see his entertaining blog posts.  (Warning: though I think Bjoern is hilarious, being German, you may find his posts to be 'not funny.'  German humor is an acquired taste.)

I left for the first stop, Tunisia, on Memorial Day (in the USA), May 26, 2014...