Blog

  • Books, books & the Kindle

    This device is almost as polarizing as American politics. Crazy! I spend close to 200 days on the road per year and to me, this thing is the best thing since sliced bread…well…almost. I am talking about the Kindle – Amazon.com’s eBook reader. We are in the middle of the holiday season and many of us still hunting for presents. Many of us have to read a ton to stay current with business practices and we also travel. As a result, I wanted to share some thoughts about the Kindle. I have had one for a long time. Since the very first version. It is an amazing, yet extremely boring piece of technology. I do recommend it to anybody who likes to read and travel.

    AMAZING STUFF

    Kindle vs the iPad

    This Kindle is amazing because it allows you to read books on an electronic device that doesn’t feel like one. The Kindle is as light as a small paper back and the screen looks and feels like a real book. When you first read something on the Kindle it feels almost fake. Yes, the screen does look that real. Start reading something on a Kindle and you will notice that it ‘disappears’ within  a few seconds of reading. You just become one with the content. Just like with a real book. And you can read it anywhere. The screen is just as good as any book. Event at the beach.

    COMFORT

    The Kindle is extremely light. You can hold it easily. It is actually a lot easier to hold than many books. I have read books on a plane (less space needed), on a train, on a ship, in a car, in a bed, at the coffee machine and on the beach. It simply feels really good in your hands. Much easier to handle than a book. Seriously.

    HEAVY STUFF

    And then there is the capacity. I used to travel with a bunch of books. No more. Books are heavy. eBooks typically don’t require much storage and the Kindle can easily hold 100s of books. Perfect. Think about going on vacation. One tiny device instead of 5 hard-covers.

    REAL-TIME

    You see a book and you want it. The Kindle allows you to download books instantaneously. Once again…great for traveling. And they are typically pretty cheap.

    NOTES & HIGHLIGHTS

    One of the best things about the Kindle is the ability to highlight sections, to annotate them and to bookmark pages. The kicker is that you can download the highlights and annotations to a PC or MAC. Extremely useful for business books. I love having a txt file with all my highlighted and annotated sections. It is perfect for sharing with friends & colleagues or to use stuff for presentations.

    THE iPAD

    The Kindle iPad App

    Some people thought that the iPad would kill the Kindle. Not really. The Kindle is like a real book. The iPad is icing on the cake. The Kindle App works extremely well. Books synchronize with the Kindle so you can read books on both devices. In terms of actual reading, I do not like the weight of the iPad. It is quite heavy. And the screen is not suited for reading outside. There is too much glare. BUT the iPad works extremely well for certain graphics-intensive books. Reading business or photography books on the Kindle is a real pleasure. So the combination between both is great. But the iPad is definitely not a Kindle killer to me. On the contrary: it really enhances the Kindle experience.

    THE BORING STUFF

    Did I mention that the Kindle is extremely boring. Perfect. It looks a bit dull and there isn’t much you can do with it. Sure. You can browse the web but it is a poor experience. There are some games, but they suck. Really boring. Some bloggers have called that the biggest flaw of the device. One magazine was disappointed that the Kindle wouldn’t support Voice over IP. Hmm. Not really. When is the last time, we placed a call using a book? The Kindle’s lack of functionality is its greatest asset: it retains the real character of a book. I sometimes read on the iPad at night. But guess what: I end up checking email, looking at Twitter, surfing…it is just too tempting. That doesn’t happen with the Kindle. It is a real eBook! And that is awesome.

    Shhh…THE SECRET

    The 3G version of the Kindle allows you to go online pretty much anywhere around the world. That means you can access social websites like Facebook and Twitter. There are some countries on this planet that do not like social media and they block access. Not with the Kindle, apparently. When I traveled to China I noticed that I could get my tweets. At first I thought that it must have been a mistake. But when I returned from the trip, I found some reports that confirmed my suspicion. (see…the Kindle is revolutionary!)

    THE UGLY?

    Honestly, there isn’t anything worth writing about. The Kindle is that great. Sure. It could look a bit nicer. I certainly do not like the fact that I have to turn it off during take-off and landing. But I honestly don’t care. The Kindle has allowed me to read a lot more than I used to.  And it is really fun and extremely comfortable. Hope you are enjoying your eBook readers as well!

  • Cool software? The Connected Business – Part 3

    Yeah, those spreadsheets. Welcome to part 3 of this series of posts. An interesting special section in the Financial Times prompted me to post a quick summary with interesting quotes. But the report did not necessarily provide some specific details about why spreadsheets make our lives difficult. Part 2 then focused on the particular pain points we all experience in our daily business lives.

    THE PROBLEM & ANSWER

    But how exactly does Business Analytics software help and how can we replace spreadsheets? I get very frustrated when I read white papers that talk about ‘gaining efficiencies and critical insights with the push of a button’. There is so much BS talk out there. And as a result, I find that there are many managers out there that still don’t understand what technology can do for them. It’s time for clarity, isn’t it?

    A FAIRY TALE?

    Let’s take a look at one of my clients. When we first met, the new CFO was extremely frustrated with the tedious annual budgeting process. A team of six well paid finance professionals spent almost seven months pulling the annual budget together. The entire process was run through spreadsheets. The team spent an awful lot of time managing the 250 something workbooks for the different cost and profit centers. Complex formulas had to be fixed, data had to be copied & pasted from SAP R3, files had to be distributed and collected, reports had to be manually compiled and reconciled. In other words: it was painful and the team of six had very little time to do something fun. Their workload was extremely close to the picture we discussed in part 2 of this post.

    HERE COMES THE SOFTWARE

    The CFO decided to do something and selected Cognos to help automate the budgeting process. It was actually a rather short project with only 35 business days for the expense budget. Cognos replaced the entire spreadsheet jungle. But why and how did it help exactly. Here are some basic examples:

    • Centralized model maintenance: One of the key issues with spreadsheets is formula maintenance across different workbooks and files. Instead of copying and pasting, BA software allows me to maintain my formulas in a central repository. One change in one place only. That saves a ton of time and also ensures data integrity. How is that?
    • Automated interfaces: Why should we have to manually load actuals or other data from transactional systems into spreadsheets? There is a lot of risk (apart from the boring manual labor). BA software allows you to run automated interfaces. Just like in our transactional systems. Nothing fancy. It just works. And it saves a ton of time and frustration.
    • GPS: One of the other frustrations with spreadsheets comes from the inability to track progress. A simple question like: “Has Ted started his budget?” can be extremely difficult to answer. The file is not on the central server anymore as Ted is out on a business trip (and then he deletes his file by mistake..). BA software allows us to keep track of progress and it stores all the data in a central repository. Again…a very simple thing. But extremely effective. Imagine a spreadsheet with a powerful GPS on the roof!
    • Cool interface: Working with a spreadsheet template can be very frustrating. Either the templates are completely locked down or they are so flexible that I can break them. Modern software provides us with easy-to-use interfaces (web-based). They are actually fun to use and I can customize the layout to my personal needs – all that without breaking the model. This is a great way to engage managers that are not so technology-savy.
    • Automated aggregations: Getting a snapshot of your budget can be a bit tedious with spreadsheets. We need to make sure all files are accounted for so that we can link our master spreadsheet to them and aggregate the numbers. BA software takes care of that….in real time. All the data is stored in a central repository. You need a snapshot? Give me a minute. Here you go!
    • Easy analysis: Performing detailed analysis on a spreadsheet budget can be extremely difficult. Management decides to make some top-down changes and finance then has to figure out how to push this into the different organizational units. Asking some what-if questions can turn into a tedious exercise. BA software allows us to perform analysis in real-time. It’s that simple. We make change somewhere, and we can report on that right away. Cool!

    Ok…I admit it. This is probably a bit ‘salesy’. But that’s the way it is. By the way, this particular client is now able to turn the entire budget around in less than 1.5 months. They actually like the budget process (scary thought?) now. It’s nice to talk about this but it’s better to see this in action. Why don’t you come and join one of our global workshops?

  • Spreadsheets Confidential – The Connected Business – Part 2

    The other day I wrote about the special section of the Financial Times called ‘The connected business’. One of the key take aways from this section was the fact that way too many finance departments are putting their faith into spreadsheets.

    A few years ago, my team started conducting some surveys amongst finance professionals. For this purpose we teamed up with David Axson (co-founder of the Hackett Group, book author). We specifically went after professionals that were not using Performance Management software, yet. One of the key things we were interested in was the type of work finance professionals do. It quickly crystalized that there were five major categories of work. The results looked like this:

    Cognos Finance Survey 2008

    The majority of the time is apparently spent on manual tasks such as collecting data (loading data from systems into spreadsheets, copying & pasting, manually entering budgeting numbers, etc..), maintaining spreadsheets (development, fixing formulas, aggregating spreadsheet data, Visual Basic programming etc.) and then also developing reports & presentations (creating spreadsheet reports, graphs, Powerpoints etc.). Only about 20% of the overall time is apparently spent on the high-value tasks such as performing in-depth analysis, running what-if scenarios, personal development etc.. A shocking but not a surprising picture. When we present the results to finance professionals we get a lot of head-nods. But I often sense a certain level of resignation as well (“Oh yeah….I know….that’s just the way it is.”).

    Statistics are always a bit dry. So we took the data and applied the percentage distribution to a work week. The picture now looks quite interesting. What do you think?

    Cognos Finance Survey 2008 – part 2

    How does this feel? Same numbers. Just a different perspective. Two key questions come to mind: Can we live with that situation? Would we want to live with this situation? I doubt it. I have been there and didn’t necessarily like this. Sure, it’s nice to play around with spreadsheets knowing that you are indispensable. But is that what we want to get out of our professional lives? Is that why we went to business school? Is that why we spent so many hours studying for the CPA, CMA, CFA exams?

    Technology helps shift this picture around tremendously. We can literally reverse this. I will write about that in the next few weeks. For now, I will leave you with this picture. Take a look at your own work environment. How do you get things done? How do your clients operate? Is there room for improvement? Would love to hear your thoughts and about your own experiences.

  • The connected business?

    The Financial Times from December 8th 2010 included an interesting special report called “The Connected Business”. A bunch of great articles about technology in the office of the CFO. One thing that caught my attention was the fact that the entire section highlighted the problems caused by the use of spreadsheets.

    For people who work in the field of Business Analytics it has long been clear that while spreadsheets are useful, they are not the right tool to manage your company. People like us sometimes take that knowledge for granted. Here are some interesting pieces I picked up in the section.

    Nigel Rayner from Gartner is quoted as saying: “But when I talk to them [CFOs] about management reporting, understanding the drivers of profitability, forecasting or planning, all they know are spreadsheets because they have always done it that way. They are not aware of how the technology market has developed.” Andrew Meade from Accenture confirms this notion in another article: “Most companies bemoan the fact that they have a spreadsheet jungle.”

    Mr Giles Thomas from Revolver system highlights some of the inherent risks: “Businesses that start using spreadsheets for a specific purpose can get grabbed and they never escape. When you have a spreadsheet with thousands of rows in it, things can get quite nasty.” He highlights this problem with the case of an unnamed investment company: “For several months, they had been running the business on numbers that were meaningless. When people copy and paste, they often forget to incorporate the changes they have made.” The FT then highlights some of the other associated risks like proliferation, tracking, version control etc..

    One article raises the question of whether the massive use of spreadsheets is likely to change in the near future. But the somber conclusion is: “He (Mr. John Van Decker – Gartner) and other business analysts do not see this situation changing quickly, because they say most business and finance education does not address these issues“. Mr Rayner adds “It is a cultural issue, because finance folks tend to be very conservative. They are comfortable with what they know, which is spreadsheets, and having an army of spreadsheet jokeys.

    The point about education is an excellent one. I used to be an active  member of the Institute of Management accountants (IMA). The organization itself is great and I highly recommend their professional degree CMA (Certified Management Accountant). But they consistently frustrate me with their singular focus on spreadsheets. Hundreds of articles in their publications teach people how to leverage spreadsheets. They offer courses for managing a complex budgeting process with spreadsheets. Time to wake up, from my perspective.

    The conclusion? Well, the section does offer some nice examples of how technology helps and I will continue to write more blog posts in the near future about that. But the key finding for me here is the astonishing fact that there is a serious opportunity for all of us. As a CFO I have the ability to gain a serious competitive advantage (or: to avoid disaster) and as a Business Analytics professional I can make a serious contribution to the success of many businesses. Let’s use this opportunity.

    E9RBNEHCCAP3

  • Behind the scenes – Middle East Cognos 10 launch

    Snow. Massive amounts of snow. And it’s really cold. Hmm…Do I really want to leave here? Greetings from Dubai airport. My colleague and I are stuck here right now. Most flights to Europe are delayed due to winter weather. Oh well….the joys of traveling. But this trip was really worth it. We just finished a three-country tour through the Middle East for the Cognos 10 launch. Three days, three cities. Three amazing launch events in Dubai, Qatar and Kuwait. Some of the customers I talked to were wondering what it was like to execute such an event series. Well, here is a little peak behind the scenes.

    The amount of work that goes into these large customer events is crazy. Our great marketing teams spend a lot of time arranging locations, speakers, food, drinks and inviting customers etc.. Luckily, I hardly ever get involved in these activities. But let me say that much: I admire my colleagues for consistently doing an amazing job. It really makes a difference. I get to focus on the content and the presentation delivery.

    For this particular event series, we had to leave Munich on Saturday evening to get to Dubai in time. The first event started on Monday. Getting up in a new time-zone always hurts on the first day. And so day after day we rush out to the event location early in the morning to setup the room, prepare the laptop, make sure that all the demos are working, check the microphones, upload additional presentations from other speakers etc.. I am always amazed at how much can go wrong with these type of events: The demo that worked in the morning suddenly stops working. The laptop shuts down without notice. The beamer does not receive a signal. Murphy’s Law?

    The event in Dubai was a success but I am tired after delivering three presentations. Right after lunch, our team of close to ten people rushed to break down all the banners, pack up brochures, badges, lists etc.. Then off to the airport with a ton of extra luggage in hand. A few hours later, we sit down in Qatar for a quick debrief and discussion of the next event. There is always some tweaking that needs or should happen. Every country is different. Cultures are different. Audiences are different. There is no one-size fits all. Each and every presentation needs to be customized.

    The next morning looks similar. Setup at the hotel around 8am, preparations and then another round of three presentations with a few breaks between. Before heading off to the airport with all our extra luggage, a journalist from the Qatar Tribune comes over for a quick interview about the launch. We finally arrive at our hotel in Kuwait around 9pm. Quick shower than out for a quick team dinner at a local place. Back at the hotel I can’t remember my room number and head back down to the reception. Long day.

    The 7am wake up call feels like a scene from the movie Groundhog Day. Shower, pack, quick breakfast, taxi to event location, setup the laptop, discussions with the local team and a quick cup of java. As much as most of this is really busy routine work, I always get excited when the event finally starts. Presenting our products and talking to customers is a privilege and it is a lot of fun. Luckily, the Kuwait event was very special again. The audiences in all three countries were great. Unfortunately, I had to leave for Dubai right after the final presentation. On the way to the airport, my colleague noticed that the cab driver was falling asleep. So we engaged him in a discussion even though he did not speak a word of English. The surprises never end. Check-in at the Air Kuwait counter and then a quick snooze on the plane.

    Waiting for the flight

    8pm…I am checking into my hotel room in Dubai. 8:01pm….I am checking out my mind but I am very grateful for four special days with amazing colleagues & customers. But everything seems like a blur now. Too many impressions to process at this point. But it feels good.

    Some final statistics:
    Days: 4.5
    Total travel time: 32h
    Presentations: 8
    Tired: Yes!

  • Collaboration and BI?

    One of the first things we learn from our parents and teachers is that we are stronger when we act as a team. 1+1=3 or something like. And it is true! I have had some of my best learning experiences in a team environment. Every once in a while, we forget just how powerful teamwork and collaboration can be. We get stuck trying to solve a problem by ourselves and we loose a lot of time. Okay. Everybody knows that.

    But what about Business Intelligence and Business Analytics? Are we really collaborating with that team idea in mind? Even more important: even if we wanted to collaborate, would we be able to do so in an effective and efficient manner?

    What does collaboration for BI and PM look like. Think about the following common situation. It is early Monday morning and you conduct some analysis in your BI portal. You quickly realize that there is a big problem. And you have no idea what to do about it. The first question that comes to mind is whether anybody else has come across this issue. But what do you do? It’s early in the morning. Nobody is in the office.

    Social media are changing the way we communicate with each other. Email did that for us 15-20 years ago. Today we are at the start of a new revolution again. Twitter, Facebook, Flickr etc allow us to collaborate in an unprecedented way. We can leverage the wisdom of large crowds of people. People we don’t even know. The other day, I had a problem with my camera. I sent out a tweet with a question about it. 20 minutes later I had the problem solved with the help of other photographers out there on this planet. And this new way of collaborating is now entering the corporate world.

    Back to our little Monday morning problem. We still have no idea what to do. Imagine we could quickly identify whether another colleague had reviewed this dashboard and come across this problem? What if you could see what steps they have taken to identify a solution? Wouldn’t it be nice to search for similar problems and find out how colleagues fixed this in the past? How about we could help other team members by contributing to their questions?

    The time is right. We should be able to collaborate in our corporate world just like we collaborate in our private lifes. Cognos 10 allows us to just that. We can comment on dashboards, reports, cells, graphs. We can share activities, we can assign tasks. We can discuss, review and share. Just like we do on Facebook and Twitter. Within our own company. I have had to opportunity to test this functionality and I love it! But most importantly, the many customers I have shown this to love it just as much. When I return from travels through Europe and the Middle East I will share some additional thoughts and reactions about this. What do YOU think about this?

  • Postcard from Moscow

    Greetings from Moscow! We just finished an incredible IBM Cognos Performance event. Over 450 customers spent the day to discuss the latest news in Business Analytics. It was a busy day for me up on stage: keynote presentation, two technical sessions and a press conference.
    The Cognos fans in Moscow

    Before I start repacking my bags for the next trip on Sunday, I wanted to share one interesting fact with you. The biggest discussion topic on Moscow was Collaboration. Facebook and Twitter have changed the way we communicate. Email did that about 20 years ago. People are now demanding the ability to collaborate and communicate in business just like we do in our personal lives. More about that in a few weeks. Off to Tel Aviv, Vienna and Madrid this week. Hope to see you there!

  • The power of Data visualization

    We all know that visual information display is more effective. But yet, we still create, run & analyze hundreds of thousands of flat reports. A survey from 2007 (CFO Executive Board) found that the average management report is 30-40 pages long and that it contains 12000 to 15000 data points. But only 5% of those are deemed to be important. The most obvious question that comes to mind is: How much time is wasted to go through this amount of data and turn this into real insights? Would it help to start using more powerful visuals to display the hidden meaning behind all those data?

    Watch this inspiring and entertaining speech by author, journalist & visualization pioneer David McCandless. I will blog about some of his ideas and how they relate to business at a later point.

     

  • The Speed of the Dragon

    The other day I met a good friend of mine. We hadn’t seen each other in a few weeks. But it felt a lot longer than that. A ton of stuff had happened. A sign of the times? The speed of business and our personal life seems to increase steadily. The economy already feels like a freight train racing through the night. But I believe that we are about to ditch that train and replace it with a high-speed bullet train.

    ENTER THE DRAGON

    At the end of August, I had the opportunity to run a bunch of performance management workshops for finance professionals in China. I do have to admit that I was blown away by what I saw and experienced. Hustling & buzzing cities, shiny buildings, fancy airports, giant construction sites and many ambitious people. Many, many ambitious people. People that are starving for success.

    Early morning traffic & smog in Beijing

    THE SPEED OF CHINA

    Time seems to run faster in China. Construction sites are open 24*7. Co-workers from that region told me stories about areas of large cities changing within just a few weeks or months. Changes that would take years in the US or Europe. And that was evident everywhere we looked. Our hotel had just opened a few weeks before.

    THE STRADDLING BUS

    But there was one story that really told the story of Dragon Speed. Right about when I left for this 14 day trip, some newspapers reported that Chinese engineers had developed a futuristic concept for a straddling bus. This bus literally straddles the road. Passengers sit in a cabin high up over the street allowing cars to travel underneath it. Well, that was a concept. We didn’t think much of it at first. But I almost could not believe my eyes when I read the paper in the Air China lounge on the way back to Europe: The city of Beijing had reviewed and approved the concept. And not only that: they were expecting to have a working prototype with the next 6-9 months. Wow.

    THE ECONOMIST

    In 2007, the Economist had predicted that China would overtake Japan as the 2nd largest economy in the world within the next ten years. It only took three years. What’s next?

    Western governments & businesses will hardly be able to ignore this trend. We will all have to pick up speed and it will affect businesses across the globe. It will be ever more important to make sound decisions quickly. Performance Management plays a crucial role in this.

  • Unleash my talent?

    Greetings from the IBM Cognos Business Analytics Forum. IBM just released the latest version of Cognos: Cognos 10. The general theme around this new product is: Intelligence Unleashed.

    The theme is quite powerful and it made me think about how most of us conduct our work. I have met many clients that are still struggling to gain control over all their spreadsheets. They struggle to reconcile data between different systems. As a result, many professionals spend way more time on mundane and non-value added tasks than on inspirational and high-value tasks. As a matter of fact, a survey that we conducted a few years ago revealed that finance professionals spend over 70% of their time on administrative things. Many people that I talk to feel that they are not using their talents appropriately. A customer recently joked: “The CPA credentials that I have worked really hard for stand for Copy & Paste”. That’s a tribute to the enormous amount of manual labor conducted by her and her team.

    Isn’t it time to take things seriously? Is this the way we want to work? Shouldn’t we start spending a lot more time on the exciting and analytical tasks? Technology like Cognos 10 allows us to automate processes and to seriously increase our analytical capabilities. Just imagine if we could spend time on all the cool and exciting things that we learned about in business school. The tools are there to help. Let’s start unleashing our very own talent!