9:00am - 5:00pm
Course Overview - IDT in a Day

Course Description: A detailed look at building universe with the new IDT.    Learn about creating connections, building the data foundation layer, adding a business layer, and applying security profiles.  This one day hands on course will also explore features in IDT like creating List of Values (LOV’s), combining LOV’s with Parameters, Defining Context, adding aggregate awareness, and sharing projects within your organization.    

Intended Audience:  This class is designed for technical analysts, or those first being introduced to Information Design Tool who are required to and looking to better understand what it takes to create the BusinessObjects Connections, Data Foundations and Business Layers as an interface to the data in a data warehouse, data mart, or database. 

Major Topics Include: 

  • IDT Overview 
  • Creating Connections 
  • Creating Projects 
  • Applying Security Profiles 
  • Adding Business Layers 
  • The Data Foundation Layer 
  • List of Values 
  • LOV’s with parameters 
  • Defining Context 
  • Adding Aggregate Awareness 
  • Sharing Projects 
9:00am - 5:00pm
Course Overview - InfoBurst Certified Expert Administrator (ICE-A)

This course is focused on advanced InfoBurst administration and will provide students with an InfoBurst Certified Expert Administrator (ICE-A) certificate upon completion. This one-day hand’s on course will provide students with an in-depth understanding on document management and security, platform installation and maintenance, user and group management and best practices, platform security, system configuration, as well as advanced features of report bursting and distribution.  

Intended Audience:  InfoBurst administrators who wish to become certified in advanced administrative aspects of the InfoBurst platform.  

Prerequisites:  You should have a basic understanding of SQL and relevant reporting platforms, InfoBurst user-level knowledge of report bursting and/or XDC, basic understanding of relevant reporting platforms (BO, MSRS), and basic knowledge of DBMS and Windows server concepts.  

Major Topics include:  

  • Product history and information  
  • Platform installation requirements and installation procedures  
  • Repository configuration  
  • User and Group Management  
  • Users & Groups Platform  
  • Configuration and Software Updates  
  • Document Management and Security  
  • Advanced Bursting  
  • Troubleshooting and Logging 
9:00am - 5:00pm
Course Overview - SAP BO Dashboards for Beginners

An introduction to SAP Dashboards (Xcelsius) for beginners/newbies to the tool. This 1 day course will provide a detailed understanding of key concepts, consolidated with hands-on experience. Learn how to navigate the interface, select and position components on the canvas and configure component properties, all while building your first fully interactive dashboard. Finally, benefit from a host of hints and tips that we wish someone had shown us when we were starting out. 

Intended Audience: This course is open to anyone interested in learning the fundamentals of Dashboard Development and Design. 

Prerequisites: None; although some knowledge/experience of MS Excel would be advantageous. 

9:00am - 5:00pm
Course Overview for Web Intelligence for Beginners

This course is for users and report designers who are new to Web Intelligence 4.2 and need to learn to access, analyze and share data using Web Intelligence.

What will I learn?

Upon completion of this boot camp, participants will be able to create, format and maintain Web Intelligence documents. Participants will also be able to use complex functions such as creating documents using multiple sources, use character and date strings, redefine calculation contexts, use “If” logic, as well as link Web Intelligence documents.

10:00am - 12:00pm
Tableau from A-Z: Introduction and connecting to data

COURSE DESCRIPTION:  This course covers an introduction to Tableau along with a number of advanced topics to give the attendee the tools to be productive with Tableau. Each 2-hour module will be “hands-on” and will include exercises for the class.

INTENDED AUDIENCE:  Those wishing to boost their Tableau skills.

MAJOR TOPICS INCLUDE:

  • Connecting to data and how to use the data interpreter
  • The data sources available in Tableau with examples of connecting to several different data sources.
  • Examples of data blending and joins with multiple data sources
  • How to use features such as splitting, union and pivoting
  • The different chart types available in Tableau.
Allan Williams

COURSE DESCRIPTION:  This course covers an introduction to Tableau along with a number of advanced topics to give the attendee the tools to be productive with Tableau. Each 2-hour module will be “hands-on” and will include exercises for the class.

INTENDED AUDIENCE:  Those wishing to boost their Tableau skills.

MAJOR TOPICS INCLUDE:

  • String calculations
  • Data calculations
  • Booleans (True/False)
  • If-Then calculations and Case statements
  • Aggregation and Disaggregation
  • Advanced calculations.
  • Table Calculations
Allan Williams

COURSE DESCRIPTION:  This course covers an introduction to Tableau along with a number of advanced topics to give the attendee the tools to be productive with Tableau. Each 2-hour module will be “hands-on” and will include exercises for the class.

INTENDED AUDIENCE:  Those wishing to boost their Tableau skills.

MAJOR TOPICS INCLUDE:

  • Bins, Top and Bottom N
  • Moving Average
  • Dynamic Dates
  • Key Performance Indicators
  • Field Swapping and Sheet Swapping.
Allan Williams
10:00am - 12:00pm
WebI Dashboards Boot Camp: Alerting Dashboard Using Heat Maps and Scorecards

This module will cover the first of three types of dashboards, Alerting dashboards. Our first session will cover charts that alert including heat maps and scorecards.

Intended Audience:  This module is a good intro to charting for users of all abilities in Web Intelligence.   No prior Web Intelligence experience necessary.

Major Topics Include:

  • Bringing in Data
  • Displaying data in Heat Maps
  • Displaying data in Scorecards
  • Using Specialty Fonts
  • Highlighting with Conditional Formatting
  • Turning on Tracking
Amy O'Neel and Roxanne Pittman - InfoSol Inc.

