by Aaron Solar | Released July 2017 | ISBN: 9781788394833

Reduce your reliance on Excel and begin to let Cognos do the heavy lifting by learning the fundamentals in this Cognos BI courseAbout This VideoAnalyze your data to find interesting patterns and trendsCreate stunning reports and dashboards to get actionable insights using IBM Cognos Business IntelligenceA fast-paced tutorial designed to build a solid foundation in Business Intelligence concepts using IBM Cognos BIIn DetailIBM 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. Show and hide more

1. Chapter 1 : Introduction to Report Studio
   • The Course Overview 00:01:03
   • Navigating Report Studio 00:05:48
   • Types of Reports 00:04:49
   • Adding Data 00:06:48
   • Filters 00:05:01
   • Prompts 00:05:13
   • Formatting Reports 00:04:51
2. Chapter 2 : Introduction to Report Studio – Advanced
   • Prompt Pages 00:06:47
   • Conditional Formatting and Variables 00:04:01
   • Joins and Unions 00:05:23
   • Creating Dashboards 00:07:57
   • Drill Through Reports 00:04:30
   • Active Reports 00:04:35
3. Chapter 3 : Securing the BI Environment
   • Navigating Cognos Administration 00:02:15
   • Securing Reports 00:03:40
   • Securing Directories 00:03:10
   • Securing the Data 00:03:20
   • Using Macros 00:03:11
4. Chapter 4 : Tips and Tricks
   • Changing Packages 00:01:58
   • Adding Javascript 00:02:15
   • Linking Multiple Objects to One Query 00:02:04
   • Page Breaking on Groups 00:01:49
   • Cascading Prompts 00:01:57
   • Working with SQL 00:04:05
   • Handling BLOBs and CLOBs 00:02:34
Show and hide more