This course gives you the comprehensive skills and in-depth knowledge needed to access, analyze, and share data using BusinessObjects InfoView and BusinessObjects Web Intelligence. BusinessObjects Web Intelligence is a query, reporting, and analysis tool that allows you to access the data in your corporate databases directly from within BusinessObjects Enterprise InfoView, and to present and analyze this information in a Web Intelligence document.

Report designers who need to access and analyze information using InfoView and Web Intelligence

• Create Web Intelligence documents for your reporting needs
• Build queries to retrieve data using BusinessObjects universes
• Enhance documents for easier analysis using Web Intelligence
• Organize, manage, and distribute documents using InfoView
• Design reports using Web Intelligence and share your analysis with other users
• Apply alternative query and reporting techniques when creating complex Web Intelligence documents
• Create combined queries and use sub-queries
• Use character and date string functions
• Create variables using "If" logic
• Redefine calculation contexts
• Create hyperlinks in your documents using Web Intelligence dialog boxes

This instructor-led course teaches you the comprehensive skills, concepts, and terminology needed to design, build, and maintain well-designed universes using BusinessObjects 6.5, BusinessObjects XI R1/R2, and BusinessObjects XI 3.0/3.1 universes. Report designers and business users can create reports without having to know anything about the underlying data source or structure.

Developers who design metadata models

After the completion of this course, you will be able to:

• Identify common data structures
• Gather requirements
• Create a baseline project
• Prepare reusable metadata
• Model for predictable results
• Create calculations and filters
• Implement a time dimension
• Create the presentation view
• Create analysis objects
• Manage OLAP data sources
• Set Security
• Manage packages
• Basic model maintenance and extensibility
• Working with different query subject types
• Identify generated SQL and complex queries
• Optimize and tune Framework Manager model
• Work in a multi-modeler environment
• Use advanced parameterization techniques
• Manage MUNs and model for drill-through
• Employ additional modeling techniques
• Solve business problems with universe design and BusinessObjects Universe Designer
• Describe the course universe, database data, and structure
• Create universes from stored procedures and JavaBeans
• Create, modify, and update universes from OLAP data sources using the enhanced OLAP functionality in Universe Designer

SAS Analytics provides an integrated environment for predictive and descriptive modeling, data mining, text analytics, forecasting, optimization, simulation, experimental design and more. From dynamic visualization to predictive modeling, model deployment and process optimization, SAS provides a range of techniques and processes for the collection, classification, analysis and interpretation of data to reveal patterns, anomalies, key variables and relationships, leading ultimately to new insights and better answers faster. This instructor-led course provides students with the knowledge and skills to leverage SAS tool to analyze data about customers, suppliers, operations, performance and more.

Working professionals who wish to gain expertise in SAS.

After the completion of this course, you will be able to:

• Read data into SAS, perform simple manipulation and write basic reports
• Perform various data transformations and summarizations, and read several types of data sources.
• Read and manipulate complex forms of data and how to use SAS utilities to manage SAS libraries
• SQL processing with SAS software

This course provides step-by-step instructions for creating analyses and dashboards, which compose business intelligence applications. Participants learn how to administer the Oracle BI Presentation Catalog and to build a simple Oracle BI dashboard starting with basic analyses, then adding more complexity as the course progresses. Participants learn to include pivot tables, graphs, gauges, maps, prompts, embedded content, navigation links, and KPIs on the dashboards. Participants also use Oracle BI Delivers to send real-time, personalized alerts to dashboards and for subscribed users, and are introduced to the use of Oracle Business Intelligence Mobile in accessing BI content on their mobile devices. Participants are introduced to the use of Oracle BI for Microsoft Office to integrate Oracle BI data and views in Microsoft Office presentations and spreadsheets. Participants create KPIs and add KPIs to a dashboard. Finally, they explore the use of Oracle BI Briefing Books.

Application Developers, Business Analysts, Business Intelligence Developer, Developer, End Users, Functional Implementer, Technical Administrator and Technical Consultant interested in pursuing career in Oracle Business Intelligence.

Learn To:
Build analyses and dashboards.
Build and use views and graphs in analyses.
Create analyses using Essbase data sources.
Create and work with KPIs.
Create and modify Oracle BI Dashboards.
Use Oracle Business Intelligence Mobile to access BI content.
Use BI content in Microsoft Office applications.
Configure, schedule, and deliver personalized alerts using Oracle BI Delivers

This course provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Students begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company's business requirements, import schemas, design and build logical business models, and expose business models to users in the Oracle BI user interface. In the process of constructing the repository, they learn how to build physical and logical joins, simple measures, calculation measures and learn how to validate their work by creating and running analyses, and verifying query results using the query log.

Application Developers, Business Analysts, Business Intelligence Developer, Data Modelers, Data Warehouse Administrator, Data Warehouse Analyst, Data Warehouse Developer, Reports Developer: Wanting to pursue carriers in Oracle Business Intelligence.

Use the Oracle BI Administration Tool to build, manage, and maintain an Oracle BI repository. Build a dimensional business model to address business intelligence requirements. Build and execute analyses to test and verify a dimensional business model analyses. Use the Oracle BI Administration Tool to administer Oracle BI Server.

The Microsoft Certified Information Technology Professional (MCITP): Business Intelligence Developer course validates that an individual has the comprehensive set of skills necessary to be a senior Business Intelligence consultant and leads to career paths as Data Warehouse Architect, and Data Warehouse Designer.

Students and working professionals who wish to gain expertise in SQL Server Business Intelligence development.

After the completion of this course, you will be able to:

