Developed a specialized Data Warehouse schema focusing on Sales performance. I transformed raw transactional data into a Star Schema (Fact and Dimension tables) to facilitate fast and efficient business intelligence reporting.
Key Results: Optimized query performance and enabled deep-dive analysis of regional sales trends and product performance.
Tools: SQL (CTEs, Subqueries), Star Schema, Data Warehousing.
