Now, let's start the practical implementation and set up the Data 360 configuration.
Let’s assume that ABC Company has provided us the below Excel file containing customer purchase data from its physical store.
Click Here to Download Offline Sales Details
As a Data 360 Consultant/Architect, the first responsibility is not to immediately start configuring Data 360. Instead, we first need to understand and analyse the data.
So, let's take a look at the Excel file and identify:
- What data is available?
- What does each column represent?
- Who is the customer?
- What information can uniquely identify a customer?
- Are there any duplicate or missing records?
- How can this data be mapped to the Data 360 data model?
Remember: Before configuring Data 360, understanding the source data is the first and most important step.
Our Analisys:
- In the above offline Sales Details sheet, we could found that for Customer Id 1001 and 1002, we have multiple or we can say dulicate record for same customer ids.
- We have also noticed that in the above sheet there is no customer data like customer's name or email or phone number etc. which are very much needed as identifier to maintain unique customer.
- There could be many more as such analysis, but for simplicity let's start with these only.
Our Next Steps:
- As we need customer's name, email etc. so request ABC Company to share these detials from their Offline Physical Store.
- Now there could be 2 possibilities,
- ABC Company will share you again a considated sheet with customers' details.
- Or else ABC Company will share you a seperate sheet with only customers' details.
Let's say ABC Company has shared the below seperate sheet with only customers' details,
Click Here to Download Offline Customer Details
So, our Offline data is ready and we have 2 set of data,
1. Offline Sales Details
2. Offline Customer Details
Note: For this POC, I am only using very very minimal data to make it very easy to understand but in real scenario these data volume will be very large.
Next Step: Now our next step will be ingesting these data in our Data Clould Org.
