1. Introduction to SQL for Analytics

Activity 1.01: Classifying a New Dataset

Solution

1. The unit of observation is a car sale.
2. Date and Sales Amount are quantitative, while Make is qualitative.
3. While there could be many ways to convert Make into quantitative data, one commonly accepted method would be to map each of the Make types to a number. For instance, Ford could map to 1, Honda could map to 2, Mazda could map to 3, Toyota could map to 4, Mercedes could map to 5, and Chevy could map to 6.

Activity 1.02: Exploring Dealership Sales Data

Solution

1. Open Microsoft Excel to a blank workbook.
2. Go to the Data tab and click on From Text.
3. Find the path to the dealerships.csv file and click on OK.
4. Choose the Delimited option in the Text Import Wizard dialog box and make sure that you start the import at row 1. Now, click on Next.
5. Select the delimiter for your file. As this file is only one column, it has no delimiters, although CSVs traditionally...