Expert Excel Dashboard for Retail Operations

Job ID: 39667749

Budget: $10 – $30 USD

I'm in need of an expert dashboard creator proficient in Excel to develop a comprehensive dashboard tailored for retail operations. The dashboard should be designed to provide insightful analytics and performance metrics across various key modules, ensuring a detailed overview of our retail operations.

Key Modules and Requirements:

1. **Financials:**
- MTD/YTD Sales vs Budget, Sales vs Last Year
- Advanced drill-down capability from Top Category to Brand and Item ID
- Sales per Sq.M, Top 10 & Bottom 10 SKUs by sales
- Promotion Sales Mix, Items per Bill, Sales per Item
- Wastage % for Fresh & Non-Fresh items
- Contribution of Categories, Online Sales Contribution

2. **Stock & Availability:**
- Availability % for Top Selling SKUs, Focus List, Private Label, Promo
- Days of Cover by Category, Aging Stocks

3. **Customer Experience:**
- Customer Count vs Last Year, Average Basket Size

4. **Store Operations & Compliances:**
- QA Audit by Store, Area, and Format

5. **Fresh Section Performance:**
- Sales Performance, Contribution, Wastage

6. **HR & Productivity:**
- Manpower actual vs Budget, Staff by Section

Key Requirements:
- The dashboard must be created in an Excel Workbook.
- It should support advanced drill-down capabilities for sales data.
- Data updates should be facilitated on a monthly basis.

Ideal Skills and Experience:
- Expertise in Excel, including advanced functions and data visualization.
- Experience in creating detailed and interactive dashboards for retail or similar industries.
- Strong analytical skills to interpret and present data effectively.
- Ability to incorporate complex data structures and drill-down features.

I am looking for someone who can deliver a user-friendly and visually appealing dashboard that provides actionable insights into our retail operations. If you have the skills and experience to bring this project to life, I would love to hear from you!