Discipline of Making-it-Happen
Discipline of Making-it-Happen
  Sign-in         Register
    
 
 BiPM HOME                                                                     

                      INDIA +91-8800557544                                                                 bipmsales@ExecutionMiH.com

Intensive Subject-Matter Workshops on Enterprise Information & Intelligence

Enterprise Information & Intelligence are well integrated subjects, which provide end-to-end thread of information management.

BiPM Institute is dedicated to knowledge-dissemination on Building Intelligent and Performing Organizations. On the strength of over 1000+ page of pure content in our knowledge portal on Enterprise Intelligence and DM, as well as focused research on these subjects, we provide world-class training programs. These training programs are highly customized, on the basis of the training needs analysis (TNA) conducted with your organization.

Data Management as a subject deals with quality, availability and reliability of data and it includes Data Quality, Data Integration, Metadata Management and Master Data Management. Unlike Enterprise Intelligence, the subjects are equally application to transaction processing systems and Enterprise Intelligence related systems. Enterprise Intelligence works on generating actionable information from the data. It includes subjects like Data Warehouse, Data-Marts, OLAP, Reporting, Analytics and Data-Mining.

Our training programs provide career and expert-level training workshops for all levels and roles with in an organization. These training programs are highly customized and we conduct a high-level diagnostics on your context, your business needs and your skill-levels. On that basis we recommend a training schedule.

Our workshops include the following imperatives:

  • Pre-Work: Through diagnostics and review of existing documentation, we get an understanding of your context around the subject of the workshop.
  • Delivery: Sharing the detailed knowledge-base in the context of your organization
  • Case-Examples: Where-ever applicable we use work-cases for reinforcing the subject, taking reference of your own projects.
  • Interactive situation-based discussions: We encourage the participants to discuss on how they apply the learnings in their own work-situations.

We provide a complete range of customized workshops on Enterprise Intelligence and DM, encompassing technology, people and processes for all levels in an organization. Here is the sample list of workshops.

We can transform your Enterprise Information & Intelligence Capabilities- Contact us for free and no-obligation Training Needs Analysis Session (bipmsales@ExecutionMiH.com)

List of Workshops - sample list

Awareness Workshops

Information Management – Top Management Imperatives
Managing your Enterprise Intelligence Agenda- Enterprise Intelligence Primer

Enterprise Intelligence Training Programs

Enterprise Intelligence & Data Warehouse Program Management
Enterprise Intelligence Competency Centre- Training Pack
Enterprise Intelligence & Dimensional Modeling
Data-Warehouse Design Fundamentals
Data-Warehouse Testing

Data Management Training Workshops

Data Quality Assurance Techniques- IT, Process, Business and People
Customer Data Quality
Customer Data Integration and Master Data Management
Metadata- Data about Data
Data Quality Program



Enterprise Information & Intelligence – Top Management Imperatives                                    GOTO TOP

This workshop transcends across vast range of subjects related to Enterprise Intelligence and Data Management. It cuts through the technical terms and explains the concepts to the audience, in a simple business language.

Training Workshop Agenda (Sample Listing)

Demystifying Enterprise Intelligence and Data Management

  • What is Enterprise Intelligence
  • What is Data Management
  • What is Master Data Management
  • What is Metadata Management
  • What is Enterprise Information Integration
  • MDM vs. Metadata vs. Enterprise Intelligence vs. Data Management vs. EII
  • ........

Business Value-Chain

  • Getting the right data
  • Generating right information
  • Generating right information at the right time at the right place
  • Using the information generated
  • Achieving business results by using the right information
  • ....

Topology and Components of Enterprise Intelligence

  • End-to-end view of an organization process and IT components
  • A graphical representation of how Enterprise Intelligence and DM overlay on these components
  • ...

Myths on Enterprise Intelligence and Data Management (what is the myth, what are the facts & breaking the myth)

  • Myth 1: Enterprise Intelligence and Data Management are Business subjects, with technology being an enabler
  • Myth 2: Technology is the constraint in Enterprise Intelligence
  • Myth 3: .....

Life Cycle of attaining Enterprise Intelligence maturity—How to get the best out of Enterprise Intelligence

  • Doing the basics right
  • Use the free stuff to test your Enterprise Intelligence
  • Functional Enterprise Intelligence- Data Marts
  • Functional Enterprise Intelligence- Data Warehouse
  • Enterprise Enterprise Intelligence
  • ...

