Excel Database

Please read the following.

I have 6 requirements in the attached requirements document.

1. Create a database from 4 different tabs of information in the excel spreadsheet to then be able to run reports and or join tables to run reports. Guessing this might need to be done either via power query or SQL Server databases

2. Regarding the database I need the flexibility to add in data / import for FY23 example July 22 data and be able to run reports or join tables to run reports. Guessing I’m going to need a range to execute. Would also need a report template setup to export into excel or email.


3. Require a dynamic dashboard to be developed from 2 tabs in the spreadsheet so I can also compare years and months on the dashboard so require some sort of filter to choose years and months from


4. I then need the flexibility to add in the same information for the dashboard for FY 2023 example July 22 data and be able to also compare via the dashboard

5. Heat map required of Australia to show sales by postcode to include the below. (Sales by postcode tab)

• Customer column (D)
• Product column (A)
• Qty Column (B)
• Postcode Column (H)

6. The dashboard needs to look professional, clean, attractive, and work correctly. I have added in a screen shot as an example in the requirements document