Analytics Engineering Fundamentals: Modeling Data for BI Consumption

<p>Follow analytics engineer Priya Nandan as she rebuilds a company's messy raw data into a trusted, well-documented set of staging, intermediate, and mart models that analysts and BI tools can actually use. You'll write real PostgreSQL SQL across all three layers, design wide and narrow tables for different reporting needs, build a shared definition of contested metrics like "active customer" and "revenue," and add dbt-style tests and git-based code review so a broken model gets caught before it ever reaches a dashboard.</p>

Tools: PostgreSQL, SQL, dbt, Git, GitHub Actions, BI Tools