We will take our Alerting dashboard further to make it work for our attention!  This module will include using a script for refreshing on a timer, creating eye-catching marquees and adding options in scheduling that can trigger alerts and emails.

Intended Audience:  This module will provide the scripting and walk through each step of scheduling for users of all abilities in Web Intelligence.   A basic understanding of adding blocks and cells to Web Intelligence reports and in scheduling documents is helpful.

Major Topics Include:

  • Adding Scripts to Webi
  • Schedule to Alert
  • Schedule to Email
  • Marquee and HTML Options
Amy O'Neel and Roxanne Pittman - InfoSol Inc.

Once alerted to anomalies in our Alerting dashboard, we may need to drill in further to get details to determine the cause of the alert.  In this module we will cover ways to display our dashboard either in the HTML5 interface and in BI Workspaces.  We will also look at various linking options between documents and report as well as chart to table display and for adding external links.

Intended Audience:

We will provide step by step instructions for users of all abilities in Web Intelligence.

Major Topics Include:

  • HTML5 Fiori Interface
  • Biworkspaces
  • OpenDocument Linking
  • Report to Report Linking
  • Cell Format as Hyperlink
Amy O'Neel and Roxanne Pittman - InfoSol Inc.
10:00am - 12:00pm
Webi 4.2 SP6 Boot Camp: What’s the latest with Web Intelligence 4.2 SP6?

Course Overview: This course is for both users and report designers with beginner to intermediate familiarity of Web Intelligence reporting whom need to learn to access, analyze and share data using Web Intelligence 4.2 SP6.

Upon completion of this boot camp, participants will be able to create, format and maintain Web Intelligence documents. Participants will also be able to use complex functions such as creating documents using multiple sources, use character and date strings, redefine calculation contexts, use “If” logic, as well as link Web Intelligence documents.

Prerequisites: Familiarity with the web Intelligence report building designer.

Intended Audience: Web Intelligence developers

Module Overview:

This hands-on session explores the latest changes in Web Intelligence 4.2 SP6 and how these changes can make your life easier.  Topics include: (bullets of what will be covered are fine too)

  • Java/DHTML Clients Parity
  • Cascading Input Control
  • Merged Variables and Objects Display
  • References
  • Shared Elements
  • Comments
  • Geo Maps
  • Parallel Queries
Tyler Koitka - InfoSol Inc.

Course Overview: This course is for both users and report designers with beginner to intermediate familiarity of Web Intelligence reporting whom need to learn to access, analyze and share data using Web Intelligence 4.2 SP6.

Upon completion of this boot camp, participants will be able to create, format and maintain Web Intelligence documents. Participants will also be able to use complex functions such as creating documents using multiple sources, use character and date strings, redefine calculation contexts, use “If” logic, as well as link Web Intelligence documents.

Prerequisites: Familiarity with the web Intelligence report building designer.

Intended Audience: Web Intelligence developers

Module Overview:

This session will be a deep dive into the most common used formulas in every day report writing, along with some more advanced formulas for expanding your tools as a report writer.  We will be covering:

  • Aggregate functions
  • Character functions
  • Date & Time functions
  • Logical functions
  • Numeric functions
Tyler Koitka - InfoSol Inc.

Course Overview: This course is for both users and report designers with beginner to intermediate familiarity of Web Intelligence reporting whom need to learn to access, analyze and share data using Web Intelligence 4.2 SP6.

Upon completion of this boot camp, participants will be able to create, format and maintain Web Intelligence documents. Participants will also be able to use complex functions such as creating documents using multiple sources, use character and date strings, redefine calculation contexts, use “If” logic, as well as link Web Intelligence documents.

Prerequisites: Familiarity with the web Intelligence report building designer.

Intended Audience: Web Intelligence developers

Module Overview:

This session will cover how to use breaks and break formatting to achieve dynamic results.  We will also be covering conditional formatting and, when combined with document hyperlinks, we can show how to create interactive scorecard type formatting.

Tyler Koitka - InfoSol Inc.
10:00am - 12:00pm
IDT UNIVERSE DESIGN BOOT CAMP – COMPARE AND CONVERT UNV TO UNX UNIVERSES

 

What are the advantages of using IDT versus UDT?  What are the new features and benefits in creating an IDT UNX Universe? What do I do with my old UNV universes? This session will address all of the above questions. The steps to create an IDT universe, its differences from UDT and how to modify reports to use the new UNX will be covered.Topics:

  • Basics of Semantic Layer and BO universes
  • Getting Started with Information Design Tool interface
  • Converting an UNV universe to UNX universe
  • Mapping Web Intelligence and Crystal Reports to the new UNX universe
Runali Ghosh - InfoSol Inc. and Minith Patel - InfoSol Inc.

Creating a connection and a data foundation is the first step in a relational universe build. This session covers the different types of data sources accessed within IDT, the connection parameters and options, creating and modifying a data foundation as well as guidelines and tips for good data foundation design.

Topics

  • Creating local and secured connections, publishing and retrieving the connections from CMS
  • Designing a data foundation, identifying tables and columns, joins, keys and cardinalities
  • Creating Derived tables, calculated columns, families, comments
  • Using data foundation views
  • Creating data foundation parameters
Runali Ghosh - InfoSol Inc. and Minith Patel - InfoSol Inc.

The business layer of the universe is the user interface between users and databases. This session covers the design of the different components of a business layer including how a business layer takes advantage of the data foundation modeling. Creating queries, filters, parameters and advanced features will also be covered.

