Dashboard based on Excel Workbooks. Small Step by step over 2 months.
Budget: $15 – $25 USD
I have some data in Excel. I dont wont to change the format of these sheets, because I take out new reports every week. So - I need you to get data from my existing sheets and make a good powerful dashboard from these data.
I need to work "step by step" so we know we have full control.
In this project we will included aprox 4-6 different datasheets, to merge data based on unique reference.
Dashboard is about (by month, year and prognoses for the rest of the year)
- Quotes (numbers and amount - both all togheter and seller by seller)
- Orders and Invoices
- Invoice vs budget and prognose for rest of year
- Sales and earnings total and by seller
- Days from order to production (split by small orders and big orders) and also by individual or togheter
- Orders with low margins (and seller)
- Orders with
and more. Expect small steps.
I need to work "step by step" so we know we have full control.
In this project we will included aprox 4-6 different datasheets, to merge data based on unique reference.
Dashboard is about (by month, year and prognoses for the rest of the year)
- Quotes (numbers and amount - both all togheter and seller by seller)
- Orders and Invoices
- Invoice vs budget and prognose for rest of year
- Sales and earnings total and by seller
- Days from order to production (split by small orders and big orders) and also by individual or togheter
- Orders with low margins (and seller)
- Orders with
and more. Expect small steps.