I'm really excited about this chapter because we are going to learn about the foundation of blending multiple datasets. This concept has been around for decades using SQL and other technologies including R, pandas, Excel, Cognos, and Qlikview.
The ability to merge data is a powerful skill that applies across different technologies and helps you to answer complex questions such as how product sales can be impacted by weather forecasts. The data sources are mutually exclusive, but today, access to weather data can be added to your data model with a few joins based on geographic location and time of day. We will be covering how this can be done along with the different types of joins. Once exposed to this concept, you will learn what questions can be answered depending on the granularity of data available. For our weather and sales data example, the details become important...