Topics:

  • Designing a Business layer based on a relational data foundation
  • Creating Folders, dimensions, attributes, measures, filters and validating the objects
  • Queries, parameters, Business Layer views and Navigation paths
  • Using your UNX to create a Web Intelligence report
Runali Ghosh - InfoSol Inc. and Minith Patel - InfoSol Inc.
Full Agenda Coming Soon!
The full IBIS agenda will be posted in December!
Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

10:00am - 12:00pm
Tableau from A-Z: Level of Detail Expressions

COURSE DESCRIPTION:  This course covers an introduction to Tableau along with a number of advanced topics to give the attendee the tools to be productive with Tableau. Each 2-hour module will be “hands-on” and will include exercises for the class.

INTENDED AUDIENCE:  Those wishing to boost their Tableau skills.

MAJOR TOPICS INCLUDE:

  • LOD syntax prefixes and when to use each one
  • When to use an LOD
  • What kind of LOD should be used
  • Understanding how LOD expressions work “under the hood”
  • Examples of use cases for using LOD Expressions.
Allan Williams

COURSE DESCRIPTION:  This course covers an introduction to Tableau along with a number of advanced topics to give the attendee the tools to be productive with Tableau. Each 2-hour module will be “hands-on” and will include exercises for the class.

INTENDED AUDIENCE:  Those wishing to boost their Tableau skills.

MAJOR TOPICS INCLUDE:

  • Tableau excels at mapping. In this hands-on session we will cover the following topics:  Articulate Tableau’s geocoding
  • How to use custom Geocoding in Tableau
  • Filled maps vs. symbol maps
  • Creating custom territories
  • Adding map layers
  • Creating custom background maps
  • Building dashboards with maps
  • Visual best practices for using the mapping functionality in Tableau.
Allan Williams

COURSE DESCRIPTION:  This course covers an introduction to Tableau along with a number of advanced topics to give the attendee the tools to be productive with Tableau. Each 2-hour module will be “hands-on” and will include exercises for the class.

INTENDED AUDIENCE:  Those wishing to boost their Tableau skills.

MAJOR TOPICS INCLUDE:

  • Dashboard formatting basics
  • Workbook level formatting (i.e. font styling, titles, lines)
  • Focusing on the narrative
  • Using color with purpose
  • Using fonts that optimize online readability
  • The importance of using tooltips for your audience
  • Removing clutter.

Dashboard actions will be covered as well – this is the functionality in Tableau that allows users to connect workbook elements for interactivity between workbooks in a dashboard.

Allan Williams
10:00am - 12:00pm
WebI Dashboards Boot Camp: Analytical Dashboard – What If?

With the second type of dashboards – Analytical dashboards, we will dive right in with What-If Analysis including modifying range inputs and adding multi-select filters and single select filtering.  We will also cover passing a value when refreshing data to influence the resulting format and switching dimension and measure selections on the fly.

Intended Audience:

We will provide step by step instructions for users of all abilities in Web Intelligence.

Major Topics Include:

  • Range Input Controls
  • Measure Selection
  • Multi-select Input Controls
  • Prompts
Amy O'Neel and Roxanne Pittman - InfoSol Inc.

This module will cover bringing in add-ons known as Custom Elements.  There are a variety of add-ons available in the market place that can greatly increase your charting options with Webi.  We will cover a few of them and how to add them as well as walk through an example of creating your own from a Google Charting link.  With all these charts to choose from, we will also take this time to cover a little of when to use which chart type to convey what message.

Intended Audience:

We will provide step by step instructions for users of all abilities in Web Intelligence.

Major Topics Include:

  • Adding Custom Elements
  • Using Node.js for Google Charting
  • When to Use Which Chart
Amy O'Neel and Roxanne Pittman - InfoSol Inc.

This module will cover statistical charting options including the reusability of complicated formulas with Shared Elements as well as some functions and formulas that we have available to us to calculate.

Intended Audience:

We will provide step by step instructions for users of all abilities in Web Intelligence.

Major Topics Include:

  • Statistical Functions
  • Percentile
  • Context Operators
  • Polynomial Functions
  • Shared Elements
Amy O'Neel and Roxanne Pittman - InfoSol Inc.
10:00am - 12:00pm
Webi 4.2 SP6 Boot Camp: Making an impact with Web Intelligence 4.2 charts

This course is for both users and report designers with beginner to intermediate familiarity of Web Intelligence reporting whom need to learn to access, analyze and share data using Web Intelligence 4.2 SP6.

Upon completion of this boot camp, participants will be able to create, format and maintain Web Intelligence documents. Participants will also be able to use complex functions such as creating documents using multiple sources, use character and date strings, redefine calculation contexts, use “If” logic, as well as link Web Intelligence documents.

Prerequisites: Familiarity with the web Intelligence report building designer.

Intended Audience: Web Intelligence developers

Module Overview:

Each service pack upgrade with Web Intelligence continues to bring improvements with charting features.  This session gives a deeper dive into the latest updates as well as some ‘out of the box’ examples for adding alert features to your charts:

  • Geomaps
  • Chart comments
  • Charting engine updates
  • Creating Alerts on charts
Tyler Koitka - InfoSol Inc.

This course is for both users and report designers with beginner to intermediate familiarity of Web Intelligence reporting whom need to learn to access, analyze and share data using Web Intelligence 4.2 SP6.

Upon completion of this boot camp, participants will be able to create, format and maintain Web Intelligence documents. Participants will also be able to use complex functions such as creating documents using multiple sources, use character and date strings, redefine calculation contexts, use “If” logic, as well as link Web Intelligence documents.

Prerequisites: Familiarity with the web Intelligence report building designer.

