Problem: Why use a database instead of Excel?
Outcome
- Identify reasons to use a relational database instead of Excel
Problem
ABC Woodworking has asked you to analyze sales records. They want invest $20,000 into a new Google Adwords campaign, which their CMO thinks will boost sales by 20%. However, they want to maximize their return on investment.
What one product should they promote to maximize their investment?
Process
- Download the problem file and load it into Excel
- Open the file in Excel
- Examine the data for potential data problems. Try to look at reasons for a DB, and see if you can find any problems in the Excel file.