This is not just a database design course, but covers concept modeling with business people, architecture-type modeling, and extensive, enterprise-level data modeling. Extensive modeling can also be done quickly and efficiently – with the right methods and organization.
Ari Hovi and his team have developed a unique method for this – the Hovi Data Framework, which models business information quickly and as comprehensively as possible. It creates a common language between the internal IT, data professional, consultant and business. Utilizing it will greatly increase the probability of projects succeeding.
The exercises in the courses use the easy-to-use Ellie modeling tool we developed that works in the cloud. This further enhances learning through practice.
The course covers a wide range of concepts and data modeling in different areas: business data modeling, modeling required in data architecture, modeling leading to a database, and in brief also modeling methods related to data warehousing. Includes universal concept models developed by Ari Hovi to speed up modeling.
Data modeling, or conceptual analysis and description, are important methods and are needed in many different information management processes. It is necessary to describe top-level business-oriented overall models, more specific application-specific models, and the models needed for database design. Thus, models are developed for many purposes and it is important to be able to create accurate and also top-level overall models. We also deal with unstructured, Big Data modeling.
Modeling produces data or concept models. But moreover, modeling is at its best a synergy collaboration where participants share their views, learn and – what is important – commit to the project. Modeling defines important concepts, creating a common language and vocabulary between different parties, at best across organizational boundaries.
To whom this course is suitable:
The course is suitable for architects, those involved in modeling, project managers and supervisors. The course is also important for individuals who read or apply models already made, such as application designers, programmers, and ETL and report implementers. No prior information requirements.
Training times:
9: 00-16: 15
The structure of the course:
In the course, we will become familiar with the many description methods and methods of modeling and provide practical guidance on both top-level “helicopter image” models and accurate models and specifications. We also review the data warehousing area modeling methods for EDW stock design (including the introduction of the Data Vault model) and the principles of star model design. Plenty of hands-on exercises and examples deepen learning.
Modeling background
– Why conceptual modeling is essential
– Areas of modeling
– ER modeling (concept analysis), Object Oriented Modeling (UML)
– How to get results faster
Modeling steps
– Modeling at different levels of the organization, e.g. enterprise and application level
– Top down vs. bottom up
– The role of modeling in Information Architecture
– Description of steps
– Connection of conceptual models to relational strains
ER modeling (concept analysis)
– The “mentality” of the modeler
– Elements of modeling
– Finding and defining concepts
– Infrastructure
– Complex structures
– Basic key considerations
– Writing definitions
Practical instructions
– Tools (CASE tools, wall technology), Ellie tool
– Conducting modeling sessions with users
– Extensive modeling, planar modeling
– How to get business people and substance experts involved
Other methods
– Needs analysis
– Normalization
Different target areas
– Enterprise level modeling
– Court Universal Data Models
– Business modeling
– Data Warehouse modeling options
– Basic principles of operational position modeling
– Big Data modeling