Intended Audience: Web Intelligence developers

Module Overview:

Two great methods of analyzing data in Web Intelligence are Drilling and Element linking.  Drilling allows users to examine hierarchical subsets of data to explore trends.  Element linking provides an easy, intuitive method of examining related sets of data and, when combined with Input Filters, can bring further clarity to selections of business data for analysis.  This hands-on session will show step by step how to utilize these great Webi features.

Tyler Koitka - InfoSol Inc.

This course is for both users and report designers with beginner to intermediate familiarity of Web Intelligence reporting whom need to learn to access, analyze and share data using Web Intelligence 4.2 SP6.

Upon completion of this boot camp, participants will be able to create, format and maintain Web Intelligence documents. Participants will also be able to use complex functions such as creating documents using multiple sources, use character and date strings, redefine calculation contexts, use “If” logic, as well as link Web Intelligence documents.

Prerequisites: Familiarity with the web Intelligence report building designer.

Intended Audience: Web Intelligence developers

Module Overview:

By combining the powerful new visualization features of Web Intelligence with interactive functionality—like input controls, linking, and drill-down—companies can now create attractive, robust, and meaningful dashboards in SAP BusinessObjects Web Intelligence. In this hands-on session, attendees will learn how to create visual and interactive reports plus aggregate and trend analysis, filtering with input controls, document linking, charts, and more. Come and hear how you, too, can create engaging dashboards using only SAP BusinessObjects Web Intelligence as your BI tool.

 

Tyler Koitka - InfoSol Inc.
10:00am - 12:00pm
IDT UNIVERSE DESIGN BOOT CAMP – LIST OF VALUES, UNIVERSE PROMPTS, CASCADING & OTHERWISE

The list of values and universe prompts are entities that can be authored, shared and reused across data foundation and business layer resources. The different types of list of values and its association with universe objects such as filters and Prompts will be covered in this session. Steps to create cascading prompts and navigation paths will also be covered.

Topics:

  • Parameters created in the Data Foundation vs Business Layer
  • Static List of Values and List of Values based on Custom SQL
  • Parameter definition, association with list of values and parameter usage in a WebI report
  • Optimizing Prompts with cascading prompts and custom prompt properties
  • Creating a Pre-defined Filter using @Prompt syntax
  • Utilizing the new dynamic default value option
Runali Ghosh - InfoSol Inc. and Minith Patel - InfoSol Inc.

This session covers the steps to resolve some common traps in a data foundation design and avoid incorrect query results. The IDT features to detect and solve loops will also be covered.

Topics:

  • Identifying Fan traps and Chasm Traps
  • Resolving traps with Aliases and contexts
  • General use of @aggregateaware and resolving traps with @aggregateaware
  • Using outer joins
  • Setting up optional outer joins
Runali Ghosh - InfoSol Inc. and Minith Patel - InfoSol Inc.

This session will be a recap of all the IDT features and functionalities.  We will start with two report requirements and create a universe from start to finish using the techniques we have learned.

Topics

  • Designing universes to meet report requirements.
  • Best practices for Universe development
  • Usage of built in @functions
  • Using Index awareness
Runali Ghosh - InfoSol Inc. and Minith Patel - InfoSol Inc.
Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

10:00am - 12:00pm
Tableau from A-Z: Understanding how Tableau Server works

COURSE DESCRIPTION:  This course covers an introduction to Tableau along with a number of advanced topics to give the attendee the tools to be productive with Tableau. Each 2-hour module will be “hands-on” and will include exercises for the class.

INTENDED AUDIENCE:  Those wishing to boost their Tableau skills.

MAJOR TOPICS INCLUDE:

  • Licensing
  • Installation
  • Creating users
  • Sites, groups, projects
  • Types of roles, permissions
  • Publishing reports and extracts, and Scheduling.
Allan Williams

COURSE DESCRIPTION:  This course covers an introduction to Tableau along with a number of advanced topics to give the attendee the tools to be productive with Tableau. Each 2-hour module will be “hands-on” and will include exercises for the class.

INTENDED AUDIENCE:  Those wishing to boost their Tableau skills.

MAJOR TOPICS INCLUDE:

  • Delivering a BusinessObjects report as a Tableau Data extract (TDE)
  • Scheduling BusinessObjects reports to deliver TDE’s to Tableau server
  • Bursting Tableau workbooks outside of Tableau server
Allan Williams

COURSE DESCRIPTION:  This course covers an introduction to Tableau along with a number of advanced topics to give the attendee the tools to be productive with Tableau. Each 2-hour module will be “hands-on” and will include exercises for the class.

INTENDED AUDIENCE:  Those wishing to boost their Tableau skills.

MAJOR TOPICS INCLUDE:

  • Extracts Vs Live Connections
  • How best to work with live connections as well as interpreting universes into metadata
  • Creating Custom SQL with Query Prompts
  • IBTab UNX Web Data Connector
  • Removing clutter.
Dashboards 10:00am - 12:00pm
Webi Dashboards Boot Camp: Strategic Dashboard – Using Space Wisely

The third dashboard type is Strategic dashboards.  These dashboards are typically tracking KPIs and are often for management use.  We want to convey a lot of information quickly using images and color instead of text where it makes sense.   We will begin with covering smart use of space issues including designing for mobile consumption.  We will overlay transparent images and cover using color coding to communicate.

Intended Audience:

We will provide step by step instructions for users of all abilities in Web Intelligence.

Major Topics Include:

  • Designing for Mobile Display
  • Transparency in Image Overlays
  • Color Coding
