Calumo - Business Intelligence and Performance Management Blog

Controlling the Cost of Compliance with CALUMO

The National Greenhouse and Energy Reporting Act 2007 was passed in September 2007 establishing a mandatory reporting system for corporate greenhouse gas emissions and energy production and consumption. The first reporting period under the Act commenced July 2008 with reports due in July 2009.

Key features of the Act are:

• Reporting of greenhouse gas emissions, energy consumption and production by large corporations.
• Public disclosure of corporate level greenhouse gas emissions and energy information.

The Calumo and Elwyn groups in conjunction with CIO’s and Sustainability Experts from front running organisations have collaborated to develop an environmental reporting platform to enable corporations to meet the initial reporting requirements.

While the specific detail regarding the format and substance of the reporting requirements have not yet been fully locked down, it is clear that organisations will be required to capture, analyse and report on those operations of their organisation that have significant energy consumption or generation.

We expect that as the new legislation evolves over the introductory period organisations must be able to quickly adapt to the inevitable iterations that will flow from both global and local imperatives. This reality informed the design of our Environmental Reporting platform to offer;

1. quick and highly adaptable implementation to minimise the cost of expected changes to the Act during the introductory period 
2. a one-stop shop for data capture and all environmental reporting
3. flexibility to enable data to be collected from existing ERP and operational data sources
4. multiple hierarchy reporting platform to enable look-through transparency of information and accountability
5. qualitative (via commentary and traffic light reporting) capability to allow management to better interrogate the information.

About the Elwyn Group
Elwyn Group is a boutique consulting firm specialising in reporting solutions to medium and large organisations utilising pre-existing or custom developed solutions.  

About CALUMO
The CALUMO Group (www.calumo.com) is a leading provider of Performance Management solutions for enterprise-wide reporting planning and Business Intelligence.  Since 1998 the group has successfully delivered solutions to a wide range of enterprises from SME's to some of the largest listed companies and government organisations.   These solutions provide quantifiable and valuable business insight, offering a single platform from which to integrate Corporate, Financial and Operational performance and objectives. 
 
The Group is a Microsoft Gold Certified Partner in Business intelligence (achieving full competency in both Platform and Performance Management Specialisations), Data Management Solutions and ISV/Software Solutions.

SYDNEY,- 3 November, 2008 — After taking the difficult commercial decision to substantially change their Business Intelligence technology stack in February of this year, University of New South Wales have taken out a little time at the conclusion of their annual planning process to celebrate what has been achieved.

Reflecting on the process the UNSW Finance Division stated “This project has and will continue to be the catalyst for very positive change at UNSW. The UNSW team, with CALUMO’s expert guidance, are delivering a platform that enables us to maximise the financial resources available to support our teaching and research priorities more effectively and in minimal time.”

“The time frame from commencement to yielding real business value was astonishingly short.  The University environment is very demanding and complex; the flexibility and performance of CALUMO has been excellent.  It’s a breath of fresh air for the user community and the University was proud to be supporting world-class Australian innovation in Business Intelligence.”

CALUMO Group CEO Dominic Parsons said “As an academic institution there is a great deal at stake for the future in laying a platform that will enable the institution to effectively deliver on its vision.  Working with the University has been a special opportunity for us and the combination of their staff, senior sponsorship and our delivery teams has produced a benchmark result.”

The UNSW system is serving 250 users with critical information in frequencies ranging from daily and monthly to quarterly and annually.  It allows for collaboration across that broad range of users both for reporting and contribution to future financial and academic resourcing plans.

Summing up from the teams’ perspective MIS Manager Alister Cairns added “We are saving considerable time in administration compared with other products in the market. CALUMO’s simplicity of design and openness allows us a flexible system that we can use for data collection, analysis and reporting on a wide range of data. There are no unnecessary administration programs, and thus native Analysis Services, SSIS and SQL Server are used to develop and administer applications (Cubes, fact tables, data sources, dimensions etc.)”

“The CALUMO reporting frontend is intuitive and flexible in that we have a range of options for delivery to our wide ranging user community. We can use a web portal, Excel, deliver PDF's or hard coded excel reports. It is open for us to decide on our options for the data we choose to analyse, the user experience and administration.”

UNSW is using Microsoft and CALUMO Business Intelligence solution for their annual budgeting cycle, management reporting and forecasting.  The value return from BI increases exponentially with deployment.  Over the next 12 months UNSW are planning to further expand their BI platform to incorporate additional reporting and scorecarding.

About the University of New South Wales
UNSW was established in 1949 and now has close to 40,000 students, including more than 7000 international students from over 130 different countries. UNSW has an annual turnover of $1 billion and employs over 5000 staff. UNSW is a founding member of the prestigious Group of Eight research intensive universities in Australia and a member of the Universities 21 international consortium

About CALUMO
The CALUMO Group (www.calumo.com) is a leading provider of Performance Management solutions for enterprise-wide reporting planning and Business Intelligence. Since 1998 the group has successfully delivered solutions to a wide range of enterprises from SME's to some of the largest listed companies and government organisations. These solutions provide quantifiable and valuable business insight, offering a single platform from which to integrate Corporate, Financial and Operational performance and objectives.

