The TM1 community spoke and we listened. After years without a TM1 conference post IBM Cognos aquiring TM1, Cubewise recently put on the Conference of the year.Two hundred people flocked from over 77 companies last week to attend the first annual Cubewise IBM Cognos TM1 User Conference at Luna Park, Sydney.
Among the conference's many draw cards, Cubewise was able to get Manny Perez, the original developer of TM1 to headline. Not only did he provide insight and analysis on the current functionality of the product, but also shed light into the future roadmap of TM1. Some of the other conference highlights were TM1 black belt feeder sessions, Excel beautification, and an insightful real world case study of TM1's success at MSS Security.

Having sold out, the first annual Cubewise IBM Cognos TM1 User Conference was a blinding success with 98% of those who attended saying they would come back. If you were unable to attend this year , don't miss out next year as we are planning a bigger and better opportunity for TM1 users in Australia to keep up to date on software developments and news in the TM1 community.

Don't just take our word for it; here is what those who attended have been saying:
"Congratulations on a great day!"
"Keep up the excellent work!"
"Probably the most useful and informative conference I've attended"
"...the info from the conference is invaluable to my learning"
"Having attended TM1 user conferences in the past they have been missed since being taken over by IBM/Cognos. Thank you for bringing back quality TM1"

With the introduction of Cubewise Vizier, the previewing of data in the main tab of Turbo Integrator includes additional functionality in the sampling and extraction of data via ODBC Connectivity, file source or cube/subset source.

Additional Functionality:

• Standard TI allow for only the first 10 records to be displayed; with Vizier the user can control the number of records to be displayed  by changing the count of preview records.  
• Vizier also allows the data in the preview pane to be highlighted and copied to either Excel, notepad in the format selected (Tab, Comma, Semicolon, Other).

Benefit:

• Easily cut down the sample data to process data in development mode
• Gives you a broader view of the data to highlight possible inconsistencies within data records

Much of what we do at Cubewise involves assisting our clients to analyse business problems and that invariably involves presentation of data. Many of our customers are finance departments and one graphic that many finance and planning departments are obsessed with is the waterfall chart, also variously known as the "earnings walk." The purpose of this chart is often to illustrate the reasons for variation between profit from one year to the next, or as in the following simplified example, to illustrate the flow from revenue to net income.

There are a few problems with waterfall charts. Anyone who has ever had to do one knows that Excel does not provide native functionality to do these charts and therefore every accounting firm, management consultancy and finance department has their own template complete with data input ranges and data series with "blank" formatting in order to massage data into the format required to "trick" Excel into producing a waterfall chart. However, that's not the issue I want to focus on. These charts, although almost universal are prime examples of bad design, they take up a lot of screen or printed report "real estate", yet convey little actual information and are often difficult to interpret due to the layout and volume of white space.

Let's start with a typical waterfall chart:
OK, so how might we go about improving this chart to make it a more effective data visualisation?

STEP 1.
Remove the chart title and flip the chart on it's side to make it into a "horizontal waterfall".
Right now you might be thinking "what the ...?" but bear with me!

STEP 2.
Remove the axes which are cluttering up the chart but conveying little information

STEP 3.
Let's remove the data labels which are difficult to read and place them in a table next to the row items. Our original walk chart is now laid out much like we would normally read a P&L but with a visual representation of scale on various profit effects. Notice how it is much easier to scan down rows of horizontal bars than across columns to see size relativity.

STEP 4. (final step)
Shrink the graphic down so that it can be presented in line with the actual tabular report as part of the spreadsheet or dashboard. Each value is now effectively represented by a "sparkline."

The same information is now displayed in about ¼ the space of the original chart but yet in a more impactful and easy to interpret way:
• Horizontal bars representing the dollar value scale are now lined up vertically which makes it easier to accurately interpret size variations
• Series values are now lined up with the series names so the reader's eye doesn't have to jump around, it is easy to scan down the graphic
• The data is presented as a finance reader would usually expect to see a financial result
• There is no unnecessary clutter from chart titles and axes!

More impact in far less space! I know which one I prefer but which one do you like best?

Please contact your Cubewise consultant for more tips on effective data visualisation.

For more resources on efficient and effective ways to display business data see these websites
Stephen Few, Perceptual Edge (author of "Information Dashboard Design" and "Show Me the Numbers" and consultant to most of the big BI companies)
Peltier Tech (John Peltier's website, Excel MVP and charting expert)
Excel Charts blog (Jorge Camoes' blog, a balanced view between the demands for business charts and data visualisation best practices)
Bissantz blog (musings on effective data visualisation and charts contains a very similar example to the one above)
Edward Tufte (credited with inventing sparklines and author of "The Visual Display of Quantitative Information")

October 22, The Climate Group's Greater China Director Changhua Wu joined a high-profile BBC World Debate panel with IPCC Chair Dr RK Pachauri, EU President Jose Barroso and Advisor to President Obama Mario Molina.  BBC Presenter Stephen Sackur asked panellists about the prospects for COP15. What's needed to seal a global deal on climate change?  And what if negotiators fail to do so at Copenhagen?  Watch it here. (25 mins)    Ref: BBC Worldwide

Is there a climate problem?  That is one of the big questions.  Another is, do we need to do anything about climate change?  It doesn't matter if you agree with the pro or con of this debate, here is an interesting perspective on the issue.  Click here. (9 mins 33 secs)  Ref: Youtube

In an Australian first,  Premiers from every Australian state joined with business leaders to focus on climate change.  The Climate Group convened the meeting and The Climate Group CEO, Steve Howard, led the discussion around establishing new public-private partnerships that will fast-track smart, low carbon development across Australia.  That same week, Steve and the Climate Group Australian team joined Queensland Premier Anna Bligh to host the Queensland Climate Summit  which included a video message from former UK Prime Minister Tony Blair. 

Ref: The Climate Group