Instructor Led Analysis Training in Canada - Training Resources

Statistical Analysis with Microsoft EXCEL This course will introduce students to both descriptive & univariate inferential statistical procedures. The emphasis for this course, however, will be on the application of these procedures in the spreadsheet environment of Microsoft Excel.  more...

Design and Analysis of Earth Retaining Walls In this course, the theoretical aspects of retaining structures are studied first, followed by the analysis and design of common earth retaining structures. Students will practice the analysis and preliminary design of common earth retaining walls.  more...

2791 Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization.  more...

Microsoft Excel Level 3 Advanced - ctc This course will consist of the following lessons: Outlining And Grouping Your Data Pivot tables Exploring Scenarios What If Analysis Excel And Hyperlinks Excel Workbooks As Web Pages Creating And Using Shared Workbooks and more!  more...

Implementing Cisco Security Monitoring Analysis and Response SystemMARS This course is part of the Cisco Security Management Suite which provides security monitoring for network security devices & host apps made by Cisco or non-Cisco providers. Topics include event correlation, data reduction features, topology awareness...  more...

Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services - newera This instructor-led course discusses how to use the Analysis Services development tools to create an Analysis Services database & an OLAP cube, how to use the Analysis Services management & administrative tools to manage an Analysis Services solution.  more...

Microsoft Excel 2003 Spread Sheet Analysis This course is designed for users of Excel who need to analyze spreadsheet data. Concepts covered include using financial functions, using the Solver add-in, projecting figures, creating and managing what-if scenarios, and auditing workbooks.  more...

The Comprehensive Business Analysis Seminar Part 1 This 4-day course, covers the underlying competencies, Business Analysis Planning and Monitoring and Requirements Communication and Management knowledge areas from the Business Analysis Body of Knowledge ® (BABOK ®).  more...

Microsoft Project 2003 Beyond Basics - TPLANIT Project 2003 Beyond Basics presents skills training and assessment for Microsoft Project 2003. This course provides competency in evaluating project schedules; tracking project performance and managing costs; customizing project tables, filters, views and reports; creating and using templates; and managing multiple projects. Customizing your project; formatting the Gantt Chart; Tasks; tracking  more...

Microsoft Excel 2007 Spreadsheet Analysis - uofa This course is designed for users of Excel who need to analyze spreadsheet data. Concepts covered include using financial functions, using the Solver add-in, projecting figures, creating and managing what-if scenarios, and auditing workbooks.  more...

Civil Engineering Principles for non-Civil Engineers Geotechnical Foundation Design 12 CEUs Foundation Engineering. There is no need for a civil engineering background as the civil engineering concepts will not be introduced in depth. This course deals with basic aspects of modern good practice in geotechnical and foundation design. These include: the importance of both the geological and geotechnical aspects of the ground conditions, simple estimation of bearing capacity, and  more...

Certified Business Analysis Professional CBAP Preparation The Certified Business Analysis Professional (CBAP ™) designation is increasingly recognized as the benchmark for personnel in a business analysis role. If you are preparing for the examination you should attend our intense preparation course.  more...

Life Cycle Cost Analysis for Pavement Design EPIC is presenting a 1. 5-day workshop on the principles of LCCA and how it is used in the context of overall transportation asset management. The course is focused on the practical aspects of LCCA in transportation asset management..  more...

Compressors and Pumps Selection Applications Operation Troubleshooting and Maintenance 30 CEUs This course is a MUST for those who use this equipment. It covers how compressors and pumps operate and provides the guidelines and rules that must be followed for their successful application. Their basic design, specification and selection criteria, sizing calculations as well as all maintenance issues including vibration analysis, and used oil analysis are discussed in detail.  more...

*Water Supply Systems Security This course presents detailed coverage of the major infrastructure issues in water system security. Course topics range from vulnerability assessment to safeguards against cyber threats to hydraulic network analysis for contamination response.  more...

