Alec Sharp
Clariteq Systems Consulting
This three-day interactive workshop combines the core content from two popular data modelling offerings by Alec Sharp – Business Oriented Data Modelling and Advanced Data Modelling. Suitable for both new and experienced modellers, this course first explores unique techniques for rapidly developing high-quality models while maintaining the involvement of business professionals. It then provides hands-on practice with skills in more challenging topics – generalisation, recursion, subtyping, modelling time and history, presenting models to non-technical groups, the connection between E-R modelling and dimensional modelling, and many more. In all cases, the underlying philosophy is that a data model is a description of a business, not of a database.
Three main themes are explored in a very practical way:
1. The foundations of data modelling – what a data model really is, and maximising its relevance
2. The human side of data modelling – improving communication skills and engaging the business
3. The complex side of data modelling – getting better at modelling difficult situations
After introducing entity-relationship modelling from a non-technical perspective, the basic components of a data model are thoroughly covered – entities, relationships, attributes, and rules. Practical tips, quality checklists, and warnings of common pitfalls are also shared. Through hands-on work, the workshop demonstrates why there is a global surge of interest in data modelling, especially conceptual data modelling or “concept modelling.” It also show how a concept model can be a great platform on which to develop application requirements (use cases and services) and to identify business processes.
A repeatable method for developing a data model is emphasised.
The first day of the workshop gets both new and experienced modellers to the same baseline on terminology, conventions, and the unique, business-friendly approaches this course provides. For the next two days, the course moves on to more advanced situations, such as the enforcement of complex business rules, handling recurring patterns, satisfying regulatory requirements to model time and history, capturing complex changes and corrections, dealing with existing databases or packaged applications, and integrating with dimensional modelling.
The Business-Oriented Data Modelling workshop by Alec Sharp is generally evaluated by the attendees with an overall rating of 9 or better.
On workshop completion, participants will be able to:
None, although an understanding of information systems concepts may be helpful.
Roles that are currently benefitting from this workshop include:
Members of the DAMA NL Dutch chapter as well as Belux or International chapter are eligible for ten percent discount.
At the top of this page you can download the PDF brochure of this workshop.
Van der Valk Hotel Utrecht
Winthontlaan 4-6
3526 KV Utrecht
Telefoon 030 8000 800
The hotel is very well accessible by public transport. From busstop ‘Kanaleneiland Zuid’ it is only a three-minute walk. You can take buses 63, 65, 66, 74 and 77 from Utrecht Central Station and you also take the tram line 20 or 21 from the train station and get off at stop ‘Kanaleneiland’. Please consult www.9292.nl (door-to-door journey planner, also available in English) or call 0900-9292 (travel advice by phone, € 0.70 p/m).
Van der Valk Hotel Utrecht is also located next to the highway A12, exit 17 (Utrecht / Jaarbeurs / Kanaleneiland).
Although the hotel has a large parking garage, we cannot guarantee parking spots. We therefore advise you to go by public transport.
For those who would like to arrive the day before, there is the possibility of staying at the Van der Valk Hotel Utrecht. However, the hotel does not provide special discounts for attendees of events. Therefore, when interested in an overnight stay, please consult Van der Valk directly to make a reservation.
More information about the hotel and the location can be found on their website www.vandervalkhotelutrecht.nl.
“Excellent training and trainer which I would highly recommend when you have to have a more indepth knowledge about data modelling.”
“Alec explained interesting and complex concepts of data modelling in a very interactive and indulging way that it is very hard to forget them :-).”
“Most interactive workshop I ever experienced.”
“Will never forget this, especially the moves.”
“Very clear course from an experienced speaker with many useful examples.”
“Great course, enjoyed it a lot and learned even more!”
“The course had a very high and immediate Return on Time Invested.”
“Very practical approach to data modeling and very business oriented. It was a great pleasure listening to Alec.”
“Using business language to model your business data is an absolute plus in this course. Alec is very energetic & knowledgeable.”
“Course that I will recommend to my colleagues and boss. Nice method and great clarity from great teacher!”
“Good masterclass with valuable examples which I directly can use in my work.”
“Business Data Modelling Course by Alec was informative and enjoyable. Alec provides a practical guidelines & best practices for representing business in terms of Conceptual Data Model and Logical Data Model.”
“Excellent introduction to data modeling. Alec Sharp is a fantastic trainer who can explain the course material in a way that everyone can understand. The training course introduces the basics of data modeling and evolves towards some more advanced data modeling topics near the end.”
“Focus on the business purpose with real examples made by an excellent speaker with actual experience.”
“Great workshop! Alec is an expert and knows how to teach in an easy and clear way.”
“Very active, well explained and presented course about Data Modelling!”
“The workshop gave an excellent view on data modelling and the speaker contains a lot of knowledge supported by real examples.”
“A great way of working is introduced that makes sure the business is never left out of data modelling. Alec Sharp is a great teacher.”
“Very complete data modelling course, since the basic concepts to more advanced topics. A lot of the content have practical immediate application.”
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.
How Concept Modelling Supports Process, Business Analysis and Architecture Work [Virtual half day] Alec Sharp illustrates the many ways concept models (conceptual data models) support business process change and business analysis. And Alec covers what a data professional needs to know on business processes. [Half day virtual delivery.]
November 7 - virtual half day
Your office or home office
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.
November 11 - 13, 2024
Utrecht
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.
December 2 -4, 2024
Utrecht
A Data Strategy for Success This seminar by Nigel Turner will outline the practical steps needed to produce an achievable data strategy and plan, and how to ensure that it becomes a living and agile blueprint for digital change.
November 21, 2024
Utrecht
Organizations need data science, self-service BI, embedded BI, edge analytics, and customer-driven BI. This seminar provides guidelines, roadmaps, design criteria, tips, design rules, use cases, case studies, and practical examples for developing a new future-proof data architecture.
November 26-27, 2024
Utrecht
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.