Course Description
This course's goal is to help report authors improve their knowledge of IBM Cognos Analytics by using dimensional reporting methodologies. Participants will gain knowledge of the unique dimensional functions and capabilities offered by IBM Cognos Analytics in order to produce reports that navigate and manipulate dimensional data structures through interactive demonstrations and activities.
Prerequisites
- IBM Cognos Analytics: Author Reports Fundamentals (v11.0)
- Knowledge of your business requirements
- Knowledge of dimensional data
Target Audience
Report authors working with dimensional data sources.
Learning Objectives
- Comparing dimensional and relational data sources
- Understanding dimensional concepts and reporting styles
- Creating reports using dimensional data items such as members, levels, and hierarchies
- Focusing reports using dimensional techniques such as edge filters, slicers, and filter functions
- Navigating dimensional data structures using functions to find related members or comparison time periods
- Creating sophisticated measure calculations
- Understanding totals and aggregation
- Analyzing reports with drill-up and drill-down techniques
- Configuring advanced drilling behavior to support complex calculations and dashboard reports
- Setting up drill-through access from one data source to another
Content Outline
- Different data sources & models
- OLAP dimensional structure
- Dimensional data items & expressions
- Differentiating the IBM Cognos Analytics query language from SQL & MDX
- Differentiate relational & dimensional report authoring styles
- Working with members
- Identifying sets & tuples in IBM Cognos Analytics
- Purpose of report context
- How data is affected by default & root members
- Comparing dimensional queries to relational queries
- Importance of filtering dimensional queries
- Different filtering techniques
- Filtering based on dimensions & members
- Filtering based on measure values
- Filtering using a slicer
- Using IBM Cognos Analytics dimensional functions to create sets and tuples
- Performing arithmetic operations in OLAP queries
- Identifying coercion errors and rules
- Navigate dimensional data using family functions
- Navigate dimensional data using relative functions
- Navigate dimensional data using relative time functions
- Default drill-up and drill-down functionality
- Identifying cases when you need to override default drilling behavior
- Configuring advanced drilling behavior to support sophisticated use cases
- Defining member sets to support advanced drilling
- Defining member sets to support functions
- Navigating from a specific report to a target report
- Drill down to greater detail & then navigate to target report
- Navigating between reports created using different data sources
- Reviewing concepts covered throughout the course
FAQs
A web-based comprehensive business intelligence package from IBM is called Cognos Business Intelligence. It offers a suite of tools for analytics, score carding, reporting, and keeping track of events and data. The software is made up of a number of parts that are made to satisfy the various information needs of a business. For example, IBM Cognos Framework Manager, IBM Cognos Cube Designer, and IBM Cognos Transformer are all parts of IBM Cognos.
To attend the training session you should have an operational Desktops or Laptops with required specification along with good internet connection to access the labs.
We would always recommend you to attend the live session to practice & clarify the doubts instantly and get more value from your investment. However, if due to some contingency if you have to skip the class Radiant Techlearning would help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use.
Radiant Techlearning has a data center containing the Virtual Training environment for the purpose of participant’s hand-on-practice.
Participants can easily access these labs over Cloud with the help of remote desktop connection.
Radiant virtual labs provides you the flexibility to learn from anywhere in the world and in any time zone.
The learners will be enthralled as we engage them the real world and industry Oriented projects during the training program. These projects will improve your skills and knowledge and you will gain better experience. These real time projects, they will help you a lot in your future tasks and assignments.
Radiant Telelearning offers customized solutions and training programmed for individuals, teams and businesses depending upon what they require. Here is how we help each one through our diverse formats.
Individuals / One-O-One Training
▪ Focused learning sessions
▪ Programmed scheduling according to your choice
▪ Get personalized attention
▪ Choose what technology interests you
Teams: Enroll for our Classroom or online Public Batches
▪ Get our specialized updated content for different skill levels
▪ Get on-demand learning and solve problems quickly
▪ Get help from the ground level through sequential learning
Enterprise:
▪ Get customized training programmed and solutions that can be curated especially for your business
▪ Meet needs of all learners
▪ Let your employees be geared up for all kinds of problem solving
▪ Inspire your teams for future
▪ Update your employees with latest information stretching from technology, business leadership to marketing
Radiant Telelearning has large pool of in-house certified trainers & consultants with strong background and working experience on the technology.
Radiant Telelearning offers more than 800+ courses and for each course Radiant have identified best-in-class instructors.
Radiant has highly intensive selection criteria for Technology Trainers & Consultants, who deliver you training programs. Our trainers & consultants undergo rigorous technical and behavioral interview and assessment process before they are on boarded in the company.
Our Technology experts / trainers & consultant carry deep dive knowledge in the technical subject & are certified from the OEM. Our faculty will provide you the knowledge of each course from fundamental level in an easy way and you are free to ask your doubts any time from your respective faculty.
Our trainers have patience and ability to explain difficult concepts in simplistic way with depth and width of knowledge.
Radiant believes in practical and creative approach to training and development which distinguishes it from the other training and developmental platforms. Moreover, training courses are undertaken by some of the experts who are having vast range of experience in their domain.