Introduction to Business Analysis 3 day course Target Audience: New Business Analysts Experienced Business Analysts who need to update or formalize their implicit understanding of their role, accountabilities and activities Project Managers who incorporate the Business Analyst role within their functional activity sets Business Managers who work within a project environment, and who interface with Business Analysts and Project Managers  more...

Cost Engineering-Effective Estimating and Cost Control This seminar examines the key concepts of cost engineering including estimating, risk analysis, cost control, scheduling and change management to achieve best value for investments and expenditures.  more...

Excel 2003 Spreadsheet Analysis - presidio After the course, participants will be able to accomplish the following: Use absolute and mixed references in a formula, use financial functions; Use the Goal Seek feature, data tables, create and manage scenarios, create scenario reports and more  more...

Effective Project Cost Estimating and Control 12 CEUs This seminar starts with the basic fundamentals of finance such as time value of the money, calculation of interest; present; future; and annual worth, rate of return, benefit/ cost ration, cash flow diagrams, and depreciation. The seminar then shifts to cost estimating concepts such as types; purposes; and methodologies of cost estimates, total cost of a project, direct and indirect costs, labor  more...

Project Planning Scheduling and Control 12 CEUs ...ath Method (CPM) calculations, creation of CPM schedules, analysis of float, precedence networks (PDM), schedule updating, project control and Earned Value analysis, resource allocation and leveling, schedule compression (acceleration), and tricks and tips for better project scheduling. The seminar contains many definitions, concepts, practical examples, and exercises. Although the seminar  more...

Microsoft Excel 2007 Intermediate Available in French and English The Objective of this 2-day course is to efficiently use workbooks as well as their tools for management and data analysis. Using graphs and databases. Using different Excel functions and their database analysis features.  more...

BusinessVision - Level 2 BusinessVision provides business management and accounting solutions for small and mid-sized companies and offers sophisticated tools, previously only available to large corporations. Level 2 Topics Include: * Inventory control * Bill of material * Order entry * Sales analysis * Purchase orders * Purchase analysis  more...

Sage Accpac for Windows GL Financial Report Designer The Financial Statement Designer that is part of the General Ledger module is a powerful report writing tool that integrates directly with Microsoft Excel. This course provides an in-depth overview of report designer commands and their functionality within Excel. Topics Include: * FR commands and functions * Using the FR menu in Excel * Specification layouts and  more...

Access 2007 Intermediate Level 2 - computer help We look further at relating tables (join types, 1-1 relationships, database analysis tools), more about reports (sub-reports, letters) & more about forms (tab control, option groups, sub-form sub-totals, list boxes, sync combo boxes, printing options).  more...

BA00 - Business Analysis Boot Camp An intensive course covering all aspects of the Business Analyst role from requirements gathering to testing. All major techniques both Structured & Object-Oriented (OO) are addressed in this course.  more...

Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services This course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.  more...

Excel 2007 Level 3 - teksource In this course, you will extend your knowledge into some of the more specialized & advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others...  more...

Excel 2003 Level 3 - teksource You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.  more...

Environmental Statistical Analysis for Effective Cost Reduction-Epic ...analysis is being increasingly used in environmental assessment and monitoring projects. Consequently, a growing number of professionals are involved with statistical studies, both as technical experts and as project managers coordinating the activities of technical experts. This course is designed to familiarize participants with modern statistical methods for the analysis of environmental  more...

Business Analysis for Testers This is a survey course that examines the information that should be present in requirements deliverables, & also reviews the typical analysis & modeling techniques used by business analysts.  more...

Microsoft Excel 2003 - Level 3 - Newera You have used Microsoft Office Excel 2003 to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. In this course, you will do all of these things.  more...

Fundamentals of Capital Project Cost Control- EPIC Using, case studies, exercises & discussion, this seminar will address the fundamentals of project cost control including project life cycle, project development, planning, scoping, estimating, risk analysis, procurement, earned value analysis, & more.  more...

Microsoft Excel 2007 Level 3 - Spreadsheet Analysis- Nexient Upon completion, students will: Use absolute & mixed references in a formula, as well as using financial functions, Use the Goal Seek feature & data tables, Create & manage scenarios, and create scenario reports, Define & solve problems with Solver ...  more...

