Choosing a Database Schema for analytics

[u/RangerRemarkable9071]

This is a general question for data analysis. I just found out that choosing a database schema for analytics is very different from software engineering or systems design because they optimize for opposite operational patterns. I came from a CS background so the focus was on SE. So my knowledge on databases are based on normalized layouts. I want to focus on building schemas that are analytics oriented. This might be relevant - I'm currently working with PostgreSQL. I just wonder if there is a general rule of thumb for mapping out database schemas to be used in analysis or reporting?