Descriptive Analytics II: Business Intelligence and Data Warehousing - Data Warehouse Development
4 important questions on Descriptive Analytics II: Business Intelligence and Data Warehousing - Data Warehouse Development
List the benefits of data warehouses
- end user analysis in numerous ways
- consolidated view of corporate data (single version of the truth)
- Better and more timely information
- Enhanced system performance
- Simplified data access
- enhanced business knowledge
- competitive advantage
- improved customer service and satisfaction
- facilitates decision making
- help reforming business processes
List several criteria for selecting a data warehouse vendor, and describe why they are important.
See card "Sample list of Data Warehousing Vendors"
Do you want to completely outsource the data warehousing effort?
Security and privacy concerns
What is OLAP, and how does it differ from OLTP?
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
What is a cube? What do drill down, roll-up, slice, and dice mean?
Drill down/Up: the user navigates among levels of data ranging from the most summarized (up) to the most detailed (down)
Roll-up: involves computing all the data relationships for 1 or more dimensions. Formula might be defined.
Slice: is a subset of a multidimensional array (usually a 2 dimensional representation) corresponding to a single value set for 1 or more of the dimensions
Dice: is a slice on more than 2 dimensions of a data cube
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