Practicing developing a data warehouse

Now we are set and ready to build our first data warehouse. We will proceed with the help of two scenarios. Each scenario will have different learning purposes.

In the first scenario, we are going to focus on how to use the tools. After understanding the tools, in the second scenario, we will focus on the practice. Practice here means learning how to build a solution, not only learning how to use the tools.

We understand that even though we know how to use the tools, there are many possibilities for using them. But when it comes to practice, usually we learn from common best practices, patterns, and different theories from practitioners.

We will use the San Francisco bike-sharing dataset. The dataset relates to a bike-sharing company. The company records the trip data of its members. Each bike trip contains information about the stations, and each station is located in certain regions. This dataset is very simple compared to a real-world...