Getting Started with IBM Cognos Insight: A Guide for Importing Data - Part I
Congratulations on downloading your free copy of IBM Cognos Insight! If you're unfamiliar with Cognos Insight it's our personal analytics solution that lets you explore, analyze, visualize and share data without relying on IT for assistance. In minutes, analysts and line-of-business managers can create and share custom applications, dashboards and visualizations to help solve individual and workgroup challenges. If you don't have our free, downloadable copy of Cognos Insight, click here to get it now!
Before you get too far reading this post the assumption is that you've looked over the first blog in this series, 'Getting Started with IBM Cognos Insight: First Steps with Insight' which provides an explanation of the opening screen of Cognos Insight including navigational tips so you're up and running with this personal analytics tool as quickly as possible. If you haven't read this post yet, click here to go directly to it.
Since we've got such a vast amount of resources available to people just getting started with Cognos Insight we wanted to put this series together to walk you through all that's available as you learn the power and capabilities as an individual and workgroup analytics solution while being ente
Let's get started. We should focus on importing data into Cognos Insight. For starters, importing data into Cognos Insight could be from delimited data or text, file, spreadsheet or relational data accessed through an ODBC source.
(Note: You can also import an IBM Cognos BI package or BI report into Cognos Insight which we'll cover in a later post.)
To import data into Cognos Insight you'll select items from the Get Data drop-down from the top-line menu or you can drag and drop your files into Cognos Insight. See the two red boxes below to see where these options are within Cognos Insight.
Use the keystroke 'Get Data/Quick Import' from the top-line menu to have the system determine what columns are dimensions and measures in your import file. The system will assume the last column is where your data, or measure, exists with the preceding columns assumed to be dimensional information. To import more complex data which includes levels and hierarchies or to exclude data from your import, you would instead choose the 'Get Data/ Import Data' option from the top-line menu.
Here's a short video on importing data into Cognos Insight using 'Get Data/Quick Import':
Let's look at situations where you would need to use 'Get Data/ Import Data' selection item instead of simply selecting 'Get Data / Quick Import'.
Using the 'Import Data' instead of 'Quick Import' applies when your import file is a text file. If you want to change the structure of your data you'll want to use this type of import. Files would contain columns of data where you'll want to preview the information to map source-to-target. You're able to move items around or even add a calculated item. This section also allows to change the properties of each dimension being imported. An example property change would apply when dealing with a time dimension.
Check out this video to see an illustration of these points:
View this short video which covers importing a relational data source using ODBC:
Importing data into Cognos Insight is clearly an important activity for users of this solution to perform. That's why we've done extensive development work to make this process as easy as possible so that you can easily import data into this personal analytics solution so you can get to the full-breadth analytics Cognos Insight enables for what-if scenarios, budgeting, visualizations and sharing of information.
Once you've got a handle on importing data into Cognos Insight I suggest get our excellent 'Tutorial & Samples'. Get this tutorial and samples package by clicking here.
Tim O'Bryan, AnalyticsZone
Read more at the Insight Community blog