Back to Tracks and Agenda

Presenters:  Amy O’Neel & Rajesh Ponnurangam, InfoSol Inc.

Monday, June 22 – Module 1

Converting UNV to UNX

Intended Audience:

This module is intended for individuals who want to know how to convert existing universes (.unv) into Information Design Tool universes (.unx).

Prerequisites:

None, however Universe Designer experience will be helpful.

Synopsis:

This course is designed to provide the steps for converting.  We will cover some of the pitfalls and known bugs/issues with converted universes as well as why you might still need to convert.

Major Topics include:

• Converting universes
• Object Types
• Using UNX universes
• Known Bugs
• Shared Projects

Monday, June 22 – Module 2

Connections

Intended Audience:

This module is intended for individuals who work with Connections.  This is often Designers, but may also include Administrators.

Prerequisites:

None, however Universe Designer experience will be helpful.

Synopsis:

This course is designed to walk through creating connections and using existing connections as well as the requirements when using a Multiple connection universe.

Major Topics include:

• Creating Connections and Shortcuts
• Single vs. Multiple Connections
• Data Federator tool
• 64-bit vs 32-bit Requirements

Monday, June 22 – Module 3

Creating Data Foundations

Intended Audience:

This module is intended for the Novice to Experienced universe designer.

Prerequisites:

None, however Universe Designer experience will be helpful.

Synopsis:

This module is intended to show attendees how Data Foundations are created and how to work with them.

Major Topics include:

• Creating the Data Foundation
• Inserting/Editing Joins
• Refreshing Structure
• Contexts vs Aliases
• Data Foundation Views
• Comments and Families

Tuesday, June 23 – Module 4

Resolving Chasm Traps and Fan Traps and Using Outer Joins

Intended Audience:

This module is intended Universe Designers who may be working with Snowflake or Transactional databases.

Prerequisites:

None, however Universe Designer experience will be helpful.

Synopsis:

This course will discuss fan traps and chasm traps- what they are and how they affect the results of a query.  We will walk through how to work with them in IDT.  This course will also cover outer joins both in discussion and exercise.

Major Topics include:

• Recognizing traps
• Resolving traps
• Outer Joins 101

Tuesday, June 23 – Module 5

IDT Extras – Exclusive to IDT

Intended Audience:

This module is intended for the universe designer wishing to familiarize themselves with the new IDT tool.

Prerequisites:

None, however Universe Designer experience will be helpful.

Synopsis:

This module is intended to demonstrate some of the smaller but useful additions in the IDT software for working with universes.

Major Topics include:

• Calculated Columns
• Colors
• Comments
• Running Queries

Tuesday, June 23 – Module 6

Creating Business Layers

Intended Audience:

This module is intended for the universe designer wishing to familiarize themselves with the new IDT tool.

Prerequisites:

None, however Universe Designer experience will be helpful.

Synopsis:

This module will walk through creating the Business Layer and creating Business Views.

Major Topics include:

• Creating a Business Layer
• Inserting Folders and Objects
• Creating a Business View
• Security Business Views

Wednesday, June 24 – Module 7

Prompts – Cascading and Otherwise

Intended Audience:

This module is intended for the universe designer wishing to familiarize themselves with the new IDT tool.

Prerequisites:

None, however Universe Designer experience will be helpful.

Synopsis:

This module will walk through creating prompts in the Data Foundation Layer and in the Business Layer and why you would choose one over the other.

Major Topics include:

• Creating Prompt in Data Foundation
• Creating Prompt in Business Layer
• Cascading Prompts
• Hierarchy Prompts

Wednesday, June 24 – Module 8

Helpful Predefined Conditions

Intended Audience:

This module is intended for the universe designer wishing to familiarize themselves with the new IDT tool.

Prerequisites:

Knowledge of SQL

Synopsis:

This module will cover some commonly created predefined conditions.

Major Topics include:

