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.
5. 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?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.