7.36 Tech Tool: Spreadsheet Software, Database Software Software Videos: Spreadsheet ODBC, Spreadsheet Data Tables, Spreadsheet PivotTables and PivotCharts EspressoCoffee has asked for your assistance with the following tasks.

1. Download the EspressoCoffee file for this exercise.

2. Set up open database connectivity (ODBC) to import data from the Microsoft Access file you downloaded into a spreadsheet.

3. Format the imported data into a data table in Excel.

4. Create a PivotTable to analyze the sales data.

S. Create a pie chart with totals for each country.

6. Create a bar chart by quarter.

7. Using the PivotTable and charts you created, develop a digital dashboard that could be used to monitor and track EspressoCoffee sales.

8. Analyze the information provided by your digital dashboard to create intelligence. What intelligence can you glean from your analysis?