• Creating Predefined Conditions
• Date Prompts
• Correlated Subqueries
• Creative Conditions

Wednesday, June 24 – Module 9

IDT: Using OLAP and SAP Data Sources

Intended Audience:

This module is intended for the universe designer wishing to familiarize themselves with the new IDT tool.

Prerequisites:

Knowledge of OLAP cubes and/or SAP Bex Queries and BW Connectivity.

Synopsis:

This module will walk through some of the less common connection types.  We will cover creating a universe based on an OLAP cube and universes based on some of the SAP connection options.

Major Topics include:

• Creating an OLAP connection
• Creating and OLAP connected Universe
• Options for Connecting with SAP Data

Back to Tracks and Agenda

 

Back to Tracks and Agenda

Presenter: Ethan Durda, Ascension Business Intelligence, LLC.

Intended Audience:

This beginner level course is for business intelligence professionals who are interested in learning more about the how’s and what’s regarding data warehouse design.  Extensive knowledge in reporting systems is not required, but understanding of SQL and reporting/dashboarding concepts will be helpful.

Prerequisites:

Basic SQL and database concepts.  This is not a hands on course but an understanding of these items will assist in understanding the concepts described.

Synopsis:

This session will be a review and walk-through of the major steps and processes of data modeling.  The general theoretical model will be a Kimball/Inman approach with an overall case study walking through the process of reshaping a transactional data model to a star schema.

Major Topics Include:

• Define and explain the language of data modeling.
• Review the theoretical underpinnings and reasons and purpose of various models.
• Understand best practices and limitations of different data models and their practical application.
• Review techniques and examples of what and how to move from a transactional model to a star schema.
• Explore the SQL challenges that a transactional system presents and how to develop solutions to them.
• Explain and explore key concepts of data modeling including slowly changing dimensions, row level security models, dimensional modeling (conforming dimensions), fact granularity and fact table types.
• A high level review of tools and methodologies for implementing a new data model.

 

This session will be delivered in a seminar format.

Back to Tracks and Agenda

Presenters:  Steve Thatcher and Oliver Prucha, InfoSol Inc.

Monday, June 22nd – Module 1

Web Intelligence XI 3.1 to BI 4.1 Delta Boot Camp

Intended Audience:

This module is intended for users and report designers who are experienced in Web Intelligence 3.1 and need to learn the new features and functions in Web Intelligence 4.1.

Prerequisites:

Attendees should have experience using Web Intelligence 3.1

Synopsis:

This hands-on immersion boot camp will cover the main differences between the new Web Intelligence 4.1 and its XI 3.1 predecessor. This will include the re-designed BI Launch Pad, new features in the Query Panel, the re-designed Report Panel interface, the overhauled chart engine and new report options including element linking, Fit to Page, Hiding Dimensions and Freeze header.

Major Topics Include:

• Learn the key differences between Web Intelligence 3.1 and the new Web Intelligence 4.1
• Become familiar with the new look and feel of Web Intelligence 4.1
• Learn new functionality available with Web Intelligence 4.1

Monday, June 22nd – Module 2

Queries and Data Provider

Intended Audience:

This module is intended for users and report designers looking to understand the various types of queries available in Web Intelligence, and how to build reports that leverage multiple data providers.

Prerequisites:

Attendees should have at least one year’s experience using Web Intelligence.

Synopsis:

Depending on your needs, there may be times where simple queries will not yield the results you want in a report. In these cases, more advanced techniques using combined queries or subqueries may be necessary. This unit teaches you about these advanced querying techniques.

Major Topics Include:

• Combined Queries
  • Union
  • Intersect
  • Minus
• Subqueries
• Query of a Query
• Using Personal Data Providers

Monday, June 22nd – Module 3

Dynamic Graphics and Interactive Charts

Intended Audience:

This module is intended for users and report designers who are experienced in Web Intelligence 4.1 and are looking to display graphics and charts based on conditional formulas and user interaction.

