Interactive Sales Data Dashboard
Budget: $250 – $750 USD
I am seeking an Excel expert to construct a dynamic and interactive Sales Dashboard. The user should be able to:
- Select mandatory inputs: Start/End Dates, summary by day, week, month, quarter, or year
- Select optional inputs: Sales Person Name, Geographic Area, Zipcode, Type of Account
- Data will be in an Excel file folder and refreshed daily. Work scope includes connecting to that file and refreshing the data automatically.
The dashboard must accurately display:
- Total sales by CaseEquiv
- Trend line of the dataset
- Display both numerics and line graph of the dataset
The dashboard should incorporate the following functionalities:
- Filter by date range
- Filter by region
- Filter by salesperson
- Filter by 'Type of Account'.
The ideal freelancer should have advanced knowledge and experience in Excel, especially within Sales Data Analysis and Dashboard Creation. It would be beneficial if the freelancer has worked with retail data before and has a strong understanding of sales metrics.
- Select mandatory inputs: Start/End Dates, summary by day, week, month, quarter, or year
- Select optional inputs: Sales Person Name, Geographic Area, Zipcode, Type of Account
- Data will be in an Excel file folder and refreshed daily. Work scope includes connecting to that file and refreshing the data automatically.
The dashboard must accurately display:
- Total sales by CaseEquiv
- Trend line of the dataset
- Display both numerics and line graph of the dataset
The dashboard should incorporate the following functionalities:
- Filter by date range
- Filter by region
- Filter by salesperson
- Filter by 'Type of Account'.
The ideal freelancer should have advanced knowledge and experience in Excel, especially within Sales Data Analysis and Dashboard Creation. It would be beneficial if the freelancer has worked with retail data before and has a strong understanding of sales metrics.