Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learning Path: The Roadway to IBM Cognos Analytics
Rating: 3.9 out of 5(415 ratings)
1,822 students

Learning Path: The Roadway to IBM Cognos Analytics

Acquaint with new unified interface of Cognos Analytics to consume, modify, and author dashboards
Created byPackt Publishing
Last updated 4/2018
English

What you'll learn

  • Learn to build stunning Dashboards with Cognos Analytics
  • Learn how and when to use visualization
  • Create tabbed dashboards and stories using the new Dashboard tool of Cognos v11
  • Master the full-fledged Report Authoring tool
  • Understand how a dashboard is different from a report, and when to use both
  • Understand the Reporting Interface
  • Implement crosstabs and SQL queries

Course content

2 sections • 49 lectures • 6h 0m total length

  • The Course Overview5:05

    This video will an overview of entire course

  • Introduction to Business Intelligence3:19

    What is business intelligence and what does it bring to businesses?

  • Cognos and Its High-Level Architecture6:50

    What is Cognos and how does it work?

  • Setting Up an Account for Cognos on the Cloud4:22

    Learn how to get access to a free trial of Cognos Analytics in cloud.

  • Sample Databases and Files4:42

    This familiarises you with the sample database that we will use throughout this course, and talks about fictitious companies called NO-Sales and GO-Sales.

  • Welcome Portal7:15

    If you are already using previous versions of Cognos, then there is a big leap in the user interface for you. This video shows Welcome Portal, which is the gateway into Cognos Analytics. 

  • Where’s Report Studio Gone?4:33

    In order to create new reports or edit reports, earlier the Report Studio tool was used. In the new interface, you might be wondering: where’s Report Studio gone?

  • Your First Dashboard7:17

    Action Time! In this video you will learn how to create your first dashboard.

  • On the Back Stage – Connecting to Databases4:23

    For Cognos to connect to any database in the organization, you must set up the database connection. This video shows how.

  • Creating Your Own Data Modules8:16

    Now Cognos allows you to create and update your model on the Web without having to build any Framework Manager model and going to through the publish process. This video shows how.

  • Adding Your Own Data to Dashboards10:43

    Unleash the real power of BI by stitching your own data to organizational data for comparisons, what-if analyses, impact of new hierarchy structures, and so on.

  • Improving Module – Examining the Data Model10:14

    In this video, I will show you some options that are useful to examine the data model you have created and correct any issues. Also, we will see how to check and correct the Usage of columns as Measures, Attributes and Identifiers.

  • Refining Module – Filtering and Cleaning5:34

    For dashboards to perform faster, this video shows how to make data modules sleeker by removing unwanted data. We will also see how to CLEAN UP values in columns.

  • Extending Module – Creating Custom Calculations5:27

    Any simple or complex calculations must be defined in DATA MODULE for use on the dashboard.

  • Generating Stitched Facts – How and Why?9:36

    The data module provides a quick way to generate stitched facts from multiple sources at the required aggregated level of hierarchies. These can be then fed back to the module for use in dashboards.  

  • How to Change Visualization Properties?7:45

    Wondering how to change basic visualization properties like colors, legend, etc? This video will show you how. You will also look at TABBED dashboard and templates.

  • Singletons, Static Texts, and Display Order8:11

    Let’s see how to add HEADLINE figures that not static but rather update automatically when values in the database change or the context of the dashboard changes. We will also see how to add Static Texts and change the Display Order to arrange items behind or in front of another item.

  • Changing Widget Connections9:40

    Functionality to compare facts and figures between two different product lines or other drivers is a common ask. Let’s see how to achieve that by breaking and changing widget connections.

  • Navigation Group for Drill Down9:42

    In order to provide the ability to DRILL DOWN from a high level of hierarchy to a lower level, you need to define a NAVIGATION GROUP in the module. This video shows how, and demonstrates Packed Bubble chart.

  • Creating a Story Using Pins16:09

    Cognos provides a SLIDESHOW like output called STORY. Stories differ from dashboards because they provide an over-time narrative and can convey a conclusion or recommendation. In this video, let’s see how to create a STORY.

  • Changing the Theme and Background5:40

    By changing the THEME of a STORY, you can give it a new look and feel.

  • Adding Multimedia and Info-Graphics9:29

    To enrich the presentation, you can also add images (for example, Company Logo) and videos. In this video, we will add a video from YouTube to a scene in a slideshow. We will also see what info-graphic is and how to add it. 

  • Sharing Story and Dashboard Using Custom URL8:50

    To distribute STORY and DASHBOARD or to create one-click access, the direct URL can be used. You can customize this URL with extra parameters to hide the application bar from top and navigation bar from left. 

  • First Guide to Dashboards using IBM Cognos Analytics

