Category: Analytics

  • Updates, updates, updates

    Busy times

    Wow. It’s been a busy but exciting week. There is a lot going on in the business analytics space these days. Here are some updates that you might find interesting.

    Analyticszone.com

    • On Tuesday, IBM launched a revolutionary new solution that combines. IBM Decision Management combines business rules, optimization and predictive analytics to embed intelligence into the fabric of organizations’ decision making. Along with that IBM also launched various new versions of other products like SPSS Modeler, Cognos Express etc.. You can watch a replay of the launch event.

    That’s it for today. Short and sweet. Have a great weekend!

  • TM1 – The swiss army knife for the finance department?

    IBM Cognos TM1

    No doubt, IBM Cognos TM1 is a unique solution. I have never met so many loyal and enthusiastic long-term customers than for any other finance-related software solution. TM1 is special indeed. There is a lot to like: it is lightening fast (64-bit in memory), configuration does not require rocket-science, it supports Excel, there is a great-looking web interface etc.. But one of the biggest benefits is that TM1 is very flexible. You can do many things with this solution. Usage is not limited to just planning and forecasting. It is not limited to the finance department but it can be leveraged across the enterprise for a plethora of business problems. And that is why many people say that TM1 is as versatile as a Swiss Army Knife.

    What can you do?

    What can you do with IBM Cognos TM1? A good colleague of mine recently put an interesting slide together. It shows various applications that European customers have built. This is not an exhaustive list but just a snapshot of what is possible.

    TM1 Usage

    Much more…

    Does this inspire you? Find out more about TM1 by reading my interviews with the author of the IBM Cognos TM1 The Official Guide. And if you haven’t bough the book itself, make sure to pick up a copy sooner than later.

  • The robot – a case study about the value of process automation

    The case for process automation

    Many business analytics programs follow a classic approach – they start with process automation. It is the low hanging fruit. Executives and project managers like process automation as it is usually easy to measure and identify the benefits (e.g.: cycle time reduced by 2 days, aggregation is 60% faster). However, that raises a question: What happens with the ‘free time’. Can automation lead to higher effectiveness as well? Let me tell you a personal story….

    Stuck in the process

    AutomationMy wife and I hate mowing the lawn. Our garden is not all that big but it still takes us around 1.5hrs per week to get the task done. Setting up the equipment, getting the stuff cleaned and put away consumes the majority of the time. We do not enjoy any of the involved tasks. It’s just a waste of time without any added personal benefits. It’s really just basic garden maintenance without any kind of physical improvements over time.

    Last year was really busy for us as a family and we often neglected the lawn for obvious reasons. As a result, our garden looked like a football field at the end of a season. It was not pretty. We ended up not enjoying ourselves in the garden.

    The robot

    A few weeks ago, we made the decision to invest in a new tool – a robot for mowing the lawn. It is a tiny and friendly 10lbs car that whizzes around your garden while mowing the lawn. It works extremely well and it is fun to watch. Setting it up every other day takes about 2 minutes. It doesn’t need any major cleaning and there are no wires. Pretty cool stuff. This saves us a few hours every week.

    Process automation in action

    And what are we doing with the time savings? Well, here is the honest answer: we spend more time working in the garden than ever before. However, it is time well spent and we have more fun doing it. Why? Very simple: the garden always looks nice and fresh. That in turn has inspired us to do more. We now frequently dedicate time on improvements and enhancements that benefit our family. The efficiency gains have effectively been translated into effectiveness gains. And this is a self-perpetuating process. It is contagious.

    Robomow

    Business analytics and process automation

    Process automation with business analytics often allows us to dispense with mundane and boring tasks. Think about spreadsheet maintenance. Think about copying and pasting data from one system into another spreadsheet. Think about fixing formulas that don’t work. That type of work typically zaps energy. Process automation allows us to get rid of the boring work that does not add value to us personally and to our company. Getting rid of the mundane work allows you to focus on the important things. And that’s where the true benefits are.

    Once we gain time, we often identify improvements. Our energy and motivation increases as well. Trying to improve things without process automation is tough.

    Take a look at your business analytics projects. Are there opportunities where you can leverage the power of process automation?

  • Success with Performance Management – An interview with Mark Lack from Mueller Inc.

    The 80 year-old company Mueller Inc is a a leading manufacturer of pre-engineered metal buildings and metal roofing products. Mark Lack is responsible for performance management at Mueller Inc. He delivered a great presentation about their IBM Cognos implementation at  the recent IBM Vision 2012 event in Orlando. Following his session we sat down for a short interview.

    Christoph Papenfuss: Mark, tell us about your role at Mueller Inc.

    Mark Lack:  I was hired to manage the planning and forecasting function and as my role evolved Strategy Management and Business Analytics became a natural extension.

    Christoph Papenfuss: Did Mueller already have established performance management processes when you joined the company. Can you provide examples?

    Mark Lack: Yes, it was Excel based.  I can’t say it wasn’t sophisticated because it was.  Lots of automation and VBA scripts to manage the roll-ups.  The problem with the system was the inordinate amount of time it took to perform manual manipulations. Ultimately it rolled up to a series of financial performance items.  The process was long and complicated, and in the end we had difficulty matching the output with the actual drivers of the performance.

    Christoph Papenfuss: Reporting and Analysis was difficult then. What about the planning and forecasting process? Did you encounter any difficulties?

    Mark Lack: The budgets weren’t kept in our main ERP system, only in Excel. We had to manually type in 300 lines of actuals each quarter in order to run variance reports.  Invariably we would encounter that someone inserted a new line and it flowed through the rollup.  Forecasting was done by evaluating what could be done, backing it off 10% and seeing if that could get passed.  Often times when a number or a project was accepted, every other plan would magically look similar.

    Christoph Papenfuss: You decided to implement new performance management processes. How did you go about that? Did you use a big bang or a phased approach?

    Mark Lack
    Mark Lack

    Mark Lack:  We had just come off of an ERP implementation that was big bang, so we realized that this next project should be phased.  Actually, when working with PM, you have to be careful of what you incentivize (to avoid bad behaviors) so it lends itself to a more phased approach.  We began by implementing a corporate balanced scorecard.  This became the framework for which the organization’s activities would be managed around, so this became the parameters.  The scorecard reporting at first was done in Excel with Red yellow green traffic lights as the metrics success and failures.  The first question when we reviewed these was always “What caused the target to be off?”  We realized that we had to put a better system in place to manage and automate the PM if we were to be able to communicate what was important about executing our strategy and drive behavior.

    Christoph Papenfuss: What does you current solution look like? What have you implemented and which processes are automated?

    Mark Lack: We have an integrated system that uses the strategy as the foundation of our company.  All of our PM processes are integrated from the balanced scorecard, to reports that indicate why we met or missed a target, to a planning system to help us get back on track.  We try to allow the data to flow systematically with little to no intervention.  We’re pretty close to an entirely closed loop system and the told we have provide the ability to automate the dissemination of important information needed to run the organizations.  The goal is to get relevant information to decision makers when and how they need it.  We’re pretty close to that goal and automation of information delivery against our “big data” has helped us in this regard.

    Christoph Papenfuss: One of the key problems companies are struggling with is target settings. Managers tend to fight for lower targets. Their argument is that their goals are arbitrary. Do you have similar issues?

    Mark Lack:  We did for a while, and for the most part they have a point.  If the goal is 15 % and they are at 5% now, a 3 times jump can be difficult to obtain if looked at from a high level.  What we were able to do with our analytics tools was to analyze organizations around a common theme, such as revenue.  By breaking them into groups and analyzing the processes within the groups, the result in target setting is less arbitrary.  In our case if 7 organizations have a similar revenue level and 5 are performing at a high level in regards to customer satisfaction scores, all things being equal, the remaining 2 orgs should be as well.    So we set the target within the per group range as an expectation.  The top 5 in the peer group set the target and then the conversations switched from “That target is arbitrary” to “This was set by your peer’s performance”.  The idea here is that now we can remove the distraction of who set the target (now it is the peer group) to what are the best practices that drive this performance?  If 70% of your peers can perform, what keeps you from performing?  Ultimately it changes the conversation for the better.

    Christoph Papenfuss: Implementing a solid performance management platform requires resources. What is the benefit for your organization? Have you ever attempted to calculate the ROI?

    Mark Lack: We always knew the answer was positive, because you can see results, right?  The problem we always had was how do you quantify it?  We had a research study done by Nucleus Research and the direct benefits were 113% per year.  If we add the indirect benefits of a better informed workforce, I’m guessing it would have to be 10x that figure.

    Christoph Papenfuss: What are your future plans?

    Mark Lack:  I’d like quote Jeff Spicoli and say “me and Mick are going to wing on over to London and jam with the Stones” but I can’t.  There are too many opportunities to use the tools available to continue to maximize the value out of our system.

    Christoph Papenfuss: Thanks much for your time, Mark

    You can find out more about the Mueller Inc implementation on IBM’s website.

  • Want to run a company? The Business Analytics Experience Workshop

    You are the new CEO!

    What does it feel like to run a company? How cool would it be to make really important decisions? How awesome would it be to have all the critical information that you need to get your job done? Good questions? Here is the good news for you: You can certainly experience what it feels like. How? Simply join the Business Analytics Experience Workshop. IBM has developed these workshops together with the team from Align-Alytics and PMSI. Participants get to run a fictitious company called Future Chips. Together with your team mates and a workshop host, you will analyze the past performance of Future Chips and you will get to develop strategic plans, marketing tactics, pricing strategies etc.. But it doesn’t stop there – the business analytics experience workshop gives you real-time feedback. All your decisions will be executed by a simulation engine. It’s quite cool!

    The Mini-MBA in a fun format

    A participant of the workshop recently said: “Attending the workshop is like getting a mini-MBA. And it’s fun!”. The business analytics experience workshop does teach you quite a bit about real-life business. It is based on the book “The Performance Manager“. Along the way you will also experience what it feels like to have business analytics available to prepare and make decisions. But rather than me describing it in more detail, you should hear from the creator of the workshop. My friend Roland Mosimann is the CEO of Align Alytics. We recently met at the IBM Vision event in Orlando. The team hosted one of the first CFO versions of the workshop.

    The Business Analytics Experience Workshop

    Come and join the Business Analytics Experience Workshop! First of all, it’s great fun and you can learn a lot. I have hosted close to a hundred of these and I love it. Find out more about the upcoming schedule on the IBM page. You can also read more about the workshop in a prior post on this blog.

  • Business Analytics News

    Business Analytics News

    Greetings from Munich, Germany! Just a quick update for this week.

    New Business Analytics blog

    There is a new business analytics blog you should check out. It is written by my Australian colleague Katrina Read and it’s called Kat’s Insigh. Her blog focuses on thoughts and ideas around IBM Business Analytics. Make sure to bookmark the site and/ or to subscribe to Katrina’s RSS feed.

    Katrina Read
    Katrina Read's Business Analytics Blog

    Finance Forum 2012

    The Finance Forum 2012 events are happening across the globe right now. These are one day events for finance and IT professionals. IBM has hired some fantastic external thought-leaders to speak at these conferences. Speakers include book author and leader of the Beyond Budgeting Roundtable, book author and forecasting expert Steve Morlidge as well as the ‘King of KPIs’ Dave Parmenter. I will be delivering the keynotes at some of the Asian and the European events next month. You can find the detailed schedule on the IBM website. Please drop me a note if you want to connect.

    IBM Vision 2012

    The IBM Vision 2012 event in Orlando was awesome. Almost 800 finance and risk professionals met last week to discuss trends in processes and technology. I personally enjoyed the clear focus on the conference. The break-out sessions were fantastic. I will try to post a few customer interviews next month. In the meantime, I would like to encourage you to watch the keynotes from Vision 2012. The Livestream channel features some great stuff including a thrilling presentation by Mt Everest explorer Alison Levine and IBM’s CFO Mark Loughride.

    ibmsoftware on livestream.com. Broadcast Live Free
  • IBM Vision 2012 – A great conference

    IBM Vision 2012

    Greetings from the JW Marriott hotel in Orlando. The IBM Vision 2012 conference for Finance and Risk Management professionals is going really well. Close to 800 professionals from all over the world are here. The atmosphere has been great so far. An event of this size allows people to easily connect with each other and to exchange a few ideas.

    Keynotes

    The keynotes of the events have been well received. They were action and information packed. The Tuesday morning presentations were especially insightful. Les Rechan kicked off the day with a few thoughts about the role of analytics in the office of finance. He was followed by book author Michael Mauboussin who talked about the power of counterintuition in decision making. John Hagerty from Gartner closed out the morning session with a few customer interviews.

    Make sure to watch or scan through the video recording.

    Watch live streaming video from ibmsoftware at livestream.com

    Stay tuned for further updates

  • IBM Vision 2012

    IBM Vision 2012

    Greetings from Orlando. I left Munich Saturday morning to attend the IBM Vision 2012 conference. This three day event for finance & risk management professionals will be exciting. There are fantastic keynotes lined up as well as a ton of awesome break-out sessions. I am really looking forward to it.

    IBM Vision 2012

    Keynotes

    The keynotes at IBM Vision 2012 promise to be especially interesting this year. The list of external speakers includes John Hagerty from Gartner, book author Michael Mauboussin and Everest explorer Alison Levine. Of course, there are also exciting IBM speakers including Les Rechan (GM for Business Analytics) and Mark Loughridge (CFO of IBM). I will be showing some great new solutions as part of the general keynote Tuesday morning from 11am – 12am EST.

    Join the conversation

    For those of you who will attend IBM Vision 2012, please do reach out to me (@cpapenfuss). I would love to connect. If you cannot attend the conference, you can still participate in the conversations. There are two main options:

    • Join via Twitter. The official hashtag is #vision12 . Also, make sure to follow @ibmcognos for updates. I will try to tweet whenever possible.
    • View the keynote sessions from your desk via Livestream. All keynote sessions will be broadcast and should be available for viewing after the event as well.

    Stay tuned for updates!

  • Part 2 – Interview with the TM1 book author. More about TM1

    Last Thursday, I posted an interview with the author of the new TM1 book Karsten Oehler. Here is the continuation of the conversation. This part of the interview focuses on the new IBM Cognos TM1 10.1 release.

    Christoph Papenfuss: IBM Cognos TM1 10.1 was released in February of 2012. What is so special about this release?

    Karsten Oehler: One of the central components of version 10.1 is a new modeling environment. It is called Performance Modeler. It really encourages finance and business professionals to develop their own models. Performance Modeler allows them to develop complex rules and links. You can also easily import data into applications. None of this requires deep technical knowledge.

    Christoph Papenfuss: Does Performance Modeler replace Architect?

    Karsten Oehler: Performance Modeler is an enhancement. The user can choose which tool to use. Architect is closer to Excel and has some features which are currently not supported by Performance Modeler. This includes dynamic subsets and report generation of Excel sheets from the cube viewer.

    Christoph Papenfuss: There is a new desktop tool call Cognos Insight. It looks similar to TM1. Is there a relationship or connection between the products.

    Karsten Oehler: Cognos Insight is a very powerful desktop tool that allows business people to conduct analysis, explore data and to develop prototypes. TM1 and Cognos Insight are closely connected – a local TM1 engine is part of Cognos Insight. It uses the same rule syntax and a simplified Turbo-Integrator version for data import. You can also import Cognos Insight models into Performance Modeler and refine them further.

    Christoph Papenfuss: What is the advantage of using Cognos Insight in the planning process along with TM1

    Karsten Oehler: There are two aspects: Planning applications are often created by prototyping. Cognos Insight is a great tool to express ideas and to develop prototypes. Secondly Cognos Insight can be used an additional front-end for contributors to the planning, budgeting and forecasting process.

    TM1 Book
    The TM1 book was the big star at the Budapest Finance Forum on May 9th

    Christoph Papenfuss: Who should use Cognos Insight as a client for planning and forecasting models?

    Karsten Oehler: TM1 has strong tools to support a highly decentralized planning and forecasting process. I recommend to use the IBM Cognos Contributor front-end because it is easy to distribute (non-local installation). With TM1 10.1 you can also integrate web sheets created via the Excel add in. However if somebody is using Insight for data discovery it is very interesting to contribute to the planning process directly within Cognos Insight. Another advantage is the scalability: With Insight it is possible to let the local insight engine do all the calculation which is needed for the planning slice assigned to the user.

    Christoph Papenfuss: What do you like best about TM1?

    Karsten Oehler: It is definitely the rule language. It is the most compact way to formulate all kinds of calculations to solve all kinds of business problems. The most complex cost and profitability calculations often look pretty easy after modeling them with TM1 rules.

    Christoph Papenfuss: Thank you so much, Karsten!

    You can purchase the TM1 book on Amazon.com: IBM Cognos TM1 – The Official Guide

    About Dr. Karsten Oehler (author of the TM1 book):

    Karsten is head of the Performance Management Client Technical Professionals at IBM Germany. Prior to joining IBM, he spent more than 15 years with several international software companies as a product manager, marketing executive, and consultant for financial accounting and business intelligence software. He has published several books and well over 130 articles about business analytics.

  • Interview with the TM1 book author: IBM Cognos TM1 – The Official Guide (Part 1)

    The new TM1 book

    The highly anticipated 10.1 version of IBM Cognos TM1 was released in February 2012. Along with the software there is also a great new TM1 book: IBM Cognos TM1 – The Official Guide. My German colleague Karsten Oehler is one of the authors of this comprehensive TM1 book. We had the opportunity to catch up last week. It was very early in the morning and we were both on our first cup of coffee. This is the first part of two short interviews. Check back Tuesday next week to read more.

    Christoph Papenfuss: Let’s start this discussion with an important question. TM1 is a strange product name. What does TM1 stand for?

    Karsten Oehler: The name sounds still fresh and interesting after 25 years, right? Oh well…..it is an interesting name, indeed. And we do get a lot of questions about it. Here is the truth. Don’t be shocked – it stands for Table Manager 1. And it is the solution No 1 from my point of view.

    Christoph Papenfuss: What is TM1? Can you describe it in an elevator-speech style?

    Karsten Oehler: Cognos TM1 is the universal tool for the business person wanting to do all kinds of analytical work like forecasting, planning, simulation, analysis and reporting. Some people call it the ‘Swiss Army Knife’ for the business. The only thing it can’t do (yet) is to cook coffee 😉

    Christoph Papenfuss: Who can use IBM Cognos TM1 and why should they?

    Karsten Oehler: Everybody with a need or desire to perform analytical work should use TM1. TM1 links typical analytical office work (Excel) with a high performing analytical database. However it doesn’t require that much conceptual overhead so that a business user is able to define his own data structure. TM1 doesn’t replace spreadsheets or data warehouses. It literally brings both worlds together.

    Christoph Papenfuss: There are many planning, budgeting and forecasting solutions out on the market. What makes IBM Cognos TM1 so special?

    Karsten Oehler: I am heading up a research group at the Controller Verein, the biggest European community for management accountants and finance experts. We describe several classes of planning tools: spreadsheet enhancements, ERP enhancements, OLAP, specific (financial) planning solutions and generic planning solutions. The last category is the most powerful one because it provides a lot of flexibility while also allowing you to leverage strong predefined planning functions like workflow, simulation, financial intelligence. Within this group TM1 is the best one because it has the most modern architect (scalability, write back queuing, rule optimization, batch processing environment) and the newest interface.

    Christoph Papenfuss: Is TM1 just for planning, budgeting and forecasting?

    Karsten Oehler: Absolutely not! As I mentioned before, TM1 is extremely powerful and flexible. Planning, budgeting and forecasting is just one area where TM1 can add tremendous value. Other important areas where TM1 excels at is profitability and sales analysis, costing (an area where TM1 is extremely strong), management consolidation, and last but not least production planning.

    Christoph Papenfuss: You have just released the book IBM Cognos TM1 – The Official Guide. What prompted you to write this book?

    Karsten Oehler: When you look at the bookstores and see shelves of SAP books and hardly any book about the best analytical tool, you have to scratch your head. We wanted to change that. Also, together with our customers we had developed a lot of valuable business content over the past decade. We really wanted to share this with others.

    Christoph Papenfuss: What can you expect to learn from the book?

    Karsten Oehler: How to live a better life – just kidding. No, in all seriousness it should help you with your daily TM1 work. It explains the architecture in a focused and structured way. This is an area where the standard documentation is sometimes a bit too extensive. Also, we have included a ton of business content. There are several small models that explain how TM1 can solve specific business problems like rolling forecasting, inter-company matching, variance analysis, activity based management etc..

    Christoph Papenfuss: Who should read the book?

    Karsten Oehler: Anybody who has an interest in TM1! Early feedback shows that power users and business consultants are the primary readers of this book.

    Christoph Papenfuss: What is the best way to read your TM1 book? Is it more like a workbook or a resource guide that you pull out when you need it?

    Karsten Oehler: Of course you could read the entire book, but I wouldn’t recommend that. It’s 800 pages strong! I would rather suggest to focus on just those business areas that you are interested in. Simply read it section by section. I would imagine that most people will use the book as a powerful reference.

    Christoph Papenfuss: IBM recently released TM 10.1 . Do you cover the latest version in your book?

    Karsten Oehler: We certainly cover it but it was not easy because there were a lot of short term changes in the development process. The business models are backward compatible. We wanted to make sure that users from the older releases are also able to leverage the book.

    To be continued next Thursday…..the second part will focus on the 10.1 release.

    Karsten-Oehler

    About Dr. Karsten Oehler (author of the TM1 book):

    Karsten is head of the Performance Management Client Technical Professionals at IBM Germany. Prior to joining IBM, he spent more than 15 years with several international software companies as a product manager, marketing executive, and consultant for financial accounting and business intelligence software. He has published several books and well over 130 articles about business analytics.