Project Intermediate Available in French and English synesis Maximize efficiency by different methods of sharing information. Exploit the advanced analysis tools of the application and personalize your working environment.  more...

Microsoft Excel 2000-2003 Level 3 Spreadsheet Analysis-Nexient This course is intended for participants who are familiar with Excel 2000/ 2002/ 2003 and wish to use some of the advanced functionality for data analysis and reporting.  more...

Microsoft Excel 2000-2003 Level 3 Spreadsheet Analysis- Nexient This course is intended for participants who are familiar with Excel 2000/ 2002/ 2003 and wish to use some of the advanced functionality for data analysis and reporting.  more...

How to Gather and Document User Requirements 4 day course -Nexient This how-to course introduces the roles of the business analyst as they relate to the analysis and documentation of requirements. It familiarizes participants with the core knowledge and skills required to identify and document user requirements.  more...

Introduction to Business Analysis-Nexient This introductory course is designed to give people new to the business analyst role or those who supervise and/ or work with business analysts a basic understanding of the benefits, functions and impact of this critical position.  more...

Introduction to Business Analysis- Nexient This introductory course is designed to give people new to the business analyst role or those who supervise and/ or work with business analysts a basic understanding of the benefits, functions and impact of this critical position.  more...

Excel 2007 Level 3 - Acend This course will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, and collaborating on worksheets with others.  more...

Foundation Design This course deals with all aspects of modern good practice in foundation design: the importance of both the geological & geotechnical aspects of the ground conditions, current limit analysis methods for bearing capacity, & definition of factors of safety  more...

Excel 2003 Level 3-acend In this course, you will use Microsoft Excel 2003 to apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.  more...

Business Analysis Crash Course IIBA B07 An intensive course covering all aspects of the Business Analyst role - from requirements gathering to testing. All major techniques - both Structured and Object-Oriented (OO) - are addressed in this course.  more...

Excel 2007 - Level 3 In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.  more...

Excel 2003 Level 3 In this course, you will use Microsoft Excel 2003 to apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.  more...

Excel 2003 Level 3 In this course, you will use Microsoft Excel 2003 to apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.  more...

Microsoft Excel 20022003 Level 3 This 1 day course topics are : pivot tables, macros, outlines, Excel functions, auditing, what-if analysis and more.  more...

Excel 2007 Spreadsheet Analysis- Presidio Learning Center Location: Winnipeg Date: 2009-03-18 List Price: $179 Offered Price: $143. 00 Seats Available: 2 Upon completion of the course, participants will be able to accomplish the following: Use absolute and mixed references in a formula, as well as using financial functions Use the Goal Seek feature and data tables Create and manage scenarios, as well as create scenario reports Define and  more...

How to Gather and Document User Requirements 4 day course This how-to course introduces the roles of the business analyst as they relate to the analysis and documentation of requirements. It familiarizes participants with the core knowledge and skills required to identify and document user requirements.  more...

Seismic Analysis And Design Of Steel And Reinforced Concrete Buildings This course provides an opportunity to learn the basic principles and practices of analysis and design of earthquake-resistant design building structures. Static and dynamic analysis of buildings using advanced computer codes is presented.  more...

How to Gather and Document User Requirements - nexient ...tivities. Project Managers who incorporate the business analysis role within their functional activity sets. Business Managers who work within a project environment, and who interface with Business Analysts and Project Managers Learn How to: Define the role of the business analyst in the requirements process Effectively document a solution's vision and scope Develop a Requirements  more...

Analysis and Problem Solving for Consultants 2 day course Target audience: This course is designed for project managers, business analysts, IT professionals, engineers and others in technical roles who are either seeking to become practitioner technical consultants, or who wish to become more consultative in their work with their internal or external clients. Course Synopsis: From a client's perspective, the primary responsibility of a consultant  more...

