<< Go to Upcoming Classes Page

Reporting Essentials using App Studio – Part 2

August 20th, 2018  |  2 days  |   Online   EST   |  Closed

Course Number:  502

Release 8.2.01M

Expand your knowledge beyond what you have learned in the Reporting Essentials – Part 1 course.  Using App Studio, this class will explore additional concepts and techniques for creating insightful application content through advanced filtering, constructing effective virtual columns, and producing sophisticated reports.

You will learn how to:

  • Employ advanced filtering techniques
  • Control complex expressions for virtual columns
  • Simplify your calculations with prefix operators
  • Format numeric-oriented reports easily with cumulative totals, section headings and totals
  • Enhance content by accessing multiple data sources
  • Provide reporting flexibility for users with variables
  • Enable investigative analysis from summary to detail with drill-downs
  • Explore extract file techniques, such as creating HOLD files, or SQL Subqueries


Building InfoApps Using App Studio

August 22nd, 2018  |  2 days  |   Online   EST   |  Closed

Course Number:  521

Release 8.2.01m

This course will show you how to build a professional user interface for your InfoApps application. Using App Studio’s HTML canvas tool, you will build a cohesive and efficient series of user interfaces for existing reports and charts that range from non-parameterized procedures to heavily parameterized self service procedures.

You will learn how to:

  • Lay out content and modify their attributes
  • Create a custom template for a consistent look-and-feel
  • Have the web page reference external and embedded procedures
  • Populate controls statically and dynamically when the web page loads
  • Use HTML canvas graphical tools to show and hide objects on the web page
  • Dynamically populate calendar controls and limit their range choices
  • Add your own customizations with CSS and JavaScript

Self-service Analytics with InfoAssist+ Basic Techniques

August 22nd, 2018  |  1 day  |   Online   MST   |  Enrollment Closed

Course Number:  390

Release 8.2.x

This course will show you how to use Information Builders’ InfoAssist+, an enterprise-grade analytics tool connected to the WebFOCUS BI and analytics platform, for governed self-service reporting, analysis, and data discovery. It will also introduce you to the WebFOCUS BI infrastructure and background information necessary to use InfoAssist+ effectively.

You will learn how to:
• Report from simple and dimension-enabled metadata
• Create static and interactive tabular reports
• Display detailed and aggregate information from one or more data sources
• Declare your own virtual fields, based on alphanumeric, numeric, and date formats
• Control which data rows are to be included in a variety of output display formats
• Build charts and maps from a wide selection of available templates
• Use InfoAssist+ built-in features to easily create data discovery type of displays
• Combine multiple tabular reports and charts into one document

Developing Responsive Applications with App Studio

August 30th, 2018  |  1 day  |   Online   EST   |  Enrollment Closed

Course Number:  523

Release: 8.2.01

This App Studio course will show you how to build user-based solutions, concentrating on layout, design, and responsive behavior. In this course, you will use App Studio’s HTML Canvas to build context-aware html components that can be viewed on devices of varying screen sizes. In this course, you will discuss design considerations for responsive web applications.


You will learn how to:

  • Create responsive html documents using App Studio’s responsive design templates
  • Create responsive html document dashboards using App Studio’s report component
  • Convert existing static html document dashboards into responsive html document dashboards
  • Leverage external script libraries in App Studio to create responsive contents
  • Add responsive html documents to the WebFOCUS Portal

Reporting Beyond Essentials using App Studio

August 30th, 2018  |  2 days  |   Online   EST   |  Enrollment Closed

Course Number:  504

Release 8.2.02
Expand your knowledge beyond what you have learned in the Reporting Essentials – Part 2 course. Using App Studio, this class will explore additional concepts and techniques for turning your existing procedures into effective, sophisticated application content. Gain insight for managing your resources efficiently.

You will learn how to:

• Utilize content stored in the Data Servers environment node
• Add visual impact to your reports
• Build multi-page documents
• Create active dashboards
• Merge data sources
• Apply reporting techniques for specialized output
• Employ advanced joining techniques
• Explore new partition functions

iWay DataMigrator Essentials Advanced Techniques

September 10th, 2018  |  2 days  |   Online   EST   |  Closed

Course Number:  976

Release 7.7.07

The iWay DataMigrator Advanced Techniques course is designed as an advanced course to teach the student iWay DataMigrator advanced concepts, and to provide the knowledge and skills to build complex applications to Extract, Transform, and Load data targets. The student will learn how to take existing data and process flows and push them into production, build a star schema data warehouse, build complex load routines, and load the data into a target using Change Data Capture techniques.

