Data Models & Manipulation

Master data modeling and challenge yourself to learn how to transform data in SQL to obtain the best possible results for your business. Our two-day Data Models and Manipulation course enables you to design data models that are efficient, transparent and robust, as well as transform the data to build the analysis dataset you require for analyses or AI model development.

Duration: 2 day

Star Level: Practitioner

Certification: Yes

 

MIacademy / Badge Overview / Open Course Calendar / 4204 Data Models and Manipulation

Course Description

Before you can start using data for AI and analytics purposes’ you need to set up the right database architecture, transform data in an efficient way, and make sure data quality is fixed. This two-day badge takes you through this process step-by-step, while directly applying the theory to a case; starting with designing a good data model, identifying and solving the data quality issues, and finally applying the right SQL queries in transforming the data. If you are a Data Scientist, dealing with data quality issues and transformations to create an analysis dataset is all in a day’s work. This training is designed to ensure you are building the most efficient databases which enable easy browsing of the data by providing a compact, well-structured overview. This badge is made up of two parts: the four-hour Data Quality pre-work e-learning, and the two-day course.

 

 

Why is this for you?

 

In order to effectively carry out any analysis or develop AI models, you need a proper set-up database and analysis table. When making the translation from a business question to arrive at that stage, it is essential to know how to structure and transform data in the correct way. This module is designed specifically to provide you with all the basics you need to build the necessary well-structured analysis table according to best practice standards.

 

 

Who should attend?

 

This training is perfect for starting Data Scientists, AI Engineers and Data Engineers who are eager to learn how to design and get hands-on experience with data modeling and creating a relevant analysis dataset. We require you to have prior knowledge of SQL before doing the pre-work and taking part in this course.

 

 

What will you learn?

 

An integrated view of the entire process and hands-on practice to gain experience in building proper analysis datasets and learning:

  1. Applying Entity Relationship Diagrams and Entity Relationship Models
  2. Dimension modeling
  3. How to identify and solve the most common data quality issues, including steps to perform a data audit
  4. Applying the data quality cycle
  5. How to transform data in SQL

 

 

Learning Goals

 

    • Entity Relationship Modeling – Become confident in explaining and designing an ERD and ERM
    • Dimensional Modeling – Explain the rules of dimension modeling and its uses, and design a star scheme
    • Applying the data quality cycle – To ensure continuous control and improvement of data quality in periodic processes
    • Transforming data in SQL – Apply the most important SQL statements for data transformation

 

 

Theory and practical use

 

All trainings in the GAIn portfolio combine high-quality standardized training material with theory sessions from experts and hands-on experience where you directly apply the material to real-life cases. Each training is developed by top of the field practitioners which means they are full of industry examples along with practical challenges and know-how, fueling the interactive discussions during training. We believe this multi-level approach creates the ideal learning environment for participants to thrive.

 

 

Skills

 

    • Data
    • Technology
    • Data quality
    • Data quality issues
    • Data quality cycle
    • Data audit
    • Data modelling
    • ERD
    • Entity Relationship Diagram
    • ERM
    • Entity Relationship Model
    • Dimensional modelling
    • Star schema
    • SQL basics
    • Transforming data in SQL
    • Data manipulation
Interested in taking the course?

Open Course Schedule

 

MIacademy does offer part of its portfolio in an Open Course Schedule Format in our location in the center of Amsterdam. Via the form below you can register your interest to participate. Our team will contact you to finalize the booking and answer any questions you may have.

All of our courses are delivered by our expert trainers.

 

If no dates are mentioned. The specific course is not scheduled yet in 2020. If this is the case you can use the form to register your interest. In case there is enough demand MIacademy can schedule additional courses and will notify you.

Dates & Availability

 

In-company Training Programs

Are you are interested to train a larger group of people, looking for specific training pe or and/or interested in creating a company-wide program? We will be happy to assist!

Whether you have a very specific training need (for example: training your Data Engineers on advanced technical topics, or your Data Scientists on model implementation), or the need for a large transformational program, or something in between, we can help. Over the past 13 years, we have built up extensive experience not only in the implementation of multi-year, multi-population, multi-country programs but also in providing high quality, very specific modules for specific target groups. Both in in-house set-ups and cross-company programs. Not sure what type of program would fit your organization best? We’d be happy to discuss the best approach together.