Prerequisites:

Attendees should have at least one year’s experience using Web Intelligence.

Synopsis:

Web Intelligence 4.1 introduced exciting new options for developers to display report elements based on underlying report conditions and user interaction with the report elements. This hands-on immersion boot camp will explore using these new features to provide report users with a more engaging, and interactive experience.

Major Topics Include:

• Adding graphics to report cells
• Using the display element dialogue box
• Explore the new element linking input control
• Integrating report level filtering

Tuesday, June 23rd – Module 4

Using Advanced Calculation Context

Intended Audience:

This module is intended for users and report designers who are experienced in Web Intelligence 4.1 and are looking to create custom calculations beyond the default aggregation.

Prerequisites:

Attendees should have at least one year’s experience using Web Intelligence.

Synopsis:

There are times one of the most dynamic and user-friendly features of Web Intelligence – default aggregation – limits report developers when creating required calculations in reports. This hands-on immersion boot camp will explore using advanced calculation context to create customized solutions to challenging report calculation requirements.

Major Topics Include:

• Using Input context
• Using Output context

Tuesday June 23rd – Module 5

Exploring Built-in Functions & Formulas

Intended Audience:

This module is intended for users and report designers who are experienced in Web Intelligence 4.1 and are looking to create custom reporting solutions leveraging many of the available built-in functions.

Prerequisites:

Attendees should have at least one year’s experience using Web Intelligence.

Synopsis:

There are many formula functions built into the Web Intelligence report designer.  Many of these functions are similar to functions found in other reporting tools, and many leverage the metadata within Web Intelligence, and the Business Objects platform.  This hands-on immersion boot camp will explore using the formula editor to create customized solutions to challenging report design requirements.

Major Topics Include:

• Overview of the Web Intelligence formula editor
• Use many of the unique Web Intelligence built-in functions to build customize solutions such as:
  • Automate report titles, etc. by referencing user prompts
  • Display date values formatted based on the users locale settings
  • Reference ASCII codes (new line, currency symbols, etc.) in formulas and cells
  • Convert string and data values per report design requirements

Tuesday June 23rd – Module 6

Dynamically Displaying Data

Intended Audience:

This module is intended for users and report designers who are experienced in Web Intelligence 4.1 and need to learn techniques to both group data values, and display data conditionally at the report level.

Prerequisites:

Attendees should have at least one year’s experience using Web Intelligence.

Synopsis:

Sometimes a report developer is presented with challenging requests to display values in unique ways, and with little help at the universe level. This hands-on immersion boot camp will explore two main techniques available in Web Intelligence 4.1 to assist with such requests. These techniques include grouping data values, and using conditional formatting and display.

Major Topics Include:

• Grouping data values using:
  • If/Then/Else formula
  • Personal data providers
  • The new custom grouping feature in Web Intelligence 1
• Conditional Formatting
  • Using traditional font, cell, report formatting
  • Using formulas to customize display of underlying data

Wednesday, June 24th – Module 7

Going Mobile – Design and Deployment

Intended Audience:

This module is intended for users and report designers who are looking to display their Web Intelligence 4.1 content on mobile devices.

Prerequisites:

Attendees should have at least six months of experience working with various Web Intelligence report tables and charts and their respective properties.  Basic understanding of the user experience using mobile devices such as tablets.

Synopsis:

Due to the proliferation of mobile devices in business today, report designers are increasingly being asked to provide reporting solutions for distribution on a mobile platform.  More often than not, users would like to consume their Web Intelligence content on their mobile devices such as smartphones and tablets.  This hands-on immersion boot camp will explore design considerations to enhance the display of both existing and new documents on mobile devices using the SAP BusinessObjects Mobile Client application.

Major Topics Include:

• Exploring mobile platform design challenges
• Mobile report design best practices
• Configuring and using the SAP BusinessObjects Mobile Client application