The iWay DataMigrator Self-Study course serves as a prerequisite for the iWay DataMigrator Advanced  Techniques course to further manage and monitor your deployed applications.  The iWay DataMigrator Advanced Techniques course is an instructor led two-day curriculum.  A PDF copy of the course manual is included for your reference.

You will learn how to:

  • Push an application into production
  • Understand and build a star schema data warehouse
  • Use the various Data Load Operating Modes
  • Build complex load routines – advanced techniques
  • Create a data flow using a File Listener
  • Consume a REST Service
  • Utilize Change Data Capture
  • Debug a data/process flow

Self-Service Analytics with InfoAssist+ Advanced Techniques

September 11th, 2018  |  2 days  |   Online   EST   |  Closed

Course Number:  391

Release 8.2.x

This course goes beyond the basics to show you how to use Information Builders’ InfoAssist+ for governed self-service reporting, analysis, and data discovery. Besides point-and-click methodologies, it also covers techniques and best practices to gain more insights about your data.

You will learn how to:

  • Use Boolean logic and filter for aggregated data values
  • Specify parameters for dynamic filters, measures, and dimensions
  • Automatically link procedures to display additional related information
  • Set up customized links to procedures that dig deeper into your data
  • Build free-form reports
  • Retrieve unmatched data
  • Cache data for further processing
  • Rank values with an “all others” category
  • Customize charts and animate them over a given time span
  • Create an active display where multiple charts are interconnected
  • Generate reporting and charting templates

Server Administration

September 17th, 2018  |  2 days  |   Online   EST   |  Closed

Course Number:  96182

Release 8.2.02

This Server Administration course will show you how to configure an adapter server, techniques for balancing performance and resource utilization using the Server Web Console, debugging and diagnostic tips and techniques, and how to control your server environment on a daily basis.  You will also learn to implement security models to protect and manage privileges based on user role.

You will learn how to:

  • Visually and conceptually understand the iWay server architecture
  • Navigate the Web Console
  • Customize the Web Console appearance including different languages
  • Configure an adapter server
  • Manage adapter server operations on a daily basis
  • Configure a data source and set up metadata for an adapter server
  • Create user and service profiles and how to use them
  • Understand role of different configuration files
  • Troubleshoot and solve problems
  • Tune your adapter server for efficient performance
  • Analyze and trace (log) server activity
  • Secure the reporting server Web Console and manage privileges

You will also review:

  • Adding and configuring a remote server
  • Adding a server node using the WebFOCUS Client
  • Creating custom monitor page

Master Data Management with Omni-Gen

September 18th, 2018  |  2 days  |   Atlanta   EST   |  Enroll

Course Number:  800

Release 3

Master Data Management with Omni-Gen is a two-day instructor-led course taking the student through all phases of Master Data Management with detailed emphasis on the core steps of Master Data Management using Omni Designer, i.e. modeling, cleansing, matching, merging, and remediating source data to produce master records.

The foundational concepts, roles and processing steps of Master Data Management & Governance are introduced, and the iWay products (Omni Designer, Data Quality Server & Omni Governance Console) are mapped to functions.

The hands-on sessions begin with the student taking a source data from independent data sources, conducting inspection through profiling, developing the master model, populating the model, mastering the data using cleansing, matching, merging services and defining remediation.  Basic methods are discussed along with best practices, common pitfalls and alternative approaches.

The workshop finishes with the integration of the data model with Omni Governance Console for review and remediation.  This provides an initial understanding of the Master Data Management & Governance system using Omni-Gen Master Data Management Edition.

In this workshop the student will learn how to:

  • Develop a logical data model using Omni Designer for both instance and master data;
  • Instantiate and load the physical data model using the Omni Designer generated Omni-Gen Server;
  • Implement cleansing, matching, merging, and remediation plans within Omni Designer and generate Data Quality Server components;
  • Customize cleansing, matching, merging, and remediation components within Data Quality Server;
  • Add scoring and remediation logic to the appropriate components for later remediation of instance data;
  • Reload instance data employing the now customized DQS components and create cleansed and matched instance data along with merged golden records and data for remediation.
  • Employ Omni Governance Console to review (360 Viewer) and remediate (Remediation) instance and master data.

Security Administration

September 19th, 2018  |  1 day  |   Online   EST   |  Closed

Course Number:  36182

Release 8.2.x

How can you give users access to the information they require while protecting sensitive or confidential data? Build an effective security policy. The database-driven security infrastructure in WebFOCUS 8 allows administrators within your organization to develop and implement very granular security requirements for your WebFOCUS applications.