Amy O'Neel and Roxanne Pittman - InfoSol Inc.

This module will cover Strategic Dashboards using interactive charts and blocks including geographic charts, element linking and special input controls as well as using show/hide options on blocks to display based upon formula.

Intended Audience:

We will provide step by step instructions for users of all abilities in Web Intelligence.

Major Topics Include:

  • Geographic Charts
  • Element Linking
  • Hide Cell or Block Based on Formula
Amy O'Neel and Roxanne Pittman - InfoSol Inc.

In this section we will display trends and highlight current status to track key performance indicators.  We will take this opportunity to discuss Key Performance Indicators both in display and concept.  We will include adding infographics, using comments on dashboards and using reference cells as input for tiles to make important results stand out above the noise.

Intended Audience:

We will provide step by step instructions for users of all abilities in Web Intelligence.

Major Topics Include:

  • Key Performance Indicators
  • Comments
  • Infographics
  • Alignment Dependency
  • Comments
  • Reference Cells
  • Tiles
Amy O'Neel and Roxanne Pittman - InfoSol Inc.
10:00am - 12:00pm
Webi 4.2 SP6 Boot Camp: Mobile magic with Web Intelligence

Course Overview: This course is for both users and report designers with beginner to intermediate familiarity of Web Intelligence reporting whom need to learn to access, analyze and share data using Web Intelligence 4.2 SP6.

Upon completion of this boot camp, participants will be able to create, format and maintain Web Intelligence documents. Participants will also be able to use complex functions such as creating documents using multiple sources, use character and date strings, redefine calculation contexts, use “If” logic, as well as link Web Intelligence documents.

Prerequisites: Familiarity with the web Intelligence report building designer.

Intended Audience: Web Intelligence developers

Module Overview:

This session equips the Web Intelligence report writer to develop reports that are designed for viewing on mobile applications, covering the best practices for page layout and learning the chart syntax for creating mobile specific charts and displays.

Tyler Koitka - InfoSol Inc.

Course Overview: This course is for both users and report designers with beginner to intermediate familiarity of Web Intelligence reporting whom need to learn to access, analyze and share data using Web Intelligence 4.2 SP6.

Upon completion of this boot camp, participants will be able to create, format and maintain Web Intelligence documents. Participants will also be able to use complex functions such as creating documents using multiple sources, use character and date strings, redefine calculation contexts, use “If” logic, as well as link Web Intelligence documents.

Prerequisites: Familiarity with the web Intelligence report building designer.

Intended Audience: Web Intelligence developers

Module Overview:

This module will discuss how to use more complex query features of Web Intelligence, giving real world examples and hands on experience.  The complex query features discussed in this module include:

  • Combined Queries
  • Nested filters
  • Query on Query
  • Using Subqueries
Tyler Koitka - InfoSol Inc.

Course Overview: This course is for both users and report designers with beginner to intermediate familiarity of Web Intelligence reporting whom need to learn to access, analyze and share data using Web Intelligence 4.2 SP6.

Upon completion of this boot camp, participants will be able to create, format and maintain Web Intelligence documents. Participants will also be able to use complex functions such as creating documents using multiple sources, use character and date strings, redefine calculation contexts, use “If” logic, as well as link Web Intelligence documents.

Prerequisites: Familiarity with the web Intelligence report building designer.

Intended Audience: Web Intelligence developers

Module Overview:

This module will cover some advanced techniques to improve user experience with Web Intelligence reporting, including the following topics:

  • Multiple data providers and using ForceMerge
  • Using Rank to flip the sort on a Horizontal chart
  • Using Dynamic logos in Webi reports
Tyler Koitka - InfoSol Inc.
10:00am - 12:00pm
IDT UNIVERSE DESIGN BOOT CAMP – DATA AND UNIVERSE SECURITY

Because universes can be used to centralize access to data sources that are sensitive, IDT also offers security capabilities to control access to these data sources. This session covers the different Security profiles and rights enforced by the BI platform and the objects access levels.

Topics:

  • Deploying and securing a published universe
  • Creating business and data security profiles
  • Assigning Security profiles to users
  • Using User Defined Attributes in Filters
  • Using @BOUSER in Filters
Runali Ghosh - InfoSol Inc. and Minith Patel - InfoSol Inc.

In some organizations, an entire team of designers may work together to create universes. To enable collaborative work and resource exchange, a shared project can be created in the CMS repository. This session covers the steps to create local projects and shared projects and how they can be used to share authored resources

Topics:

  • Creating shared projects and working with multiple IDT developers
  • Opening a shared project, locking and unlocking resources
  • Project synchronization for shared project management and resource synchronization
  • Renaming universes and files and the implications
Runali Ghosh - InfoSol Inc. and Minith Patel - InfoSol Inc.

Because of the evolution of BusinessObjects releases over time, different types of connections exist in BI 4.x based on different components. This session covers the steps to create an IDT connection with OLAP data sources, SAP HANA, BW and other relational data sources and also  the use of Linked Universes

  • Identifying the different data sources specific to SAP and non-SAP
  • Creating an OLAP universe on top of SQL Server Analysis server cube
  • Designing a multisource data foundation
  • Using Data Federator for optimizing multisource performance
  • Using Linked Universes
Runali Ghosh - InfoSol Inc. and Minith Patel - InfoSol Inc.
Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

Full Agenda Coming Soon!

The full IBIS agenda will be posted in December!

9:00am - 5:00pm
Course Overview - InfoBurst Certified Expert (ICE)

Course Overview  

