Sempre Analytics Training Courses

• Understanding IBM Planning Analytics data
• Creating books
• Creating and saving views
• Changing the way data is displayed
• Displaying specific members by using sets
• Adding calculations to views
• Highlighting exceptions by using conditional formatting
• Entering data
• Experimenting with data by using sandboxes
• Working with spreadsheets online by using websheets
• Formatting for reporting
• Exploring data by using visualisations
• Creating dashboards
• Examining performance by using scorecards
• Exporting data
• Introduction to IBM Planning Analytics for Microsoft Excel
• Creating websheets
• AI Forecasting
• Apps and Plans
• Decision Optimisation Overview

• Overview of IBM Planning Analytics
• Create dimensions
• Load and maintain data
• Add business rules
• Optimise rule performance
• Transfer data into your model
• Customise drill paths
• Use rules for advanced modelling
• Convert currencies
• Model for different fiscal requirements

• Consume content in IBM Cognos Analytics
• Create reports in IBM Cognos Analytics
• Create dashboards in IBM Cognos Analytics
• Create metadata models in IBM Cognos Analytics
• What’s new in Cognos V11.2
• Compare IBM Cognos Analytics and IBM Cognos BI (Optional)
• Explore IBM Cognos Analytics AI capabilities

Introduction to IBM Cognos Analytics – Reporting 

• Examine IBM Cognos Analytics
• Reporting and its interface
• Explore different report types
• Create reports in preview or design mode
• Create a simple, sorted, and formatted report
• Examine dimensionally modeled and dimensional data sources
• Explore how data items are added queries
• Examine personal data sources and data modules

Examine data tables and list reports

• Create a data table
• Group, format, and sort list reports
• Describe options for aggregating data
• Create a multi-fact query
• Create a report with repeated data

Create crosstab reports

• Format and sort crosstab reports
• Create complex crosstabs using drag and drop functionality
• Create crosstabs using unrelated data items

Create visualisation reports

• Understand visualisation categories
• Create and customize visualisations
• Understand client-side visualisations
• Create enhanced map visualisations

Focus reports using filters

• Create filters to narrow the focus of reports
• Examine detail and summary filters
• Determine when to apply filters on aggregate data

Focus reports using prompts

• Identify various prompt types
• Use parameters and prompts to focus data
• Search for prompt types
• Navigate between pages

Extend reports using calculations

• Create calculations based on data in the data source
• Add run-time information to the reports
• Create expressions using functions

Customise reports with conditional formatting

• Create multilingual reports
• Highlight exceptional data
• Show and hide data
• Conditionally render objects in reports

Drill-through definitions  

• Introduction to drill-through definitions
• Navigating to related data
• Introduction to bookmark references

Enhance report layout

• Force page breaks in reports
• Format data and report objects
• Modify existing report structures

Use additional report building techniques

• • Enhance report design with report objects
  • Add objects to reports
  • Convert a list to a crosstab
  • Reuse objects within the same report
  • Share layout components among separate reports
  • Choose options to handle reports with no available data

Unit 1: Create query models 

• build query models and then connect them to the report layout
• edit an SQL statement to author custom queries
• add filters and prompts to a report using the query models

Unit 2: Create reports based on query relationships 

• create reports by joining queries
• combine data containers based on relationships from different queries

Unit 3: Introduction to dimensional reporting concepts and dimensional data in reports 

• List and describe the data model types
• Describe the OLAP data structure and elements
• Differentiate between report authoring styles
• use members to build reports
• identify and use sets and tuples in reports Unit 4: Dimensional report context
• understand report context
• root members
• default members
• current members
• default measures
• current measures

Unit 5: Focus your dimensional data 

• understand how relational data sources behave
• understand how dimensional data sources behave
• create efficient queries
• understand filtering techniques
• use dimensional objects and functions
• create slicers and prompts

Unit 6: Calculations and dimensional functions 

• understand the different types of dimensional functions within Cognos Analytics
• create reports utilizing dimensional functions
• use calculations within reports

