Hazra Hadee
Member
Hello,
I am working on creating a dashboard for travel rates received from 2 vendors for adults and child for around 400 airports spread around the world. The information is sent to us on a quarterly basis.
I need to come up with a useful automated dashboard which can give me the
1. Average rate for the full year based on 4 quarters - for a city (selected from drop down) - for both vendors to be displayed - I was thinking of displaying rates for each quarter and then give the average price
2. Highest rate for a city for both vendors - by quarter, by year
3. Lowest rate for a city for both vendors - by quarter, by year
Which is the best approach keeping in mind that the raw data is added/changed every quarter. Any idea for the dashboard screen itself would be great help. This will be my first dashboard. Thank you in advance.
Best
I am working on creating a dashboard for travel rates received from 2 vendors for adults and child for around 400 airports spread around the world. The information is sent to us on a quarterly basis.
I need to come up with a useful automated dashboard which can give me the
1. Average rate for the full year based on 4 quarters - for a city (selected from drop down) - for both vendors to be displayed - I was thinking of displaying rates for each quarter and then give the average price
2. Highest rate for a city for both vendors - by quarter, by year
3. Lowest rate for a city for both vendors - by quarter, by year
Which is the best approach keeping in mind that the raw data is added/changed every quarter. Any idea for the dashboard screen itself would be great help. This will be my first dashboard. Thank you in advance.
Best