Descriptive Analytics II: Business Intelligence and Data Warehousing - Data Warehousing Process
3 important questions on Descriptive Analytics II: Business Intelligence and Data Warehousing - Data Warehousing Process
Describe the data warehousing process
- Data are sourced (multiple sources)
- Via the custo written ETL process, data are extracted and properly transformed
- Data are loaded into a staging area, where they are transformed and cleansed
- Data is now ready to load into the data warehouse and/or DM's
Describe the major components of a data warehouse
- Data sources
- Data extraction and transformation
- Data loading
- Comprehensive database: this is the EDW to support all decision analysis
- Metadata: include software programs about data and rules for organizing data summaries that are easy to index and search
- Middleware tools : enable access to the data warehouse
Identify and discuss the role of middleware tools
enable access to the data warehouse for power users such as SQL analysts, Business Objects users, Front-end applications
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
Remember faster, study better. Scientifically proven.
