SQL and Data Warehousing - Data Warehouse Framework - Components
4 important questions on SQL and Data Warehousing - Data Warehouse Framework - Components
What is Data warehouse?
the data in this part is more ‘formed’ to support the information
requirements for managers and decision-making. This data is cleaned, ordered and linked.Star and snowflake modelling. This part does not have up-to-date data. There is a certain delay, because of the ETL process.
What is meta data?
data about the data (such as location, meaning, transformations etc.)
What are BI applications?
is connected with the data warehouse or data mart.
query and reporting
OLAP
data mining
data visualazation
There are two trends:
- Integrated BI/BA-suits
- Enterprise information portals
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
What is subject oriented?
- Focusing on the analysis of data or decision makers not on daily operations/transition processing.
- Providing a simple view around particular subjects by excluding data that are not useful in the decision support process.
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding