Adept Events
  • Home
  • Event Info
    • Customer service / FAQ
    • In-house Info
    • Online and Live Streaming
    • Sponsoring
    • Terms and Conditions
  • Speakers
  • Contact us
    • Contact us
    • Customer service / FAQ
    • Call for speakers DW&BI Summit
    • About us
    • Newsletter
    • Materials upload
  • English
    • Dutch
Watch Video

Advanced Data Modelling

Communication, Consistency and Complexity

Date Price Contact
Only available as In-house Please request quote seminars@adeptevents.nl
+31 (0)172 742680
Location
In-house
TYPELanguage
Face-to-Face English spoken
Date Price
Only available as In-house Please request quote
Next Edition
Location Contact
In-house seminars@adeptevents.nl
+31 (0)172 742680
TYPE
Face-to-Face
Date
Only available as In-house
Price
Please request quote
Location
In-house
Contact
seminars@adeptevents.nl
+31 (0)172 742680
TYPE
Face-to-Face
  • Overview
  • Course description
  • Registration fee
  • Speakers
  • Venue

Advanced Data Modelling

Communication, Consistency and Complexity

After gaining some practical experience, data modelers encounter situations such as the enforcement of complex business rules, handling recurring patterns, dealing with existing databases or packaged applications, and other issues not covered in introductory data modelling classes.  This intense, participative workshop provides approaches for many advanced data modelling situations, as well as techniques for improving communication between data modelers, business analysts, designer/developers, and subject matter experts.
sharp_alec_dsc_0722_w1024

There are experienced data modelers out there who somehow develop accurate and stable models that are actually used, often in non-typical or high-pressure situations. They get the job done without wasted effort, maintain the involvement and respect of the subject matter experts, and – worst of all! – make it look easy. Others modelers might have great technical skills, but fare poorly, maintaining tense relationships with content experts and developers who “just don’t get it,” and watching in dismay as their models are continually undone by “new” requirements.

What accounts for the difference? Magic? Luck? Better tools? No – it’s having a concrete set of frameworks, methods, techniques, scripts, heuristics, and other tools that they draw on to keep the process moving, with everyone engaged, even when complex, difficult situations are encountered.  And that’s what we’ll cover in this full, but fun, two-day workshop – specific, repeatable techniques that you can use to drive your data modelling skills to the next level.

The workshop

The Business-Oriented Data Modelling workshop by Alec Sharp is always evaluated by the attendees with an overall rating of 9 or better.

Three main themes will be explored:

  1. The technical side of data modelling – getting better at modelling difficult, complex situations
  2. Developing and using data models in new ways, and in conjunction with other techniques
  3. The human side of data modelling – improving processes and communication skills

Topics will be covered with a discussion of the issue, a review of techniques, guidelines and examples, a brief workshop exercise, and a group solution and debriefing. The emphasis is on maximizing the delivery of content while keeping everyone engaged – the workshop has recently been extensively redesigned to focus on the topics that data modelling professionals have continually rated as the most concrete and useful.

Objectives

On workshop completion, participants will be able to spot various advanced situations (listed below in “Course Outline/Topics”) as they arise in their own modelling assignments, and deal with them efficiently and effectively.

Prerequisites

Practical experience with data modelling, for instance, attending our Data Modelling workshop by Alec and/or six months or more of applying the techniques.

Target Audience

Specialist data modelers, data architects, and DBAs who wish to hone their skills. Also business analysts, application developers, and anyone else with substantial data modelling experience who needs additional skills.

Course Topics

  • Level-setting on terms, concepts, conventions, and structures
  • Interesting structures –  generalisation and recursion
  • Preparing and delivering a data model review presentation
  • Modelling time, history, and time-dependent business rules
  • Modelling rules on relationships and associations
  • Working with higher-level models
  • Bridging the “E-R vs. Dimensional” divide – the world’s shortest course on dimensional modelling.

DAMA-I_logo_black

At the top of this page you can download the PDF brochure of this workshop.

 

Alec Sharp

Founder
Clariteq Systems Consulting
Alec Sharp, a senior consultant and acclaimed teacher with Clariteq Systems Consulting, has deep expertise in a rare combination of fields – business analysis and requirements specification, data modelling, strategy development, facilitation, and, of course, business process modelling, analysis and design.

Read more

Antoine Stelma

