Tag
Articles tagged "Analytics"
2 articles found
Tutorials
4 min read
PostgreSQL for Analytics: Best Practices
Keep OLTP and analytics paths separate, pre-aggregate what dashboards repeat, and index for the filters users actually touch. Patterns we use on BI and ETL projects.
PostgreSQLAnalyticsSQL
Read →Tutorials
4 min read
Building Your First Analytics Dashboard
Start with three metrics, one grain, and a schema you can query without heroics. A practical path from spreadsheet exports to a dashboard small teams can maintain.
AnalyticsDashboardPostgreSQL
Read →