InfoBurst Certified Expert (ICE) ICE is a hands-on training course to both further your knowledge of the InfoBurst solution and to be recognized as a certified expert in using the solution. The course is hands-on immersion-style training designed to bring you to an advanced level of expertise quickly and effectively. At the end of this course, participants will be certified in advanced InfoBurst administration. Intended  

Audience 

InfoBurst users who wish to become certified in utilizing InfoBurst for report bursting, publishing, and delivery.  

Prerequisites:  

You should have a basic understanding of SQL and relevant reporting platforms.  

Major Topics include:  

  • Product history and Wiki information  
  • User interface overview  
  • Cataloging Documents  
  • Managing objects  
  • Object Management  
  • Data Sources  
  • Report Bursting  
  • Parameter Aliases  
  • Document Source  
  • Basic Report Publishing and Delivery  
  • Delivery  
  • Publishing Formats  
  • Destination  
  • Publishing  
  • Advanced Bursting, Publishing, and Delivery  
  • Delivery Templates and Mixed Inline Content  
  • Content Grouping 
9:00am - 5:00pm
Course Overview - BI 4.2 Core Administration Boot Camp

Course Description: 

This two-day hands on post seminar course will cover the core features and functionality of BusinessObjects BI 4.1 and BI 4.2 that are essential to keep your BO system running smoothly. This course covers how to set up and manage security with key functions in the CMC in addition to Life Cycle Management (LCM) tools (Promotion Management, Version Management), customizing the Launchpad (previously known as InfoView), Monitoring, Auditing, Multitenancy, splitting the Adaptive Process Service (APS), and more. This training will also include information on Monitoring, troubleshooting and Maintenance along with recommendations on best practices. 

Intended Audience: 

BusinessObjects Administrators 

Prerequisites: 

A minimum of one-year experience in working knowledge of Business Objects Administration XIR2 or 3.x releases including the use of the CMC with basic knowledge of servers, security and networking required for functioning of BO application and tools. 

Major Topics Include: 

  • What’s new in BI 4.1 and 4.2 
  • Upgrade Management Tool 
  • System Configuration wizard 
  • Splitting APS 
  • Life Cycle Management, System Management 
  • Promotion Management 
  • Version Management 
  • Visual Difference 
  • Auditing 
  • Monitoring & Probes 
  • Administrator Cockpit 
  • Recycle Bin 
  • Platform tools 
  • Client Tools 
  • Launch Pad 
  • BI Mobile 
  • OLAP Connection and Analysis 
  • Security and Access Control 
  • Cryptographic Keys 
  • User Attribute Mapping 
  • Multitenancy 
  • Walkthrough 
  • Troubleshooting 
9:00am - 5:00pm
Course Overview - SAP BO Dashboards Hands-On

Intended Audience: 

This course is open to anyone interested in furthering their knowledge and expertise with data visualization, as well as with expanding their capabilities with SAP BO Dashboards (Xcelsius). 

Prerequisites: 

Experience with SAP BO Dashboards (Xcelsius); or have completed the SAP BO Dashboards for Beginners pre-con course. 

Information Design Workshop: From Concept to Visualization 

Successful dashboards all have one thing in common, they allow the end user to find or see the information they are looking for easily. The science/art of preparing information to be used by human beings with efficiency is known as information design. 

In this workshop we will employ methods and techniques used to evolve an idea and turn it into a data visualization, exploring each of the key attributes for effectively communicating information. 

Consistency is Key: Design guides and company design languages 

The tastes and trends of web applications are continually evolving, as are the processes companies such as Google, Apple, Twitter etc. use to ensure consistency across their products.  In this session we will look at the role of design guides and design languages in web development and how they can be applied to your BI projects. 

We will get hands on with Xcelsius and use native as well as 3rd party components to achieve a “modern design language” appearance to a dashboard. 

Bringing your dashboard to life: Taking your model live with connected data (Query Browser vs. BIWS vs. XDC vs. CSV connector) 

There are various ways to inject live or connected data into your dashboard, whether you want to use SAP Business Objects, InfoBurst XDC, database queries or even CSV files.  We will go through and have a look at each of these methods, discuss pros and cons for each approach and then get hands on with each connectivity type in a dashboard. 

Dynamic Visibility and the power of the Canvas : Building a navigation template for your dashboard 

The canvas container has received some negative press in the past.  Performance issues led to a generally accepted avoidance of this component in dashboards. However, since SAP Dashboards 4.0 these issues have been fixed, and there are many benefits to using it.  In this session we will review when to use grouped objects versus canvas containers, and showcase some of the power the canvas can bring to your project.  At the end of the session you will have built a fully functioning navigation template for a dashboarding project. 

Working with data: Best practice and options for moving data around your dashboard 

Whether you are using live data or static / offline data, chances are you need to move information around your excel model depending on selections the user has made.  There are many different native and 3rd party ways to handle data movement, in this session we will go through the various options, look at the pros and cons of each approach and put them into practice in a in a functioning dashboard. 

Are you a dashboard superhero? Put your powers to the test with this data visualization challenge 

This mid-week session is a chance to put your dashboard powers to the test.  We will provide a detailed scenario along with data sets and a partially complete dashboard.  All you have to do is finish the dashboard for a chance for you to show off what you can do.  We will review the various results and will be awarding prizes for the most inventive and ground breaking dashboards

Take it everywhere: Taking your dashboard mobile with and without SAP BI Mobile 

There are many things to consider when deploying your dashboard for mobile devices, we will review these key topics, and get hands on with various options for taking your dashboard mobile. 

Bring your own iPad to interact with the mobile optimised dashboard that you will develop during this session. 

More than meets the eye: Using tips and tricks to build unique visualizations and infographics 

