<< VIEW FULL RESOURCE LIBRARY

New Capabilities with Cognos Data Modules

September 12, 2019

Cognos Analytics (v11)

Demos of Features that Boost Self-Service Analytics

If you aren’t all that familiar with the data modules capability in Cognos Analytics, you are doing yourself and your data a disservice. Allowing you to connect to and combine the world of your data, data modeling in Cognos Analytics opens the door to self-service analytics and a world of deeper insights. With software release 11.1, Cognos includes some major—dare we say huuuuge—improvements to its data modeling capabilities. New features and capability tweaks that boost the ability of organizations' self-service content creation.

Listen to this webinar recording to find out what’s to love about data modules. Our in-house Cognos expert, and one of our most sought after Cognos instructors, September Clementin shares her perspectives, discuss intent-driven modeling, calculations and data security, and demo uploading files, creating custom tables, unions, joins and content organization.

▼ TECHNOLOGIES COVERED

Cognos Analytics

▼ PRESENTER

September Clementin
Cognos Consultant & Trainer
Senturus, Inc.

September has over 15 years of expert level experience with the Cognos suite. She has helped 50+ public and private sector clients with large scale business intelligence implementations including dashboard design, interactive performance metrics development and data modeling. She designs business intelligence course curriculum, delivers 20+ advanced BI reporting courses a year, develops BI best practice webinars and provides mentoring services for other BI professionals.

▼ PRESENTATION OUTLINE

  • Overview?
    • Data modules encourage and empower users to perform self-service analytics combining multiple data sources.
  • Data modules are based on
    • Existing data modules built in Cognos Analytics
    • Pre-configured database connections such as SQL Server, DB2, Redshift, SAP HANA
    • Desktop-based files such as Excel workbooks, CSV
    • Extracts or Snapshots from existing packages
    • Live connections to existing (relational) packages
    • Simple join relationships can be defined and managed by business (end) users.
    • Join type, cardinality and join filters can be easily managed using non-technical terminology and cues.
  • Interface
    • Enhanced data module interface enables filtering by data source type and time frame.
  • Intent-driven modeling proposes tables to add to the module
  • Custom tables operations can be used to include or exclude records or to add additional detail to existing records.
  • Content organization
    • Folders can be created to organize tables and columns
    • Folders can be created at the root of the data module, within a table, and within another folder
    • Folders, tables and data items can be hidden from view
  • Calculations
    • Folders can be created to organize tables and columns
    • Folders can be created at the root of the data module, within a table, and within another folder
    • Folders, tables and data items can be hidden from view
  • Data security
    • In addition to filtering data, row level security can be added to a data module only if it is sourced from database tables
    • Security can be assigned at the user, group or role level
  • Quick tips
    • Data granularity differences between data module sources may need to be addressed
    • Create table views, alter data module aggregation settings or create calculations
    • Create joins, sets or calculations directly in the report
    • Data format must be consistent between fields used for joins and between all columns when creating a union between tables
    • More complex modeling requirements (i.e. complex security requirements, parameter maps, versioning) are well suited for Framework Manager