Developed a high-performance reporting system utilizing Modern Dynamic Arrays and Cascading Logic.
Key Technical Architecture:
• 3-Tier Dynamic Hierarchy: Engineered a synchronized drill-down system (Year > Month > Individual) where SUMIFS and Data Validation dynamically update all metrics across 3 tiers simultaneously.
• Automated Workflow Logic: Leveraged dynamic data validation, conditional formatting, SORT, UNIQUE functions to ensure the dashboard evolves automatically when source Data Table is updated.
• Power Query extracts, transforms, loads data into Data Table for seamless data flow.