Example case study

Let us continue the same example of the fictitious company, AB LLC. In the previous step, we had given an estimate of hardware and software to the client. Depending on our input, the client has made available the hardware and all setup has been done successfully.

Let us look at the various input parameters from the client and the best approach for designing the data architecture.

Data Sources

The client has mentioned that they would need data input from multiple sources, like SAP, Excel, and few CSVs:

• SAP: Contains all the transaction data captured from various locations (stores). This data is at a daily level and has information of all the products which the company is selling
• Excel: Excel contains the budget data which is available at store level, month level, and product category level
• CSV: It contains mapping of various fields, such as customer categorization, store master, and so on

Business logic

The client has provided business logic which needs to be incorporated to get...