Facilitation Techniques for Requirements Development 2 day course Learn How to: Identify the use of facilitation in business analysis Explain the role and responsibilities of a business analysis facilitator Plan a facilitation session Use the appropriate facilitation techniques for a given session Conduct a facilitation session using best practices Manage conflict during a session Identify facilitation opportunities in business analysis  more...

Introduction to Business Analysis - nexient Target Audience: New Business Analysts Experienced Business Analysts who need to update or formalize their implicit understanding of their role, accountabilities and activities Project Managers who incorporate the Business Analyst role within their functional activity sets Business Managers who work within a project environment, and who interface with Business Analysts and Project Managers  more...

Facilitation Techniques for Requirements Development - nexient Learn How to: Identify the use of facilitation in business analysis Explain the role and responsibilities of a business analysis facilitator Plan a facilitation session Use the appropriate facilitation techniques for a given session Conduct a facilitation session using best practices Manage conflict during a session Identify facilitation opportunities in business analysis  more...

Microsoft Project 2007 Level 2 - nexient Who should attend This course is intended for participants who are familiar with Microsoft Office Project 2007. Performance Objectives Upon completion of the course, participants will be able to accomplish the following: Understand the concepts of word processing, and how to create, save, and open documents for easy document management Use sample templates, create custom templates, and  more...

Testing Techniques for Tracing and Validating Requirements -NEXIENT Target Audience: Business analysts Data analysts Process analysts Application designers Learn How to : Recognize the role of the business analyst (BA) in the testing process Validate the business requirements document (BRD) and analysis models Verify that the solution conforms to the requirements Communicate the importance of a testing methodology Determine what to test and  more...

CATIA V5 - Analysis 5 days This course is the first within the CATIA V5 curriculum. Upon completion of this course, the student will be able to describe the basic terminology and use the basic features of the CATIA V5 Solutions.  more...

Excel 2007 Data Analysis Tools Are you experienced in Excel but want to learn additional, more advanced ways to view and analyze your worksheet data? Do you want to use tools such as the Scenario Manager, Goal Seek, Solver, and the Conditional Sum Wizard to work with data?  more...

Excel 2003 Data Analysis Tools Are you experienced in Excel but want to learn additional, more advanced ways to view and analyze your worksheet data? Do you want to use tools such as the Scenario Manager, Report Manager, Goal Seek, and Solver to work with data?  more...

Comprehensive Review Of Drainage Design Methods ...hem. Engineers must deal with drainage planning, run off analysis, storm sewer hydraulics and watercourse drainage within the government regulations. Also, they should be able to benefit from the use of computer software for design work The course focuses on these topics, develops them so that the participants gain comprehensive understanding and then presents the latest developments so that  more...

Fluid Flow and Mixing for Heat Transfer Fluid flow, mixing and heat exchange are both common and critical to most process plants. Successful operation of the equipment depends on a number of important actions being properly addressed. The course will introduce new concepts and approaches through actual case studies, which will enable you to successfully implement new ideas. The focus is on methods for hands-on analysis and design.  more...

Interpretation and Enforcement of Construction Contracts for Industrial Plants ...dustrial applications including project life cycle, risk analysis, developing tender documents, contract first principals, tendering contracts, types of contracts, RFQa s, bidding, contract language, Earned Value Analysis for the control of contracts, bonding and insurance. Developing, managing, interpreting, and enforcing contracts is a lot of work. It requires an understanding and the  more...

CATIA V5 -DMU 5 days This course is intended for CATIA V5 or ENOVIA V5 users. This version of CATIA V5 training focuses on Digital Mock-up (DMU). Some of the course topics will include: Digital Mock Up Basics (DMB); Digital Mock Up Navigator (DMN); Digital Mock Up Optimizer (DMO); Digital Mock Space Analysis (SPA); among other things; and much, much more. We offer small class sizes, full manuals, one workstation  more...

Business Analysis Essentials ...have designed an inclusive 3-day introduction to business analysis (BA) that will equip you with all the basic skills for performing effective analysis. You will learn valuable approaches to determine the business problem, root cause identification, solution definition strategy, business case preparation, requirements gathering and documentation, quality management and developing  more...

