UK flag UK
+44 (0) 207 874 5000
+44 (0) 207 874 5000

Mastering Data Stewardship: Hands-On

Course 1287

  • Duration: 3 days
  • Language: English
  • Level: Foundation

Unlock the power of data with our intensive 3-day Data Steward course. Designed for data professionals, this hands-on program covers essential topics such as Data Management, Data Governance, Data Analytics, Data Modelling, and Modern Data Architecture.

Gain practical experience through real-world exercises and learn to leverage industry standards, best practices, and cutting-edge technologies. This course will equip you with the skills and knowledge necessary to effectively manage and govern your organization's data assets.

Mastering Data Stewardship Training Delivery Methods

  • In-Person

  • Online

  • Upskill your whole team by bringing Private Team Training to your facility.

Mastering Data Stewardship Training Course Information

In this course, you will:

  • Dive deep into data fundamentals, management, governance, analytics, modelling, and architecture.
  • Apply your knowledge with practical exercises using common data storage, analytics, and modelling services.
  • Learn the latest standards, processes, and technologies from experienced instructors.
  • Enhance your skills and advance your career as a data professional with roles like Data Architect, Data Engineer, and Data Modeler.
  • Understand the policies, procedures, and roles critical for managing data security, integrity, and compliance.
  • Stay current with scalable data lakes, purpose-built analytics services, and unified data access and governance solutions.

Training Prerequisites

  • Attendees should understand the basic concepts of data management, core data services and technologies, and how the cloud can be used for data management.
  • Experience with Microsoft Azure Portal would be beneficial.

Mastering Data Stewardship Training Outline

Data Overview

Databases

Data Lakes

Data Warehouses

Data Analytics

Machine Learning and Artificial Intelligence

Business Insights

Data Management Overview

  • Collecting, storing, securing, and using an organization’s data
  • Data quality management
  • Data distribution and consistency
  • Big data management
  • Data architecture and data modeling

Data Management Organizations

  • Data Management Association (DAMA)

Data Management Roles and Responsibilities

  • Data Architect
  • Data Engineer
  • Data Modeler

Data Management Processes

Data Management Workflow

  • Data Collection
  • Data Processing
  • Data Distribution
  • Data Discovery
  • Data Analysis
  • Data Archiving
  • Repurposing

Data Management Services and Applications

Creating a Data Management Plan

Data Analytics Overview

Data Analytics Process

  • Data collection
  • Data storage
  • Data processing
  • Data cleansing
  • Data analysis

Data collection

  • Extract Transform Load (ETL)
  • Extract Load Transform (ELT)

Data storage

  • Data warehouses
  • Data lakes
  • Comparing data lakes and data warehouses

Data processing

  • Centralized processing
  • Distributed processing
  • Batch processing
  • Real-time processing
  • Data cleansing
  • Data analysis

Data Analytics

  • Descriptive analytics
  • Diagnostic analytics
  • Predictive analytics
  • Prescriptive analytics

Computing techniques used in data analytics

  • Natural language processing
  • Text mining
  • Sensor data analysis
  • Outlier analysis

Data Modelling Overview

Conceptual Data Models: Big picture view of data

  • What data a system contains
  • Data attributes and conditions or constraints on data
  • What business rules data relates to
  • How data is best organized
  • Security and data integrity requirements

Logical Data Models: Mapping conceptual data classes to technical data structures

  • Data types of various attributes
  • Relationships between data entities
  • Primary attributes or key fields in data

Physical Data Models: Mapping logical data models to a DBMS

  • Data field types as represented in a DBMS
  • Data relationships as represented in a DBMS
  • Performance tuning

Data Modeling Techniques

  • Hierarchical data modeling
  • Graph data modeling
  • Relational data modeling
  • Entity-relationship data modeling
  • Object-oriented data modeling
  • Dimensional data modeling

Data Modeling Process

  • Overview
  • Identify entities and properties
  • Identify relationships between entities
  • Identify data modeling technique
  • Optimize and iterate

Modern Data Architecture Overview

Scalable Data Lakes

Purpose-Built Analytics Services

Unified Data Access

Unified Data Governance

Data Governance Overview

  • Policies and procedures an organization implements to manage data security, integrity, and responsible data use
  • Regulatory compliance
  • Data security and access control

Data Governance Organizations

  • Data Governance Institute

Data Governance Roles and Responsibilities

  • Data Governance Council/Data Administrator
  • Data Steward
  • Data Custodian
  1. Hands-on Exercise: Creating a Data Lake
  2. Hands-on Exercise: Collecting Data with Extract Transform Load (ETL)
  3. Hands-on Exercise: Performing Data Cleansing
  4. Hands-on Exercise: Performing Data Analytics
  5. Hands-on Exercise: Implementing the Data Modelling Process
  6. Hands-on Exercise: Creating Conceptual Data Models
  7. Hands-on Exercise: Creating Logical Data Models
  8. Hands-on Exercise: Creating Physical Data Models
  9. Hands-on Exercise: Examining Data Modeling Techniques
  10. Hands-on Exercise: Examining the Data Modeling Process
