Data Warehousing and Modeling
Because data is critical to making business decisions, we will find that a large part of business intelligence is the study of data management systems. This video explains the differences between a database (where we often find our transaction data), a data warehouse (where we organize data at a higher level of aggregation), and a data lake (which can be quite unstructured). We will also need to start thinking about getting data from our database sources to our data warehouse. We call this process data mining and ETL. More on this later in the course. Can you identify examples of data warehouses from your personal experiences or companies you have researched? How was the data warehouse and the data in it used to support the needs of executives? How would you go about deciding if a given data warehouse is effective in meeting executives' needs? How would you score the warehouse?
Source: Alex The Analyst, https://www.youtube.com/watch?v=-bSkREem8dM
This work is licensed under a Creative Commons Attribution 3.0 License.