Wednesday, June 24th – Module 8

Creative Linking and Document Scheduling

Intended Audience:

This module is intended for users and report designers who are experienced in Web Intelligence 4.1 and are looking to link multiple documents into their analysis project.  Once created, users may wish to schedule these documents for distribution using the document scheduler.

Prerequisites:

Attendees should have at least one year’s experience using Web Intelligence.

Synopsis:

There are times when more than one document is needed to tell the whole story.  And the story may be received using multiple methods of report distribution, such as online and e-mail.  This hands-on immersion boot camp will explore linking a document to other documents and websites, and scheduling documents for distribution.

Major Topics Include:

• Linking documents to other documents and websites
  • Hyperlink
  • OpenDoc
• Exploring document scheduling options
  • Built-in Business Objects document scheduler
  • Introduction to the InfoBurst 3rd party report bursting tool

Wednesday, June 24th – Module 9

Design Considerations and Charting

Intended Audience:

This module is intended for users and report designers who are looking for ideas and suggestions for best practices and design considerations, while gaining a deeper understanding of the new charting engine in Web Intelligence 4.1.

Prerequisites:

Attendees should have at least six months of experience working with various Web Intelligence report tables and charts and their respective properties.  Basic understanding of the user experience using mobile devices such as tablets.

Synopsis:

Over time, Web Intelligence report designers develop tips and best practices to develop reports efficiently and effectively.  These tips and best practices are enhanced by the new features and functionality offered by each new  Business Objects platform release, and release 4.1 is no exception!  This hands-on immersion boot camp will explore report design tips and best practices, while also exploring the new charting engine in Web Intelligence 4.1 to assist report developers with  understanding their many charting options beyond basic bar, line, and pie charts.

Major Topics Include:

• Exploring report design tips and best practices
• Understanding the new charting engine
• Exploring examples of the intended use of many of the available charts in Web Intelligence 4.1

Back to Tracks and Agenda

 

Back to Tracks and Agenda

Presenters:  Roxanne Pittman and Taylor Packwood, InfoSol Inc.

Monday, June 22nd – Modules 1 & 2

What’s New in Dashboards 4.1

Intended Audience:

This module is intended for individuals who want to know what has changed since Xcelsius 2008 and what’s new in the latest and greatest version of SAP Dashboards (Xcelsius).

Prerequisites:

Experience with Xcelsius 2008 or SAP Dashboards 4.0.

Synopsis:

This course is designed to provide experienced dashboard attendees with an overview of the changes to the dashboard tool we know and love as Xcelsius. There have been many changes since the Xcelsius 2008 version to the current version; we will discuss the new features and best practices to make to most use of them.

Major Topics Include:

• Introduction
• New Features in Dashboards 4.1 and How To Make Use of Them

Monday, June 22nd – Modules 3 & 4

How to Move From Basic to Visually Compelling Dashboards

Intended Audience:

This module is intended for the Novice to Experienced dashboard developers who want to move beyond the basics of ‘now I know how to connect a chart’ to ‘how to put it all together to look amazing’

Prerequisites:

Novice to Experienced dashboard developers with Xcelsius 2008 or Dashboards 4.x

Synopsis:

This module is intended to show attendees the techniques that are common to awesome dashboards.  We will discuss how to help the business visualize KPI’s, best dashboard layout concepts, and best components to use.  Then we will critique several existing dashboards and discuss what works well, what distracts, what could be improved and what has impact and draw.

Major Topics Include:

• KPI’s to Visualization
• Layout Design Concepts
• Critiquing Existing Dashboard Visual Designs

Monday, June 22nd – Modules 5 & 6

Dashboard Data Filtering

Intended Audience:

This module is intended for the Novice to Experienced dashboard developers who wish to expand their knowledge on filtering data in the Excel model of Dashboards.

Prerequisites:

Novice to Experienced dashboard developers with Xcelsius 2008 or Dashboards 4.x

