Numius Academy 2011 Catalog by Numius

2011 Catalogue

Training & Coaching Numius Academy

BUSINESS ANALYTICS

BETTER PERFORMANCE STARTS WITH TRAINING

93% of all participants rate Numius Academy as good to excellent in 2009-2010 due to the pragmatic and experience-based approach.

Why choose Numius Academy No matter how good a Business Analytics solution may be, it is only a success when the end-users express that the solution offers added value. Training and coaching play a crucial role in the acceptance and optimal usage of any Business Analytics solution.

BUSINESS ANALYTICS

Training starts with a training plan at a project’s start, not at the end, since it is a key success factor to a project’s results. After project delivery, education should continue to ensure that users gain and develop the knowledge and skills they need. Numius Academy develops and executes a training plan tailored to your company’s needs. Using our standard modules we can quickly customize our training material, based on your applications in order to ensure maximum knowledge transfer. As a leading service provider in Business Analytics, Numius Academy is dedicated to train, coach and assist its participants in order to grow in their day-to-day activities. Our goal is to provide participants with the necessary knowledge so they can put their main focus on using the information available in their Business Analy-tics environment. We encourage participants to fully engage during the training. Our facilities are equipped with PC’s and a training environment where the participants can log onto individually. For onsite training at your company, we can assist you with the installation and configuration of the training environment. Numius Academy uses both a modular and practical approach in the training material. The modular approach ensures that the participants can search through the syllabus in a fast and efficient way, making it a clear user manual. The practical approach implies that business cases are immediately incorporated in the syllabus. Hence, the syllabus is immediately applicable to the participant’s daily activities.

Contents

Numius Academy

Why Choose Numius Academy Public and in-house Training Pricing And Registration

2 4 5

General Business Analytics Cognos Business Intelligence Cognos Planning Cognos TM1 Planning BSP Software

6 10 26 28 30

Sites Terms and Conditions

32 33

The Numius Academy course leaders are a team of highly qualified and professional consultants who are certified experts in their business and technological area. They can build on the practical experience they have gained during implementation projects, making the course leader an ideal person to interact with during a training session and to relate to your own challenges. As an IBM Premier Business Partner, Numius is authorized for the Cognos Business Intelligence , Cognos Planning and Cognos TM1 platforms. All our courses are developed in-house and based on actual experience from implementation projects. Visit our website on www.numius.eu for the latest information on Numius Academy. We are constantly developing new course material for new training offerings. We look forward to welcoming you as a course participant at the Numius Academy Numius Academy

BETTER PERFORMANCE STARTS WITH TRAINING

Our in-house training package contains several course types Standard: Any course direct from the training curriculum using the standard syllabus developed by Numius and based on a fictive Cognos environment. Customized (Light): Any course direct from the training curriculum, based on the standard syllabus, but with exercises directly applied to the participant’s own Cognos environment. The main purpose is for the participant to recognize his/her own environment during practical exercises.

Public and in-house training Delivering education in a way that suits your needs

Customized (Full): Any course direct from the training curriculum, based on the standard syllabus, where exercises and screenshots are adjusted to the participant’s Cognos environment. The training focus throughout the training is still based on the standard syllabus’ content but can be adjusted to suit specific requirements. The main purpose is for the participant to recognize his/her own environment throughout the whole training.

As a leading supplier of Business Analytics solutions based on IBM Cognos technology, Numius is committed to the ongoing development of Business Analytics users. We offer an extensive program for end-users, business analysts, project managers, developers and administrators.

Tailor-made: Any course specifically developed in accordance with the requirements for your organization. The content, length and course focus is discussed and agreed with our course coordinator. All our trainings are offered in Dutch, French and English. Our syllabus material is available in Dutch and English. In French it is available upon specific request.

We offer a public training service as well as an in-house training service where we provide you with a flexible and cost effective approach to learning as we bring our experts to you.

Our training material is also available in the form of self-paced eLearning and in a pay-peruse model. Pay-per-use allows you to organise your own trainings based on the Numius Academy training material. For more information, please call Numius on +32 16 20 29 05 or contact us on academy@numius.eu.

Our public training service includes use of a PC with training environment, sandwich lunch and refreshments during the break.

Our in-house training service delivers several benefits First class training As in our public courses, all trainers are highly skilled in their areas of expertise and have a wealth of personal knowledge and experience. All combine training delivery with hands on experience in Business Analytics implementations.

Pricing and Registration Numius uses a transparent pricing model to ensure cost-effective education:

In-house training

Cost effective

Full day (level: Basic and Intermediate courses)

€ 1.500,-

Since the training takes place at your own premises, there is no travel, no time away from the workplace and no expenses often associated with public training courses. Fees are charged per day rather than per delegate, therefore staff can be trained at a very low cost per person enabling you to maximize your training budget.

Full day (level: Advanced courses)

€ 1.700,-

Flexible All the courses from our public training program can be offered on an in-house basis. Should you require something more tailored to your exact training requirements, we can also develop a course to suit your specific needs. As you are able to arrange a date that fits in with existing work demands, in-house training offers the ultimate flexible training solution.

Half day

€ 950,-

Customization (per day)

€ 1.250,-

Syllabus per person

€ 100,-

Public training Per day, per person (level: Basic and Intermediate courses)

€ 535,-

Per day, per person (level: Advanced courses)

€ 595,-