Management Imperatives

  • Business case of Enterprise Intelligence & Data Management
  • Success Measures of Enterprise Intelligence and Rules of Success
  • Organization Capabilities
  • Sample Initiative
  • Your sponsorship role
  • ...

Audience: CXO and Direct Reports to CXOs
Training-Time: 5 hours- 1 day
Number of Workshop slides/pages- 42

We can transform your Enterprise Information & Intelligence Capabilities- Contact us for free and no-obligation Training Needs Analysis Session (bipmsales@ExecutionMiH.com)



Enterprise Intelligence Primer                                    GOTO TOP

This work-shop provides a basic grounding on the subject of Enterprise Intelligence, for middle and senior level managers

Training Workshop Agenda (Sample Listing)

Awareness

  • What is Enterprise Intelligence?
  • Business Case of Enterprise Intelligence
  • Organization Capabilities needed
  • Myths of Enterprise Intelligence and Breaking the Myths
  • Enterprise Intelligence is a business challenge
  • What defines a successful Enterprise Intelligence?
  • Rules of Successful Enterprise Intelligence
  • ...

Understanding

  • Components of Enterprise Intelligence
  • Enterprise Intelligence Architecture Scenarios
  • Enterprise Intelligence Competency Centre
  • How Enterprise Intelligence evolves overtime
  • ...

Management

  • High-level milestones of a Enterprise Intelligence initiative
  • Functional Responsibilities for Making Enterprise Intelligence happen
  • Your role as champion or owners of Enterprise Intelligence initiatives
  • Selecting Vendors and Tools for Enterprise Intelligence
  • Specific Tricks to achieve Enterprise Intelligence success
  • .....

Enterprise Intelligence Success Metrics

  • Project success metrics
  • Information Quality metrics
  • Information systems quality metrics
  • Individual Usage and Impact
  • Organization Impact Metrics
  • Operational Metrics

Audience: IT Managers, Enterprise Intelligence Managers, Business Owners of BI, BI Core Team
Training-Time: 6 hours- 1 day
Number of Workshop slides/pages- 51

We can transform your Enterprise Information & Intelligence Capabilities- Contact us for free and no-obligation Training Needs Analysis Session (bipmsales@ExecutionMiH.com)



BI and data warehouse Program Management                                    GOTO TOP

This workshop prepares the core team and project managers on driving/participating in a BI project

Training Workshop Agenda (Sample Listing)

BI Back-ground and setting the context

  • BI Architecture
  • BI Vendor management
  • BI Tools Selection
  • BI Rules of Engagement
  • .....

BI Success Metrics

  • Project success metrics
  • Information Quality metrics
  • Information systems quality metrics
  • Individual Usage and Impact
  • Organization Impact Metrics
  • Operational Metrics

BI Project Work-Break-Down Structure

  • BI project initiation
  • BI project definition
  • BI business requirement
  • BI modeling and analysis
  • BI Design
  • BI Testing
  • BI Implementation

BI Project Management Leadership

  • Do not be driven purely by Business Requirements
  • Fact-based Conflict Resolution
  • Understand the root-cause of BI project failures
  • Enterprise vs. Functional Hat
  • Communicate, Communicate, Communicate
  • ...

BI Project Management Skills

  • BI Project Organization Imperatives and typical examples
  • BI Project Management Skills
  • BI Requirements Management Skills
  • BI Modeling Skills
  • BI Designing and Architecture Skills
  • ...

Audience: Core team and the project manager (s), responsible for delivering to BI
Training-Time: 8 hours- 1 day
Number of Workshop slides/pages- 80

We can transform your Enterprise Information & Intelligence Capabilities- Contact us for free and no-obligation Training Needs Analysis Session (bipmsales@executionmih.com)



Enterprise Intelligence Competency Centre- training Pack                                    GOTO TOP

This is comprehensive training program for establishing a Enterprise Intelligence Competency Centre. It will include a combination of trainings (for different audience) related to different skills and knowledge to establish a holistic BICC.

The training pack includes:

  • BICC Awareness and understanding Workshop
  • BI Project Management Workshop
  • BI modeling and analysis Workshop
  • BI Design Workshop
  • BI testing Workshop
  • BI Operations Workshop
  • BI Governance Workshop
  • ...

Methodology and Frame-works

  • BI Tool Evaluation Kit
  • BI Project Management Kit
  • ......

As this is a complete training pack, the time, audience and workshop material will vary depending upon the level of sophistication of BICC and current state of skills.

We can transform your Enterprise Information & Intelligence Capabilities- Contact us for free and no-obligation Training Needs Analysis Session (bipmsales@executionmih.com)



Enterprise Intelligence Modeling and Analysis                                    GOTO TOP

This is a subject matter workshop for people who have to be deeply involved in analysis and design of BI platform. This is much less a technical subject and most of data modeling and business analysis domain. This is preferred both for business and IT members of BI team.

Training Workshop Agenda (Sample Listing)

What is Enterprise Intelligence Modeling different?

  • Why is a data-warehouse/data-mart needed?
  • Why data-warehouse/data-mart business requirements have to be managed differently
  • Why the BI modeling is different from transaction processing system
  • Dimensional modeling vs. Relational modeling
  • .....

What is Dimensional Modeling?

  • Dimensional Modeling Components- Fact tables, Dimension tables...
  • Dimensional Modeling Schemas- Star, Snowflake, Constellation
  • Slowly Changing Dimensions
  • Special Situations in Dimensional Modeling
  • Aggregate vs. Granular Dimensional Modeling
  • .......

Dimensional Model Imperatives and Best Practices

  • Foundation Dimensions
  • Foundation Attributes
  • Foundation Fact Tables
  • Foundation Measures...
  • Data Bus
  • .....

Dimensional Modeling Process

  • Data-Mart Business Theme Matrix
  • Data Mart Dimension Fact Table Matrix
  • .....

Dimensional Modeling Tips

  • Different tables for time dimensions
  • Keeping aggregate and granular tables separate
  • How to model the currencies and time zones
  • How to handle different units of measurements
  • .....

Dimensional Modeling Governance and Management

  • Version and Change Management
  • Using Metadata
  • Who should be Dimensional Modeling Champion?
  • ...........

Audience: BI modelers and BI designers
Training-Time: 16 hours- 2 day
Number of Workshop slides/pages- 150

We can transform your Enterprise Information & Intelligence Capabilities- Contact us for free and no-obligation Training Needs Analysis Session (bipmsales@executionmih.com)



Enterprise Intelligence Design Fundamentals                                    GOTO TOP

This workshop provides the fundamentals of BI design from a technology-independent practice. It provides an in-depth and conceptual understanding of designing BI capability.

Training Workshop Agenda (Sample Listing)

Design Components of a BI

  • Source System
  • Extraction
  • Transformation
  • Loading
  • Data-Warehouse Metadata
  • Data-Warehouse Quality Assurance
  • Data Warehouse job control and audit
  • Data Warehouse sharing and browsing
  • Data Warehouse Infrastructure
  • .....

Source System Design and Mapping

  • Type of Source Systems
  • Source Systems Mapping Design concept
  • Source system mapping process
  • ....

Extraction, Transformation & Loading Design

  • Reliable Resource
  • Extraction process assurance
  • Consistency, completeness quality
  • Design process and specifications
  • Integration
  • Standardization
  • Correction, Augmentation and Enrichment
  • ....

Front-end services Design

  • Access and Browsing
  • Publishing and Printing
  • Front-room Metadata design
  • ....

Back-end services design

  • Job Control and Audit
  • Data Quality Assurance
  • Back-end metadata

Infrastructure

  • Hardware
  • OS
  • Middle Ware
  • ....

Audience: BI designers & Architects, BI Modelers and IT Specialists
Training-Time: 15 hours- 2 day
Number of Workshop slides/pages- 143

We can transform your Enterprise Information & Intelligence Capabilities- Contact us for free and no-obligation Training Needs Analysis Session (bipmsales@executionmih.com)



Data-Warehouse Testing                                    GOTO TOP

Testing a data-warehouse/BI (like the other aspects of BI) requires a fairly different approach vis-à-vis transaction processing system. This workshop prepares IT and Business stakeholders on how to ‘optimally’ test data-warehouse/BI platform

Training Workshop Agenda (Sample Listing)

Why Data-Warehouse Testing is different?

  • Preparation Difference
  • Testing Cycles Difference
  • Unique Challenges
  • Difference in Managing Test Environments
  • ...

Data-warehouse Testing Strategy

  • Scope of Data-warehouse testing
  • Testing Strategy options and related scenarios
  • Factors influencing the testing strategy
  • Documenting the testing strategy
  • Risks to strategy and possible mitigations
  • ...

Data Warehouse Testing Scenarios

  • Real-Life Simple Scenarios
  • Complex Scenarios
  • Pure Data-Warehouse vs Data-Warehouse+ OLAP+ BI tools
  • Negative Testing
  • Production testing
  • ......

Data Warehouse Test-Data

  • How you can build smart test-data
  • Phased testing data evolution
  • Re-cycling test data
  • Using test-beds
  • ...

Data-Warehouse Testing Categories

  • Extraction, Transformation and Loading Testing
  • Front-End Services Testing
  • Back-end Services testing
  • Integration Testing
  • ...

Testing is science and an art

  • Judgment plays supreme
  • Heuristics on what to test and how much
  • Training and Development of testing team
  • Ground-Rules of Testing
  • .....

Audience: Business and IT Stakeholders for Testing
Training-Time: 8 hours- 1 day
Number of Workshop slides/pages- 72

We can transform your Enterprise Information & Intelligence Capabilities- Contact us for free and no-obligation Training Needs Analysis Session (bipmsales@executionmih.com)



Data Quality Assurance Techniques                                    GOTO TOP

This workshop goes through the details of how one can ensure good data-quality through robust processes, systems and business rules.

Training Workshop Agenda (Sample Listing)

Data Quality Fundaments

  • What is Data Quality
  • What is the impact of bad data-quality?
  • What are the reasons of bad data quality?
  • Data quality is relative
  • Master Data quality vs. Transactional Data Quality
  • Data Quality Assurance is not an IT subject
  • ...

Data Quality Assurance Techniques- Interface Controls

  • Data Integrity
  • File or Data-Group Integrity
  • Interface Controls in Integration Tools
  • Rationalizing your Interfaces
  • Interfacing with your partners
  • .....

Data Quality Assurance Techniques- Input Controls

  • Field drop-down controls
  • Form Level Controls
  • ....

Data Domain and Data Entity Relationship Controls

  • Data Standards
  • Data Domains
  • Optional/Null Handling
  • Insert, Delete and Update Rules
  • .....

Business Rules Definition

  • Completeness Rules
  • Consistency Rules
  • Accuracy Rules
  • ...

Business Process Control

  • Front-End Information and Instrument Capture
  • Customer Form Design
  • ...

Batch-Processing Controls

  • Pre and Post Checks Rules
  • Smart use of batch processing
  • Batch time window assurance
  • ....

Business Partner Interface Controls

  • Data Interchange Standards
  • Database to Database Monitoring
  • ...

Audience: Information Systems/Quality/Business Process Professionals
Training-Time: 8 hours- 1 day
Number of Workshop slides/pages- 68

We can transform your Enterprise Information & Intelligence Capabilities- Contact us for free and no-obligation Training Needs Analysis Session (bipmsales@executionmih.com)



Customer Data Quality                                    GOTO TOP

This workshop focuses on a subset of overall data quality domain- Customer Data Quality, which includes any legal entity or individual linked to an organization (Customer, Vendors, Business Partners, Sales Channel...)

Training Workshop Agenda (Sample Listing)

Customer Data Quality- Setting Context

  • What is Customer Data Quality?
  • Why Customer Data Quality is different from Transactional Data Quality?
  • Is customer data quality most important?
  • There are many different definitions of a customer
  • Impact of bad customer data quality
  • Challenges related to maintaining Customer Data Quality

Customer Data Variations

  • Name Variations
  • Address Variations
  • Phonetics variations
  • Cultural Variations
  • Character Variations
  • ....

Customer Data Searching and Matching

  • Parsing
  • Pattern Matching
  • N-Gram Indexing
  • Match Codes
  • Searching with Wild-Cards
  • ....

Customer Data Correction Techniques

  • De-duplication
  • Standardization
  • Pattern Standardization
  • Spelling correction
  • ....

Customer Data Augmentation and Enrichment

  • Customer Data House holding
  • Customer Data Derivation
  • Extrapolation and Best Guess
  • What to enrich and what not to enrich?- Purpose dependent
  • ...

Customer Data- People and Process Imperatives

  • Front-end data capture
  • Incentives and encouragement
  • Customer Data Champion
  • Data Steward
  • Vendor Engagement on Customer Data Quality
  • ............

Audience: CRM/Data Quality Professionals
Training-Time: 8 hours- 1 day
Number of Workshop slides/pages- 74

We can transform your Enterprise Information & Intelligence Capabilities- Contact us for free and no-obligation Training Needs Analysis Session (bipmsales@executionmih.com)



Master Data Management- Customer Data Integration                                    GOTO TOP

This workshop provides a detailed insight into Master Data Management as a subject. Master Data Management is also known as a synonym of Customer Data Integration.

Training Workshop Agenda (Sample Listing)

Master Data Management- Setting the Context

  • What is Master Data Management?
  • Is Master Data Management same as Customer Data Integration?
  • Why is Master Data Management Needed?
  • MDM is not an IT issue
  • MDM vs. BI vs. Metadata vs. Data Management vs. OLAP
  • ....

Master Data Management- Components

  • Data Quality
  • Standardization of presentation and storage
  • Single point of reference
  • Business Rules
  • Business Processes
  • ....

Master Data Management Architecture Principles

  • De-coupling
  • Flexibility
  • Business Requirements alignment
  • Open computing
  • Incremental implementation
  • ....

MDM-CDI Hub

  • Unique identifier
  • Persistent Style
  • Registry or virtual style
  • Transaction Hub
  • ...

MDM-CDI Usage Patters

  • Transaction Interception
  • Publish/Subscribe Pattern
  • Message Based Integration Pattern
  • MDM Information Synchronization
  • ...

Audience: Data Management Specialists/CRM Professionals
Training-Time: 8 hours- 1 day
Number of Workshop slides/pages- 78

We can transform your Enterprise Information & Intelligence Capabilities- Contact us for free and no-obligation Training Needs Analysis Session (bipmsales@executionmih.com)



Metadata – Data about Data                                    GOTO TOP

Metadata is most pervasive subject, as it touches the entire organization environment. Metadata is data about data and is a key vehicle for managing the data more effectively in systems and processes (including manual processes)

Training Workshop Agenda (Sample Listing)

Metadata Management- Setting the context

  • What is Metadata?
  • Why Metadata? Metadata objective and purpose
  • Technical Metadata
  • Business Metadata
  • MDM vs. Metadata vs. Enterprise Intelligence
  • ....

Metadata Standards

  • Imperatives of a Good Metadata Standard
  • Metadata Standards types
  • Metadata standards for design
  • Metadata Standards for Integration
  • ....

Metadata Architecture and Design

  • Metadata Architecture Design- Imperatives
  • Metadata Architecture Design Scenarios
  • Metadata Extraction Design
  • Metadata Transformation Design

Metadata Repository Project

  • Key imperatives of Metadata Repository Project
  • Metadata Repository Project Plan- Work-Break Down Structure
  • Building Metadata Model
  • Data Quality of Metadata Repository
  • ....

Evaluating Metadata Management Tools

  • Metadata Tools Architecture Features
  • Metadata Repository Sharing
  • Metadata Tools administration and security
  • Metadata tool change management
  • ...

Audience: Data Management/Enterprise Intelligence professionals
Time: 8 hours- 1 day
Number of Workshop slides/pages- 63

We can transform your Enterprise Information & Intelligence Capabilities- Contact us for free and no-obligation Training Needs Analysis Session (bipmsales@executionmih.com)



Data Quality Program                                    GOTO TOP

A Data Quality Program contains a set of initiatives, to achieve the Data Quality Agenda. These work-shops cover all stages of the Life Cycle of a Data Quality initiative.

Training Workshop Agenda (Sample Listing)

Data Quality Program- Setting the Context

  • What is Data Quality Program?
  • A Data Quality Program is not a Dedicated Program
  • Business Case for Data  Quality Program
  • Piggy-Backing
  • ....

Data Quality Program Initiation

  • Trigger points
  • Sponsor should be carefully selected
  • Under the surface  disturbances
  • Theory of concepts
  • ....

Data Quality Program- Data Mapping and Assessment

  • Scoping of Data Quality Mapping
  • Gap identification
  • Root Cause Analysis- Techniques and Tips
  • ....

Data Quality Program Approach and Planning

  • Key Considerations to Data Quality Program Approach
  • Identifying solutions and initiatives
  • Gap to Solutions Matrix
  • Prioritization of Data Quality Gaps and Solutions combination
  • Consolidation into well-defined initiatives
  • Prioritization of the initiatives
  • Plan of implementation
  • ...

Data Quality Frame-Work

  • Data Quality Policy
  • Data Quality Assurance
  • Data Quality Organization
  • Data Group Master
  • Project Level Data Quality Assurance
  • ....

Audience: Data Management/Quality/Business Process Management Professionals
Training-Time: 12 hours- 2 days
Number of Workshop slides/pages- 131

We can transform your Enterprise Information & Intelligence Capabilities- Contact us for free and no-obligation Training Needs Analysis Session (bipmsales@executionmih.com)