Unit 7: Create advanced dynamic reports 

• filter reports on session parameter values
• create dynamic headers and titles that reflect report data
• create a customer invoice report

Unit 8: Design effective prompts 

• control report displays using prompts
• specify conditional formatting values using prompts
• create sorted and filtered reports based on prompt selection

Unit 9: Examine the report specification and distribute reports 

• work with the report specification
• report specification flow
• considerations when modifying a report specification
• Create custom toolbox and template objects
• distribute reports using bursting
• create burst keys
• identify report recipients and data items using burst tables
• distribute reports using email and the IBM Cognos Analytics portal

Unit 10: Enhance user experience with HTML and Custom Controls 

• create interactive reports by using HTML
• Include additional information with tooltips
• Send emails by using links in a report
• understand custom controls
• AMD models
• adding a custom control
• using JavaScript files

Unit 11: Advanced techniques

• • understand advanced features
  • booklet and reference reports
  • table of contents
  • tabbed reports
  • classes and class extensions
  • global parameters
  • create a report binder

Introduction to IBM Cognos Framework Manager

• Model data and identifying related data
• Define requirements and modelling strategies
• Overview of IBM Cognos Framework Manager
• Create a baseline project
• Extend a model
• Prepare reusable metadata

Model for predictable results in IBM Cognos Framework Manager

• Identify query issues
• Identify reporting traps
• Model virtual star schemas
• Use query subjects, modify relationships, and consolidate metadata using virtual objects
• Create calculations, filter data, and customise metadata for runtime
• Implement a time dimension and specify determinants

Model for presentation in IBM Cognos Framework Manager

• Create a presentation view
• Examine data source query subject types and stored procedure query subject types
• Specify data security and package security
• Specify object security and dynamic data security
• Create analysis objects
• Manage OLAP data sources

Advanced capabilities in IBM Cognos Framework Manager

• Explore SQL generation and the use of governors
• Examine the use of IBM Cognos SQL and generated SQL for DMR data
• Other query considerations
• Use session parameters, prompt macros, and security macro functions
• Use materialized views, minimise SQL, and enable Dynamic Query Mode (DQM)
• DQM, CQM, caching metadata, query processing, aggregate calculation, and other ways to improve performance

Extended capabilities in IBM Cognos Framework Manager

• • Perform basic maintenance and management on a model
  • Remap metadata to another source and import and link additional data sources
  • Run scripts to automate or update a model and report on a model
  • Segment a project, link a project, and branch a model
  • Nest packages and specify package languages and functions
  • Explore additional modelling techniques and customize metadata for a multilingual audience

Introduction to IBM Cognos Analytics administration 

• IBM Cognos Analytics components
• Administration workflow
• IBM Cognos Administration
• IBM Cognos Configuration

Identify IBM Cognos Analytics architecture 

• Features of the IBM Cognos Analytics architecture
• Examine the multi-tiered architecture, and identify logging types and files
• Examine IBM Cognos Analytics servlets
• Performance and installation planning
• Balance the request load
• Configure IBM Cognos Analytics

Secure the IBM Cognos Analytics environment 

• Identify the IBM Cognos Analytics security model
• Define authentication in IBM Cognos Analytics
• Define authorisation in IBM Cognos Analytics
• Identify security policies
• Secure the IBM Cognos Analytics environment

Administer the IBM Cognos Analytics server environment 

• Administer IBM Cognos Analytics servers
• Monitor system performance
• Manage dispatchers and services
• Tune system performance, and troubleshoot the server
• Audit logging
• Dynamic cube data source administration workflow
• Manage run activities
• View current, past, and upcoming activities
• Manage schedules

Manage content in IBM Cognos Administration 

• Data sources and packages
• Manage visualisations in the library
• Deployment
• Other content management tasks

Examine departmental administration capabilities 

• Create and manage team members
• Manage activities
• Create and manage content and data
• Manage system settings
• Manage Themes, Extensions, and Views
• Share services with multiple tenants