Get This Course £1,780 For Team Prices Call: 44 (0) 207 874 5000

  • 3-Day Instructor-Led Training

  • Hands-on Labs

  • After-Course Instructor Coaching Included

  • Available for Private Team Training

Get the Advantage £3,150
  • Take this course and gain unlimited access to more than 300 virtual instructor-led courses
  • Future-proof your career with more than 100 sought-after certifications in the market
  • Build real skills through hands-on learning in more than 180 virtual labs
  • Grow your skills and capabilities with more than one course at a time and save
Thank you for choosing subscriptions!
#1287
  • Feb 12 - 14 9:00 AM - 4:30 PM GMT
    London or Virtual
  • Mar 5 - 7 2:00 PM - 9:30 PM GMT
    Ottawa or Virtual
  • Mar 26 - 28 9:00 AM - 4:30 PM GMT
    London or Virtual
  • Apr 23 - 25 2:00 PM - 9:30 PM BST
    Herndon, VA or Virtual
  • May 14 - 16 9:00 AM - 4:30 PM BST
    London or Virtual
  • Jun 4 - 6 2:00 PM - 9:30 PM BST
    Ottawa or Virtual
  • Jun 25 - 27 9:00 AM - 4:30 PM BST
    London or Virtual
  • Jul 23 - 25 2:00 PM - 9:30 PM BST
    Herndon, VA or Virtual
  • Aug 13 - 15 9:00 AM - 4:30 PM BST
    London or Virtual
  • Sep 3 - 5 2:00 PM - 9:30 PM BST
    Ottawa or Virtual
  • Sep 24 - 26 9:00 AM - 4:30 PM BST
    London or Virtual
  • Nov 12 - 14 9:00 AM - 4:30 PM GMT
    London or Virtual
  • Dec 17 - 19 9:00 AM - 4:30 PM GMT
    London or Virtual

Scroll to view additional course dates

  • Bring this or any training to your organization

  • Full-scale program development

  • Delivered when, where, and how you want it

  • Blended learning models

  • Tailored content

  • Expert team coaching

Get the Advantage £3,150
  • Take this course and gain unlimited access to more than 300 virtual instructor-led courses
  • Future-proof your career with more than 100 sought-after certifications in the market
  • Build real skills through hands-on learning in more than 180 virtual labs
  • Grow your skills and capabilities with more than one course at a time and save
Thank you for choosing subscriptions!
#1287
Questions about this course?
* Required Fields
Customise Your Team Training Experience

Fill out the form below or call 44 (0) 207 874 5000

* Required Fields
Preferred method of contact:

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Contact Us

Mastering Data Stewardship Training FAQs

This course is designed for data professionals including Data Stewards, Data Architects, Data Engineers, Data Analysts, Data Modelers, IT Managers, Business Intelligence Professionals, and Compliance Officers. It is also suitable for anyone looking to advance their career in data management, governance, and analytics.

Basic understanding of data concepts and familiarity with data storage and processing technologies are recommended but not mandatory. The course will cover foundational topics before advancing to more complex material.

You will gain a comprehensive understanding of data fundamentals, Data Management, Data Governance, Data Analytics, Data Modelling, and Modern Data Architecture. You will also acquire hands-on experience through practical exercises using common data services and technologies.

The course includes practical exercises such as creating a data lake, performing ETL processes, data cleansing, data analytics, implementing data modelling processes, and examining various data modelling techniques.

Yes, we offer customized training solutions tailored to meet the specific needs of your organization. Please contact us for more information on bespoke training options.

Related Courses

  • Learning Tree
    Introduction to Data Literacy Training

    Learn to use and communicate data effectively with our Data Literacy Training. No prerequisites. Join professionals from all fields.

    Foundation
    2 days
    Online or In-class
    Starts from £1,490
  • Learning Tree
    Introduction to AI, Data Science & Machine Learning with Python

    This AI ML Data Science Python course teaches you how to use Python libraries to build, evaluate, & deploy Machine Learning & Artificial Intelligence models.

    Foundation
    5 days
    Online or In-class
    Starts from £2,830
  • Learning Tree
    Fundamentals of Statistics for Data Science Training

    Learn data analysis tools & R environment to draw conclusions. Get hands-on Fundamentals of Statistics training for Data Science.

    Foundation
    2 days
    Online or In-class
    Starts from £1,255
  • Learning Tree
    Introduction to Data Analytics

    This Data Analytics Introduction provides a clear understanding of data analytics's purpose, tools, and techniques.

    Foundation
    3 days
    Online or In-class
    Starts from £1,540