Pragmatic Workbench Training

The Pragmatic Workbench Training is a 4 day course that gives users an extensive look at every feature our tools have to offer. Attendees will learn how to use the Pragmatic Works product suite to its fullest potential in their unique environment and how the tools will help with overcoming common challenges and creating an overall more efficient BI experience.

IMPORTANT: When you purchase a seat in this class you also receive 2 hours of our BI Virtual Mentor service for assistance with YOUR project work. This remote service lets you work ONE on ONE with our BI mentors to accelerate YOUR project and further improve YOUR skills. Your Virtual Mentor hours can be used during business hours anytime during the 12 months following your class. To set up a session, download this simple questionnaire, fill it out, and send it as an attachment to mentor@pragmaticworks.com. This unique Pragmatic Works offering insures that your training will translate into real world success for YOUR projects.

All virtual training students are provided a previously recorded version of the class that are available for 7 days after the end of the class.

Outline

Day 1

Module 1 - Overview of the Pragmatic Works Tools
  • Overview of Pragmatic Works Tools
  • Integrating the Pragmatic Works Tools into your Development Lifecycle
  • Understanding the Licensing Model
Module 2 - Introduction to DBA xPress
  • Overview of DBA xPress Features
  • Who Would use DBA xPress?
  • DBA xPress use Cases
Module 3 - Assessing Your Data Sources Using DBA xPress
  • Using Data Space Analyzer to Assess Data Source Storage Space
  • Using Object Browser to Analyze Source Metadata
  • Data Profiling with Data Surf
Module 4 - Introduction to DOC xPress
  • Overview of DOC xPress Features
  • Who Would use DOC xPress?
  • DOC xPress use Cases
Module 5 - Assessing Data Source Dependencies with DOC xPress
  • Find Data Source Dependencies with Object Lineage
  • Observe how Object Changes Affect our Project with Impact Analysis

Day 2

Module 6 - Introduction to Task Factory
  • Overview of Task Factory Features
  • Who Would use Task Factory?
  • Task Factory use Cases
Module 7 - Using Task Factory for Data Preparation and Cleansing
  • Downloading Source Data Files with the Secure FTP Task
  • Check if a File is in Use with the File Properties Task
  • Normalize Address Data Elements with the Address Parse Transform
  • Identify Questionable Data with the Data Validation Transform
Module 8 - Understanding Data Warehouse Design
  • Why do you need a Data Warehouse?
  • Designing Dimension Tables
  • Designing Fact Tables
Module 9 - Loading Dimension Tables Using Task Factory
  • Loading a Simple Dimension using the Upsert Destination
  • Loading a Complex Dimension using the Dimension Merge Transform
  • Updating Rows in Bulk with the Update Batch Transform
  • Speed up Development with the Package Builder Wizard
Module 10 - Loading a Fact Table Using Task Factory
  • Configuring the Advanced Lookup Cache Transform for Joining Data
  • Doing Range Lookups with the Advanced Lookup Transform
  • Handling Inferred Members with the NULL Handler Transform
  • Loading Fact Tables with the Fact Table Destination
Module 11 - Creating a Master Package with Task Factory to Orchestrate your Data Warehouse Load
  • Understanding Parallel Execution of Packages
  • Executing Child Packages with the Advanced Execute Package Task

Day 3

Module 12 - Introduction to BI xPress
  • Overview of BI xPress Features
  • Who Would use BI xPress
  • BI xPress use Cases
Module 13 - Find Problems Early with LegiTest
  • Designing a Test
  • Running a Test and Viewing the Results
Module 14 - Adding Notification and Auditing to SSIS using BI xPress
  • Implementing a Notification Process with the Notification Framework
  • Applying an Auditing System with the Auditing Framework
  • Visualize Package Executions using the SSIS Monitoring Console
Module 15 - Verify Best Practices with the BI xPress Best Practices Analyzer
  • Using Predefined Best Practices Rules
  • Creating User Defined Best Practices

Day 4

Module 16 - Determining Development Changes with BI xPress BI Compare
  • Setting up a Comparison Scenario
  • Viewing the Results of a Comparison Scenario
Module 17 - Making MDX Easy with the BI xPress MDX Calculation Builder
  • Quickly Build MDX Calculations using Predefined Templates
  • Use Predefined Template to Create Dynamic or Static Named Sets
Module 18 - Administrating your Report Server with BI xPress
  • Easily Deploy Reports using the Report Deployment Tool
  • Monitor Report Execution Performance with the Reporting Performance Monitor
Module 19 - Documenting your Completed Solution with DOC xPress
  • Creating a Data Dictionary on your Solution to Additional Metadata Details
  • Customizing Document Output for Users with Role Based Output
  • Produce the Final Document for your Project
Module 20 - Administrating your Pragmatic Works Toolset
  • Scheduling DOC xPress Snapshots with the Command Line Scheduler
  • Sharing DOC xPress Solutions with Other Users
  • Migrating BI xPress / DOC xPress Databases to a New Server
  • Purging BI xPress / DOC xPress Databases when they Become too Large
  • Migrating Licenses to a New Machine

Prerequisites

This class is targeted for BI developers that spend most of their time developing in SSIS, with some time spent in SSRS and SSAS who would like to reduce development time and simplify the development process. Students will need to have knowledge of BIDS or SSDT.

SystemRequirements

  • SSIS 2005, 2008, 2008R2, 2012 or 2014
  • BIDS or SSDT
  • The Pragmatic Workbench (BI xPress, DBA xPress, Doc xPress)
  • Task Factory

Some of our clients