Project Management
Fundamentals of Project Management *
Identifying and Mitigating Risks *
Quality Management During a Project *
Managing the Software Testing Process
Agile Project Management
Data Warehouse Project Management
Creating a Business Case
* An IT focused version is available
Business Analysis
Fundamentals of Business Analysis
Lean Six Sigma for Business Analyst and IT Professionals
Root Cause Analysis and Error Proofing
Data Warehouse and Data Analysis Concepts
Process Modeling
Creating Logical Data Models
Finance for Non-Finance Staff
Creating a Business Case
Data Warehousing
Strategies for Building and Maintaining a Data Warehouse
Determining the Return on Investment of a Data Warehouse
Data Warehouse Project Management
Data Modeling and Data Warehouse Design
Data Warehouse and Data Analysis Concepts (also listed under Business Analysis)
Data Mining and Analytical Applications
Data Quality Concepts and Considerations
Establishing a Data Warehouse Data Quality Program
Introduction to SQL
Introduction to PL/SQL
Business Intelligence
Pentaho BI Suite for Reporting
Pentaho Metadata Editor
Pentaho Analysis
Business Objects Web Intelligence (Intro)
Business Objects Web Intelligence (Advanced)
Business Objects Designer
COGNOS Query Studio
COGNOS Report Studio
COGNOS Framework Manager
SQL Server 2008 Reporting Services
SQL Server 2008 Analysis Services
Data Integration
Pentaho Data Integration
SQL Server 2008 Integration Services
Project Management
* Fundamentals of Project Management (2 days)
This course is intended to provide participants with a framework from which they can create project plans. It follows the five project management processes as described by the Project Management Institute. Each process is supported by a set of tools that can be used to create the necessary deliverables. Presented in a workshop environment, concepts are reinforced by the use of practical exercises.
* Identifying and Mitigating Project Risks (1 day)
Most project managers only consider project execution risks. Those risks involved in meeting project deadlines and budgets. This course instructs managers on how to dig deeper into risks and consider how their outcomes (positive and negative) will impact the project objectives and the business as a whole. Most importantly we examine how to ensure that the deliverable will perform as planned after the project is completed.
* Quality Management During a Project (1 day)
Quality planning is a key component of a project manager’s ability to prevent defects rather than inspecting afterward. This course examines how quality management should be included as part of the overall project plan and how that effort translates into long term benefits to the organization.
Business Analysis
* Fundamentals of Business Analysis (3 days)
As an introductory course participants will be provided with a basic understanding of the benefits, functions and impact of the role of a business analyst. The course examines the business analysis process as it is applied throughout a project.
* Lean Six Sigma for Business Analyst and IT Professionals (3 days)
The tools and techniques of Lean Six Sigma are excellent problem-solving and thought focusing capabilities, even when not used by a certified green belt or black belt. This course introduces some of the key topics of Lean Six Sigma and how they can be applied.
* Root Cause Analysis and Error Proofing (1 day)
Root Cause Analysis is a process designed to investigate and categorize the what, how and why of process events and failures. This course introduces several techniques that can be used and then defines methods to ‘error-proof’ the process for long term gains.
* Data Warehouse and Data Analysis Concepts (2 days)
The world of data warehousing and data analysis has seen a significant improvement in capabilities during the last 18 months. New tools, DW ‘appliances’ and approaches have been introduced. This course is designed to introduce business analyst to the concepts of data warehousing and data analysis and links those concepts to business improvements. Participants will use several open source tools to see how the concepts are applied. (The focus of the course is not on learning the tools. They are used merely to demonstrate the concepts.)
* Process Modeling (2 days)
Process models allow us to understand how the business is operating and to ‘see the opportunities’ for improvement. In this class, participants will work through exercises that define ‘as-is’ processes and move towards ‘to-be’ processes. Techniques such as data flow diagrams, value stream maps and state maps will be taught.
* Creating Logical Data Models (2 days)
Logical Data Models are used to learn the data that is important to the business. Participants will learn entity relationship diagramming, super and sub-types, attributive and associative entities, and documenting data constraints. The objective is to be able to create models without being limited by technology or organizational structure.
* Finance for Non-Finance Staff (1 day)
Often referred to as ‘the language of business’, finance is a primary driver in project selection and execution. This course will provide business analyst with a solid understanding of how their projects impact corporate financial statements and knowledge of key finance terms.
* Creating a Business Case (2 days)
The story told by a Business Case, or Cost Benefit Analysis, is the root of most project go/no-go decisions. This course has two objectives. First, defining what the components of a cost/benefit analysis are and second, learning how to present the analysis for maximum impact. (This course can be customized to fit specific terms and methodologies of clients.)
Data Warehouse and Data Quality
* Strategies for Building and Maintaining a Data Warehouse (2 days)
This course follows an outline that provides an in-depth examination of the technical perspectives of a data warehouse project. What is the right type of DW? How will the ETL process be executed? What degree of auditing is necessary and how will that be carried out? It will start with gaining a clear understanding of the business drivers behind building a data warehouse and use these as guidelines for many of the technical decisions.
The course is presented in a discussion, lecture and exercise format. Extensive student participation is built in to the class. Instructors make every attempt to incorporate student projects into the training materials. Concepts are reinforced through the use of team lab exercises.
* Determining the Return on Investment of a Data Warehouse (1 day)
A straight cost/benefit analysis (CBA) of a Data Warehouse project usually does not warrant doing the project but an in-depth look at the benefits usually uncovers a significant positive side with respect to better decisions, faster decisions, improved quality and improved customer relationships. Using a proven framework, this course will take participants through a process of accurately identifying costs and quantifying benefits that usually remain intangible.
* Data Modeling and Data Warehouse Design (3 days)
Utilizing a case study approach, participants will design and develop a working data warehouse. Emphasis is placed on identifying and answering those questions that will have the most significant impact on a successful result.
* Data Mining and Analytical Applications (2 days)
At the forefront of Data Warehouse technologies are data mining, using unstructured data, and analytical applications. Using several open source products, participants will learn what these concepts mean and how they can be applied. (The focus of the course is not on learning the tools. They are used merely to demonstrate the concepts.)
* Introduction to SQL (2 days)
Participants will learn how to create a query and modify database tables and views using SQL. SQL and database efficiency are examined along with the appropriate use of indexes.
* Introduction to PL/SQL (2 days)
This class teaches participants how to use PL/SQL as a means of enhancing their ORACLE based applications. The use of loops, cursors and error handling are practiced through a series of exercises.
Business Intelligence Tools
* Pentaho BI Suite for Reporting (2 days)
This course explores the foundational and advanced techniques involved in developing reporting solutions using the Pentaho BI Suite. At the completion of this course, participants will understand the reporting tools and architecture of the Pentaho Business Intelligence (BI) Suite and be able to build and deploy reporting solutions using Report Design and the BI Server.
* Pentaho Metadata Editor (1 day)
Participants gain knowledge of metadata modeling concepts and how to model metadata for consistent reporting and analysis results. Participants will learn the full scope of Pentaho’s Metadata Editor, the metadata modeling process, from initial project creation, to publishing of metadata to the Web, enabling end users to easily author reports and analyze data.
* Pentaho Analysis (1 day)
This course explores the architecture, concepts, and features of Pentaho Analysis (Mondrian). At the completion of this course, participants will understand the basics concepts of OLAP and demonstrate the ability to Pivot, Drill and Slice and Dice data using the Pentaho Analysis Client tools.
* Business Objects Web Intelligence - Introduction (1 day)
This class covers the concepts and mechanics of building and formatting simple reports using Web Intelligence. Additionally, it provides an overview of major Web Intelligence functionality.
* Business Objects Web Intelligence - Advanced (1 day)
Building upon the introductory class, this session provides more details on a number of topics (linking, subqueries, charts, etc.) needed to construct more sophisticated reports. This class is designed for individuals and project team members that need to produce “production” quality reports. These reports are generally more complex and require an in-depth knowledge of Web Intelligence capabilities.
* Introduction to Designer – Universe Construction (2 days)
The objective of this course is to teach the concepts and techniques required for constructing accurate, usable and effective Business Objects universes. Special topics, such as performance and security are also discussed.
* COGNOS Query Studio (1 day)
This class covers the concepts and mechanics of building and formatting simple reports using COGNOS Query Studio. Participants learn how to graphically display the data and how to create reports with a consistent look and feel through the use of templates. The course also covers scheduling reports and delivering reports in different formats (HTML, PDF, Excel, etc.). Additionally, it provides an overview of major Query Studio functionality.
* COGNOS Report Studio (1 day)
This course provides and introduction to Report Studio and provides details on a number of topics (linking, subqueries, charts, etc.) needed to construct more sophisticated reports. This class is designed for individuals and project team members that need to produce “production” quality reports.
* COGNOS Framework Manager (2 days)
IBM Cognos 8 BI Framework Manager is used to design metadata models that are then used by report developers. This course provides participants with knowledge of metadata modeling concepts and how to model metadata for consistent reporting and analysis results. Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing of metadata to the Web, enabling end users to easily author reports and analyze data.
* SQL Server 2008 Reporting Services (2 days)
This is a comprehensive course that teaches participants how to create, personalize, manage, and deliver reports from different data sources using SQL Server 2008 Reporting Services./p>
* SQL Server 2008 Analysis Services
Analysis services is the Microsoft OLAP engine and data mining platform for reports, spreadsheets, KPIs and analytic applications. This course examines how to use the core functionality of Analysis Services.
Data Integration Tools
* Pentaho Data Integration
The purpose of this course is to teach the concepts and techniques for using Pentaho Data Integration. Topics covered include creating transformations, steps used in transformations and putting transformations into jobs. Emphasis is placed on understanding how to design the transformation to achieve the business objectives./p>
* SQL Server 2008 Integration Services
The purpose of this course is to teach the concepts and techniques for using SQL Server 2008 Integration Services. The extract, transformation and loading of data is discussed in detail. Discussions of how the Integration Services work with the Reporting and Analysis Services is also included./p>
|
Courses