Requirements

  • Basic knowledge of data and relationship between variety of data

Description

The latest version of IBM Cognos Business Intelligence is Cognos Analytics and it brings IBM right back into the game against new-age competitors such as QlikView and Tableau. This sleek, next-generation, unified tool provides you with a fast, intent-driven dashboard and report-authoring interface on top of the strong foundation that IBM Cognos has provided over decades.

Packt’s Video Learning Paths are a series of individual video products put together in a logical and stepwise manner such that each video builds on the skills learned in the video before it. The highlights of this Learning Path are:

  • Explore Cognos and it’s high level architecture
  • Augment enterprise data with your offline data to produce stunning dashboards and presentations without IT costs
  • Learn to secure your data with advanced filters

Let’s take a look at your learning journey. Here, you will strongly focus on the new analytics dashboard tool, that is not only the future of reporting authoring but also appeals much wider audience – right from end users who are simply consumers of data, to power-users who analyze data and create dashboards for consumption, and IT developers who deliver high quality reporting solutions. In addition to analytics dashboarding, which is the completely new feature in v11, you will also learn about what users and author gain by upgrading from older v10 or v8 (why upgrade, and why not). You will get a hang of the completely new connection portal interface. You'll also know the limitations of the dashboarding tool and shows how to mitigate them in the report development tool as it is completely dedicated to Cognos Analytics – Reporting, the advanced report authoring tool. Going further, you will master the Report Tool interface and learn how to create a report dashboard l using simple objects (for beginners). Finally, you’ll go through advanced topics to overcome the limitations of a dashboard tool such as drill-through, prompt manipulation, advanced data formatting, making the dashboards printable, conditional highlighting, and more.

On completion of this Learning Path, you’ll master the art of dashboard creation with advanced report authoring using IBM Cognos Analytics. 

Meet Your Expert:

We have the best works of the following esteemed author to ensure that your learning journey is smooth:

Abhishek Sanghani worked with Cognos 8.x and 10.x for 12 years and delivered countless reporting solutions; he is thoroughly excited to see Cognos 11.x taking a big leap in self-service authoring and dashboard reporting. Currently, he leads a team of software developers, in a large global financial services company, to deliver analytical applications with dashboards and self-service capabilities. Version 11.x being fairly recent, he is involved in testing it from all aspects to assess when and where to use it in the deliveries. He also tries other products such as QlikView, Tableau, and Micro strategy. He believes such experiences with other products make one’s viewpoint wider, and understanding deeper.

The other technology that interests Abhishek is Micro strategy. He possess advanced skills in TM1, Oracle, Micro strategy, SQL Server, and SSAS. He also has a book written on IBM Cognos 8 Report Studio, followed by a video course for Cognos 10 Report Studio Fundamentals. Both have been very fulfilling experiences. He believes this could be a natural and organic update of those Report Studio works. Note that this course focuses on the brand new Dashboarding tool.

Who this course is for:

  • This Learning Path is targeted at:
  • Accountants, managers, controllers, sales heads, and so on will find this Learning Path useful for their day to day work and career progression
  • Developers, business analysts, testers, product owners of reporting system / data warehouse / MIS can use Cognos Analytics (Cognos v11) to author dashboards and stories within IT department
  • Those who are already using Cognos BI v8 or v10 will also find it useful as v11 is dramatically different from the previous versions

Report abuse