The Group is a Microsoft Gold Certified Partner in Business intelligence (achieving full competency in both Platform and Performance Management Specialisations), Data Management Solutions and ISV/Software Solutions.

CALUMO and Microsoft will co-present  “The Business Intelligence Scenario” at The 2nd Annual Southern Region CFO Symposium 2008, where more than 100 CFO’s are scheduled to attend over two days.

Business Intelligence has gathered increasing profile in recent years as both the IT and Finance functions have become aware of its potential to improve business. Tim Dawson (Financial Services Industry Manager, Microsoft ) and Chris Mentor (Director Consulting Services CALUMO Group) will profile typical BI scenarios focusing on deployment challenges and outcomes.

When: Monday 13th and 14th October 2008
Where: Hilton on the Park, Melbourne

About CALUMO
The CALUMO Group (www.calumo.com) is a leading provider of Performance Management solutions for enterprise-wide reporting planning and Business Intelligence.  Since 1998 the group has successfully delivered solutions to a wide range of enterprises from SME's to some of the largest listed companies and government organisations.   These solutions provide quantifiable and valuable business insight, offering a single platform from which to integrate Corporate, Financial and Operational performance and objectives.

The Group is a Microsoft Gold Certified Partner in Business intelligence (achieving full competency in both Platform and Performance Management Specialisations), Data Management Solutions and ISV/Software Solutions.

- Last week we presented a logic puzzle devised by Einstein which we used as a simple analogy to explain business intelligence and the components (cubes, dimensions and elements) typical of a real business with thousands or millions of transactions.
– This week, we provide a solution to the puzzle as well as discussing the Data Mining perspective illustrated in Einstein's puzzle...

Click on this link to look back at the original puzzle and the 15 hints provided.
The question is: Who owns the fish?
Here is The Solution:

Since we know we have only 25 data points to derive, let's start by making a five by five table (instead of a 5 x 5 x 5 x 5 x 5 x 5  or 15,625, six dimensional cube) where columns represent the five houses and the rows represent nationality, colour, drink, smoke, and pet per the table below.

• In the next table below, let's fill in the easy clues first (hints 8, 9 and 14).
• Then, the green house/white house combination (hint 4) cannot be houses 1 and 2 or houses 2 and 3 because the second house is blue. It also cannot be houses 3 and 4 because the green house owner drinks coffee (hint 5) and the third house owner drinks milk. So the green house must be fourth and the owner drinks coffee and the white house is fifth.
• The red house with the Brit (hint 1) cannot be the second, fourth or fifth house (which are blue, green, and white), nor can it be the first house (which contains the Norwegian), so it must be House 3.
• Therefore, the yellow house with the Dunhill smoker (hint 7) must be the first house and horses are kept in the second house (hint 11).

We can now complete the puzzle in the last table below as follows:

• The Norwegian in the first house does not drink milk or coffee, because we already know these beverages are drunk in the third and fourth houses.  They do not drink tea, because the Dane drinks tea (hint 3), nor beer, because the Blue Master smoker drinks beer (hint 12) and the Norwegian smokes Dunhill. Therefore, the Norwegian must drink water.
• The Blend smoker is in the second house, with a neighbour who drinks water (hint 15).
• This Blend smoker cannot drink beer (hint 12), so the beer-drinking Blue Master-smoking person must live in the fifth house.
• The tea-drinking Dane (hint 3) lives in the second house.
• The German who smokes Prince (hint 13) must be in the fourth house.
• The Swede must live in the fifth house with his dogs (hint 2).
• The Pall Mall smoker lives in the third house and raises birds (hint 6).
• That leaves only the Norwegian in the first house as the one with cats who lives next door to the man who smokes Blend (hint 10).

Therefore, assuming that the fifth pet is a fish, it is the GERMAN who owns the fish.

The Data Mining Perspective
It is worth commenting that the distribution of data in this problem makes it manageable as a solution in two dimensions. In the business world however, there will be thousands or millions of transactions and the distribution of data will not be so neat. For example, not all Germans own fish and not all people who drink water also smoke Dunhill. So with many many transactions, business decision makers might typically want the answers to questions like:

• Which nationalities drink beer?
• Is there a link between pet ownership and cigarette preference?
• What is the most popular house colour in Norway?

For questions like these, the process of discovery is inverted and, rather than having the gathered intelligence allow us to fill in the data points, we use the available data points to enable business to extract answers about the relationships implied by the data. Relationships that may not be apparent or obvious from a dimensional business intelligence review of the available data. This is Data Mining. “Data mining is the semi-automatic extraction of patterns, changes, associations, anomalies, and other statistically significant structures from large data sets.”

So how do Business Intelligence and Data Mining differ? Terms associated with traditional BI include analytics or exploration, drill down, trending, reporting, planning data entry and modeling of business rules. For data mining, terms include predictive analytics, classification, association, regression, segmentation.

In a future post, we will go into these data mining terms in more detail.

About CALUMO
The CALUMO Group (www.calumo.com) is a leading provider of Performance Management solutions for enterprise-wide reporting planning and Business Intelligence.  Since 1998 the group has successfully delivered solutions to a wide range of enterprises from SME's to some of the largest listed companies and government organisations.   These solutions provide quantifiable and valuable business insight, offering a single platform from which to integrate Corporate, Financial and Operational performance and objectives.

Calumo is partnering with Microsoft in a series of sessions, to illustrate how Microsoft, one of the world's largest companies, reduces the cost and risk associated with financial reporting.
Microsoft Corporate Accounting Group Manager Lisa Nelson, and Director of Corporate Accounting Alice Jolla, will be discussing in detail how Microsoft's financial reporting process creates a well controlled work environment.

CALUMO Group will be discussing the relevance of this best practice to Australian close and reporting. These practices enable Companies to dramatically streamline time-consuming traditional methods by operating out of one consolidated environment. Companies can collaborate and manage calendars, task lists, documents, and sign offs with a complete audit history and streamline the audit process to boot.

• Microsoft has benefited through this best practice as follows:
• Reduced annual report filing time from 50 days to 31 days
• Shaved approximately five days out of internal checking process
• Reduced black-out periods for stock trading
• Enabled quarterly reporting simultaneously with earnings press release
• Streamlined auditor involvement and reduced related costs

These events are scheduled for:
Melbourne: 23 September 2008
Sydney: 24 September 2008
Perth: 26 September 2008

Please Register Here.
Places at this complimentary event are limited - don’t miss your chance to attend an exclusive invite only session.

About CALUMO
The CALUMO Group (www.calumo.com) is a leading provider of Performance Management solutions for enterprise-wide reporting planning and Business Intelligence.  Since 1998 the group has successfully delivered solutions to a wide range of enterprises from SME's to some of the largest listed companies and government organisations.   These solutions provide quantifiable and valuable business insight, offering a single platform from which to integrate Corporate, Financial and Operational performance and objectives.

The Group is a Microsoft Gold Certified Partner in Business intelligence (achieving full competency in both Platform and Performance Management Specialisations), Data Management Solutions and ISV/Software Solutions.

The logic puzzle below is attributed to Albert Einstein and it is said that only 2% of us can solve it.

The Puzzle
There are 5 houses in 5 different colours.
In each house lives a person with a different nationality.
These 5 owners drink a certain type of beverage, smoke a certain brand of cigar, and keep a certain pet.
No owners have the same pet, smoke the same brand of cigar or drink the same drink.

Hints
1. The Brit lives in a red house.
2. The Swede keeps dogs as pets.
3. The Dane drinks tea.
4. The green house is on the left of the white house.
5. The green house owner drinks coffee.
6. The person who smokes Pall Mall rears birds.
7. The owner of the yellow house smokes Dunhill.
8. The man living in the house right in the middle drinks milk.
9. The Norwegian lives in the first house.
10. The man who smokes Blend lives next door to the one who keeps cats.
11. The man who keeps horses lives next door to the man who smokes Dunhill.
12. The owner who smokes Blue Master drinks beer.
13. The German smokes Prince.
14. The Norwegian lives next to the blue house.
15. The man who smokes Blend has a neighbor who drinks water.

The Question: Who owns the fish?

At the CALUMO Group, we have been providing business intelligence and performance management solutions since 1998. To solve this puzzle, we viewed it as a typical business intelligence or data mining challenge where very often all the information required is available, but where the means to derive and present the answers is not that obvious. Here is how we answer these questions for our customers:

The Business Intelligence Perspective - Cubes, Dimensions and Elements
We broke the problem down into a matrix, or cube, comprising six dimensions with each dimension comprising five elements as follows:

We then combined the six dimensions into a cube. Physical cubes can only be three dimensions, but the representation below is a great way to visualize the concept of six or more dimensions. Start with the cube made up of 3 dimensions; Drinks, Smokes, Pets. This cube is then embedded into a further cube comprising; Houses, Nationality and Colour.

It's of significant interest at this stage to note that the puzzle only contains 30 populated data points (5 houses, 5 Nationalities, 5 Colours, 5 Drinks, 5 Smokes, 5 Pets). The possible data points or combinations are comparatively huge at 5 x 5 x 5 x 5 x 5 x 5 or 15,625. This phenomenon of few actual data points, but a large number of possible data points is referred to as sparse data and data explosion and is very typical of real life commercial business intelligence applications.

Remember, this puzzle only has 6 dimensions with only 5 elements in each dimension and only 5 transactions in total. Imagine a real business with dimensions like Customers or Products, which typically have hundreds or thousands of elements, and cubes with more than 6 dimensions and transaction numbers in the thousands or millions.

On a typical CALUMO assignment, we gather and transform data to support the business intelligence building blocks. We then integrate and present the data in a unified business intelligence and performance management application. The challenges we face and the business answers we provide are not too dissimilar to Einstein's puzzle.

So, it is no coincidence then that all of our consultants are able to derive the answer to Einstein's puzzle. Were you able to work it out, or more importantly, are you able to answer all the difficult business intelligence questions at your organization? If the answer is no to the first question, and if you're interested, we will be posting the solution to the puzzle next week.

If the answer is no to the second question, please contact us to find out how CALUMO can help you get the answers for stand-out business intelligence and performance management. If you were able to work out the answer (in less than 15 minutes), please contact us to consider a career in business intelligence at CALUMO

- In addition to providing a solution next week, we will also be discussing the Data Mining perspective illustrated in Einstein's puzzle.

About CALUMO
The CALUMO Group (www.calumo.com) is a leading provider of Performance Management solutions for enterprise-wide reporting planning and Business Intelligence.  Since 1998 the group has successfully delivered solutions to a wide range of enterprises from SME's to some of the largest listed companies and government organisations.   These solutions provide quantifiable and valuable business insight, offering a single platform from which to integrate Corporate, Financial and Operational performance and objectives.

Sydney, NSW, - September 9, 2008 — Today, MIKADO DYNAMICS is proud to announce that we are now an IBM Cognos Platinum Reseller Partner, making us one of only a few other Australian partners to achieve Platinum status and with offices in Sydney, Melbourne and Brisbane! The Platinum partner status is the highest level of distinction within the IBM Cognos partner program and MIKADO DYNAMICS has achieved this through our continued success in delivering successful business solutions and increased product sales.

"Going Platinum with IBM Cognos recognises that MIKADO DYNAMICS is seriously committed to its customers, it's people and its partnership with IBM Cognos and the Cognos TM1 BI Platform" said Dominic Parsons - MIKADO DYNAMICS CEO.

About IBM Cognos Reseller Partners and Partnering with IBM Cognos
IBM Cognos Reseller Partners sell IBM Cognos products and provide business intelligence, enterprise planning and corporate performance management consulting services, ensuring the successful implementation of IBM Cognos products. IBM Cognos Partners provide products, services, and technology expertise that help our customers improve and direct corporate performance. Our broad range of partnerships allows us to meet the distinctive needs of our customers in purchasing, deploying, and servicing their business intelligence and performance management solutions. Cognos TM1 offers a single software suite that supports all the components of corporate performance management - from planning and budgeting, to measuring and monitoring performance, to reporting and analysis. Through their industry expertise and specialized knowledge, our partners extend that offering, helping our clients maximize their technology investments.

About MIKADO DYNAMICS and The CALUMO Group
MIKADO DYNAMICS (a CALUMO Group associated company) is the longest standing performance management solution provider in Cognos TM1, with over 12 years experience. The CALUMO Group (www.calumo.com) is a leading provider of Performance Management solutions for enterprise-wide reporting planning and Business Intelligence.  Since 1998 the group has successfully delivered solutions to a wide range of enterprises from SME's to some of the largest listed companies and government organisations.   These solutions provide quantifiable and valuable business insight, offering a single platform from which to integrate Corporate, Financial and Operational performance and objectives.

Microsoft announced the release of SQL Server 2008 on August 6th, 2008. Code-named "Katmai", SQL Server 2008 is the new version of the company’s acclaimed data management and business intelligence platform. This version of SQL Server provides powerful new capabilities such as support for policy-based management, auditing, large-scale data warehousing, geospatial data, and advanced reporting and analysis services.

SQL Server includes several data management and analysis components as follows:

Database Engine
The Database Engine is the core service for storing, processing and securing data. The Database Engine provides controlled access and rapid transaction processing. The Database Engine also provides rich support for sustaining high availability.

Analysis Services - Multidimensional Data
Analysis Services supports OLAP by allowing you to design, create, and manage multidimensional structures that contain data aggregated from other data sources.

Analysis Services - Data Mining
Analysis Services enables you to design, create, and visualize data mining models which can be constructed from other data sources by using a wide variety of industry-standard data mining algorithms.

Integration Services
Integration Services is a platform for building high performance data integration solutions, including packages that provide extract, transform, and load (ETL) processing for data warehousing.

Replication
Replication is a set of technologies for copying and distributing data and database objects from one database to another, and then synchronizing between databases to maintain consistency.

Reporting Services
Reporting Services delivers enterprise, Web-enabled reporting functionality so you can create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.

Service Broker
Service Broker helps developers build scalable, secure database applications. This new Database Engine technology provides a message-based communication platform that enables independent application components to perform as a functioning whole.
 
About CALUMO
The CALUMO Group (www.calumo.com) is a leading provider of Performance Management solutions for enterprise-wide reporting planning and Business Intelligence.  Since 1998 the group has successfully delivered solutions to a wide range of enterprises from SME's to some of the largest listed companies and government organisations.   These solutions provide quantifiable and valuable business insight, offering a single platform from which to integrate Corporate, Financial and Operational performance and objectives. 
 
The Group is a Microsoft Gold Certified Partner in Business intelligence (achieving full competency in both Platform and Performance Management Specialisations), Data Management Solutions and ISV/Software Solutions.

IBM Cognos TM1 9.4 was released on August 14 and can be downloaded from the Cognos support site for registered customers (userid and password required).

Key new features of this release include:

1. "Active Forms" replace dynamic slicing
   TM1 9.4 has removed dynamic slicing.  Instead, new Active Forms allow for standard Excel format options in a worksheet and to view and update live TM1 cube data directly in Excel when connected to a TM1 server.
2. New features to support Sarbanes-Oxley Compliance
   - Three TM1 Administrator Roles
   - New TM1 Audit Log
3. Long String Support
   TM1 9.4 supports strings longer than 255 bytes in cell data and SQL statements.