CATIA V5 Week B Analysis ...rse focuses on topics such as: Generative Part Structural Analysis Fundamentals (GPF); Generative Part Structural Analysis Expert (GPE); Generative Assembly Structural Analysis (GAS); FEM Surface (FMS); FEM Solid (FMD); Realistic Shape Optimizer (RSO); and much more. We offer small class sizes, full manuals, one workstation per student, customized courses, and up-to-date technology.  more...

Dynamite Sales Presentations ...ng to help solve their business problems is by a thorough analysis and understanding of their current business circumstances and a demonstration of your in-depth knowledge of the products and services you are selling. This comprehensive workshop will take you through all the steps required to close the sale, including proposal-writing, handling objections, dealing with difficult buyers, selling  more...

The Business Analysts Crash Course 2 Days ...holders and developers through comprehensive requirements analysis and documentation and by guaranteeing results through structured testing and quality assurance. ...An intensive course covering all aspects of the Business Analyst role from requirements gathering to testing. All major techniques both Structured and Object-Oriented (OO) are addressed in this course. Each trainee  more...

Resilient Thinking for Leaders ...and process information. They will be smarter about their analysis and conclusions they take from their surroundings. They will learn to react calmly and decisively. They will be more resilient with abilities to bounce back, steer through, overcome and reach out in a productive fashion. * Develop the skills to analyze thoughts for accuracy. * Learn how to change to more accurate  more...

CATIA V5 - Week B - Analysis 5 Days ...rse focuses on topics such as: Generative Part Structural Analysis Fundamentals (GPF); Generative Part Structural Analysis Expert (GPE); Generative Assembly Structural Analysis (GAS); FEM Surface (FMS); FEM Solid (FMD); Realistic Shape Optimizer (RSO); and much more. We offer small class sizes, full manuals, one workstation per student, customized courses, and up-to-date technology.  more...

Problem Solving and Decision Making Skills This one-day course will help students to learn a rational process for problem solving, learn, and practice creative techniques for generating solutions to business problems and learn a rational process for making decisions: * Solving Problems * Brainstorming * Metaplan * Your Mind is Better than You Think! * The Fishbone Diagram * Force-Field Analysis * The Six  more...

Microsoft Excel 2007 Level 2 Functions and Analysis - English ...Analysis. This course builds on the knowledge gained from the Level 1 course and provides additional training based on that course. We will go over the prerequisites when we start the course, and then proceed to teach topics such as Reviewing Formulas; Understanding Functions; Financial Functions; Logical Functions; Lookup Functions; Date Functions; Statistical Functions; What-if Analysis; and  more...

Facilitation Skills for Business Analysts 2 Days ...Analysis Facilitation Skills is a solid base for planning and facilitating effective meetings is imperative to success. Limited course enrollment ensures plenty of opportunity to practice and interact with other course participants as well as allowing time to focus on issues specific to their situation. Case-study driven workshops and simulations provide all participants with full hands-on  more...

End to End Business Analysis Workshop 3 Full Days ...o-end IT project, employing the full spectrum of Business Analysis skills and techniques learned in the BA program. Trainees step through a complex case study, employing business and system use case analysis, object modeling, activity diagramming and other essential BA skills, chronologically, as they would need to use them over the course of a real project. When delivered with a modeling tool  more...

Preparing to become a BA Professional ...ew and existing BAs who plan to make a career in Business Analysis and plan to move from Junior to (Senior) Business Analyst Professional. The course is particularly addressed to the trainee who is considering acquiring the CBAP (Certified BA Professional) designation. You will learn what responsibilities and skills you will need to make the transition to BA Professional, as well as tips for  more...

Writing Testable Requirements 2 Days Software development often fails because requirements are written poorly, or testing does not adequately cover those requirements, or both. Half of the test effort is just trying to understand the requirements. The better that requirements are written, the higher the likelihood of the development and testing team being able to understand those requirements and focus on their software development  more...

