This 3-day interactive workshop combines the core content from two popular data modelling offerings by Alec Sharp – “Business Oriented Data Modelling” and “Advanced Data Modelling.” First, the workshop gets both new and experienced modellers to the same baseline on terminology, conventions, and the unique, business-engaging approaches this course provides. Next, it provides intense, hands-on practice with 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. 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

• Apply a variety of techniques that support the active participation and engagement of business professionals and subject matter experts;
• Use entity-relationship modelling to depict facts and rules about business entities at different levels of detail, including conceptual (overview) and logical (detailed) models;
• Learn an easy, language-oriented approach to initiating development of a data model;
• Recognise the four basic patterns in data modelling, and when to use them;
• Effectively use definitions and assertions (“rules”) as part of data modelling;
• Use an intuitive approach to data normalisation within an entity-relationship model;
• Apply various techniques for discovering and meeting additional requirements ;
• Read a data model, and communicate with specialists using the appropriate terminology.
• Understand “the four Ds of data modelling” – definition, dependency, demonstration, and detail;
• Be able to implement lists, trees, and networks with recursive relationships;
• Know how and when to use supertypes/subtypes (generalisation/specialisation) vs. roles vs. both;
• Combine subtyping and recursion, as appropriate, to model difficult rules;
• Recognise the “category vs. types vs. instances” problem, and model reference data properly;
• Model “vectors” (attibutes that repeat a fixed number of times) properly – entity or attribute?;
• Use complex associations and relationship constraints to handle complex rules;
• Handle circular relationships and cyclic dependencies properly with advanced normal forms;
• Model history, corrections, and time-dependent business rules with “temporal data models”;
• Understand the connection between analytic data structures (star schema or dimensional models) and ER models;
• Rapidly develop a first-cut dimensional model from a well-structured ER model;
• Prepare and deliver a data model review presentation.

Roles that are currently benefitting from this workshop include:
• Specialist data modellers, data architects, data analysts, and DBAs who wish to hone their skills.
• Business analysts, business architects, enterprise architects, and application architects
• Application / solution developers (especially on Agile teams)
• Business professionals, Subject Matter Experts, and Project / Programme Managers involved in the analysis, design, and development (or selection and configuration) of a system.
• BI (Business Intelligence) professionals, DW (Data Warehouse) professionals, big data specialists, data scientists, analytics specialists, and data lake implementers