4. Microsoft Windows Vista and Excel 2007 Support
   - New TM1 ribbon for Excel 2007
   - .xlsx files can be opened in TM1 Web if Excel 2007 is installed on the web server
5. TM1 Web 64-bit IIS Support
6. Unicode Support for multiple languages

A more detailed review of all these new features can be found in the attached TM1 NEW FEATURES GUIDE.

Pictured: In 9.4 seconds, a WORLD RECORD by Frank Wykoff runnning the 100 YARD DASH on June 7, 1930 - A segue reference to "version 9.4" (since Usain Bolt can only run 100m in 9.69 seconds) and a reference to the legendary speed of TM1 cubes.

Integration of IBM Cognos 8 and TMI 9.4
Other exciting developments include Integration of IBM Cognos 8 and TMI 9.4.
At the Cognos TM1 Forum this week (3-5 September) Cognos demonstrated how Cognos 8 Business Intelligence enhances the deployment and implemention of IBM Cognos TM1. This included complex and simple reports, multi-source dashboards, report packs, comprehensive analyses, managed reports with prompts, scorecards, scheduling, distribution and alerts, without scripting or coding!

Utilising the real-time in-memory facilities of TM1 cubes, data updates can be reflected immediately by the BI components. Employing a multi-user live scenario, Cognos illustrated these abilities in a web-based zero footprint environment.

About CALUMO
The CALUMO Group (www.calumo.com) is a leading provider of Performance Management solutions for enterprise-wide reporting planning and Business Intelligence.  Since 1998 the group has successfully delivered solutions to a wide range of enterprises from SME's to some of the largest listed companies and government organisations.   These solutions provide quantifiable and valuable business insight, offering a single platform from which to integrate Corporate, Financial and Operational performance and objectives.

Mikado Dynamics (a CALUMO Group associated company) is an IBM Cognos Platinum Reseller Partner. The Group is the longest standing performance management solution provider in Cognos TM1, with over 12 year’s experience.

Port Douglas, Queensland,— August 7, 2008 — Today, CALUMO Group proudly announced that it has won the Partner of the Year Award for Business Intelligence at the 2008 Microsoft Australia Partner Program Awards. The company was chosen out of a local field of top Microsoft Partners as delivering market-leading customer solutions built on Microsoft technology.

Pictured: holding the award and celebrating were Bruce McCarthy, Dominic Parsons, Johann Potgieter, Brenden Russell, Jeff Walter and Mike Henegan of CALUMO Group.

Accepting for CALUMO, group CEO Dominic Parsons said “I am proud to accept this award on behalf of the CALUMO team.  Our developers and professional services teams work tirelessly to deliver truly innovative, effective and world-class solutions for our clients.  This is our second award from Microsoft in as many years and to be recognized with the inaugural Microsoft award for BI is a great affirmation of our vision for Performance Management.”
 
The CALUMO Group has been providing Business intelligence and Performance Management solutions for over 12 years and began working with Microsoft only 3 years ago.  Their unique BI application and pragmatic approach to delivering fully fledged BI has been openly embraced by its clients.
 
This award recognises partners who provide data-warehousing and business-intelligence solutions that improve organisations by providing business insight to all employees — leading to better, faster, and more-relevant decisions.  CALUMO Group was recognised for superior technology and innovation in Business Intelligence. 
 
“Our partners are the lifeblood of Microsoft’s business and through the Awards we’re able to highlight and recognise those who have gone above and beyond in delivering exceptional technological solutions and services to Australian customers,” said Mr Paul Voges, Director of Small and Mid Market Solutions and Partner Group, Microsoft Australia.
 
“It’s an honour to acknowledge their dedication and success as part of the Microsoft partner community, and also to recognise the broader role that they play as leaders in Australia’s IT sector.”
 
The Microsoft Australia Partner Program Awards recognise Microsoft Partners that have developed and delivered exceptional Microsoft-based solutions over the last year.
 
 
About CALUMO
The CALUMO Group (www.calumo.com) is a leading provider of Performance Management solutions for enterprise-wide reporting planning and Business Intelligence.  Since 1998 the group has successfully delivered solutions to a wide range of enterprises from SME's to some of the largest listed companies and government organisations.   These solutions provide quantifiable and valuable business insight, offering a single platform from which to integrate Corporate, Financial and Operational performance and objectives. 
 
The Group is a Microsoft Gold Certified Partner in Business intelligence (achieving full competency in both Platform and Performance Management Specialisations), Data Management Solutions and ISV/Software Solutions.

Whilst enthusiasm and investment in business intelligence and performance management projects continues across enterprises of all sizes and all industries, major project successes cannot be taken for granted.

From enlightening to disappointing, we use the “helicopter view” and “head in the clouds” analogies to describe the range of outcomes possible from business intelligence projects.

The "Helicopter View" is a metaphor for rising above the detail of the situation so that you can see it as a whole, and see the wider context. It means taking the overview in order to see the essential rather than the detail.

Business Building Blocks
The "Helicopter View" is the big picture of your business and a way to see how all of the parts fit together. To achieve this, the Business Intelligence solutions must be holistic and include all the building blocks of the enterprise. The Business Intelligence solution must also highlight the linkages between the building blocks. The building blocks typically include:

