Midwest Virtual BusinessObjects User Group – Thursday, September 17th, 2020 @ 1:00pm CT

You and your colleagues are personally invited to join us at the Midwest Virtual BusinessObjects User Group meeting Thursday, September 17th, 2020 running from 1:00pm to 4:30pm CT.

Attendance is FREE, however, you will need to register to get access to the virtual user group.

1:00 – 1:05 pm CT | Welcome & Announcements

1:05 – 1:35 pm CT | BusinessObjects for a New Decade – Paul Grill, InfoSol Inc

We have just started a new decade and already the world is dramatically different to anything we have seen or experienced before.

The COVID-19 pandemic has clearly shown the importance of data and business intelligence and, with an inevitable global financial recession and recovery, BI will be even more significant.

BusinessObjects remains the most widely used BI suite in the world today and will continue to play a large role in the foreseeable future of BI. A brand-new version, BI 4.3, is just being released and this will become the BusinessObjects standard of this new decade. There is a lot to be excited about with this new version but, then, there has always been a lot to celebrate with BusinessObjects.

Paul Grill, CEO of InfoSol, will present his optimistic, and always entertaining, view of where he sees BusinessObjects heading in this new decade.

1:35 – 2:05 pm CT | Moving on from Xcelsius with Squirrel365 – John Z and Roxanne Pittman, InfoSol Inc

Learn how to convert existing Xcelsius dashboards using Squirrel365 from simple to complex. We will show conversion examples and the steps to make the Squirrel version ‘walk & talk’ like the original Xcelsius Dashboard. We will also discuss tips and tricks to show workarounds for possible encountered conversion issues.

2:05 – 2:15 pm CT | Break

2:15 – 2:45 pm CT | Magic of Breaks: Part 1 – Michael Ward, CTTS

This presentation will provide an in depth look at the Break Function.  Learn how to apply a single break as well as multiple breaks to a report block.    Learn how to manage breaks to control display of headings and footings.  Learn how to apply a value-based break. Learn how to control page breaks through the break function.  See how calculations are applied when adding breaks to a report.  Learn how to control calculations when applied to a break.

2:45 – 3:15 pm CT | Building Calculations in Webi – Michael Ward, CTTS

This presentation will provide a look at how to create a variety of calculations from simple arithmetic to complex If Then Else expressions utilizing the Inlist function.  It will include creating formulas, variables and how to convert a formula to a variable. It will include a variety of examples of how to utilize the function library of pre-built in functions.  Presentation includes examples of creating universe-based objects instead of a report based calculations, and the many advantages it provides.  It will also include best practices when building calculations.

3:15 – 3:25 pm CT| Break

3:25 – 3:55 pm CT| Creating Webi Dashboards that Blow Your Socks off! – Roxanne Pittman, InfoSol Inc

Taking inspiration from the 2020 Most Valuable Dashboard award winning dashboard, we will show some amazing techniques to creating dashboards in Web Intelligence.  This session will cover out the box Webi features as well as some third-party add-on components to make stunning visual dashboards.

3:55 – 4:25 pm CT| Power Of Excel Files In Webi – Michael Ward, CTTS

This presentation will provide the user with a variety of ways Excel files can be used in reporting. It will include using Excel as a data provider, using Excel for a bridge file when encountering incompatible format types, as a dynamic filer file, and other uses.  It will include an in-depth look at how to properly import an Excel files, where to store the Excel file, and how to update an Excel file without breaking the Webi Document.  It will include some nice tips and techniques when using Excel files. It will open your eyes to the real power of an Excel file.

4:25 – 4:30 pm CT| Raffle

Better BI, SAP 4.3 Preview and Simpler Migration with Red Olive and InfoSol – Virtual Event – April 23rd

With SAP 4.3 on the horizon, join us for a virtual event and find out what the latest developments will be with Red Olive, SAP and InfoSol. Learn about smarter reporting tools, better Business Intelligence and enhanced migration and integration, which will help you increase productivity.

Whether you are an existing user or just curious about the new features in SAP 4.3, take this opportunity to see a live demo of the latest improvements planned in BI 4.3 in our virtual event. 

April 23rd at 3pm BST/7am PT/10 am ET

Register here

Agenda:

3:00 – 3:20 pm | Smarter and Faster Migration – David Searro, Red Olive

