|
Cognos 8 BI Training
|
|
Ad-hoc Querying
1 day
|
For business authors who want to create, modify and organise ad hoc reports. Also covers basic administrative tasks, such as scheduling reports and delivering reports in different formats (HTML, PDF, Excel, etc.). |
Report Authoring
Part 1
2 days
|
Covers an introduction to Cognos Connection, report management, basic and intermediate report building techniques, and a way of enhancing, customising and managing professional reports in Report Studio. Attendees will learn the report building process and participate in hands-on demos and workshops that illustrate key concepts. |
Report Authoring
Part 2
3 days
|
Teaches professional report authors advanced techniques for creating, modifying and distributing professional reports using Report Studio and Cognos Connection. You will examine and create query models, burst reports, examine and edit XML report specifications, and author advanced reports. You will also manage events in Event Studio including managing task execution rules, creating a schedule for an agent, and working with agents. |
Metadata Modelling
Part 1
3 days
|
Introduces modelling metadata with Framework Manager using Cognos recommendations as a modelling strategy. Participants will review generic modelling structures and techniques as a foundation for the rest of the course, then be introduced to basic modelling concepts and naming conventions in the Framework manager environment, followed by more complex concepts and techniques to resolve reporting traps. Participants will model both operational and star schema metadata for predictable results, as well as create a dimensional model to be used for OLAP style querying including, managing & publishing OLAP data sources. |
Metadata Modelling
Part 2
2 days
|
Teaches advanced level understanding of the modelling recommendations, as provided in the Cognos 8 BI Metadata Modelling Part 1 course. Participants review the modelling recommendations for modelling both transactional and dimensional metadata for predictable results, and identify the generated SQL for data source and model query subjects. They will also identify techniques for optimizing and tuning models for performance, modelling techniques to meet specific business requirements, and identify how to manage packages and projects |
BI Analysis
1 day
|
Teaches how to navigate and analyse data in Analysis Studio to discover trends, identify opportunities, and make better business decisions. Participants will learn techniques such as ranking, filtering, asymmetrical crosstabs, and graphing to help them analyse large volumes of data 9 whether OLAP or dimensionally modelled relational metadata). |
PowerPlay Transformer OLAP Modelling for Cognos 8 & Series 7 Vn 3
3 days |
Provides modellers with an in-depth understanding of the fundamental skills involved in designing, building and maintaining PowerCubes for use with Cognos 8 BI and PowerPlay applications. The course starts with the design and creation of simple applications becoming more complex as the course progresses. Deployment, performance and security are also covered. |
|
Impromptu
|
|
Reporting Authoring with Impromptu
2 Days
|
This 2-day course takes students with no Impromptu experience through an extensive list of topics to enable them to create fairly sophisticated reports. Subject areas covered include sorting, grouping, filters, frames, cross-tabs and formatting. |
Advanced Impromptu Authoring
1 Day |
This 1-day course follows on from the Report Building course. The topics covered on the course include systems of reports, advanced crosstabs, preparation for Impromptu Web Reports and PowerPrompt applications. |
Impromptu Administration
2 Days
|
This 2-day course covers all aspects of administrating Impromptu for Windows. The curse primarily covers the building of Impromptu Catalogs but also covers connecting to databases, deployment and performance. Students attending this course should either have attended the Report Building course or have equivalent experience |
|
PowerPlay Client
|
|
Series 7 Version 3 PowerPlay Exploration and Report Building
2 days
|
This is a 2-day instructor-led course that provides participants with the skills needed to analyse business data and create reports in PowerPlay. Fundamental Business Intelligence topics are covered, along with the technical skills required to successfully explore PowerCube data in PowerPlay and to apply these techniques to create professional reports. To analyse their data, participants will learn how to drill through cube data, replace categories and measures in a cross-tab, change the display to view the data in one of several graphical formats, format each display to enhance their analysis, sort, rank, and filter data, and create calculations. To create reports, participants will learn how to build a report cross-tab, perform and add calculations, use advanced nesting functions, create subsets, and automate and distribute reports. |
Series 7 Version 3 PowerPlay Transformer OLAP Modelling
3 days |
This 3-day course teaches students how to use Transformer to create PowerCubes for PowerPlay. The course starts with the design and creation of simple applications becoming more complex as the course progresses. Deployment, performance and security are also part of the course
|