Lead Data Architect
Connected Data Group
Antoine Stelma co-founded Connected Data Group and is responsible for business innovation with Data & Analytic architectures. Antoine has an extensive background of 20 years in Enterprise Data Warehousing, specialising in Data Vault modeling, Data Virtualization and designing Data & Analytics platforms.

Read more

The seminars and workshops that we offer as In-house will take place right at your office. Well in advance we will discuss the room requirements, especially in the case of workshops. If your organisation has widely dispersed offices we can also decide to run the workshop in a venue of your choice that is centrally located.

testimonials

Broderick Roelf Data Engineer, De Nederlandsche Bank

“Easily the best ER modelling course I've ever encountered or read.”

Joris Huijser Application designer/developer, De Nederlandsche Bank

“Everything you always wanted to know about data modelling, but were afraid to ask.”

Astrid Tromp Information Analyst, Ministry of Justice

“Very inspiring, based on experience, covering all aspects multidimensional.”

Marsha Timp Information Analyst, Nippur

“I learned a lot! Alec is a great teacher who knows how to keep his student on track. He backs up his training material with 'real life' stories. This helps a lot.”

Juraj Cseh Data Analyst, Ministry of interior of the Slovak republic

“Great course, even for beginners such as me. I learned lots of new things during those 2 days, thanks to Alec's effective way of teaching.”

Joost Bekel Enterprise Architect, APG Asset Management

“Great content to put data modelling on the map within your organization.”

Thijs van der Feltz Enterprise Data Architect, APG Asset Management

“High quality workshop, that combines a refreshing mix of education, inspiration and active involvement to get the message across. Alec is very approachable and makes a compelling case for the importance of data modelling as a critical skill & discipline in designing (or selecting) fit-for-purpose information systems, and provides numerous tips & tricks to help convince management of this fact. Highly recommended!”

Dr. Cinzia Berrittella Data Modeller, NIBC Bank

“I am leaving this workshop with much clearer view on my job and the possible issues I may expect, and with a basket of solutions and options already at hand.”

Ton Raijmakers Data Architect, DLL

“Thanks Alec for inspiring us!”

In-house Info

Practically all of our seminars and workshops can be offered as an In-house course for your company exclusively. We can tailor with extra focus on specific topics that apply to your organization. Also available in online format or in face-to-face format with live video stream.

MORE INFO

RELATED EVENTS

03-11-2025
Practical workshop by Alec Sharp himself!

Business-oriented Data Modelling Masterclass

Balancing Engagement, Agility, and Complexity This data modelling workshop by Alec Sharp covers Entity-Relationship modelling from a non-technical perspective, provides tips and guidelines for the analyst, and explores contextual, conceptual, and detailed modelling techniques that maximize user involvement.

Alec Sharp

 November 3-5, 2025

Utrecht

View

19-05-2025
Hands-on workshop - register now!

Agile Data Warehouse Design & Dimensional Modeling

Collaborative BI Requirements Analysis & Dimensional Modeling Training A dimensional data modelling course presented by leading data warehousing expert and author Lawrence Corr, covering the latest agile techniques for systematically gathering Business Intelligence (BI) requirements and designing effective DW/BI systems. Based on 7W, star schema and BEAM approach.

Lawrence Corr

 May 19-21, 2025

Utrecht

View

17-11-2025
Prepare for your DAMA Fundamentals exam and register now!

Data Management Fundamentals

DMBoK2 and CDMP Workshop This course provides you with the knowledge, methods and techniques required to analyse, mature and implement information management solutions within your organisation. Additionally, this course by Winfried Etzel prepares for the CDMP Data Management Fundamentals (DMF) examination.

Winfried Adalbert Etzel

 November 17-19, 2025

Utrecht

View

BI-Platform

Business Intelligence, Data Warehousing, Big Data and Data Management Independent portal on Business Intelligence, Data Science & Analytics, Data Warehousing, Data Management and Big Data in The Netherlands. BI-Platform offers a wealth of content, such as blogs, interviews, videos, whitepapers and more.

View

Adept Events
KvK Den Haag: 56059825
E: seminars@adeptevents.nl
T: +31 (0)172 742680
M: +31 (0)6 113 118 60
W: www.adeptevents.nl

Release
www.release.nl
@Release_nl
Download the Release App

BI-Platform
www.biplatform.nl
@BIPlatform
Download the BI-Platform App

© Adept Events is a registered trademark of Array Media B.V.
Share to Twitter Share to Facebook Share to LinkedIn
© 2025 Array Media b.v. - All rights reserved | Privacy | Disclaimer