QlikView Dashboard. For DEMO (but using actual data).

1. I have five Excel files which are used (combined) to create an open order report.
Rather than doing Vlookups and merging tables etc I would like to create a dashboard indicating the key data such as Past due items and items due in 1,2,3 weeks (by Customer, by buyer, by value, by site etc). Also need some other simple calculations indicating margin etc. Probably 4 charts on the dashboard which will cahnge based on selected criteria.
I will also need to be able to drill down via a graph. So for example if I select Supplier X and they have 50 open POs, if I click on the graph it should show a table with the key PO information.

2. I have 5 other excel files with part codes and item descriptions and I need a simple dashboard to search for common items. Note common items will have different codes and item descriptions are not an exact match so a search facility should be able to filter letter groupings. This is a small element of the work (just a search covering a few fields).

In both cases the output is for a demo so it just needs to be functional and look reasonably appealing.

Prior to starting the work we will need to have a call to ensure the requirements are understood (save time later).