1. Customer Segments – who are your customers?
2. Value Proposition - what do you offer each of your customer segments?
3. Channels - how do you reach each of your customer segments?
4. Customer Relationships – how do you relate to your customers over time?
5. Revenue Streams - how do you earn money?
6. Key Resources – based on which assets are you running your business?
7. Key Activities - what key activities do you need to run your business?
8. Partner Network - with which partners do you leverage your business?
9. Cost Structure – where and what are your most important costs?

Convergence of Data and Performance Management Applications

Performance Management includes a multitude of Business Intelligence applications. The benefits of the “Helicopter View” can only be fully realized when the entire suite of applications is integrated into a single unified application or platform.

Inextricably linked to unified application is the requirement for the convergence of data. Gather the data to support the above "business building blocks” and “performance management applications”. Transform and make it consistent via such processes as Master Data Management and data cleaning (if necessary). Integrate and package the data for BI consumption.

The “Helicopter View” relies on the convergence of both data and performance management applications.

Without a business intelligence helicopter view, supported by reliable and timely detailed information produced by quality and repeatable processes, you could be running your businesses with your head in the clouds when your focus should really be on the ground.

On Feb 14, 2008 New York City unveiled a new online performance management system they called "Citywide Performance Reporting" (CPR). CPR takes 500 key performance indicators, which are updated monthly, and makes them available to the public online. You can visit the New York CPR site here.

With an annual budget of US$58.5 billion, NYC is many times larger than Australia's largest council; however the performance management challenges faced by NYC are still comparable to those faced by Australian local government agencies.

The New York City press release said: "CPR is the culmination of more than two years of work coordinated by the Office of Operations, and involving more than 40 City agencies." The three key benefits of CPR can be summarised as follows:

1. CPR uses a standardized reporting format across all agencies and all data types, and provides a single point of access for all users.
2. CPR aggregates data across agency into "citywide themes," which represent groups of related services such as infrastructure, education, or public safety.
3. CPR will identify problem areas and improve service delivery. It is another step in improving transparency and customer service for New Yorkers.

You can read the full press release here.

Notably, these 3 benefits are very similar to the challenges faced by Australian Local Government agencies. The stated 3 key benefits of the CALUMO Local Government Performance Management Solutions" are as follows:

1. Integrate and transform multiple data sources into highly informative metrics and KPI reports for performance management of diverse and competitive Council operations.
2. Provide open and transparent reporting for improved governance and stakeholder management.
3. Provide planning and reporting from a single reliable source, satisfying a council’s strategic, organisational and compliance requirements.

The following is a screen shot of one of NYC’s online performance reports:

Whilst I have several criticisms of how the CPR data is presented and ultimately therefore it's value to the end-user, I only want to point out two flaws in CPR, which are specifically claimed in the press release as benefits.

1. "CPR is trend-based, not target-based. It compares current performance to performance during the same time last year providing a short-term performance trend or "snapshot", intended to be used for real-time decision-making."
   In our opinion, comparing current performance to the same time last year does not provide a meaningful trend and I doubt it could be used for real-time decision-making.
2. "CPR will offer graphical representation of performance, including pie charts to make performance trends easy to identify."
   CPR includes only pie charts. Pie charts are not typically used to identify trends. Pie charts are also often criticized for taking up too much space on a page and that it is not easy to visually compare the size of each slice.

I have provided below an example of the equivalent CPR report from CALUMO Local Government Performance Management Solutions.

(click on image to enlarge)

CALUMO Local Government Performance Management Solutions deliver the functionality Councils need to achieve their many internal planning and reporting objectives. It delivers open and transparent reporting for improved governance and stakeholder management.

Please join us as our guest at the Microsoft Business Intelligence Summit in Melbourne on 28 November, or Sydney on 29 November. The focus of this complimentary one day event is to excite and educate high level delegates with solutions built on Microsoft’s comprehensive BI platform.

One of the presentations, by Lea Munro of Queensland Rail, is a CALUMO user story titled “Forecasting & Reporting – How Queensland Rail have Extended the Microsoft BI Platform”.

One of the greatest risks to effectively embedding any corporate BI system is the failure of IT and operations to connect, agree and move forward together.  By choosing the Microsoft Platform and CALUMO, QLD Rail set out with the best possible start – an infrastructure that IT knew, understood and trusted; and an application layer that offered end users the depth and flexibility they need to both submit and extract the information they need.  This approach has provided QLD Rail with a successful initial roll-out and the capability to scale rapidly across its enterprise.  In this session Lea Munro discusses QLD Rail’s process for selection, the success of the initial roll-out, lessons learned and plans for the future.

The Business Intelligence Summit delves into the technology and practical benefits behind Microsoft’s leading business intelligence products, and how to seamlessly integrate them within your organisation. It’s the first of its kind to be held in Australia.

Click here to register.

Johann presented new data visualisation techniques using sparklines (aka in-cell charts or microcharts) and gave some examples of predictive analytics and data mining to extract opportunities from data.

The CPA Congress is the biggest event for public sector and business professionals to discover insights for sustainable performance. Each year the CPA Congress attracts over 2,500 like-minded industry professionals and maximises professional development by offering over 80 sessions across a range of topics from high profile speakers www.cpaaustralia.com.au

