Many midsized companies have to deal with a very particular problem: the need of a true business intelligence (BI) solution, while having to select and deploy one within a tight budget. On September 29, 2009, IBM Cognos announced the launch of Cognos Express, a new product specially designed to meet the needs of the midsized market. Of course, here at TEC, we took the time to give it a try. We downloaded the trial, and got our hands on this brand new BI tool.
Before we start, let’s have a look at some interesting facts: Cognos Express is a Web-based tool composed of three base products: Cognos Express Reporter (a reporting and querying tool), Cognos Express Advisor (a tool for data analysis and visualization), and Cognos Express Xcelerator (a tool for data analysis and planning based on Microsoft Excel; all of these three can be managed by the Cognos Express Manager. The idea behind this three-part system is to create a complete set of BI tools, giving the user the option of installing only the needed functionality. Each module can be installed separately and each can complement each other.
Now, the details: The installation can be done with ease, and there is no special rule or trick to it. If you want to try it, download a free trial version of Cognos Express, unzip it in a new directory, and click on the install icon (as for many applications). During the installation process, you will just need to define the administrator user and password, and that’s it. Once the installation process is finished, you can open the IBM Cognos Express Manager, a Web interface defined to serve as a centralized administration tool for Cognos Express. From this interface, it is possible to install all the modules (Reporter, Advisor, and Xcelerator), create and configure users, and configure data sources. There is also an event messages window to track all events occurring in the BI environment; this can be very useful for tracking events (such as tasks performed, errors, exceptions, etc.) during the installation and operation of Cognos Express. Installing a product module like Cognos Express Reporter requires only a single click and, at least on my machine, it seems to work just fine.
It really looks like IBM Cognos has made a big effort to keep things simple: the manager interface has a user-friendly appearance, and it’s easy to detect the graphical location of almost every task in the Cognos Express Manager Web interface due to its simple design.
Creating users is also very simple. There are already some preconfigured features, like user groups, that can be used to create a group of up to 100 users—if the product is licensed. It’s possible to create users immediately, and attach them to specific workgroups, like Express Administrators or Express Users. With these functionalities, it’s possible to create an acceptable and secure user access policy.
The Data Advisor is simple to use and allows users to connect to a common type of data source, such as Oracle databases, DB2, Sybase, Informix, and open database connectivity (ODBC). At this point, the “problem,” as with other applications, is that sometimes it is not a good idea for business users to mess with native data sources, particularly if they do not have the technical skills to interpret raw data coming from the data warehouse. This is what Framework Manager is for; this Windows-based interface enables the user to create business-related metadata for reporting and analysis, while providing an integrated view of data to all Cognos Express users.
The following is a brief description of the Cognos Express products.
Cognos Express Reporter. Creating a report in Cognos Express can be done using the Query Studio. It also has features to format data, fonts, decimal places, etc. All of the report creation process can be done very fast. It’s also possible to create a chart from a set of chart types with the data previously selected.
Cognos Express Advisor. This is the online analytical processing (OLAP) data engine that enables all data analysis. This tool enables users to analyze data collected from relational data sources in a dimensional way by creating data cubes that enable fast and flexible data analysis. Again, the tool was designed to keep things simple. Users can improve the decision-making process by basing their decisions on Advisor-enabled data analysis.
The third tool, Cognos Express Xcelerator, enhances Microsoft Excel with a new set of report and business analysis tools. But the description of this product will have to wait until another time; it brings a hot topic to the BI market that deserves more than a couple of lines.
Finally, it’s important to consider what made a company like IBM consider launching a new tool entirely configured for the midsized market. Midsized organizations need new technology to help them accomplish their goals. But, as they often have only a limited budget to do it, Cognos Express could be another BI software solution to consider for this type of company.
I welcome your thoughts—leave a comment below, and I’ll respond as soon as I can.
read this and tell me we shouldnt be doing this kind of stuff
I have one quick question regarding the Databases, Can Cognos Express run or fatch data from SQL database.
Need your prompt response in this regard,
We use BO today but for planning and forecasting purposes we are installing TM1. Is there any reason to review our reporting strategy and consider using Cognos Espress?
What does this mean for TM1?
Cognos Express counts on a ODBC, OLEDB, and native clients for SQL Server databases.
On the other hand, please consider that Cognos Express is not intended to replace any other Cognos product. This is a new product designed and priced for mid-size organizations. So, there are many things to consider (like information volumes, number of users, and IT infrastructure) before changing your BI product.
We already have SQL Analysis Services cubes built. Will Cognos Express display those, or would we have to build OLAP cubes using the Cognos Express Advisor?
Cognos Express can handle any data source, whether its’ direct or through an ODBC link. We haven’t found any sources that it cannot handle.
Having worked in Analytics for over 10 years, I am excited about this product and so are my customers.
Every time we show a new prospect the drag and drop reporting studios (there are 2 - one for ad-hoc reports & one for advanced reports), the Excel based Planning which updates in real time and the advanced dashboards and scorecards that can be created so quickly and simply, they always want to know more.
Cognos Express gives any size organisation access to enterprise level reporting, analysis & planning but with an easy to use interface for business users. So this means no additional strain on your IT team, as midsize organisations usually only have a small IT team anyway! And one tool means, less maintenance & lower costs.
Anyway I could go on and on about it, it’s well worth downloading the trial version and seeing for yourself.
Can you give us some idea of the ballpark cost of Cognos Express? I have used the Enterprise version of the product and was very impressed. Now I am working with much smaller companies and it might be useful for some of our projects.
The best thing I like in Cognos BI Suite is their Balance Score card module, do they plan to package it with in Cognos Express.