Immediate impact By learning in familiar surroundings and having colleagues alongside throughout the training, the impact throughout the organization is immediate. Sensitive company information can be shared and used as real life examples during the course in complete confidence to enable you to relate your learning directly back to your working environment.

All prices exclude VAT. Numius reserves the right to change above pricing model. Only the price mentioned on your booking confirmation is valid.

+32 16 20 29 05

Numius Academy

www.numius.eu

academy@numius.eu

Numius Academy

â&#x20AC;&#x153;

Numius Academy made our Business Analytics project evolve faster and more efficiently.

â&#x20AC;&#x153;

Numius Academy

General Business Analytics 8 Multidimensional modeling 9 Performance Management Awareness

Numius Academy

General Business Analytics

Cognos Business Intelligence

Multidimensional Modeling This instructor-led training package provides a thorough understanding of the purpose of multidimensional models and teaches the participants how to construct correct models. Multidimensional Modeling is a technique greatly appreciated in translating Performance Management information requirements into comprehensible information models suitable for different purposes. Multidimensional models bring structure into the information requirements analysis process. They are used as a communication medium between business, end users, ICT and implementers. They are the basis for preparing an implementation of a Performance Management solution, regardless if information will be disclosed through scorecarding, dashboards, standard and ad-hoc reports, or OLAP cubes.

Cognos Planning

Cognos TM1 Planning

BSP Software

Performance Management Awareness This instructor-led training is designed to introduce Performance Management within the context of an organization. The training offers an extensive overview of the definitions used within Performance Management, of how Performance Management can help an organization to protect their competitive position and contributes to the decision making process of an organization. The training offers a common framework to all stakeholders of a Performance Management process. Extensive experience has proven that such a common framework is essential to the success of any Performance Management project.

Code

Objectives

Topics

Code

Objectives

Topics

NUCOBI-470

• Understand the concepts behind multidimensional models. • Grasp the rules to take into account when evaluating if a multidimensional model is correct. • Construct multidimensional models

1. Introduction. 2. Define the range of analysis. 3. Transaction or status. 4. Find the measures. 5. Create a star schema. 6. Combine star schemas.

NUCOPM-465

Upon completion of this course, participants will be able to find the right combination between: • Organizing and structuring information: How should we perceive our organization and structure our information accordingly. • Providing the correct information: How can we make sure that the right person disposes of the right information at the right time and in the right format. • Creating the correct organizational processes: How can we ensure that this information allows us to improve continuously.

1. Introduction. 2. What is Performance Management? 3. Causes of poor decisions. 4. Increase your business value and create a competitive advantage by gaining on information. 5. Sources. 6. Data warehousing. 7. Reveal and analyze data. Balanced Scorecard. Data mining. On-line analytical processing. Querying and reporting. Planning and simulation. applications. Execute a report. 8. Determing the optimal BI track. 9. Data latency. 10. Relational vs dimensional. 11. ETL. 12. Quality.

Level Basic

Dates NUCOBI-470: 14/02 + 15/02 Belgium

Audience Anyone (going to be) actively involved in a Performance Management project.

NUCOBI-470: 14/03 + 15/03 The Netherlands

Prerequisites A basic understanding of the purpose of Performance Management solutions is an advantage though not specifically required.

NUCOBI-470: 03/05 + 04/05 Belgium NUCOBI-470: 07/11 + 08/11 Belgium

Level Basic

Dates NUCOPM-465: 12/04 Belgium NUCOPM-465: 03/11 Belgium

Audience

Duration 1 day

• Performance Management project leader. • Strategic decision-maker. • Stakeholders in a Performance Management project.

Duration 2 days

Prerequisites There are no prerequisites.

Numius Academy

Cognos Business Intelligence

“

A practical training with numerous exercises that are helpful and explained clearly.

“

Numius Academy

12 IBM Cognos Connection 13 IBM Cognos Query Studio 14 IBM Cognos Connection & Query Studio 15 IBM Cognos Analysis Studio 16 IBM Cognos Report Studio - Basic 17 IBM Cognos Report Studio - Advanced 18 IBM Cognos Report Studio - Express 19 IBM Cognos Report Studio - Performance 20 IBM Cognos Framework Manager 21 IBM Cognos Transformer 22 IBM Cognos BI Administration and Performance 23 IBM Cognos 10 What’s new 24 IBM Cognos Business Insight 25 IBM Cognos Business Insight Advanced

Numius Academy

General Business Analytics

Cognos Business Intelligence

IBM Cognos Connection

Cognos TM1 Planning

BSP Software

IBM Cognos Query Studio

This instructor-led training is designed to introduce IBM Cognos Connection and how it can be used to optimally manage content in your Cognos Connection Web portal.

This instructor-led training is designed to introduce IBM Cognos Query Studio and how it can be used to create, modify and organize simple ad hoc reports.

Code

Objectives

Topics

Code

Objectives

Topics

IBM Cognos version 8: NUCOBI-8-400 IBM Cognos version 10: NUCOBI-10-400

• Understand the added value and use of Cognos Connection. • Access reports. • Run reports with options. • Schedule a report to run at a specific time and with specific output and language formats. • Create report views. • Personalize the appearance of your Cognos Connection Web portal.

1. View. List view. Details view. 2. Navigate. 3. Preferences. 4. Create a folder. 5. Create a job. 6. Add a URL. 7. Create a page. 8. Set properties. 9. Change order. 10. Run a report. 11. View a report. 12. Screen. 13. Items on checklist. 14. Open reports in a studio. 15. Open studios.

