Adept Events
  • Home
  • Event Info
    • Customer service / FAQ
    • In-house Info
    • Online and Live Streaming
    • Sponsoring
    • Terms and Conditions
  • Speakers
  • Contact us
    • Contact us
    • 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
TYPE
Face-to-Face
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.

  • RT @BIplatform: Data Lakehouse: Marketing Hype of Nieuwe Architectuur? Leer alles erover in sessie van @rick_vanderlans op DW&BI Summit, 4…40 minutes ago
  • RT @BIplatform: Welk #datamodel past bij uw toepassing? Tanja Ubert bespreekt de meest voorkomende typen datamodellen en toepassingsgebiede…yesterday
  • RT @BIplatform: Learn the essence of #conceptmodelling, in this session Concept Modelling for Business Analysts by Alec Sharp @alecsharp DW…5 days ago
  • RT @BIplatform: A Data Strategy for Becoming Data Driven. In this seminar Nigel Turner @NigelTurner8 will teach how to produce a workable #…6 days ago

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

13-06-2023
Register now!

Agile Data Warehouse Design & Dimensional Modeling

Collaborative BI Requirements Analysis & Dimensional Modeling Training A 3-day dimensional modelling course presented internationally 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.

Lawrence Corr

 June 13-15, 2023

Utrecht

View

04-04-2023
On April 4 online seats still available

Data Warehousing & Business Intelligence Summit

[Room fully booked - On April 4 only online seats still available] Conference on Data Warehousing & Business Intelligence with top rated speakers Alec Sharp, Rick van der Lans, Thomas Frisendal, Nigel Turner, Mike Ferguson and others. Topics: Datamesh, Analytics & Data Science, Data Observability & Governance, Data modelling. Access to conference recordings.

Donald Farmer, Alec Sharp, acclaimed speakers

 April 4, 2023

Utrecht

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
BI-DWH | Big Data | Business Analysis | Congress | Data management | Half-day Tutorial | In-house only | Requirements workshops | Seminar | Workshop
© 2023 Array Media b.v. - All rights reserved | Privacy | Disclaimer