IBM Cognos Report Studio
4.3 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
34 students enrolled
Wishlisted Wishlist

Please confirm that you want to add IBM Cognos Report Studio to your Wishlist.

Add to Wishlist

IBM Cognos Report Studio

Create complex reports, web applications, and dynamic dashboards
New
4.3 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
34 students enrolled
Created by Packt Publishing
Last updated 8/2017
English
Current price: $12 Original price: $125 Discount: 90% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Become comfortable navigating around the Cognos BI application.
  • Understand the different applications in Cognos and when to use Query Studio or Report Studio
  • Built ad hoc reports to accomplish quick, on-the-fly reporting requirements
  • Create more complex reports that can be used by multiple users for multiple requirements
  • Develop charts, graphs, and dashboards for macro views of micro data… and drill into that micro data
  • Design professional-looking BI web applications
  • Automate redundant manual reporting tasks, reducing reliance on Excel, and get more time back in your day
View Curriculum
Requirements
  • Using real world and practical examples, learn what you need to master Cognos Report Studio for your organization.
Description

IBM Cognos BI is a web-based report development tool designed to create anything from simple list reports to complex multi-page dashboards across multiple databases.
Create any report your organization requires from visualizations to EDI feeds to third parties, all with one tool.
Using the IBM Cognos BI Developer Trial Edition, you'll learn best practices for navigating Report Studio, the types of reports available, adding data, creating fixed filters, creating prompts (dynamic filters), and formatting. Next, you'll learn advanced topics such as prompt pages, variables, joints/unions, dashboards, drill-through reports, and active reports. Then we'll discuss securing our reporting environment through Cognos Administration, securing reports/directories/data, and the use of macros. Finally, we'll cover tips and tricks such as JavaScript and dynamic page breaking.
By the end of this course, users will be able to take the practical examples used in the videos and apply them to their own environment. Learning Cognos is like learning a foreign language, so continual immersion is needed. Practice a few times a week to become familiar with the interface, your data, your organization's requirements, and your reporting style.

About the Author

Aaron Solar

With involvement in both manufacturing and service industries across multiple sectors, Aaron has 20+ years of BI, financial system, accounting, and business intelligence experience. His depth of experience from IT & MIS demands continual process improvement and automation within departmental operations as well as zero tolerance for inaccuracies in management systems. Aaron is currently a consultant for Aronson LLC, a firm based in Rockville, MD.
Specialties: Cognos Business Intelligence (BI): Query Studio, Workspace Advanced, Report Studio, Framework Manager. Cognos Impromptu. Deltek Costpoint, Deltek GCS Premier, QuickBooks, MS Dynamics NAV/Navision, Ross Systems, Crystal Reports, MS Access, SQL Server, MySQL, Oracle, Adobe Creative Suite, Joomla, WordPress, X-Cart, and so on.

Who is the target audience?
  • Anyone from the novice to the advanced user looking to get more out of Cognos.
Compare to Other Cognos Courses
Curriculum For This Course
25 Lectures
01:38:53
+
Introduction to Report Studio
7 Lectures 33:29

This video provides an overview of the entire course.

Preview 01:02

New to Cognos? Ok! Let’s take a look around to get the hang of the interface.

Navigating Report Studio
05:48

There are report templates for most items you will need, or start with a blank slate and create your own.

Types of Reports
04:49

In this video, we will add data and start building our report.
Adding Data
06:48

Adding fixed filters can help reduce data returned on a report during development, and later on we will see how filters will secure the data.

Filters
05:00

Prompts are a great way to build in dynamic filters into the report.

Prompts
05:12

We will put finishing touches to our report in this video. Always be sure to save formatting for the last step!

Formatting Reports
04:50
+
Introduction to Report Studio – Advanced
6 Lectures 33:11

Prompt pages are a great design means to put all prompts together into one or multiple pages. We can even make the prompts dynamic to make the report behave as a web application.

Preview 06:47

Conditional formatting and variables are great ways to show data outliers or hide unneeded fields in a report. Combine these with prompts for a truly dynamic report experience.

Conditional Formatting and Variables
04:01

Not all joins can be perfected in the framework. In this video, we’ll go through creating custom joins and unions in Report Studio.

Joins and Unions
05:22

Let’s turn that simple report into a dashboard in this video. We will mix numerical with graphical data for a simple dashboard that can be easily enhanced.

Creating Dashboards
07:57

While everyone loves charts and graphs in their report, they often lead to many questions. In this video, we will use drill through reports so that users can drill into the details behind their graphical data.

Drill Through Reports
04:30

Active reports are a great way to deploy automated reports and dashboards without the users requiring to be connected to Cognos or the database behind it.

Active Reports
04:34
+
Securing the BI Environment
5 Lectures 15:35

Create Cognos specific groups and add users or AD groups to facilitate rolling out Cognos security.

Preview 02:15

In this video, you will learn how to secure individual reports by modifying permissions and adding or restricting groups.
Securing Reports
03:40

Too many reports to secure? No problem, let’s go ahead and secure some directories.

Securing Directories
03:09

Sometimes securing a report isn’t enough. In this video, you will learn how to restrict sensitive data from viewers by hard coding some filters into a report.

Securing the Data
03:20

Macros aren’t often used but have great dynamic options, such as only allowing a consumer to see product lines that they manage.

Using Macros
03:11
+
Tips and Tricks
7 Lectures 16:38

Need to change packages after you have already started development? No problem!

Preview 01:57

JavaScript can be a handy tool for some advanced techniques in Report Studio.

Adding Javascript
02:15

Keep development simple using fewer queries to drive more report objects. If a report page has a chart and list that use the same date, have them both use the same query.

Linking Multiple Objects to One Query
02:04

Page Breaking on Groups helps present data to keep like data together, for example, by product line or region.

Page Breaking on Groups
01:48

Facilitate prompting and overall user experience by enabling cascading prompts, where what you select with one prompt will lead to options available on the next prompt.

Cascading Prompts
01:56

Whether you have complex datasets or just a quick requirement to extract data using SQL instead of framework modifications is a great way to get the data exactly how you need it.

Working with SQL
04:04

More databases are taking advantage of using BLOB or CLOB fields. Here’s how to handle those in your reports to prevent errors from displaying.

Handling BLOBs and CLOBs
02:34
About the Instructor
Packt Publishing
3.9 Average rating
8,249 Reviews
59,142 Students
687 Courses
Tech Knowledge in Motion

Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.

With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.

From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.

Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.