IBM Cognos version 8: NUCOBI-8-405 IBM Cognos version 10: NUCOBI-10-405

• Understand the difference between the IBM Cognos Studio’s and when to use the most suitable Studio. • Understand how to use the different report capabilities. • Understand how to graphically display the data. • Understand how to create reports with a consistent look and feel by using templates. • Perform basic administrative tasks, such as scheduling reports and delivering reports in different formats (HTML, PDF, Excel, etc.).

1. Introduction. 2. Query items. Understand how reports. are structured. Selecting fields. Drag fields. 3. Formatting. Suppressing. Auto group. Turn off auto group. Footers. Define custom groups. Change report layout. Change border styles. Change the number of rows. shown per page. Edit title area. Apply template. 4. Change the layout. Create a crosstab report. Sorting. Calculations. Generate footer summaries. for measures. Define conditional styles. Add a chart. 5. Execute a report as a standard report. Report run modes. 6. Filters. Standard filter on date field. Standard filter on numeric field. Standard filter on text field. Remove filter. Predefined filter. Negative filter. Combine filters. 7. Report in Report Studio.

Level Basic

Dates NUCOBI-8-400: 24/05 Belgium

Audience Users of the IBM Cognos Connection web portal.

NUCOBI-8-400: 09/08 Belgium

Prerequisites Basic awareness of IBM Cognos is helpful.

NUCOBI-10-400: 10/02 Belgium NUCOBI-10-400: 16/08 Belgium

Basic

Dates NUCOBI-8-405: 25/05 Belgium NUCOBI-8-405: 10/08 Belgium

Audience

NUCOBI-10-405: 11/02 Belgium

Prerequisites

Report Authors.

Basic awareness of IBM Cognos is helpful.

Duration 1 day

Level

NUCOBI-10-405: 17/08 Belgium

Duration 0,5 days

Cognos Planning

General Business Analytics

Cognos Business Intelligence

IBM Cognos Connection & Query Studio This instructor-led training is designed to introduce IBM Cognos Connection and IBM Cognos Query Studio. Participants will learn how to manage content in the Cognos Connection Web portal and how to create, modify and organize simple ad hoc reports using Query Studio.

Code

Objectives

IBM Cognos version 8: NUCOBI-8-410 IBM Cognos version 10: NUCOBI-10-410

• Understand the added value and use of Cognos Connection. • Access reports. • Run reports with options. • Schedule a report to run at a specific time with specific formats. • Create report views. • Personalize the appearance of your Cognos Connection Web portal. • Understand the difference between the IBM Cognos studio’s and when to use the most suitable Studio. • Understand how to use the different report capabilities. • Understand how to graphically display the data. • Understand how to create reports with a consistent look and feel by using templates. • Perform basic administrative tasks, such as scheduling reports and delivering reports in different formats (HTML, PDF, Excel, etc.).

Level Basic

Dates NUCOBI-8-410: 31/03 + 01/04 Belgium NUCOBI-8-410: 16/05 + 17/05 The Netherlands

Duration 1,5 days

Audience • Users of the IBM Cognos Connection web portal. • Report Authors.

Prerequisites Basic awareness of IBM Cognos is helpful.

Topics

Numius Academy

Course Topics Connection 1. View. List view. Details view. 2. Navigate. 3. Preferences. 4. Create a folder. 5. Create a job. 6. Add a URL. 7. Create a page. 8. Set properties. 9. Change order. 10. Run a report.

1. 1 12. 13. 14. 15.

View a report. Screen. Items on checklist. Open reports in a studio. Open studios.

Course Topics Query Studio 1. Introduction. 2. Query items. Understand how reports are structured . Selecting fields. Drag fields. 3. Formatting. Suppressing. Auto group. Turn off auto group. Footers. Define custom groups. Change report layout. Change border styles. Change the number of rows shown per page. Edit title area. Apply template. 4. Change the layout. Create a crosstab report. Sorting. Calculations. Generate footer summaries for measures. Define conditional styles. Add a chart. 5. Execute a report as a standard report. Report run modes. 6. Filters. Standard filter on date field. Standard filter on numeric field. Standard filter on text field. Remove filter. Predefined filter. Negative filter. Combine filters. 7. Report in Report Studio.

Cognos Planning

Cognos TM1 Planning

BSP Software

IBM Cognos Analysis Studio This instructor-led training is designed to introduce IBM Cognos Analysis Studio and how it can be used to create simple and ad-hoc reports on multidimensional data sources (OLAP cubes) within the IBM Cognos BI platform.

Code

Objectives

Topics

IBM Cognos version 8: NUCOBI-8-415 IBM Cognos version 10: NUCOBI-10-415

• Understand the difference between the IBM Cognos Studio’s and when to use the most suitable Studio. • Create reports on multidimensional data. • Create reports allowing the users to search, compare and analyse large sets of data quickly and efficiently. • Understand how to save, run and reuse reports.

1. Introduction. Starting a new analysis. Locate items. 2. Create a simple report. Add rows, columns and measures. Details or global. Working with objects in a crosstab. 3. Analyze your data. Drill down and drill up. Right clicks. Expand. Show values. Sorting of measures. 4. Focus your data. Graphs. Filtering through context. Suppress zeros. More... Highest or lowest. Include and exclude subtotals. Filters. Unbalanced reports. Hide columns. Calculations.

Level Basic