Synopsis:

This module is intended to show how to create Cascading Filters in Dashboards 4.x using the ‘Filtered Row’ option available in many selectors.  We will also how to make use of hidden filters to move data behind the scene.

Major Topics Include:

• Data Filtering
• Cascading Prompts/Filtered Rows
• Using Hidden Filters

Tuesday, June 23rd – Modules 1-4

Cool Visualizations and Charting Outside the Box

Intended Audience:

This module is intended for Novice to Experienced dashboard developers who are ready to move beyond the basic charts to advanced techniques to achieve web-type visualizations and infographics.

Prerequisites:

Novice to Experienced dashboard developers with Xcelsius 2008 or Dashboards 4.x

Synopsis:

Stretching the boundaries of Dashboards with some cool visualization tricks, this hands-on class will be taking Dashboard components and using them in creative ways to achieve customized charting, infographics and advanced navigation methods – without 3rd party components.  We will also expand your toolset by showing some very helpful 3^rd party components.

Major Topics Include:

• Cool Visual Ideas for Dashboards
• Creative Use of Charts

Tuesday June 23rd – Modules 5 & 6

Data Optimization

Intended Audience:

This module is intended for Novice to Experienced dashboard developers who need to master the basics of Excel for Dashboards, and who want tips on performance tuning a large dashboard

Prerequisites:

Novice to Experienced dashboard developers with Xcelsius 2008 or Dashboards 4.x

Synopsis:

This module will be covering the 5 most used Excel functions when creating Dashboards with hands-on exercises to go through as well as learn what functions to avoid.   The second half of this module will be spent on understanding ways to improve the performance of a dashboard, especially large dashboards or large data sets.

Major Topics Include:

• Mastering Excel
• Data Optimization
• Performance Tuning

Wednesday, June 24th – Modules 1 & 2

Dashboard Connectivity Options

Intended Audience:

This module is intended for Experienced dashboard developers who want to understand and gain some experience with the various options for connecting Dashboards to Data from BusinessObjects or even directly from databases.

Prerequisites:

Experienced dashboard developers with Xcelsius 2008 or Dashboards 4.x

Synopsis:

There are many ways to load data from BusinessObjects and databases into SAP Dashboards.  This course will give users an opportunity to learn the advantages and disadvantages of each of the following methods as well as hands-on exercises for:  Query Browser, Query As a Web Service (QaaWS), BI Web Services (BIWS) and InfoBurst

Major Topics Include:

• Built-in Dashboard Connectivity
• InfoBurst Connectors

Wednesday, June 24th – Modules 3 & 4

Mobility Options Module

Intended Audience:

This module is intended for Novice to Experienced dashboard developers who want to learn more about the latest mobility options with SAP Dashboards.

Prerequisites:

Novice to Experienced dashboard developers with Xcelsius 2008 or Dashboards 4.x

Synopsis:

This module will cover the latest options in native HTML5 dashboards from SAP Dashboards.  We will also discuss 3^rd party options for mobile dashboards and have hands-on exercises for taking an SAP Dashboard and mobilizing it in HTML5.

Major Topics Include:

• Deploying Dashboards to Mobile
• 3^rd Party Mobility Options

Wednesday, June 24th – Modules 5 & 6

Dashboard Challenge

Intended Audience:

This module is intended for Novice to Experienced dashboard developers who are ready to apply concepts they’ve learned during the preceding days at IBIS to create their own dashboard.

Prerequisites:

Novice to Experienced dashboard developers with Xcelsius 2008 or Dashboards 4.x

Synopsis:

The final module will be a challenge for the dashboard developer to take a set of requirements and data give by the instructors to create their own dashboard, applying concepts and tools they’ve learned at IBIS.

Major Topics Include:

• Capstone Exercise To Bring All Topics Together
• Hands-on Full Dashboard Building Experience

Back to Tracks and Agenda