DataPro logo
Sign in
Learning areas/Practical Data Architecture

Architecture track

Practical Data Architecture

Learn how data systems fit together in 50 hands-on lessons: 20 Beginner, 15 Intermediate and 15 Advanced.

Learn in this order

Start at step 1. Each idea prepares you for the next one.

0/10
  1. 1Find where data begins and where it must go
  2. 2Design clear tables, keys and relationships
  3. 3Separate raw, clean and reporting layers
  4. 4Shape facts and dimensions for analytics
  5. 5Choose a warehouse, lake or lakehouse
  6. 6Add contracts, quality checks and lineage
  7. 7Protect private data and control access
  8. 8Design reliable events and serving layers
  9. 9Balance speed, cost, safety and recovery
  10. 10Explain a complete architecture blueprint

Continue where you left off

Name one data source

5 questions remaining in this sector

Resume →
Industry context

Your datasets, exercises and portfolio outputs stay inside the sector you choose.

Beginner · Sources & Data Types

2 exercises — finish them all to earn a certificate

0/2 done
2 questions left to earn this certificate
  1. Name one data source
  2. Choose a useful data type

Name one data source

+20 XP

You are a data architect in the Finance team. A source is where data begins. We will map it using the payments dataset.

PYTHONSourcesData Architecture

Choose a useful data type

+20 XP

You are a data architect in the Finance team. The type says whether a value is text, a number or a date. We will map it using the payments dataset.

PYTHONData typesData Architecture

Intermediate · Normalisation & Incremental Loads

2 exercises — finish them all to earn a certificate

0/2 done
2 questions left to earn this certificate
  1. Split repeating details
  2. Design an incremental load

Split repeating details

+20 XP

You are a data architect in the Finance team. Normalisation stores repeated facts once. We will map it using the payments dataset.

PYTHONNormalisationData Architecture

Design an incremental load

+20 XP

You are a data architect in the Finance team. An incremental load moves only new or changed rows. We will map it using the payments dataset.

PYTHONIncremental loadsData Architecture

Advanced · Serving Layers

1 exercises — finish them all to earn a certificate

0/1 done
1 question left to earn this certificate
  1. Choose a serving pattern

Choose a serving pattern

+20 XP

You are a data architect in the Finance team. Serving layers shape data for dashboards, APIs or models. We will map it using the payments dataset.

PYTHONServing layersData Architecture