Jeroen van Hoof

This badge was issued to Jeroen van Hoof on 26 Sep 2019.

4204 - Data Models & Manipulation - 2019

4204 - Data Models & Manipulation - 2019

Issued by GAIn® - The Global AI network

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 badge takes you through this process step by step, while directly applying the theory to a case; starting with designing a good data model, applying the right SQL queries in transforming the data, and finally, identifying and solving the data quality issues.

Skills

Earning Criteria

  • Entity Relationship Modeling – Become confident in explaining and designing an ERD and ERM.
  • Dimensional Modeling – Explain the rules of dimension modeling and its uses to 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.
  • Exam