Click on the link to view/download the Exception Reporting presentation.

What women want and other analytical questions

Last night my wife showed me a spreadsheet where she's been recording her weight for the last 9 years (she herself admits to being a bit OCD). I saw a perfect application for CALUMO In-Cell Charting to present this data in an intensely meaningful way using a sparkline.  She was so impressed when I showed her the chart and for once my need for analytics, proof & logic satisfied her need to be understood.

My Analysis
Within a few seconds of building the chart, I was able to make the following observations:

• Other than on 4 occasions, she has stayed within + or - 10% of her 9 year average weight (her normal range).
• You can easily spot her 2 pregnancies at the 2 chart peaks, but I note she consumed more chocolate thickshakes during her first pregnancy, thus explaining her max of 90kg (at the red dot) just before the birth of our first child.
• She experienced more dramatic weight loss after her first pregnancy than after the second pregnancy. The faster weight loss was assisted by weight loss tablets, which took her to her min of 63kg (at the green dot), but the low was short lived when she stopped taking weight loss tablets.
• I proudly note a healthier and more sustainable approach during & after her second pregnancy (fewer thickshakes, no weight loss tablets and plenty of exercise).
• In the early years, prior to her first pregnancy, there are a few volatile up & down swings. These reflect those volatile and decadent years before children.

So why did I use an in-cell chart?

Well, for one thing the chart above is effectively representing more than 3,000 data points (9 x 365). CALUMO In-Cell Charting provides an intelligent visual presentation of large amounts of meaningful data for identifying trends, comparing data and highlighting exceptions. Secondly, the chart display with the min/max, normal and closing looks deceptively simple – its actually not for the novice to achieve in standard spreadsheet packages. By combining charts and data together in a table, we easily achieve this and do away with the need to separately label axes and legends, or the need to associate the table data with the chart information.

CALUMO In-Cell Charting (AKA Sparklines) provides Line, Axis, Bar, Bullet, Grid, Strip & Arrow charts. Imagine the application of this where a single page transforms and concentrates large amounts of corporate data into KPI's on a single page for rapid and effective review and analysis.

One of the Six Most Promising Private Technology Ventures from Australia

Red Herring 100 Asia is an exclusive event honouring 100 cutting-edge private technology companies from across the Asia-Pacific region.  The event brings together an elite roster of entrepreneurial and global venture investment firms to showcase excellence in innovation.
 
Winners were selected from a pool of more than 500 applicants based in 16 countries/regions including China, India, Japan, Singapore, Korea, Australia and Vietnam.  The names of the 100 announced winners can be found online at www.herringevents.com/asia07/redherring100.html#100.
 
The Red Herring editorial team carefully selected the winning companies based on both quantitative and qualitative criteria such as financial performance, technology innovation, quality of management, execution of strategy, and integration into their ecosystem. The 100 winners are based in 16 countries/regions including China, India, Japan, Singapore, Korea, Australia and Vietnam.
 
"After a rigorous evaluation process, we’re very happy with winners we selected,” said Joel Dreyfuss, Editor-in-Chief of Red Herring.  “There was a large pool to choose from and we’re impressed by the calibre an innovative talent bursting from Asia’s business and technology sector.”

About CALUMO Labs Pty Ltd
CALUMO Labs software is the only complete, unified Performance Management and Business Intelligence solution built entirely in .Net2 and powered by Microsoft’s Analysis Services 2005. CALUMO provides planning, forecasting, consolidations, reporting, analytics and dashboards across financial, executive and all operational departments. CALUMO Labs empowers the enterprise through insight, integration and collaboration. For more information, visit www.calumo.com.
 
About Red Herring
Red Herring is a global media company uniting the world’s best high technology innovators, venture investors and business decision makers in a variety of forums: a leading innovation magazine; an online daily technology news service; technology research, and major events for technology leaders around the globe. Red Herring provides an insider’s access to the global innovation economy, featuring unparalleled insights on the emerging technologies driving the economy. For more information, visit www.redherring.com.

SYDNEY, Australia, August 31, 2007 –  At a gala function at the 2007 Microsoft Australia Partner Conference held at Hamilton Island, Microsoft awarded Calumo Labs Pty Ltd the Microsoft Partner of the Year Award in the category "Data Management Solutions, Database Management".

The award recognises the partner that provides outstanding solutions in data warehousing and business intelligence. The winning partner’s solutions provide organizations with a competitive edge in performance reporting and business insight across the enterprise, leading to better and more timely business decisions.

"The award is a testament to the depth of experience and innovation that Calumo Labs brings to customer solutions delivered on the Microsoft platform" said Christine Bishop, Product Marketing Manager SQL Server, Microsoft Australia. "Given the significant investments that Microsoft have recently made to make BI capabilities more accessible across the organization, partners such as Calumo Labs are vital to the future success of Microsoft and its customers."

"We are delighted to have received this award from Microsoft” said Jeff Walter, Marketing Director, Calumo Labs. “It confirms our leadership position in delivering innovative BI solutions to clients using Microsoft technologies. For us, the award underlines the enormous opportunities for Business Intelligence delivered on the Microsoft platform and reflects the dedication, talent and professionalism of the entire Calumo Group team." Mr Walter also offered "Special thanks to the Microsoft Australia team for their ongoing support and willingness to always ‘go the extra mile’ for their partners."

