![]() What is a data warehouseĪ data warehouse is a database that has all your company’s historical data and is used to run analytical queries. These questions can be answered by querying a data warehouse. These questions ask about things that happened in the past, require reading a large amount of data, and aggregating data to get a result. Create a merchant dashboard that shows the top-performing items per merchant.Identify the customers who purchased the same/similar items together.What is the average time for an order to be fulfilled?. ![]() Get the 10 merchants, who have sold the most items?.Some of the questions and feature requests may be Merchants will also want to analyze performance and trends to optimize their inventory. Let’s assume we have two microservices, that handle customers and merchants respectively.Īs our company grows, we may want to analyze data for various business goals. Let’s assume you work for an e-commerce company where the merchant can list their items and customers can purchase them. Business requirements: dashboards and analytics By the end of this post, you will have understood what a data warehouse is, what type of databases can be used as a data warehouse, and how to choose the right data warehouse for your use case. When should I start using a data warehouse? If you are a student, analyst, engineer, or anyone in the data space, it’s important to understand what a data warehouse is.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |