Constructed EER diagrams, conceptual models, and SQL-based analytical solutions. Delivered optimised queries and a working data warehouse structure.