Dates NUCOBI-8-415: 14/04 Belgium

Audience • Report Authors (using multidimensional data sources). • Business Analysts performing adhoc analysis.

NUCOBI-10-415: 21/04 Belgium

Prerequisites

NUCOBI-8-415: 15/09 Belgium

Participants should have knowledge of Cognos Connection.

NUCOBI-10-415: 22/09 Belgium

Duration 1 day

General Business Analytics

Cognos Business Intelligence

IBM Cognos Report Studio Basic

Cognos TM1 Planning

BSP Software

IBM Cognos Report Studio Advanced

This instructor-led training is designed to introduce IBM Cognos Report Studio Basic and how it can be used to create professional reports on relational data models within the IBM Cognos BI platform.

This instructor-led training is designed for Report Authors who already had a first experience with IBM Cognos Report Studio and want to develop additional capabilities to create professional and complex reports within the IBM Cognos BI platform.

Code

Objectives

Topics

Code

Objectives

Topics

IBM Cognos version 8: NUCOBI-8-420 IBM Cognos version 10: NUCOBI-10-420

• Understand the difference between the IBM Cognos Studio’s and when to use the most suitable Studio. • Create professional and semidynamical reports on relational data. • Write optimized queries in Report Studio. • Work with dimensions and measures, and create calculated columns. • Create drill-able reports and use prompts and filters. • Build reports with perfectly finished lay-outs.

1. Introduction. 2. Create reports. 3. Orienting in Report Studio. 4. Create a simple list. 5. Create a second page. 6. Format lists – Part 1. 7. Format lists – Part 2. 8. Use clipboard to save a report. 9. Learning to understand queries. 10. Format and focus reports. 11. Detail or grouped. 12. Running totals, summaries and summary filters. Create a prompt page in order to develop an interactive report. Two lists with one query. A list in a list in a list... Point of attention: remove fields from a list. Add additional totals to a crosstab. Headers and footers. Create graphs and make. changes to the layout. 13. Calculated fields and IF THEN ELSE. 14. Multiple data items in one column. 15. Learn more about queries. 16. Manage your content in Report Studio. 17. Understanding the layout struc ture and navigating. 18. How to manage the layout better? 19. Create a drill-through. 20. Advanced formatting. 21. Multiple pages within a repeating unit. 22. Repeaters. 23. Conditional layout. 24. Conditional styling. 25. No data available. 26. Singletons. 27. PDF layout. 28. Add table of content. 29. Bursting.

IBM Cognos version 8: NUCOBI-8-425 IBM Cognos version 10: NUCOBI-10-425

• Apply advanced report building techniques to create complex reports. • Apply advanced layout techniques • Create sophisticated semidynamical reports. • Create highly formatted reports. • Create multilingual reports.

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19.

Level Basic

Dates NUCOBI-10-420: 02/03 + 03/03 Belgium NUCOBI-8-420: 26/04 + 27/04 Belgium

Audience

NUCOBI-8-420: 06/06 + 07/06 The Netherlands

Prerequisites

Report Authors.

• Participants should have knowledge of Cognos Connection. • Participants should have knowledge of Query Studio.

NUCOBI-8-420: 05/09 + 06/09 Belgium NUCOBI-10-420: 12/09 + 13/09 Belgium

Duration 2 days

Cognos Planning

Numius Academy

Level Intermediate

Audience

Dates

• Report Authors (from ICT and/or Line-of-Business). • Power Users.

NUCOBI-8-425: 28/04 + 29/04 Belgium

Prerequisites

NUCOBI-8-425: 08/06 + 09/06 The Netherlands

• Knowledge of Cognos Connection • Basic experience or knowledge of Query Studio. • Completed course “NUCOBI-420 IBM Cognos Report Studio” or alike through experience. • Practical experience with Report Studio (required).

NUCOBI-10-425: 07/03 + 08/03 Belgium NUCOBI-10-425: 19/09 + 20/09 Belgium

Introduction. Calculate percentages. Simulate crosstabs using lists. Create first page only titles. Concatenate lists. Add additional rows to the header of a list. Create a parameter to show the user/username in a report. Advanced layout techniques. A graph with a dynamic norm line. Reuse layouts. Difference between Joins & Unions . Filter data coming from another query. Create a mail merge letter. HTML code for tooltips. Send e-mails using hyperlinks. Package drill-through. Drill-through on the same report. Design a multilingual report. Complex prompts.

Duration 2 days

General Business Analytics

Cognos Business Intelligence

IBM Cognos Report Studio Express

Objectives

IBM Cognos version 8: NUCOBI-8-430

Level Basic

Dates NUCOBI-8-430: 22/03 + 23/03 Belgium NUCOBI-8-430: 27/09 + 28/09 Belgium

Duration 2 days

• Understand the difference between the IBM Cognos Studio’s and when to use the most suitable Studio. • Understand how Report Studio Express is a substitute for PowerPlay. • Perform ad-hoc analysis and write optimized reports using Report Studio Express on multidimensional data (OLAP data sources). • Author Report Studio Express reports in Professional Mode for advanced reporting. • Work with dimensions and measures and create calculated columns. • Create drill-able reports and use prompts and filters. • Build reports with perfectly finished lay-outs.

Audience • Former and current users of PowerPlay. • Report Authors (using multidimensional data sources). • Business Analysts performing ad-hoc analysis.

