John Gray Data Modeling Workshops are recognized as the most comprehensive in the industry.
How to Choose Data Management Tools
30 June 2021
9.00 am -12.30 pm
Melbourne Business School, Carlton
For small to medium-sized organisations, the selection of data management tools and repositories can appear to be a daunting and expensive task. Making choices can be challenging, especially when you feel a lot hangs in the balance. What tools are required? Why do you need them? Who is going to use them? What is their value?
This workshop aims to demystify the decision making required around the selection of:
Included is the workshop there will be a demonstration of the Erwin toolset. At the end of this half-day workshop participants will understand:
Data modeling is about understanding the data used within our operational and analytics processes, documenting this knowledge in a precise form called the “data model”, and then validating this knowledge through communications with both business and IT stakeholders. Underlying all successful applications is a robust and precise data model, and similarly, most software development failures are due to a lack of understanding of the data or data requirements.
A data model is, therefore, an essential part of applications development including forward engineering, reverse engineering, and integration efforts. Forward engineering means focusing on business requirements, whereas reverse engineering means modeling existing systems to drive the support, replacement, or customization of applications. Integration projects such as business intelligence efforts, data lakes, and master data initiatives, require a consistent holistic view of concepts such as Customer, Account, and Product.
Data Modeling Fundamentals contains two days of practical techniques for producing conceptual, logical, and physical relational and dimensional and NoSQL data models. Two case studies and many exercises reinforce the material and will enable you to apply these techniques in your current projects.
Top 4 Objectives:
Assuming no prior knowledge of data modeling, we work on our first case study to illustrate four important gaps filled by data models. Next, we explore data modeling concepts and terminology, and with a set of questions. We quickly and precisely build a data model, explaining each component and gain practice reading business rules. We will complete several exercises, including creating a data model based upon an existing set of data.
You will be able to answer the following questions:
You will also learn these concepts, terms and skills:
The conceptual data model captures a business need within a well-defined scope, the logical data model captures the business solution, and the physical data model captures the technical solution. Relational, dimensional, and NoSQL techniques will be described at each of these three levels.
We will also practice building several data models, and you will be able to answer the following questions:
You will also learn these concepts, terms and skills:
For small to medium-sized organisations, the selection of data management tools and repositories can appear to be a daunting and expensive task. Making choices can be challenging, especially when you feel a lot hangs in the balance.
What tools are required? Why do you need them? Who is going to use them? What is their value?
This workshop aims to demystify the decision making required around the selection of:
Included is the workshop there will be a demonstration of the Erwin toolset.
At the end of this half-day workshop participants will understand:
Dr John Gray has 30 years of computing experience in across Australia and the UK in both industry and academia. Jon’s research interests have included parallel and distributed systems design, database technologies, information modelling, software engineering methods and tools, organisational capability development, and business process improvement.
From 2006, Jon led a research initiative for National ICT Australia Limited (NICTA) in Canberra focused on software methods and tools for the improvement of business processes in government. He then led Performance Assurance, a spin-out company from NICTA from 2017, specialising in predictive modeling and risk management. Jon is currently CEO & Chief Data Scientist for Catapult BI, a Dialog Group company.
Jon has led numerous consulting engagements with across the Australian Government as well as in the NSW and QLD Governments, and large corporations such as Commonwealth Bank of Australia, Telstra, Optus, and NBN Co. Jon has extensive experience in planning, designing, and evaluating Business Transformation initiatives including enterprise architecture and SOA, ISR information systems integration, cloud migration, data centre consolidation, application portfolio rationalisation, legacy infrastructure retirement, and mainframe migration.
Jon has published widely in many fields of software engineering, information systems, and computer science, and he is a frequent speaker at Australian and International conferences.
Workshop Times
Morning Tea is provided.
What should I bring?
Parking
Let’s keep in touch.