With SAP 4.3 on the horizon, many businesses are already considering how and when they will move to the next version, but this is not without its issues. Migrating can take a huge amount of time and there can be many difficulties along the way that can be challenging to an organisation. Red Olive has developed a rapid migration approach, to speed up the migration and make it relatively pain-free.

3:20 – 3:50 pm | Maximising Your BusinessObjects Investment – Customer Case Study – Paul Grill, Infosol and Hazel Rasion, Lead SAP engineer, Hermes

While BusinessObjects remains the most widely used Business Intelligence suite in the world, organisations using it are not always maximising its potential in terms of getting its valuable content into the hands of the right people. This fascinating session will show how Hermes is pushing its BusinessObjects content to the masses and getting a great return on value in the process.

3:50 – 4:20 pm | Discover SAP BusinessObjects BI 4.3 – Grégory Botticchio, SAP

Learn about the content of the next SAP BusinessObjects release. Whether you are an existing Web Intelligence user or just curious about the many possibilities of the most popular Enterprise reporting platform on the market, take this opportunity to see a live demo of the new features and improvements planned in BusinessObjects 4.3.

4:20 – 4:30 pm | Q & A

Tucson BusinessObjects User Group – March 12th, 2020

You and your colleagues are invited to join us at the next information packed Tucson BusinessObjects User Group meeting taking place on Thursday, March 12th from 12:30pm to 4:15pm.

Attendance is FREE but please register below for count purposes.

Location:

Pima Community College Northwest Campus

7600 N Shannon Rd

Tucson, AZ 85709

This is about 10 min east from I-10.

Pima Maps link: https://pima.edu/maps-directions/index.html

Room:

Room Number A207 (community room)

Agenda:

12:30 – 1:00 pm | Registration

1:00 – 1:10 pm | Welcome & Announcements

1:10- 1:55 pm | Why using IDT is a good idea? – Minith Patel, InfoSol Inc

This presentation will cover all of the new features of IDT that make it a far better tool than the old universe designer. In this session you will learn what is new, why it’s good, and how it makes using IDT easy. This will be a fast passed session so make sure you hold on to your pencil and note book!

2:00- 2:30 pm | BO Administration Security Model Options – Minith Patel, InfoSol Inc

Security is unique to each organizations needs. Hence in this session, we will show you a couple of security models used by organizations and share the basics of how to build your own security with the options provided by BusinessObjects.

2:30- 2:45 pm | Break & Networking

2:45- 3:30 pm | The New Look of Web Intelligence 4.3 – Minith Patel, InfoSol Inc

A major new release of BusinessObjects, 4.3, is due to be released mid-year and with it will come a completely new interface for Web Intelligence. This session will show e sneak preview of the new Webi UI showing how it looks, how to browse and navigate in it and how to edit reports.

3:30- 4:00 pm | Open Discussion: BusinessObjects for a New Decade – Paul Grill, InfoSol Inc

A major new release of BusinessObjects will be available in 2020 that will become the BusinessObjects release of this new decade. Knowing that BusinessObjects will be around and supported for the next 10 years, this discussion will focus on how your organizations are planning to use it and evolve with it over the next decade

4:00 – 4:15 pm | Raffle & Prizes

Tucson BusinessObjects User Group – September 12th 2019

Location:

Tucson Police Department

1310 W. Miracle Mile

Tucson, AZ  85705

Room: Rillito Meeting Room

Agenda:

12:30 – 1:00 pm | Check-In

1:00 – 1:10 pm | Welcome & Announcements

1:10- 1:45 pm | Building Web Intelligence Dashboards – Part 1 – Roxanne Pittman, InfoSol Inc

In this session we will create a Webi Dashboard use the 80/20 rule to  focus attention on the top performers and also incorporate Trend charts with shared elements.

1:45- 2:20 pm | Using Excel Files In Web Intelligence – Michael Ward, CTTS

This presentation will provide the user with a variety of ways Excel files can be used in reporting. It will include using Excel as a data provider, using Excel for a bridge file when encountering incompatible format types, as a dynamic filer file, and other uses.  IT will include an in-depth look at how to properly import an Excel files, where to store the Excel file, and how to update an Excel file without breaking the Webi Document.  It will include some nice tips and techniques when using Excel files. It will open your eyes to the real power of an Excel file.

2:20- 2:35 pm | Leveraging formulas in WebI – Ozlem Kacira, Pima Community College

We will show how complex formulas have been implemented in the reports to compare different snapshot data rather than using nested or subqueries. Also we will show how to add scrolling html marquee to make more attractive dashboards.