Gathering & Documenting User Requirements (2 Days) Location: Toronto Date: 2008-05-29 List Price: $1095 Offered Price: $876.00 Seats Available: 2 The course covers what the Business Analyst needs to accomplish in each requirements gathering session (goals, agenda, who to invite, artifacts, etc.) as the project progresses - starting from business use-case sessions that focus on the business context through to system use cases that focus on user-IT  more...

Introduction To VB.net (5 Days) ...the basics including: The .net Framework; Object Oriented Analysis and Design; Object Oriented Analysis; Object Oriented Design; Creating Objects with VB .NET; Inheritance and Polymorphism; Working with Reference Types; and much much more. This course will run for five full days (from 8:30 am to 4:30 pm) starting April 28, wherein upon completion of the course many inclusions to our training  more...

Microsoft Excel 2003 Level 3 Location: Vancouver Date: 2008-02-11 List Price: $229 Offered Price: $160.00 Seats Available: 1 Outline Section 1 - Pivot Tables What is a Pivot Table? Creating a Simple Pivot Table Changing the Layout of a Pivot Table Creating a Spreadsheet for each Page of thePivot Table Multiple Field Headings on Page Axis Refreshing a Pivot Table Structured Selection Formatting a Pivot Table  more...

Microsoft Excel 2003 Level 3 Location: Vancouver Date: 2008-01-24 List Price: $229 Offered Price: $160.00 Seats Available: 2 Section 1 - Pivot Tables What is a Pivot Table? Creating a Simple Pivot Table Changing the Layout of a Pivot Table Creating a Spreadsheet for each Page of thePivot Table Multiple Field Headings on Page Axis Refreshing a Pivot Table Structured Selection Formatting a Pivot Table Adding or  more...

MS Excel 2003 Formulas for Statistical Analysis Location: City of Mississauga Date: 2007-04-13 List Price: $245 Offered Price: $171.00 Seats Available: 2 This class is an overview of calculations using selected advanced functions drawn from the statistical, database, and mathematic functions in Excel's core collections and add-in libraries. Participants will also be introduced to creating user-defined functions with Visual Basic in order to  more...

Communications and Soft Skills September 12, 2006. Executive Briefing, with hands-on mini-analysis for immediate insight and use. For executives who wish to learn about an additional way to increase the success and productivity of their teams, whether in sales, project work, customer service, etc. For trainers and coaches to experience the simplicity and power of a new communications and soft-skill tool.  more...

Mastering Microsoft Excel With our Mastering Microsoft Excel training course, students will learn how to build interactive spreadsheets that can be integrated with almost any business intelligence system. Our techniques for creating automated reports will enable any business analyst to create powerful customer report cards that can be shared throughout the organization, for a comprehensive understanding of the customer's  more...

The Agile Planning Game Rapid Estimating and Scheduling for High-Change Projects ...a schedule when we haven't done our detailed requirements analysis? While there are several solutions to this problem, the most popular is called The Agile Planning Game. This technique brings together a whole multi-disciplinary team and builds a consensus on a set of estimates. The Agile Planning Game is specifically designed to avoid the problem of "group think" -- where minority  more...

Business Analysis Crash Course IIBA B07 An intensive course covering all aspects of the Business Analyst role - from requirements gathering to testing. All major techniques - both Structured and Object-Oriented (OO) - are addressed in this course. Each trainee receives a hard copy of all course material as well as a Job Aids booklet, containing useful templates, examples, guidelines and glossary for use back on the job. Most large  more...

ITIL V3 Intermediate - SS SD ST SO CSI PPO SOA RCV OSA MALC These Accredited Certification Courses are offered in 3 venue: 1. CBT with Exam Preparation and Review with an ITIL V3 Expert Trainer 2. On-site classroom 3. Distance Learning via the Internet All ITIL V3 Intermediate courses are available ITILV3SS: Service Strategy ITILV3SD: Service Design ITILV3ST: Service Transition ITILV3SO: Service Operation ITILV3CSI: Continual Service Improvement  more...