• Planning BI solutions
• Design dimensional models
• Design a physical schema based on a logical design.
• Design indexing, partitioning, and key structures for the relational database.
• Designing SQL Server Integration Services (SSIS) Solutions
• Designing SQL Server Reporting Services (SSRS) Solutions
• Designing SQL Server Analysis Services (SSAS) Solutions
• Maintaining and Optimizing SSAS Solutions
• Designing Data Mining Solutions

The Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2005 Business Intelligence – Development and Maintenance course validates that an individual has the comprehensive set of skills necessary to be a Business Intelligence professional and leads to career paths as Business Intelligence Analyst and Report Writers.

Students and working professionals who wish to gain expertise in Microsoft Business Intelligence.

After the completion of this course, you will be able to:

• Manage SQL Server Analysis Services (SSAS)
• Develop SSAS solutions using BIDS
• Implement Data Mining using BIDS
• Manage SQL Server Reporting Services (SSRS)
• Develop Reporting Solutions using SSRS
• Implement Data Mining using BIDS
• Manage SQL Server Reporting Services
• Developing Reporting Solutions using SSRS
• Developing Business Intelligence solutions using SSIS
• Administering SQL Server Integration Services (SSIS) packages

This course is for those who want to be able to implement Extraction, Transformation and Loading (ETL) in BW and to perform BW warehouse management. It will help students to understand SAP authorization concept and be able to implement BW authorization. It also prepares for the SAP BW certification exam.

Students and professionals interested in SAP BW/BI ETL and Warehouse Management

After the completion of this course, you will be able to:

• load flat file into BW
• load data from R/3
• build generic extractor in R/3.
• write ABAP routines for Update/Transfer rules
• use BW delta management

This instructor-led course is designed to give you comprehensive skills and in-depth knowledge to plan and create reports that will help you analyze and interpret information. You will learn to use Crystal Reports 2008, a powerful, dynamic, actionable reporting solution, to design, explore, visualize, and deliver reports via the web or embedded in enterprise applications. You will also increase your understanding of formulas, variables, arrays, templates, parameters, summaries, and sections

This course provides an in-depth approach to the entire report creation cycle from planning a report prototype to distributing a report.

Report designers who are new to Crystal Reports and who are responsible for creating and distributing reports.

• Plan and create reports to help analyze and interpret important information
• Increase understanding of report processing, formulas, custom functions and subreports to make more effective report design decisions and create more efficient reports.
• Use the Repository
• Create Formulas
• Manage Reports
• Use Variables and Arrays
• Use Report Templates
• Build Parameterized Reports
• Summarize Data with Crosstabs
• Use Report Sections
• Build Specialized Reports
• Design and deliver reports via the web or embedded in enterprise applications
• Analyze and interpret information
• Gain an increased understanding of report processing, formulas, custom functions and sub reports

This instructor-led course is designed for professional report authors to learn report building techniques using relational data models, and ways of enhancing, customizing, managing, and distributing professional reports.

Working professionals who wish to gain expertise in COGNOS report writing skills.

After the completion of this course, you will be able to:

• Create and format reports using different report types, groupings, headers, footers, and formatting options.
• Focus reports by filtering data and using prompts
• Add value to your reports using calculations and additional report building techniques
• Enhance reports with advanced formatting and highlight exceptional data
• Author report through query models
• View related information in different reports
• Examine and edit XML in report specifications
• Burst reports to email and COGNOS connection
• Create relationship between queries (set operations, joins, unions)
• Design effective prompt to determine report contents and format at run time
• Navigate reports using bookmarks and table of contents
• Add HTML items to control the behavior of elements in your reports
• Set up drill-through access to reports and packages
• Create agents to manage in Event studio

This instructor-led course provides participants with knowledge of metadata modeling concepts for predictable reporting and analysis results Framework Manager. Participants will learn the entire metadata modeling process, from initial project creation, to publishing metadata on the Web, so that end users can easily author reports and analyze data. Cognos metadata modeling recommendations will be applied throughout the course. Participants will also create analysis objects by providing dimensional information to the model, learn how to apply security to the model, manage projects and packages, analyze the generated SQL for various queries, optimize and tune models for performance, manage Framework Manager projects, gain experience with advanced use of parameters, manage Member Unique Names, and model for drill-through. Data source used throughout the course include a relational database, based on operational data, and OLAP sources.

Developers who design metadata models

After the completion of this course, you will be able to:

• Identify common data structures
• Gather requirements
• Create a baseline project
• Prepare reusable metadata
• Model for predictable results
• Create calculations and filters
• Implement a time dimension
• Create the presentation view
• Create analysis objects
• Manage OLAP data sources
• Set Security
• Manage packages
• Basic model maintenance and extensibility
• Working with different query subject types
• Identify generated SQL and complex queries
• Optimize and tune Framework Manager model
• Work in a multi-modeler environment
• Use advanced parameterization techniques
• Manage MUNs and model for drill-through
• Employ additional modeling techniques

This course helps students understand data warehouse concept and BW architect. At the completion of the course they will be able to design and build BW infoProviders and use and create BW query and reports.

Students and professionals interested in SAP BW/BI Data Modeling and Reports.

After the completion of this course, you will be able to:

• use data warehouse and BW extended star schema concept
• use BW architect
• create infoObject, infoCube, ODS, infoSet and MultiProvider
• create BW query
• create BEx report
• use SAP Web Application Designer to create web reports

This instructor-led course is designed for participants to learn the fundamentals of administering PowerCenter Servers and content.

Working professionals who wish to gain expertise in PowerCenter installation, administration and deployment.

After the completion of this course, you will be able to:

1. Platform components and Service Architecture
2. Nomenclature
3. Repository Service
4. Installation
5. Security
6. Object sharing
7. Repository organization and migration
8. Database connections
9. Workflow Manager Configuration
10. Workflow properties
11. Running and monitoring workflows
12. Workflow and task errors