Overview
Developed Excel-based reporting frameworks for AtliQ Hardware, a fictional computer hardware business, focusing on commercial performance and financial reporting.
My contribution
- Developed customer performance and market-versus-target reports.
- Created monthly and fiscal-year Profit & Loss reports.
- Built ETL workflows using Power Query.
- Established data relationships using Power Pivot.
- Used DAX for calculated columns and additional reporting requirements.
- Designed structured reports for business and financial performance evaluation.
Deliverables
- Customer Performance Report
- Market Performance Report
- Monthly P&L
- Yearly P&L
Tools
Microsoft Excel- Power Query
- Power Pivot
- DAX
