Data Modeling

Course review
4.6/5
9 Reviewers

Course introduction

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

+ Read more

Course reviews

“Ari Hovi’s Data Modeling course was inspiring and engaging! Modeling teaches you to look at things in a data-centric way and can provide important insights to circumvent data management pitfalls such as duplication and data silencing. I recommend the course because data modeling is a collaboration for which learning through doing is very well suited.”
Aini Mlläri, Consultant, Capgemini Finland Oy

“A clear and practical close-knit course that made understandable an issue that is often perceived as awkward. Provides a good overall view of the topic and verifies the usefulness of modeling in many areas from database design to understanding the company’s operating models. ”
Participated in the course

“I am very pleased with the company-specific Data Modeling training I received from Ari Hovi. Trainer Minna Oksanen Tailored the training to suit us and I heard good feedback from the participants. Participants were divided into small groups with different levels of participants and all learning from each other. There was a lot of exercise involved and learning happened all the time. As a whole, I would say “Money well spent”.
Susanna Vasara, Competence Lead, OP Financial Group

 

Course review
4.6/5
9 Reviewers

Educator:

HANNU JÄRVI

CEO and Machine Learning / Artificial Intelligence lead at Ari Hovi

Hannu has been working with artificial intelligence for the first time in the mid-90s. He has a clear idea of ​​what is artificial intelligence today is realism, and what is advertising speech.

Hannu has assisted organizations in AI strategy work, from small organizations to the largest export companies, including the University Central Hospital Management Team and the Executive Committee responsible for AI strategy work at the TOP10 listed company.

He has trained heterogeneous groups from AI beginners to PhDs in machine learning to identify and work together on AI’s business opportunities.

Hannu also teaches SQL and Data Modeling.

Read more

Data Modeling

Course review
4.6/5
9 Reviewers
Theme:
Data Control
Educator:
HANNU JÄRVI
Dates:
Contact
Language:
English
Duration:
2 days
Price: 1 400 € + VAT
Sign up

More than one participants from same company?

We also organize company-specific courses.

Course for company

You might be interested in

+