IBM Cognos Connection and Workspace Advanced
3.9 (4 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.
31 students enrolled
Wishlisted Wishlist

Please confirm that you want to add IBM Cognos Connection and Workspace Advanced to your Wishlist.

Add to Wishlist

IBM Cognos Connection and Workspace Advanced

Discover Business Intelligence using IBM Cognos
3.9 (4 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.
31 students enrolled
Created by Packt Publishing
Last updated 6/2017
Current price: $10 Original price: $125 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
  • Create 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
  • Create charts, graphs, and dashboards for macro views of microdata… And drill into that microdata
  • Create professional-looking BI web applications1
  • Automate redundant manual reporting tasks, reducing reliance on Excel, and get more time back in your day
View Curriculum
  • This course will guide you through the fundamental concepts of the IBM Cognos BI suite.

This course will be your comprehensive guide to understanding all the features offered by the IBM Cognos Business Intelligence suite. Ask important questions of your data, create effective management reports, and create insightful analyses of your dataset in order to identify patterns and useful trends.

Spanning over 2 hours, this course will give you a quick overview of the basic components of the IBM Cognos BI suite – Query Studio, Report Studio, Analysis Studio, and Event Studio. By the end of this video, you will have a firm understanding of how you can efficiently analyze your data and create visually appealing reports and dashboards with IBM Cognos Business Intelligence.

Whether you're a novice or seasoned user, there is always something new to learn in Cognos BI. Automate more and become more efficient in your day-to-day working life by applying these principles.

About The  Author

With his involvement in both manufacturing and service industries across multiple sectors, Aaron has 15 years' financial system, accounting, and business intelligence experience ranging from startup QuickBooks implementations to large enterprise-class financial operations across multiple geographic locations.

His depth of experience from IT and MIS demands continual process improvement and automation within departmental operations as well as zero tolerance for inaccuracies in management systems.

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?
  • Business Intelligence professionals looking to get a quick overview of the IBM Cognos Business Intelligence suite will find this video to be useful. Some understanding of basic BI concepts will be required to get the best out of this tutorial.
Compare to Other Cognos Courses
Curriculum For This Course
17 Lectures
Introducing Cognos Business Intelligence
4 Lectures 19:12

This video provides an overview of the entire course.

Preview 02:49

Discover the best practice approach for developing meaningful reports in Cognos.
The Four Steps to Report Development

Become comfortable with navigating around Cognos-Connection.
Navigating Cognos Connection

The default Cognos setup may not be perfect for all users.

Changing Your Preferences
Running Reports
5 Lectures 20:31
Get organized! Keep reports orga-nized by role, function, department, or organization to facilitate finding reports and also deploying security later on.
Preview 03:28

Create a portal for the returns department of your organization so the users can quickly and easily run the reports they need.

Portal Tabs

Now that we have some organization to our Cognos environment, let’s run some reports!

Running Reports

Instead of creating one report per country specific revenue, you can use report views to use one report for all countries.
Report Views

Why run the same report every week at the same time, let’s have Cognos do this for us automatically.
Scheduling Reports
Introduction to Workspace Advanced
8 Lectures 29:31
New to Cognos Workspace Ad-vanced? No problem, you’ll be a pro in a few minutes.
Preview 04:51

Packages (or models) are sets of metadata that allow Workspace Ad-vanced to connect to your database using human friendly names and joins.
Selecting a Package

This is where report building be-comes fun.
Adding Data

Every report has its purpose, and we use filters to get to that purpose, oth-erwise a report is just a bunch of data.

Adding Filters

Grouping data puts like data together to facilitate analysis and data consumption.
Grouping Data

Not every package is perfect, and in some cases we’ll need to create cus-tom fields to make them closer to perfect. Luckily, this is easy to do in Workspace Advanced.

Custom Fields

Don’t forget to save this step for last, otherwise you may be formatting a report that doesn’t work correctly.

Now run the report to all formats (PDF, Excel, CSV) to ensure the re-port renders as desired.
Exporting Data
About the Instructor
Packt Publishing
3.9 Average rating
8,229 Reviews
58,946 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.