Data Warehousing

Start with the concepts

Begin with the mind map “Data warehouse”, which describes a warehouse as a repository where relational data is organized in a standardized format. Then explore “Business Information Warehouse” to see data sources such as databases, online services and the internet. Its branches also introduce terms such as InfoObject, InfoCube and InfoProvider.

For a wider view, the mind map on data warehousing, OLAP, data mining and the balanced scorecard connects data warehousing with business intelligence and decision-making. Follow the branches that relate to the terms you are studying.

Practice with questions and flashcards

After looking at a map, try the multiple-choice quiz on business intelligence. Its questions include capturing internal and external business data and analyzing decision support data. Another quiz asks about data warehouse subsets, what a warehouse may include and how a business may use business intelligence.

For term-by-term practice, “Managing Data for Business Intelligence Flashcards” asks what business intelligence is, what its advantages are, and how data and information differ. A separate flashcard deck uses true-or-false questions about business intelligence and data warehouses.

Use maps and quizzes together

Use a quiz question to identify a term you want to review, then return to a mind map and find its related branches. For example, after a question about what a data warehouse may include, look at the sources in “Business Information Warehouse”. You can then return to the question and compare it with what you found.

Place the topic in the unit

Data Warehousing is a section of Business Intelligence and Reporting in Databases and data science. The listed resources reflect that connection: they pair warehouse concepts with questions and maps about business intelligence. Choose a map and a quiz to study the connection for yourself.