Learn how to use native components to create unique visualizations, from infographics to animations.  We will take a look under the hood at the Xcelsius games (built by UK Labs and showcased at past IBIS events) and then create your own mini game.  This session is designed to challenge the way you think about components and their use.  Building games may not be useful in the workplace but the ‘out of the box’ thinking gained in this hands-on session is invaluable. 

User Testing: Xcelsius best practices and dashboard testing techniques 

User adoption is key, but how do you know if the intended audience will embrace your new dashboard? This session focuses on user testing techniques and best practices for dashboard development. 

You will experience dashboard testing from an end users point of view and learn how to conduct these sessions with your own users. We will also cover, and put into practice, some of the techniques for developing easily supportable dashboards. Ensuring that the dashboards you build in the future can be maintained by you or someone else with ease. 

Course Overview: Data Services Hands-On Boot Camp

Data Services Boot Camp – Day 1 

Course Description: 

In this two-day, hands-on training course, you will see how Data Services can play a key role in data integration and data transformation for your organization. At the end of this course, you will be hard pressed to find a challenge Data Services cannot meet! On Day 1 of this course, you will learn the fundamental concepts behind Data Services and the modelling essentials to cement your core knowledge of the tool. After Day 1, you will have the essential skills to tackle most requirements with Data Services. 

Intended Audience: 

This course is open to anyone. 

Prerequisites: 

None but understanding of Data Extraction, Transformation and Loading concepts useful. 

Major Topics Include: 

  • Data Services Designer familiarization 
  • Understanding the Data Services objects and how they fit together (e.g. Projects, Jobs, Work Flows and Data Flows) 
  • Source and target types for dataflows including Datastores and Flat files 
  • Understanding and putting to use all key transformations Data Services offers 
  • Understanding how to validate and debug your Data Services jobs 
  • Understanding the use of Functions, Scripts and Variables 
  • Job failures and error handlingPage Break 

Data Services Boot Camp – Day 2 

Course Description: 

In this two-day, hands-on training course, you will see how Data Services can play a key role in data integration and data transformation for your organization. At the end of this course, you will be hard pressed to find a challenge Data Services cannot meet! On Day 2 of this course, you will apply the learnings from Day 1 to real-world situations and challenges. After Day 2, you will now have the confidence to tackle any data challenge your organization faces with Data Services. 

Intended Audience: 

This course is open to anyone. 

Prerequisites: 

None but understanding of Data Extraction, Transformation and Loading concepts useful. 

Major Topics Include: 

  • Lifecycle Management 
  • Data Profiling 
  • Data Warehousing best practices 
  • Job Scheduling, job dependencies and monitoring.  
  • Optimization best practices 

 

9:00am - 5:00pm
Course Overview - InfoBurst Certified Expert (ICE)

Course Overview  

InfoBurst Certified Expert (ICE) ICE is a hands-on training course to both further your knowledge of the InfoBurst solution and to be recognized as a certified expert in using the solution. The course is hands-on immersion-style training designed to bring you to an advanced level of expertise quickly and effectively. At the end of this course, participants will be certified in advanced InfoBurst administration. Intended  

Audience 

InfoBurst users who wish to become certified in utilizing InfoBurst for report bursting, publishing, and delivery.  

Prerequisites:  

You should have a basic understanding of SQL and relevant reporting platforms.  

Major Topics include:  

  • Product history and Wiki information  
  • User interface overview  
  • Cataloging Documents  
  • Managing objects  
  • Object Management  
  • Data Sources  
  • Report Bursting  
  • Parameter Aliases  
  • Document Source  
  • Basic Report Publishing and Delivery  
  • Delivery  
  • Publishing Formats  
  • Destination  
  • Publishing  
  • Advanced Bursting, Publishing, and Delivery  
  • Delivery Templates and Mixed Inline Content  
  • Content Grouping 
9:00am - 5:00pm
Course Overview - BI 4.2 Core Administration Boot Camp

Course Description: 

This two-day hands on post seminar course will cover the core features and functionality of BusinessObjects BI 4.1 and BI 4.2 that are essential to keep your BO system running smoothly. This course covers how to set up and manage security with key functions in the CMC in addition to Life Cycle Management (LCM) tools (Promotion Management, Version Management), customizing the Launchpad (previously known as InfoView), Monitoring, Auditing, Multitenancy, splitting the Adaptive Process Service (APS), and more. This training will also include information on Monitoring, troubleshooting and Maintenance along with recommendations on best practices. 

Intended Audience: 

BusinessObjects Administrators 

Prerequisites: 

A minimum of one-year experience in working knowledge of Business Objects Administration XIR2 or 3.x releases including the use of the CMC with basic knowledge of servers, security and networking required for functioning of BO application and tools. 

Major Topics Include: 

  • What’s new in BI 4.1 and 4.2 
  • Upgrade Management Tool 
  • System Configuration wizard 
  • Splitting APS 
  • Life Cycle Management, System Management 
  • Promotion Management 
  • Version Management 
  • Visual Difference 
  • Auditing 
  • Monitoring & Probes 
  • Administrator Cockpit 
  • Recycle Bin 
  • Platform tools 
  • Client Tools 
  • Launch Pad 
  • BI Mobile 
  • OLAP Connection and Analysis 
  • Security and Access Control 
  • Cryptographic Keys 
  • User Attribute Mapping 
  • Multitenancy 
  • Walkthrough 
  • Troubleshooting 
9:00am - 5:00pm
Course Overview - SAP BO Dashboards Hands-On

Intended Audience: 

