SEF-DAT7729 - Agile Data Integration

Course Description

Business analytics relies on the seamless integration of data to meet the ever-evolving needs of management and decision-making. In this course, you will acquire the skills to adeptly identify and comprehend data sources, requirements, methodologies, and roles. You'll also gain expertise in applying integration techniques and crafting and deploying integrated databases within an Agile environment.

The utilization of Agile development methodologies empowers data management professionals to swiftly deploy data solutions that align with rapidly changing business objectives, ensuring that valuable insights are readily available for informed decision-making.

Course Outline

Data Acquisition:

Intake Process: Identifying request type and deliverable type.

Ongoing data request
Process automation
Application/dashboard - workflow tools
Adhoc requests
Identify data sources/frequency

Data Quality:

Business Requirements: Understanding what the business is solving for.

Business Purpose/Partners
Business Requirements/Criteria
Success Measures
Application/Dashboard/Reporting Requirements
Data Staging

Data Integration:

Understanding the ETL process and Data Analytics as a part of the process.

Extract
Clean
Transform
Load
Staging/Analyze

Processes/Resources/Development: Including tools and technologies:

Agile and Scrum Framework: Set of principles for development and technical excellence.

Adaptable
Rapid
Collaborative
Team-Orientated
Quality Driven

The Scrum Process provides a structure for applying Agile principles.

Roles/responsibilities
- Product owner/Scrum master
- Team: Developers/QA
- Epics, user stories, points, backlog, and ceremonies.
Testing/Production Deployment:
- QA (Quality Assurance)
- UAT (User Acceptance Testing)

Learner Outcomes

At the end of this class, the student will:

Identify requests and deliverables for data acquisition.
Identify data sources.
Recognize business requirements for data integration projects.
Understand and apply integration techniques.
List and explain the principles of Agile.
Recognize and explain the Scrum process.

Notes

Target Audience: This class is intended for data business professionals to understand the data lifecycle within the company to achieve successful and agile data integration solutions.

Instruction Method: Lecture with demonstration, discussion, hands-on exercises, problem-solving, and outside assignments.

Evaluation: Participation and completion of skill practices are expected. Class attendance is required for successful completion.

Information Technology Continuing Education Certificate: This course is part of the Business Data Analytics Certificate. Certificates are awarded with the completion of all required courses (no substitutions). A certificate of completion for the class will be issued to participants with at least 80% attendance, class participation, and completion of hands-on practice and projects.

Prerequisites

DAT-7711 Data Fundamentals and SQL or equivalent knowledge.

Resources: Access to a Windows-based computer and reliable internet is required as well as a camera, a headset, and preferably dual monitors.

SEF-DAT7711 Data Fundamentals and SQL: In this class, you will learn how the relational database model enables easy access to information because it represents data intuitively. You will also learn to use SQL to retrieve data, execute queries, and create content.

Applies Towards the Following Certificates

Business Data Analytics Certificate : Business Data Analytics Certificate

This class is part of the Business Data Analytics Certificate.