Data & analytics architecture design suggestions and overview
Data modeling (3NF, star schema).
Partitioning, indexing, and performance tuning strategies.