Expert Excel Dashboard for Retail Operations
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!
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!
Related categories:
Data Processing
Accounting
Excel
Business Analysis
Excel VBA
Excel Macros
Data Visualization
Data Analysis