Prerequisites • Participants should have knowledge of Cognos Connection. • Basic experience or knowledge of Query Studio and Analysis studio is helpful. • Experience with Report Studio is an advantage though not specifically required.

Topics REGISTER +32 16 20 29 05 www.numius.eu academy@numius.eu 18

Numius Academy

1. Introduction. 2. Report modes. Use sets of members. Execute a report. 3. Change the layout. Format a report. Add crosstab spaces (fact cells).

Cognos TM1 Planning

BSP Software

IBM Cognos Report Studio: From good to excellent performance

This instructor-led training is designed to introduce IBM Cognos Report Studio Express and how it can be used to create professional reports and analyses on multidimensional data sources. This course will illustrate and teach users how to report optimally on OLAP cubes within the IBM Cognos BI platform. Users of PowerPlay will understand how Report Studio Express can help to achieve the same levels of comfort as reached with PowerPlay.

Code

Cognos Planning

Add text. Conditional formatting. 4. Execute a report as a standard report. Execute a report. Execute in a different format. Save a report. Make a report clickable. Suppress zeros/empty. Simple calculations. Example of drill-able report. Multiple logical pages per category. Context filter. Create a prompt page. Nesting of levels. Create a complex report. 5. Switch to Report Studio Professional. Reasons. Switch to Professional. Start a new report. Basic principals. Add a graph. Make a drill-able report. Connect a table to a graph. Create an extra report page. Queries on the background. Ranking. Lay-out. Intersections. Change the content of calculations. Create a report with multiple pages. First page as welcome page. Page lay-out. Multiple axes on a combination graph. Explicit sorting. Suppressing. Prompt on level. Truncation in graph. Orient each page individually. Set expressions. Let the user choose a dynamical set of rows.

This instructor-led training is designed to teach report developers how to optimize Report Studio reports by getting the most out of advanced techniques such as caching, efficient query design, server processing options and other tweaks and tricks. This course will illustrate and teach users how to reduce the generating time of their reports. By doing this, they will not only build faster reports, but they will also allow their company’s IT infrastructure to support more concurrent users by using the IT resources more efficiently.

Code

Objectives

Topics

IBM Cognos version 8: NUCOBI-8-435 IBM Cognos version 10: NUCOBI-10-435

• Understand and use advanced query options in Report Studio. • Build queries that use less database resources to resolve. • Build efficient prompt pages, simple as well as cascading prompts. • Reduce network traffic by building network-friendly reports. • Improve performance of reports.

1. Introduction. Basic infrastructure: impact on performance. Reasons for slower reporting and how to master them. How changes in a report affect the generated queries. 2. Changes to reports. Avoid unnecessary items in queries. The impact of aggregation on queries. Efficient prompts. Filtering on a fact table. Efficient sorting where necessary. Avoid local processing. Master-detail relations. Drill-through. Saved versions. Job scheduling.

Level Intermediate

Dates

Audience

NUCOBI-8-435: 24/02 Belgium

• Report Authors with report building experience. • IT professionals that want to learn how reports can affect their IT infrastructure. • Business and IT management that need proof that reports can be built more efficiently.

NUCOBI-8-435: 26/05 Belgium NUCOBI-8-435: 13/10 Belgium

Prerequisites • Participants should have built Report Studio reports and should be comfortable with the basic techniques of report query building. • Business or IT management participants should have been confronted with slow reports and eager to gather proof that reports can be improved.

Duration 1 days

General Business Analytics

Cognos Business Intelligence

IBM Cognos Framework Manager

Cognos Planning

Cognos TM1 Planning

BSP Software

IBM Cognos Transformer This instructor-led training is designed to introduce IBM Cognos Transformer and how it can be used to design, build and maintain PowerCubes.

This instructor-led training is designed to introduce the metadata modeling concepts and techniques of IBM Cognos Framework Manager and how it should be used to model metadata for predictable reporting and analysis results.

Code

Objectives

Topics

IBM Cognos version 8: NUCOBI-8-440 IBM Cognos version 10: NUCOBI-10-440

• Understand the Framework Manager environment. • Understand the Framework Manager workflow. • Model a Framework Manager environment. • Create filters and incorporate calculations in the framework model. • Use translation files. • Implement security in the Framework Model. • Publish packages.

1. Introduction: What is Framework Manager. 2. Model objects. 3. Model structure. 4. Project languages. 5. Metadata import. 6. The Database layer. 7. The Business layer. 8. Role-playing dimensions. 9. The Dimensional layer. 10. The Query layer. 11. Packages. 12. Publishing. 13. Filters. 14. Calculations in Framework Manager. 15. Translation files. 16. Security. 17. Common dimensions. 18. Parameter maps and Session parameters.

Level Intermediate

Dates NUCOBI-8-440: 28/02 + 01/03 Belgium NUCOBI-8-440: 07/04 + 08/04 The Netherlands

Audience Developers of metadata models.

Prerequisites • Experience or knowledge of Cognos Connection, Query Studio. • Knowledge of star schemas. • Knowledge of facts and dimensions.

Duration 2 days

Numius Academy

Code

Objectives

Topics

IBM Cognos version 8: NUCOBI-8-445 IBM Cognos version 10: NUCOBI-10-445

• Understand the functionality of Power Cubes. • Understand the OLAP modeling concepts of Transformer. • Design OLAP models.

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11.

Level

Audience

Intermediate

Designers of OLAP models for the use in IBM Cognos.

Dates

Prerequisites

