Data preparation

Before you do any analysis, the first step is to ensure that your data is prepared. First, we'll verify the data with a simple check - in this exercise you'll put your data in a table formats and then investigate whether there are any duplicate rows in our customer level data.

In this case study, you'll be working with two different datasets in the following worksheets: Databel - Aggregate and Databel - Customer. For chapter 1 we'll focus on our customer level data before working with aggregate data later in the case study. The aggregate views are based on data in Databel - Customer.