Agile BI: Just Enough Design, Data Modeling with Agility, Canada

We can host this training at your preferred location. Contact us!

Agilists criticize the “big design up front” (BDUF) nature of plan-driven development. Uncertainty early in a project makes BDUF costly and risky. However, the avoidance of BDUF is sometimes misconstrued to mean “no design up front,” which leads to poor quality and high technical debt. Experienced agilists know that what is truly needed is sufficient design up front (SDUF)—enough to galvanize developers around a shared understanding of the problem domain, architecture, and data models. This course introduces an agile modeling approach that strikes the sufficient-up-front and just-in-time balance.

There are no prerequisites for this course.

Data warehouse architects, designers, developers, and administrators
Business intelligence practitioners
Business analysts and product owners

Agile modeling values and principles
Techniques for determining the right level of up-front design
How to avoid overbuilding solutions by designing for what is needed
Domain modeling
Data model patterns
Data smells and the impact of technical debt
Continuous integration
Safe refactoring techniques for making incremental design changes
How to determine the right level of design documentation that is needed
Effective collaborative modeling practices for cross-functional teams
How to minimize the amount of unnecessary rework through reference and conceptual designs
How to establish iteration zero as an agile practice that gives teams the runway to start delivering

1. Introduction

Agile Overview
Benefits of Evolutionary Design

2. Agile Modeling Mindset

The Challenge
Purpose of Modeling
Agile Modeling Goals
Modeling in the Agile Project Management Lifecycle
Agile Modeling Guiding Principles

3. Agile Documentation

Why, When and What to Document
Creating Self-Evident Implementations
Documenting with a clear purpose for the right audience
Minimally sufficient documentation
Negative Value Documentation and Document End of Life

4. Domain Modeling

Why, When and Who
Story-Gathering Process
Defining and Refining user roles
User Personas
Domain Modeling Exercise

5. Use Cases and User Stories

Why, When and Who
Use Cases
User Stories
Use Case Exercise

6. Sufficient Design Up Front

How Buildings Learn
Iteration Zero
Conceptual Data Modeling
Establishing Test Automation
Continuous Integration Infrastructure
Sufficient Design Guiding Principles

7. Data Model Patterns

What is a Pattern?
Pattern References
Why Use Patterns?
Drawbacks of Patterns
Patterns, Seed Models, and Archetypes

8. Technical Debt

Overview
Design and Technical Debt
Indicators of Technical Debt
Prioritizing Debt
Technical Debt exercise

9. Database Refactoring

What is Refactoring?
Refactoring Categories
How Refactoring Works
Preparing to Refactor
How to Refactor

10. Agile Modeling with Data Vault

Complexity of Changeb
Introduction to Data Vault
Hubs, Satellites and Links
Data Vault example
Data Vault Strength: Adapting to Change
Data Vault Principles
Why is Data Vault agile?
Data Vault Exercise

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Upcoming Trainings

Join our public courses in our Canada facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

14 January 2025 (1 Day)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

17 January 2025 (1 Day)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

14 January 2025 (1 Day)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

17 January 2025 (1 Day)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

01 March 2025 (1 Day)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

17 March 2025 (1 Day)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

01 March 2025 (1 Day)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

05 April 2025 (1 Day)
Toronto, Montreal, Calgary
Classroom / Virtual Classroom

Agile BI: Just Enough Design, Data Modeling with Agility Training Course in Canada

Canada is a North American country. Known as the second-largest country of the world, Canada’s capital city is Ottawa. Toronto, Vancouver and Montreal are the biggest and most popular cities of this country. The 8,891-kilometer southern and western border between Canada and the United States is the world's longest intergovernmental land border. This country also has the longest coastline in the world.

Canada is a constitutional monarchy. The country was originally a British Empire colony and is now a part of the British Commonwealth. Both French and English are Canada’s official languages. Canada’s national animal is a beaver and the its flag design is a vertical triband of red and white with a red maple leaf charged in the centre. Some of the top-rated tourist attractions in Canada are Niagara Falls, Banff National Park and Rocky Mountains, CN Tower in Toronto City, Bay of Fundy, Old Quebec (Vieux-Quebec in French), the ski resort of Whistler, Ottawa's Parliament Hill and Vancouver Island.

Choose from our extensive selection of IT courses, covering programming, data analytics, software development, business skills, cloud computing, cybersecurity, project management. Our highly skilled instructors will deliver hands-on training and valuable insights at a location of your choice within Canada.

Agile BI: Just Enough Design, Data Modeling with Agility Training in Canada

Prerequisites

Who Should Attend

What You Will Learn

Outline

6 IMPORTANT TIPS FOR AGILE COACHES IN 2021

Upcoming Trainings