NUCOBI-8-445: 17/03 + 18/03 Belgium

Cube versus table. Creation of a model. Creation of a cube. Updating a cube. Categories in a model. Views and security. Date wizard. Dimensions and measures. Preferences. PowerCubes in production. Alternate drill-down paths.

Participants have to understand the business need for ad hoc queries and analysis.

NUCOBI-8-445: 09/05 + 10/05 The Netherlands NUCOBI-10-445: 06/07 + 07/07 Belgium

Duration 2 dayS

General Business Analytics

Cognos Business Intelligence

IBM Cognos BI Administration and Performance This instructor-led training is designed to teach administrators the fundamental responsibilities of administering the server architecture and the BI content within an IBM Cognos BI deployment. Not only will this course focus on the administration of the environment, but it will also explain how to monitor and keep the performance of an IBM Cognos BI deployment at healthy levels to keep end-users satisfied.

Code

Objectives

Topics

IBM Cognos version 8 : NUCOBI-8-450 IBM Cognos version 10: NUCOBI-10-450

• Understand and define the basic architectural principles of a scalable Cognos BI platform. • Monitor system activity and system load in order to keep the IBM Cognos platform healthy. • Understand the log files and how to use them in order to keep your platform healthy. • Tune the performance of an IBM Cognos BI platform. • Explain the basic principles of IBM Cognos BI security from the point of view of a technical administrator. • Understand servers & networks with Cognos Advanced Routing Options. • Understand the setup of the standard audit package of IBM Cognos BI. • Create a working back-up. • Experience the contribution of MetaManager® to the management of your IBM Cognos BI platform.

1. IBM Cognos BI user interface components. 2. IBM Cognos BI servlets and services. 3. Installation options. 4. Load balancing mechanisms. 5. Configuration options. 6. IBM Cognos Application Firewall. 7. Authentication in IBM Cognos BI. 8. Authorization in IBM Cognos BI. 9. Secure the IBM Cognos BI environment. 10. Perform administrative tasks using Cognos Administrator. 11. Manage dispatchers and services. 12. Examine the log message facility. 13. Discuss server performance tuning. 14. IBM Cognos BI backup. 15. Manage activities. 16. Add a data source. 17. Distribute data and create a distribution list. 18. Plan a deployment. 19. Create deployment folders. 20. Schedule and manage reports. 21. Set alerts. 22. Set permissions.

Level Advanced

Dates NUCOBI-8-450: 18/05 + 19/05 Belgium NUCOBI-8-450: 27/06 + 28/06 The Netherlands NUCOBI-8-450: 21/11 + 22/11 Belgium NUCOBI-10-450: 09/06 + 10/06 Belgium

Audience

NUCOBI-10-450: 01/12 + 02/12 Belgium

Administrators who are responsible for the daily maintenance and health of the IBM Cognos BI deployment.

Cognos TM1 Planning

• Basic experience with the maintenance of an IBM Cognos BI platform is an advantage though not specifically required. • Basic experience with the content stored in a BI environment is required.

BSP Software

IBM Cognos 10 What’s New This instructor-led training is designed to introduce IBM Cognos 10 and show the remarkable advances that have been made compared to previous IBM Cognos versions. This is a hands-on training where participants get the opportunity to work with Cognos 10 firsthand.

Code

Objectives

Topics

IBM Cognos version 10: NUCOBI-10-000

• Be aware of the new features in the different Studios. • Understand where the added value for migrating from Cognos 8 to Cognos 10 can be found for your organization. • Start up new Cognos 10 pilot projects in your organization.

1. Introduction. 2. What’s new in the Portal Environment. 3. Meet the new Business Insight dashboard functionality. 4. What’s new in Query Studio. Discover a number of productivity enhancing features. 5. What’s new in Report Studio. Get started with the new analytical and statistical reporting capacity and discover how you can move from Business Intelligence to Business Analytics. 6. Create your first dashboard page and do on-line ad-hoc analyses with Business Insight Advanced. 7. Being an ad-hoc, cube (OLAP) based analyst in Cognos 10. 8. Discover the new event driven reporting features. 9. Start communicating with the new communication and collaboration platform that now comes with Cognos 10. 10. Look at the new administration and management features. 11. Find out how Active Reports can change the way you distribute reports and knowledge. We will allow ample time for exercises and familiarizing yourself with the multitude of new possibilities. We will make sure you get to the bottom of the capabilities of this great new platform.

Level Basic

Dates NUCOBI-10-000 17/01 Belgium

Audience

NUCOBI-10-000 04/04 Belgium

Prerequisites

All current Cognos users.

Have experience as a Cognos user or be new to Cognos and want to find out what added value can be found in starting with Cognos 10 rather than with Cognos.

NUCOBI-10-000 15/06 Belgium NUCOBI-10-000 11/07 Belgium NUCOBI-10-000 17/10 Belgium NUCOBI-10-000 05/12 Belgium

Duration 1 day

Prerequisites

Duration 2 days

Cognos Planning

General Business Analytics

Cognos Business Intelligence

IBM Cognos 10 Business Insight

Code

Objectives

Topics

IBM Cognos version 10: NUCOBI-10-460

• Understand the difference between Business Insight and Connection. • Assemble your own interactive dashboards. • Reuse Cognos standard reports and lift them to a higher level of usability with Business Insight. • Be familiar with all the new visualization techniques that Cognos 10 offers through the Business Insight interface.