2:35- 2:50 pm | Break & Networking

Enjoy some delicious snacks and drinks.

2:50- 3:25 pm | Building Web Intelligence Dashboards – Part 2 – Roxanne Pittman, InfoSol Inc

This session will demonstrate how to add conditional formatting to a chart and use a dual slider to view data more precisely.  We will also show how to display key data points on chart – showing beginning, low, high and ending points for quick analysis.

3:25- 4:00 pm | IDT Overview – Michael Ward, CTTS

A high level look at building universes with the new IDT. Learn about creating connections, building the data foundation layer,  adding a business layer, and applying security profiles. Also learn about creating LOV’s and combining those with Parameters. Defining Context,  adding aggregate awareness, and sharing project will also be covered.

4:00 – 4:15 pm | Raffle & Prizes

Data Services 4 Beginner-Intermediate Boot Camp

Back to Data Services Training

Price: $395 per student, per day
Duration: 3 Days

Who is this course intended for?

This boot camp is intended for ETL designers who wish to learn the SAP BusinessObjects Data Services toolset.

What will I learn?

This hands-on workshop will provide a guided approach to understanding and building ETL projects using SAP BusinessObjects Data Services.  This will cover all the core functionalities of traditional Data Integrator and Data Services including using types of objects, transforms, functions and more.

What should I know?

You should have basic concepts of ETL and a good understanding of database design and SQL.

Course Agenda

Day 1 – Beginner Concepts

  •  Introduction, role of ETL
  • Core Functionality – Architecture, Objects, hierarchy
  • Building Projects, ETL jobs, Datastore, Workflow, Dataflow, Flat Files
  • Using core transforms: Query, Case, SQL, Validation, Merge
  • Using Functions, Scripts, Variables
  • Concepts of Change Data Capture and implementing with Data Services transforms: Table Comparison, History Preservation, Key Generation.

Day 2 – Beginner Concepts Continued

  • Using Table Comparison, History Preservation, Key Generation, Mapping Operation.
  • Using Pivot and Reverse Pivot Transform

Day 3 –Intermediate Concepts

  • Data Profiling
  • Text Data Processing
  • Address Cleansing
  • Quick look at Information Steward (time permitting)

Information Design Tool (IDT) Beginner-Intermediate Boot Camp

 

Price: $395 per student, per day

Duration: 2 Days

Available Dates: 

[ESPRESSO_TABLE category_identifier=”idtironchef” order_by=id show_expired=”false”]

Who is this course intended for?

Specialists responsible for the design and development of SAP BusinessObjects universes in BI 4.

What will I learn?

This boot camp is designed to provide the universe designer with a solid understanding of the design concepts, workflow and development cycle of building a universe in SAP BusinessObjects Information Design Tool 4.1.

Participants will follow the process of designing the universe, creating a data foundation, creating business layers, testing during different stages of the development cycle and migrating a universe into production. Features such cascading prompts, calculated columns and shared projects will be covered.

Additionally we will use Data Federator to test performance on universes with multiple data sources as well as maximizing query performance and explore useful features of this tool.

Developing Amazing Dashboards with InfoBurst XDC

Back to InfoBurst Training or Back to Dashboards/Xcelsius Training

Price: Contact below for quote

Duration: 2 Days

View Course Availability

Who is this course intended for?

This hands on boot-camp is intended for Dashboard Designers wanting to know how to develop dashboards with fast and flexible access to large amounts of external data.

What will I learn?

In this hands-on boot-camp, you will learn the features of InfoBurst XDC and the mechanism to build end-to-end dashboards powered by live data via InfoBurst.

All aspects of developing connected dashboard solutions will be covered, including best practices, accessing data, performance considerations and delivery of the final solution. Upon completion of this boot camp, you will be able to create connected dashboards using Dashboard Designer and InfoBurst XDC.

What should I know?

We would suggest a minimum of 4-6 months experience with Xcelsius or Dashboard Designer

Course Agenda
Day 1

Dashboard Connectivity

  • Overview of Connected Dashboards
  • Options for data connectivity
  • Common Connectivity issues

XDC Introduction

  • Introduction to InfoBurst XDC
  • Overview of InfoBurst Connectors
  • Adding Connectors to Xcelsius

Preparing Data

  • Connected Dashboards – Where to Start
  • Understanding the Data
  • Data vs. Design
Day 2

Using XDC

  • IBE Connection Manager
  • Caches vs. Cache Queries
  • Alternative data sources