You will learn how to:

  • Create content infrastructures
  • Create and manage users, groups, roles and privileges
  • Establish rules for access to different content resources
  • Understand Resource Templates and how to use them
  • Tailor the security model to meet specific requirements
  • Establish and understand security for a WebFOCUS BI Portal
  • Interpret effective policy for each resource
  • Understand concepts such as sharing, ownership, and publishing
  • Manage private vs. publish content
  • Use utilities to troubleshoot and manage the security model
  • Access and interpret audit logs

iWay DQS Golden Record and Advanced Techniques

September 20th, 2018  |  2 days  |   Atlanta   EST   |  Enroll

Course Number:  981

Release 10.x

The iWay Data Quality Server Golden Record and Advanced Techniques is designed as an advanced course to teach the student iWay Data Quality Match and Merge concepts and to provide the knowledge and skills to Standardizing Addresses  using Loqate, Online Services and Integration with iWay Service Manager.  The student will learn how to design DQS Plans to facilitate the matching and merging of information between applications and systems.  This course will demonstrate skills on how to use Matching Measures and Matching Rules to zero in on matched records more precisely.  The student will learn how to pass transactions from an iWay Service Manager Application to a called DQS plan to cleanse data before moving the transaction on to the next phase of processing. This course is a 2-day instructor led training session.


You will learn how to:

  • Review the One Day DQS Self Study Course
  • Understanding DQS Online Services
  • Introduction to Extended Unification (Match)
  • Build the Extended Unification Plan using SimpleKey and Union Strategies
  • Build the Union Strategy using Matching Rules and Measures
  • Understanding the Merge (Representative Creator) Step
  • DQS Repository Setup
  • Understanding How to Use Loqate to Validate Addresses

WebFOCUS Advanced Security

September 20th, 2018  |  2 days  |   Online   EST   |  Closed

Course Number:  761

Release 8.2.01M

You will learn how to:

  • Define Reporting Server Authentication and Authorization

    • Security providers
    • Access control
    • User roles
  • Define WebFOCUS Client and Reporting Server Profiles
  • Integrate External Authentication/Authorization with WebFOCUS Client and Reporting Server
    • Integrating external LDAP
  • Access Control Template
    • Create template

  • Define Pre-Authentication with SSO (basic)
    • Security zones, IWA, SAML, trusted Ticket
  • Data Source Security with DBA
  • Use Encryption

Advanced Reporting Application Techniques Using App Studio

October 16th, 2018  |  2 days  |   Online   EST   |  Enroll

Course Number:  522

Release 8.2.01m

Expand your App Studio reporting application development skills beyond the basics. This course will show you how to work with and maintain reporting applications for a user community. It covers a wide range of topics, like controlling data source access, modularizing procedures, and caching data for faster response times.

You will learn:

  • The relationship between the Client and the Reporting Server through App Studio.
  • How to control the way the Reporting Server searches for metadata.
  • The scripting language, Dialogue Manager, to dynamically assemble procedures.
  • Best practices for using date and date-time formatted fields.
  • The new simplified date and date-time functions to calculate significant dates.
  • How to improve response time for webpage displays by caching data.
  • Advanced webpage techniques to:
    • Use Dialogue Manager to create webpage control choices.
    • Spawn multiple displays on a webpage with a JavaScript® drilldown.
    • Handle options for no data when displaying reports and charts on a webpage.
  • Work visually with reports and charts while maintaining flexibility.

Extending WebFOCUS with the Core Language V8.2

October 18th, 2018  |  2 days  |   Online   EST   |  Enroll

Course Number:  105

Release: 8.2.01

Are you familiar with the WebFOCUS graphical user interface, but need to know more about the underlying code that gets generated from your actions? Do you need to understand FOCUS/WebFOCUS reports you have inherited? With this course, you will learn the basic syntax contained in a FOCUS or WebFOCUS report request.

Learn to make changes to a report that needs minor adjustments, quickly and more easily. In many instances, it might be easier to manually change the code rather than navigating through a series of menu pull-downs and window buttons.

You will learn how to:

  • Understand the syntax of the FOCUS language
  • Comprehend WebFOCUS processing of requests
  • Create detailed (PRINT) and summary reports (SUM)
  • Control the order of data (BY, ACROSS)
  • Style reports (STYLE file, HEADINGS, FOOTINGS)
  • Understand Date Formats to change the way they are displayed.
  • Create compound Data Selection using WHERE clause
  • Calculate detail and summed values using DEFINE and COMPUTE
  • Display group and grand totals (Subtotal, Row-Total, Column-Total)
  • Place data from multiple files into one report (JOIN)
  • Save data in Excel, Active Report, and PDF formats
  • Add flexibility to your report request with variables (Dialogue Manager)
  • Consider relational reporting efficiencies (SQL tracing)