1. Introduction. 2. Getting your bearings in Cognos 10. 3. Create your first dashboard page. 4. Meet all the new visualization objects. 5. Build a dynamic dashboard and make it reusable for other users.

Basic

Dates NUCOBI-10-460 18/01 Belgium NUCOBI-10-460 14/06 Belgium

Audience • Business Analysts. • End Users.

NUCOBI-10-460 18/07 Belgium

Prerequisites There are no prerequisites.

NUCOBI-10-460 06/12 Belgium

Duration 1 day

+32 16 20 29 05 www.numius.eu academy@numius.eu Numius Academy

BSP Software

This instructor-led training is designed to introduce IBM Cognos 10 Business Insight and how it can be used to create a professional ad-hoc reporting and analysis environment on relational and OLAP data models using the IBM Cognos 10 Business Analytics platform.

Code

Objectives

Topics

IBM Cognos version 10: NUCOBI-10-465

• Understand the difference between Business Insight and Business Insight Advanced. • Create professional and dynamical reports on relational data as well as on cubes (OLAP). • Assemble your own optimal ad-hoc analysis environment. • Construct your own interactive dashboards. • Integrate with Report Studio Professional. • Work with dimensions and measures, create calculated columns. • Create drill-able reports and use prompts and filters.

1. 2. 3. 4.

Level Intermediate

Dates NUCOBI-10-465 31/01 + 01/02 Belgium NUCOBI-10-465 21/06 + 22/06 Belgium NUCOBI-10-465 26/07 + 27/07 Belgium

Introduction. Create your first dashboard page. Connect to a multi-dimensional data source and do ad-hoc (OLAP) analysis. Make your analysis environment reusable and flexible by using variables and prompts.

Audience Business Analysts.

NUCOBI-10-465 19/12 + 20/12 Belgium

Prerequisites • Knowledge of Cognos Connection. • Knowledge of Query Studio, Analysis Studio, Report Studio helps to better position this new tool in the complete set of Cognos 10 Business Analytics tools.

Duration 2 days

Cognos TM1 Planning

IBM Cognos 10 Business Insight Advanced

This instructor-led training is designed to introduce IBM Cognos 10 Business Insight and how it can be used to create a very attractive analytical dashboard environment for yourself or for your fellow knowledge workers. You will practice on relational as well as on OLAP data models using the IBM Cognos 10 Business Analytics platform.

Level

Cognos Planning

General Business Analytics

Cognos Business Intelligence

Cognos Planning

Cognos TM1 Planning

IBM Cognos Planning This instructor-led training is designed to introduce IBM Cognos Planning and the use of IBM Cognos planning applications and modules in the Contributor Web client.

Code

Objectives

Topics

IBM Cognos version 8 : NUCOPL-8-455

• Comprehend the role of Contributor Web in the planning process. • Understand the business process of applications. • Understand cubes in applications. • Work with IBM Cognos planning applications efficiently.

1. Introduction. Cubes. Cubes in IBM Cognos Planning. 2. How to start? Log on. Workflow. 3. Working with data. Applications. Workspace. Tabs and dimensions. Data entry. Hiding zero’s. Adding comment. Data actions. Exercise: working with data. 4. Export data. Quick export. Text file. To Excel. Quick Load. 5. Import data. Text file. Get data. Workshop 2: Import and export data. 6. What’s new in IBM Cognos 8.4?

Level Basic

Dates

Audience

NUCOPL-8-455: 20/05 Belgium

• Business subject matter experts like sales managers, account managers and product managers. • Data analysts.

NUCOPL-8-455: 29/06 The Netherlands

Prerequisites

NUCOPL-8-455: 20/10 Belgium

“

Numius Academy

Participants should have knowledge of Microsoft Excel.

Duration 1 day

The course material allows me to better grasp, implement and redirect my Business Analytics project.

BSP Software

General Business Analytics

Cognos Business Intelligence

Cognos Planning

Cognos TM1 Planning

BSP Software

IBM Cognos TM1 – Architect and Perspectives

Cognos TM1

This instructor-led training is designed to introduce IBM Cognos TM1 and how it can be used to create and maintain TM1 applications. “IBM Cognos TM1 – Architect and Perspectives” illustrates and explains users how to build a complete TM1 model through a pragmatic approach which combines theory with handson exercises.

Code

Objectives

Topics

V9.5 : NUCOTM-500

• Understand the basic principles of IBM Cognos TM1. • Design, build and maintain TM1 models. • Understand the basic principles of TM1 security. • Integrate TM1 with IBM Cognos.

1. Introduction. What is TM1? TM1 Roles and Users. TM1 Components. TM1 Building Blocks. TM1 Server. 2. Design and Build a Model. Build a Dimension. Build a Subset. Build a Cube. Build an Active Form. Build an Application. Build an Excel Websheet. 3. Advanced Modeling. Create a new TM1 Server. Create a TI process to create dimensions. Create Dynamic Subsets. Create a TI process to upload data to a cube. Create Business Rules. Create Drill Paths. Create Picklists. Create Sandboxes. 4. Managed Planning Applications. TM1 Contributor Web Client. TM1 Contributor Administration. 5. TM1 Security. Users and Groups. Objects Security. 6. TM1 Integration to Cognos. Framework Package based on TM1 Cube. Query Studio Report. Portal with TM1 Web. TM1 Navigation and Cube Viewer Portlet.

Level Basic

Dates

“