Advanced XDC functions

  • Database Writeback
  • Save as Excel
  • Bursting Dashboards

Troubleshooting

  • Best Practices
  • Troubleshooting guides
Available Dates: 

InfoBurst Certified Expert for Xcelsius (ICE-X) Training

Back to InfoBurst Training

Price: $395 per student, per day

Duration: 2 Days

Available Dates: 

For caching technology training using InfoBurst, please contact InfoSol to discuss your needs.

Who is this course intended for?

Dashboard designers who wish to become certified in utilizing InfoBurst’s caching technology as part of their dashboarding solution.

What will I learn?

At the end of this course, participants will be certified in using the InfoBurst Enterprise platform in conjunction with the InfoSol Data Connectors to implement Xcelsius dashboarding solutions

What should I know?

You should have a basic understanding of SQL and knowledge of dashboard design (Xcelsius or Dashboard Designer). Previous experience navigating in InfoBurst is helpful but not required.

Course Agenda
Day 1

Introduction

  • Agenda
  • Course overview
  • Product history and support information
  • XDC and InfoSol connectors

Module 1

  • SQL Query as a Data Source
  • Hands-on workshop

Module 2

  • Webi and Excel as Data Sources
  • Hands-on workshop

Module 3

  • Cache Query
  • Best practices for dashboards
  • Hands-on workshop

Module 4

  • Advanced Cache Query
  • Hands-on workshop
Day 2

Module 5

  • Dashboard Bursting
  • Hands-on workshop

Module 6

  • Real-time Query and Database Writeback
  • Hands-on workshop

Module 7

  • Dashboard Security
  • Hands-on workshop

Certification Exam

  • 40 Questions to test participant knowledge of course materials

InfoBurst Certified Expert for Administrators (ICE-A) Training

Back to InfoBurst Training

Price: Contact below for quote

Duration: 1 Day

View Course Availability

Who is this course intended for?

InfoBurst administrators who wish to become certified in advanced administrative aspects of the InfoBurst platform

What will I learn?

At the end of this course, participants will be certified in advanced InfoBurst administration.

What should I know?

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)
  • Knowledge of DBMS and Windows server concepts
Course Agenda
Day 1

Introduction

  • Agenda
  • Course overview
  • Product history and information
  • Platform and installation requirements

Installation

  • Exercise 1 – Installing IBE Software
  • Repository configuration
  • Exercise 2 – Licensing
  • Exercise 3 – Software Updates

User and Group Management

  • User interface
  • Exercise 4 – Users & Groups

System Configuration

  • Platform configurations
  • Exercise 5 – Configuring a Platform
  • Exercise 6 – Provider Logons
  • Exercise 7 – Network & Printer Registration
  • Exercise 8 – Email Configuration

Document Management and Security

  • Exercise 9 – Adding a Document
  • Document management overview
  • Exercise 10 – Managing Documents
  • Exercise 11 – Folder Security

Using InfoBurst

  • Exercise 12 – Basic Burst
  • Exercise 13 – Data Source
  • Exercise 14 – Advanced Burst
  • Exercise 15 – Burst Failure & Alert
  • Abort alert options

Other Aspects of InfoBurst Administration

  • Exercise 16 – Support Package
  • Logging
  • Troubleshooting
  • Troubleshooting exercises
  • Support System usage
  • Repository and application
Available Dates: 

InfoBurst Certified Expert (ICE) Training

Back to InfoBurst Training

Price: $495 per student, per day

Duration: 2 Days

View Schedule Availability

Who is this course intended for?

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

What will I learn?

At the end of this course, participants will be certified in advanced InfoBurst administration.

What should I know?

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

Course Agenda

Introduction

  • Agenda
  • Course overview
  • Product history and Wiki information
  • User interface overview

Object Management

  • Managing objects
  • Exercise 1 – Cataloging Documents

Data Sources

  • Exercise 2 – Data Sources

Report Bursting

  • Exercise 3 – Multi-Pass Burst
  • Exercise 4 – Single-Pass Burst
  • Parameter Aliases
  • Exercise 5 – Document Source

Basic Report Publishing and Delivery

  • Delivery
  • Publishing Formats
  • Destination
  • Exercise 6 – Publishing

Advanced Bursting, Publishing, and Delivery

  • Exercise 7 – Delivery Templates and Mixed Inline Content
  • Exercise 8 – Content Grouping

Wrap-Up

  • Questions
Available Dates: