Instructor led online courses available - click on the topics below to see content covered by the courses.DAta Governance & Data Stewardship
Data Governance and Data Stewardship - Online course details
Module 1.0: Data Governance and Stewardship Core Concepts Unit 1.1 Data Management and Data Governance Unit 1.2 Data Governance Business Drivers and Additional Concepts Module 2.0: Data Governance Program Overview Unit 2.1 Data Governance Scope and Organization Module 3.0: Data Governance Program Business Case Unit 3.1 Data Governance Program Business Case Unit 3.2 Data Governance Program Business Case Components and How to Build the Business Case Module 4.0: Data Governance Deployment Methodology: Part I Unit 4.1 Data Governance Program Methodology: Scope, Initiation, and Assessment Phases Unit 4.2 Vision, Alignment and Business Value Phases Module 5.0: Data Governance Program Deployment Methodology: Part II Unit 5.1 Functional Design and Governing Framework Design Unit 5.2 Road Map, and Rollout and Sustain Module 6.0:Data Stewardship Role Types, Basic Duties, Artifacts, and Tools Unit 6.1 Data Stewardship Role Types and Basic Duties Unit 6.2 Business Element Categories and Tools Module 7.0: Data Stewardship Activities: Data Architecture Focus and Data Development Focus Unit 7.1 Data Architecture Focus Unit 7.2 Data Development Focus Module 8.0: Data Stewardship Activities: Data Operations Focus and Data Security Focus Unit 8.1 Data Operations Focus Unit 8.2 Data Security Focus Module 9.0: Data Stewardship Activities: Data Integration and Interoperability Focus, and Document and Content Focus Unit 9.1 Data Integration and Interoperability Focus Unit 9.2 Document and Content Focus Module 10: Data Stewardship Activities: Reference and Master Data Management Focus and Data Warehousing / Business Intelligence Focus Unit 10.1 Reference and MDM Focus Unit 10.2 Data Warehousing and Business Intelligence Focus Module 11: Data Stewardship Activities; Metadata and Data Quality Focus Unit 11.1 Metadata Focus Unit 11.2 Data Quality Focus Module 12: Additional Data Governance and Stewardship Considerations Unit 12.1 Emerging Trend: Big Data Focus Unit 12.2 More Data Governance Trends (Data Lake, Cloud, Data Science, ML, AI) Data Governance Certification Focus 1.0 Data Governance Concepts, Business Drivers and Roles 1.1 Concepts and Definitions 1.2 Business Drivers and Organizational Awareness 2.0 Data Governance and Stewardship Roles 2.1 Data Governance Roles and Organizations 2.2 Data Stewardship Roles 3.0 Data Governance Inputs and Deliverables 3.1 Inputs 3.2 Primary Deliverables 4.0 Data Governance Function 4.1 Data Governance Capabilities Assessment 4.2 Data Governance Function Activities 4.3 Data Governance Ethics 5.0 Fundamental Knowledge Areas for Data Stewardship Activities 5.1 Enterprise Data Architecture Management 5.2 Data Development 5.3 Data Operations Management 5.4 Data Security Management 5.5 Meta-data Management 5.6 Reference and Master Data Management 5.7 Data Warehousing and Business Intelligence 5.8 Document and Content Management 5.9 Data Quality Management DAta Foundations - Workplace data literacy
Data Foundations Exam Outline 1. Data, Information & Knowledge (3%) 2. Describing, Understanding & Managing Data (35%) 3. Data Roles: (4%) 4. Data Models and Relationships (18%) 5. Data Value and Quality (4%) 6. Data Access, Storage, Protection & Security (6%) 7. Data Atrophy, Renewal and Removal, Distribution (2%) 8. Data Uses (Historical, legal...) (6%) 9. Data Storage Technologies and purposes: (4%) 10. Evolving Business and Data Analytics (Tools) (12%) 11. Corporate mergers, data integration (5%) 12. Data Strategy & Planning (4%) 13. Document and Record Management (2%) Data Modeling and design (Data Development)
1.0 Data Development Concepts and Technology Types (17) 1.1 Concepts (12) D3 1.1.1 Terms · Data development within the Systems Development Life Cycle (SDLC) · Conceptual model · Logical model · Object model · Physical model · Physical design · Model purposes 1.1.2 Data Modeling Notations · Barker · Entity-relationship modeling · Information Engineering (IE) · IDEF1X · Unified Modeling Language (UML) · Natural Language / Structured English · Business Rules · Other Notations (e.g., file, column, graph, data vault, anchor, MDM Modeling, graph modeling, node relationship) 1.2 Tools and Technology Types (5) D3 1.2.1 Data Development · Database Management Systems o Relational o Hierarchical o Inverted list o Network o Object-oriented o Multi-dimensional · Data modeling tools · Database utilities 1.2.2 Metadata & Descriptive Information · Data dictionaries · Data directories · Data encyclopedias · Metadata registries (e.g. ISO/IEC 11179) · Metadata repositories 1.2.3 Data Issues · Business intelligence technologies (OLAP, Data Mining, etc.) · Data management and the Internet / Intranet · Data management and unstructured data 2.0 Data Analysis and Design (60) Section 2 Total 2.1 Analyzing Information Requirements (3) D4 2.1.1 Fact Finding Techniques · Interviewing · Surveys, questionnaires · JAD sessions · Legacy systems analysis / profiling 2.1.2 Requirements Definition and Management · Evaluation of current environment and documentation · Future state · Gap analysis · Business rules (discovery, validation and documentation) · Data / process matrices · Requirements tracking and management to implementation 2.2 Data Model / Design Components (57) D4 2.2.1 Enterprise Data Model · Subject area · Enterprise logical data model · Other enterprise data model components · Alignment with other business models 2.2.2 Conceptual / Logical Data Model · Entity and entity type, e.g. supertype/subtype · Relationship type · Attributes and their roles · Definitions · Key · Cardinality · Optionality · Domain · Metadata type · Rules: Business / data integrity · Normalization 2.2.3 Dimensional Warehouse Model · Fact · Dimension 2.2.4 Object Oriented / UML · Object · Class 2.2.5 Physical Model / Design (DBA3.1.4) · De-normalization · Column · Row · View · Trigger / stored procedure · Performance: e.g. logical access model, index design · Partitioning and replication · Dimension · Derived field · Physical design: e.g. iterative or sub-type / supertype options; partial inheritance, space and growth calculations 2.2.6 Other physical models · File based · Column based · Document based · Graph DB 3.0 Related Data Designs (7) Section 3 Total 3.1 Information Product Designs (7) D4 3.1.1 Application Screens and Reports · Business data terminology · Metadata for context 3.1.2 Other Information Products · Reporting and analysis services · Dashboards · Scorecards 4.0 Data Model and Design Quality Management (10) 4.1 Data Model Design Standards, Versioning and Integration (7) D3 4.1.1 Types of Standards · Deliverables description · Standard names, acceptable abbreviations, abbreviation rules · Standard naming formats · Meta-data · Guidelines on how to use data modeling tools · Guidelines for preparing and leading design reviews 4.1.2 Data Model Versioning and Integration · Change control on model and other design specifications 4.2 Data Model / Database Design Reviews (3) D3 4.2.1 Types · Conceptual / logical model review · Physical design review · Application code review 4.2.2 Data Model Validation · Validation of the application purpose · Review of new design documentation for adherence to standards o Logical model review and artifacts o Physical model review and artifacts · Review of design changes to production databases 5.0 Data Implementation (6) 5.1 Database Development and Testing (6) D4 5.1.1 Information Requirements Validation 5.1.2 Change control for data model Information Systems Core (ACM - AIS Model Curriculum)
1.0 Information Systems (20%) (D3) Organizational Role, Business Drivers, Strategy, Structure, Acquisition & Management 1.1 The Role of IS in the Organization 1.2 Business Drivers and Information Systems Valuation 1.3 Structuring the IS Organization 1.4 Acquiring Information Technology Resources and Capabilities (In-house Development, External Acquisition, or Outsourcing) 1.5 Information Systems Technology Components and System Types 2.0 Data and Information Management (15%) D3 This section covers the core concepts in data and information management using conceptual data modeling techniques. This section also includes coverage of basic database administration tasks and key concepts of data quality and data security. 2.1 Data Management 2.2 Data Governance 2.3 Data Modeling 2.4 Meta-data Management 2.5 Data Quality Management 2.6 Data Security Management 2.7 Database Approach 3.0 Enterprise Architecture (15%) D3 This section covers the design, selection, implementation and management of enterprise IT solutions. The focus is on frameworks and strategies for infrastructure management, system administration, data/information architecture, content management, distributed computing, middleware, legacy system integration, system consolidation, software selection, total cost of ownership calculation, IT investment analysis, and emerging technologies. 3.1 Enterprise Architecture Types and Structures 3.2 Enterprise Architecture Frameworks, Methodologies, and Measurements 4.0 IT Infrastructure (15%) D3 This section covers topics related to both computer and systems architecture and communication networks, with an overall focus on the services and capabilities that IT infrastructure solutions enable in an organizational context. 4.1 Systems Concepts 4.2 Operating Systems 4.3 Networking 4.5 IT Control and Service Management Frameworks (COBIT, ITIL, etc.) 4.6 Managing IT Infrastructure and Business continuity 5.0 IS Project Management (15%) D3 Project management in the modern organization is a complex team-based activity, where various types of technologies (including project management software as well as software to support group collaboration) are an inherent part of the project management process. This section focuses on a systematic methodology for initiating, planning, executing, controlling, and closing projects. 5.1 Introduction to Project Management 5.2 The Project Management Lifecycle 5.3 Managing Project Teams 5.4 Project Initiation and Planning 5.5 Managing Project Scheduling 5.6 Managing Project Resources 5.7 Managing Project Quality and Risk 5.8 Systems Procurement 5.9 Project Execution, Control and Closure 6.0 Systems Analysis & Design (15%) D3 This section focuses on a systematic methodology for analyzing a business problem or opportunity, determining what role, if any, computer-based technologies can play in addressing the business need, articulating business requirements for the technology solution, specifying alternative approaches to acquiring the technology capabilities needed to address the business requirements, and specifying the requirements for an information systems solution. 6.1 Business Process Management 6.2 Structuring of IT-based Opportunities into Projects 6.3 Analysis and Specification of System Requirements 6.4 Implementation Strategies DAta Management Fundamentals (Prepare for your CDMP fundamentals exam or CDP)
Data Management - Certification Focus (Follows the Data Management Body of Knowledge V2) 1.0. Data Management Process 1.1 Concepts 1.2 Data Roles 2.0 Data Governance Function 2.1 Data Management Planning 2.2 Data Management Control 3.0 Data Architecture Management Function 3.1 Architecture Overview 3.2 Enterprise Architecture Types & Techniques 4.0 Data Development Function 4.1 Analyzing Data / Information Requirements 4.2 Data Model Component Management and Data Implementation 5.0 Data Operations Management Function 5.1 Database Support 5.2 Data Technology Management 6.0 Data Security Management Function 6.1 Data Security Principles 6.2 Data Security Implementation 7.0 Reference and Master Data Management Function 7.1 Reference Data 7.2 Master Data Management 8.0 Data Warehousing and Business Intelligence Management Function 8.1 Data Warehousing 8.2 Business Intelligence 9.0 Document and Content Management Function 9.1 Document / Records Management 9.2 Content Management 10.0 Meta-data Management Function 10.1 Meta-data Concepts 10.2 Meta-data Management Implementation 11.0 Data Quality Management Function 11.1 Data & Information Quality Principles 11.2 Data & Information Quality Profiling / Assessment / Audit 11.3 Data & Information Quality Improvement Business intelligence & Data Analytics
Online Course Focus: Business Intelligence & Data Analytics Module 1: BI Concepts Module 2: BI Current State Considerations Module 3: Infrastructures and Tool Functional Areas Module 4: BI and Data Management Module 5: BI and Organizational Roles Module 6: Corporate Performance Management Module 7: Inputs for Decision Making Module 8: Analytics Techniques Module 9: BI Justification Module 10: Evaluation and Selection of a BI Platform and Tool Module 11: BI Solution Lifecycle Module 12: Additional areas for BI Consideration Textbook: The New Era of Enterprise Business Intelligence: Using Analytics to Achieve a Global Competitive Advantage by Mike Biere, IBM Press, 2011. ISBN-10: 0-13-707542-3, ISBN-13: 978-0-13-707542-3 available through www.amazon.com. Instructor-Led, group study-paced learning, Course Start Dates:
January 19 June 17 September 20 Self Study Courses: Start any time, finish any time. Ideal for experienced Data Professionals |
12 Module Courses (12 week)
Self Study: $595 (Self Paced, Self-Study with email learner support (for 6 weeks), Each module has a pre-test and post-test quizzes, module questions for weekly work and a weekly study guide) Instructor-Led: $1295 (Cohort Paced, 12 week program, one hour/once per week live discussion and Q&A - approximately 4-6 hours/week study time requirement). Instructor-Led, group study-paced learning, Course Start Dates:
January 19 June 17 September 20 Self Study Courses: Start any time, finish any time. Ideal for experienced Data Professionals To register for the Online course or self study program:
purchase the course from the DAMA Edmonton Store and you will receive an email with the website, user name and password within 48 hours of payment. Certification Examinations: call 1.800.843.8227 to schedule a date and time to take the Data Governance and Stewardship Professional examination or any of the other Certification Examinations: You can also email: damaedmonton@gmail.com with your preferred dates for an online proctored examination. |