Plan analytical database for reporting and analytics
Design data warehouse. Star/snowflake schema, ETL pipeline, dimension and fact tables, aggregation tables, query optimization.
Building analytics infrastructure