Exercise
You are a data engineer at a book publishing company and your product manager has asked you to build a dashboard to show the total revenue and customer satisfaction index in a single dashboard.
Your company doesn't have any data infrastructure yet, but you know that your company has these three applications that contain TBs of data:
- The company website
- A book sales application using MongoDB to store sales transactions, including transactions, book ID, and author ID
- An author portal application using MySQL Database to store authors' personal information, including age
Do the following:
- List important follow-up questions for your manager.
- List your technical thinking process of how to do it at a high level.
- Draw a data pipeline architecture.
There is no right or wrong answer to this practice. The important thing is that you can imagine how the data flows from upstream to downstream, how it should be processed at each step, and finally, how you want to serve the information to end users.
