Online Academy

Our Services

​​​​Bonavista Consulting


IBM Cognos 11.0.5 - Cognos Analytics

V11 NEW FEATURES FOR EXPERIENCED AUTHORS


COURSE DESCRIPTION

This one-day, instructor-led, online course provides the quickest path to mastering the new user experience (UX) introduced with Cognos Analytics (v11) for users with experience developing reports with IBM Cognos BI 10 in either Report Studio or Cognos Workspace Advanced. The new UX merges functionality and interface features found in the current 10.2 versions of both Report Studio and Cognos Workspace Advanced. 

This course will be conducted at an accelerated pace and is not intended for users new to professional authoring. This course guides experienced authors through the new graphical user interface (GUI). Although the new GUI has significant benefits, the change is drastic enough that it can potentially decelerate adoption of the new release and delay report development tasks. We will provide a map of the v10.2 user interface to v11 so you will create reports quickly.

CLASS LENGTH

One Day

SUGGESTED ATTENDEES

Experienced professional authors familiar with building reports in either Report Studio or Cognos Workspace Advanced.

CLASS OUTLINE

  • Cognos Analytics overview
  • Reports, dashboards and data modules
  • Gotcha’s – what to look out for before migrating
  • Browser, OS, mobile and data source support
  • Creating new reports
  • New vs. legacy templates
  • Adding report data
  • Creating calculations
  • Navigating the UI
  • Data, toolbox and navigate areas
  • Connecting to packages and data modules
  • Exploring report pages, queries and advanced conditions
  • Using the properties pane
  • On-demand toolbars
  • Where did my menus go?
  • Navigating around the portal
  • Design vs. preview
  • Right-click vs. […]
  • Inserting objects
  • Toolbox grouping
  • Pinning tools and reordering
  • Advanced layout features
  • Modifying table layouts
  • Conditional styles
  • Layout component references
  • Shared set references
  • Exploring dimensional data
  • Drilling-up, drilling-down
  • Discovering the explore features
  • Migrating content
  • Large-scale migration
  • Migrating a single report using copy-paste
  • Report distributions and automation
  • Navigating the portal
  • Using Cognos viewer
  • Subscriptions and preferences
  • Managing the environment
  • Accounts, activities, content, data servers, configuration

Tableau 10 - Desktop

ADVANCED DATA VISUALIZATION AND DASHBOARDING


COURSE DESCRIPTION

Advanced Data Visualization and Dashboarding with Tableau Desktop will expand the possibilities of how students can leverage Tableau to deliver analytics in ways never thought possible. This course is a logical progression from our one-day intermediate class, and is a valuable learning opportunity for users with one or more years of experience working with Tableau Desktop.

This is a fully interactive course. Participants will have practice performing the skills in our online classroom. The instructor is able to see each student's computer screen and offer guidance. A full set of course materials is included and hard copies are sent prior to the class.

APPLICABLE SOFTWARE VERSIONS

Hands-on learning exercises in this course will be completed on Tableau Desktop 10; however, nearly all techniques are also relevant to all versions of Tableau Desktop 9.x, except where noted throughout the course.

CLASS LENGTH

Two Days

SUGGESTED ATTENDEES

Consumers of business analytics information and business analysts who have attended our one-day intermediate class or have one or more years of experience in Tableau

COURSE OUTLINE

  • Working with dates
  • Compare discrete versus continuous dates
  • Create views using different date types
  • Examine additional visualization types
  • Work with treemaps, boxplots and packed bubble charts
  • Work with multiple data sources and data extracts
  • Work with the data connection page
  • Create a data extract
  • Define joins between data sources
  • Discuss custom SQL
  • Blend data
  • Use data blends with calculated fields including NULL values
  • Create text based visualizations and add custom splits
  • Create crosstabs and data tables
  • Pivoting data
  • Sorting data in a table
  • Calculations and custom splits
  • Split data in source fields
  • Use calculations for statistical purposes
  • Examine the impact of aggregation in calculations
  • Introduce and use level of detail (LOD) calculations
  • Build regular expression calculations
  • Add parameters to a worksheet
  • Use parameters to filter
  • Use parameters for other purposes
  • Perform advanced comparisons
  • Show progress toward goals
  • Create a top-N visualization
  • Advanced mapping
  • Work with navigations and selection in maps
  • Review automatic geocoding in Tableau
  • Modify geocode locations
  • Perform custom geocoding with data blending
  • Use background images in visualizations for spatial analysis
  • Forecasting and trend lines
  • Use trend lines to create interactive models of behavior
  • Use the analytics pane
  • Work with distributions of data
  • Understand and use Pareto charts
  • Customize Pareto charts
  • Create advanced dashboards
  • Add interactivity to dashboards
  • Leverage instructions and annotations
  • Add actions to a dashboard
  • Add tabs to a dashboard
  • Add navigation and help
  • Assess performance of a dashboard
  • Bring worksheets and dashboards together in stories