This course is open to anyone interested in furthering their knowledge and expertise with data visualization, as well as with expanding their capabilities with SAP BO Dashboards (Xcelsius). 

Prerequisites: 

Experience with SAP BO Dashboards (Xcelsius); or have completed the SAP BO Dashboards for Beginners pre-con course. 

Information Design Workshop: From Concept to Visualization 

Successful dashboards all have one thing in common, they allow the end user to find or see the information they are looking for easily. The science/art of preparing information to be used by human beings with efficiency is known as information design. 

In this workshop we will employ methods and techniques used to evolve an idea and turn it into a data visualization, exploring each of the key attributes for effectively communicating information. 

Consistency is Key: Design guides and company design languages 

The tastes and trends of web applications are continually evolving, as are the processes companies such as Google, Apple, Twitter etc. use to ensure consistency across their products.  In this session we will look at the role of design guides and design languages in web development and how they can be applied to your BI projects. 

We will get hands on with Xcelsius and use native as well as 3rd party components to achieve a “modern design language” appearance to a dashboard. 

Bringing your dashboard to life: Taking your model live with connected data (Query Browser vs. BIWS vs. XDC vs. CSV connector) 

There are various ways to inject live or connected data into your dashboard, whether you want to use SAP Business Objects, InfoBurst XDC, database queries or even CSV files.  We will go through and have a look at each of these methods, discuss pros and cons for each approach and then get hands on with each connectivity type in a dashboard. 

Dynamic Visibility and the power of the Canvas : Building a navigation template for your dashboard 

The canvas container has received some negative press in the past.  Performance issues led to a generally accepted avoidance of this component in dashboards. However, since SAP Dashboards 4.0 these issues have been fixed, and there are many benefits to using it.  In this session we will review when to use grouped objects versus canvas containers, and showcase some of the power the canvas can bring to your project.  At the end of the session you will have built a fully functioning navigation template for a dashboarding project. 

Working with data: Best practice and options for moving data around your dashboard 

Whether you are using live data or static / offline data, chances are you need to move information around your excel model depending on selections the user has made.  There are many different native and 3rd party ways to handle data movement, in this session we will go through the various options, look at the pros and cons of each approach and put them into practice in a in a functioning dashboard. 

Are you a dashboard superhero? Put your powers to the test with this data visualization challenge 

This mid-week session is a chance to put your dashboard powers to the test.  We will provide a detailed scenario along with data sets and a partially complete dashboard.  All you have to do is finish the dashboard for a chance for you to show off what you can do.  We will review the various results and will be awarding prizes for the most inventive and ground breaking dashboards

Take it everywhere: Taking your dashboard mobile with and without SAP BI Mobile 

There are many things to consider when deploying your dashboard for mobile devices, we will review these key topics, and get hands on with various options for taking your dashboard mobile. 

Bring your own iPad to interact with the mobile optimised dashboard that you will develop during this session. 

More than meets the eye: Using tips and tricks to build unique visualizations and infographics 

Learn how to use native components to create unique visualizations, from infographics to animations.  We will take a look under the hood at the Xcelsius games (built by UK Labs and showcased at past IBIS events) and then create your own mini game.  This session is designed to challenge the way you think about components and their use.  Building games may not be useful in the workplace but the ‘out of the box’ thinking gained in this hands-on session is invaluable. 

User Testing: Xcelsius best practices and dashboard testing techniques 

User adoption is key, but how do you know if the intended audience will embrace your new dashboard? This session focuses on user testing techniques and best practices for dashboard development. 

You will experience dashboard testing from an end users point of view and learn how to conduct these sessions with your own users. We will also cover, and put into practice, some of the techniques for developing easily supportable dashboards. Ensuring that the dashboards you build in the future can be maintained by you or someone else with ease. 

Course Overview - Data Services Hands-On Boot Camp

Data Services Boot Camp – Day 1 

Course Description: 

In this two-day, hands-on training course, you will see how Data Services can play a key role in data integration and data transformation for your organization. At the end of this course, you will be hard pressed to find a challenge Data Services cannot meet! On Day 1 of this course, you will learn the fundamental concepts behind Data Services and the modelling essentials to cement your core knowledge of the tool. After Day 1, you will have the essential skills to tackle most requirements with Data Services. 

Intended Audience: 

This course is open to anyone. 

Prerequisites: 

None but understanding of Data Extraction, Transformation and Loading concepts useful. 

Major Topics Include: 

  • Data Services Designer familiarization 
  • Understanding the Data Services objects and how they fit together (e.g. Projects, Jobs, Work Flows and Data Flows) 
  • Source and target types for dataflows including Datastores and Flat files 
  • Understanding and putting to use all key transformations Data Services offers 
  • Understanding how to validate and debug your Data Services jobs 
  • Understanding the use of Functions, Scripts and Variables 
  • Job failures and error handlingPage Break 

Data Services Boot Camp – Day 2 

Course Description: 

In this two-day, hands-on training course, you will see how Data Services can play a key role in data integration and data transformation for your organization. At the end of this course, you will be hard pressed to find a challenge Data Services cannot meet! On Day 2 of this course, you will apply the learnings from Day 1 to real-world situations and challenges. After Day 2, you will now have the confidence to tackle any data challenge your organization faces with Data Services. 

Intended Audience: 

This course is open to anyone. 

Prerequisites: 

None but understanding of Data Extraction, Transformation and Loading concepts useful. 

Major Topics Include: 

  • Lifecycle Management 
  • Data Profiling 
  • Data Warehousing best practices 
  • Job Scheduling, job dependencies and monitoring.  
  • Optimization best practices