NUCOTM-500: 18/04 + 19/04 + 20/04 Belgium

Audience

NUCOTM-500: 25/10 + 26/10 + 27/10 Belgium

Prerequisites

Duration 3 days

Excellent teacher with rich theoretical knowledge and practical experience.

Numius Academy

“

Modelers of TM1 applications.

There are no prerequisites for the “IBM Cognos TM1 – Architect and Perspectives” course.

General Business Analytics

Cognos Business Intelligence

Cognos Planning

Cognos TM1 Planning

BSP Software

MetaManager®

BSP Software

This instructor-led training is designed to introduce MetaManager® and how it can be configured and managed in order to use the capabilities of the tool to its full extend. All modules of MetaManager® will be extensively explained, hereby helping the participant to simplify all complexities associated with metadata, data management, report validations, etc.

Code

Objectives

Topics

NUCOBI-460

• Understand the modular approach of MetaManager®. • Validate reports and correct possible errors. • Uniform reports, pagelets and preferences. • Create a backup of your BI environment. • Secure and document your objects.

1. Introduction. 2. Connection unknown. 3. Meta Editor. 4. Lock Function. 5. Meta Editor: functions. 6. Advanced Filters. 7. Quick Filters. 8. Change and save. 9. Screen Tip Generator. 10. Report Validator. 11. Create a backup. 12. Validated reports. 13. Incorrect validated reports. 14. Export Report Validator. 15. Create a data source. 16. Restore a report. 17. Restore problems in reports. 18. Search in a list of reports. 19. Favorites. 20. Properties of reports. 21. Revalidated reports Find/Replace. 22 . Global Name Changer. 23. Preview of Find/Replace. 24. Security Painter. 25. Pagelet Blaster. 26. Template Blaster. 27. Backup/Restore/Deploy. 28. Backup. 29. Restore/Deploy. 30. Content Store Documenter. 31. Content Store Documenter: output. 32. Model Documenter. 33. Preferences Blaster. 34. Content Store Size.

Level Basic

Dates NUCOBI-460: 13/5 Belgium

Audience

NUCOBI-460: 30/9 Belgium

Administrators supporting and documenting the framework model and reporting of the organization.

Prerequisites Participants should have basic knowledge of Cognos Connection, Framework Manager and security.

Duration 0,5 days

“

Well-structured training with a clear link to our day-to-day activities.

Numius Academy

“

BETTER PERFORMANCE STARTS WITH TRAINING

“ Excellence is an art — Aristotle

Sites

“

won by training and habituation

Belgium AND The Netherlands Training is organized at our facilities in

Leuven

Greenhill Campus Interleuvenlaan 1515D 3001 Heverlee or Diestsevest 32 3000 Leuven

Woerden

Numius Academy

Pelmolenlaan 1-K 3447 GW Woerden

Terms and Conditions How to book All bookings for training courses must be made in writing. You can do this online - visit www.numius.eu, select the course and date you wish to attend and then follow the booking process. Please note that once Numius has received a completed booking form, your place on a course is confirmed. If a course is fully booked, you will be notified. You are advised to read and understand the terms and conditions outlined below. Once we have received your booking we will send you a letter of confirmation within five working days. Joining instructions including venue details will be issued approximately two weeks prior to the course. If you have any doubt as to whether the course is going ahead or whether your booking has been received please telephone Numius on +32 16 20 29 05 or contact us on academy@numius.eu.

Special requirements

Course transfers

If you have a disability or a medical condition that requires special arrangements to be made, please state your requirements on the form. Every effort will be made by Numius to accommodate special requirements that have been notified.

There is no charge for transferring your booking to the same course on an alternative date provided you notify Numius in writing up to 20 working days before the start of the course and that there is availability. However, a transfer fee of 20% of the course fee (plus VAT) will be payable if notice is received within 20 workings days of the start date of the original course. No refund will be made in the event of a transfer. No more than one transfer will be allowed.

Payment Payment must be received before the start of the course or within 30 days of invoice date, whichever is sooner. For international bookings, full payment must accompany the booking before any further documentation will be issued. If your company requires a purchase order number to be stated on the invoice, please ensure that the number is quoted on the booking form. Course discounts Companies booking five or more delegates on the same public course will receive a 10% discount on the course fee (plus VAT).

Cancelling your place If you notify Numius in writing or via email up to 10 working days before the start date of the course, you will receive a full refund less an administration fee of 20% (plus VAT). Unfortunately late cancellations sometimes cause events to be abandoned therefore if a delegate withdraws for whatever reason within the 10 day period, the fee will remain payable in full if you

are unable to nominate a substitute attendee. Non attendance If you fail to attend the course on which you are registered and have not given prior notice to Numius then the course fee will remain payable in full. Cancellation by Numius Where circumstances dictate, Numius reserves the right to alter published programs, course leaders, fees or venues without prior notice. In such cases liability will be restricted to a refund of any course fee paid. Liability Numius does not accept responsibility for anyone acting as a result of information or views expressed on its training courses. Participants should take specific advice when dealing with specific situations. Opinions expressed are those of individual speakers and not necessarily those of Numius. Numius Academy

BETTER PERFORMANCE STARTS WITH TRAINING

NOTES

Numius Academy

NOTES

Numius Academy

BUSINESS ANALYTICS

Numius nv Greenhill Campus Interleuvenlaan 1515 D 3001 Heverlee (Leuven) Belgium

Numius Academy