Pictured: Jeff Walter holding the award and celebrating with Christine Bishop (Product Marketing Manager SQL Server) and Tony Mudie (ISV Business Solutions), Microsoft Australia.

About CALUMO Labs Pty Ltd (formerly SPF Pty Ltd)
CALUMO Labs software is the only complete, unified Performance Management and Business Intelligence solution built entirely in .Net2 and powered by Microsoft’s Analysis Services 2005. CALUMO provides planning, forecasting, consolidations, reporting, analytics and dashboards across financial, executive and all operational departments. Calumo Labs provides comprehensive consulting, training and support services for BI solutions built with Calumo on the Microsoft BI platform. CALUMO Labs empowers the enterprise through insight, integration and collaboration. For more information, visit www.calumo.com.

One of the Most Promising Private Technology Ventures in Asia

Red Herring carefully selected the finalists based on criteria such as technology innovation, financials, business model, management team, customers and alliances.  The 200 finalists are based in 16 countries/regions including China, India, Japan, Singapore, Korea, Australia and Vietnam. The names of the 200 companies short-listed as finalists for the "Red Herring 100 Asia 2007" can be found online at http://www.herringevents.com/asia07/redherring100.html

"The 200 finalists we selected from across 16 countries and regions are all excellent contenders," said Joel Dreyfuss, Editor-in-Chief of Red Herring. "They are exceptional companies who thrive on innovation and strongly define the important role of technology in Asia’s economy and throughout the world."

About CALUMO Labs Pty Ltd
CALUMO Labs software is the only complete, unified Performance Management and Business Intelligence solution built entirely in .Net2 and powered by Microsoft’s Analysis Services 2005. CALUMO provides planning, forecasting, consolidations, reporting, analytics and dashboards across financial, executive and all operational departments. CALUMO Labs empowers the enterprise through insight, integration and collaboration. For more information, visit www.calumo.com.

About Red Herring
Red Herring is a global media company uniting the world’s best high technology innovators, venture investors and business decision makers in a variety of forums: a leading innovation magazine; an online daily technology news service; technology research, and major events for technology leaders around the globe. Red Herring provides an insider’s access to the global innovation economy, featuring unparalleled insights on the emerging technologies driving the economy. For more information, visit www.redherring.com.

Just for fun I created the AFL ladder below using CALUMO to illustrate two of our business intelligent in-cell charts.

In the first column of the table, we're using a win/loss bar chart to show each team’s record for the 17 rounds of the 2007 AFL season. A blue bar represents a win, a red bar a loss and a blank bar a draw. With 16 teams and 17 rounds played, the bar chart effectively shows the visual equivalent of 272 data points, maximizing data density without compromising readability or ease of use.

Let's take a look at these results: Geelong took 5 rounds to warm up, but definitely seem to be on a winning roll now. Collingwood & Fremantle both seem to have a "win at home, loose away from home" problem. After winning six games straight, West Coast started paying the price for not being able to play their best football.

CALUMO In-Cell Charts provide an intelligent visual way of presenting large amounts of meaningful data for identifying trends, comparing data and highlighting exceptions.

In the last column of the table, we compare the percentage wins using a simple relative sized horizontal bar combined with numeric value percentage wins. By combining charts and data together in a table, we do away with the need to separately label axes and legends, or the need to associate the table data with the chart information. In order to achieve this, CALUMO Visualization Widgets provide in-cell charting for presentation class dashboards and charts.

With the click of a mouse, CALUMO In-Cell Charting make the design of really compelling executive dashboards easy.

Business Intelligence and Performance Management Home

CALUMO has been chosen as one of five finalists in the "Applications and Infrastructure Tools" categories for the prestigious 2007 iAwards.

The Applications and Infrastructure Tools award is presented to the most innovative nomination for the development of applications and infrastructure tools. Any software program that operates hardware increases the efficiency of systems, measures and/or monitor systems usage and performance. Any software program that provides for data access/retrieval, data manipulation (eg.sort/merge), data management, data warehousing and program design/development. It includes all database management system (DBMS) software; decision-support and executive information system (EIS) programs; spreadsheet programs; front-end and back-end CASE tools; and emerging areas like cooperative processing and/or object management application development tools.

The iAwards finalists reflect the diversity of innovation across the Australian high-tech community. The iAwards program recognises the need to celebrate the significant contributions that ICT makes to the Australian economy.
 
The iAwards will be co-presented by AIIA, the Australian Financial Review, the CSIRO ICT Centre and MIS Australia at the iAwards gala dinner on Wednesday 30 May 2007 in Sydney.

The Australian iAwards are an initiative of The Australian Information Industry Association (AIIA).

About AIIA
The AIIA is the leading national body representing the information and communications technology (ICT) industry. With almost 500 member companies right across the country, from every sector of the industry and representing every size of company. AIIA sees itself as the representative of the Australian ICT industry.

The role of AIIA is to set the strategic direction of the ICT industry, influences public policy, engages industry stakeholders and provides member companies with business productivity tools, advisory services and market intelligence to accelerate their business growth. AIIA assists the ICT industry to meet its business objectives, both locally and globally.

Business