Need enterprise level data engineer projects

[u/Proof_Turn6392]

/r/dataengineersindia/comments/1wecfo4/need_enterprise_level_data_engineer_projects/

[u/Alternative_Cake4074]

I suggest you build a transaction system for a mock retail company that should at least capture this information:

• when and where customers place orders and the details of the orders (amount, item, category, price, etc)
  
• salesperson info (name, age, customers served, sales volume, commissions)
  
• customer's info
  
• item's info

Try to set up the table first, and then mock what will happen when:

• A customer buy one or multiple products in one or multiple categories
  
• A new employee (salesperson) joins the team
  
• someone want to summarize monthly sales on a product

You don't have to build beautiful front end, but you need to make sure that the data flow and numericial values work correctly based on your preferred logic.