Descriptive Analytics II: Business Intelligence and Data Warehousing
6 important questions on Descriptive Analytics II: Business Intelligence and Data Warehousing
Describe data integration
It integrates data from multiple systems.
Describe the 3 steps of the ETL process
Transformation: converting the extracted data from its previous form into the form in which it needs to be so that it can be placed into a data warehouse (or other database)
Load: putting the data into the data warehouse
What steps can an organization take to ensure the security and confidentiality of customer data in its data warehouse?
- Establishing effective corporate and security policies and procedures. (Start at the top and communicate to all)
- Implement logical security procedures and techniques to restrict access (authentication, access controls, encryption technology)
- Limit physical access to the data center environment
- Establishing an effective internal control review process with an emphasis on security and privacy.
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
What skills should a DWA possess? Why?
- familiar with high performing software, hardware and networking technologies
- solid business insights
- familiar with decision making processes
- excellent communication skills
What is a performance management system? Why do we need one?
Underlying a BPM is a performance measurement system: they assist managers in tracking the implementation of business strategy by comparing actual results against strategic goals and objectives.
What are the distinguishing features of KPIs?
- Strategy: KPI represent a strategic objective
- Targets: KPI measures performance against a specific target
- Ranges: e.g. above target, on target, below target
- Encodings: ranges encoded in software. e.g. green, yellow, red for abovee, on or below target
- Time frames: by which the target must be accomplished.
- Benchmarks: targets are measured against a baseline or bencmark. E.g the previous year.
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
![Trustpilot Logo](/images/design_2020/lp/clp-trustpilot-en.png)
Topics that are related to Descriptive Analytics II: Business Intelligence and Data Warehousing
-
Descriptive Analytics II: Business Intelligence and Data Warehousing - Business Intelligence and Datawarehousing
-
Descriptive Analytics II: Business Intelligence and Data Warehousing - Data Warehousing Process
-
Descriptive Analytics II: Business Intelligence and Data Warehousing - Data Warehousing Architectures
-
Descriptive Analytics II: Business Intelligence and Data Warehousing - Data Warehouse Development
-
Descriptive Analytics II: Business Intelligence and Data Warehousing - Data Warehouse Implementation Issues
-
Descriptive Analytics II: Business Intelligence and Data Warehousing - Business Performance Management
-
Descriptive Analytics II: Business Intelligence and Data Warehousing - Balanced Scorecards
-
Descriptive Analytics II: Business Intelligence and Data Warehousing - Six Sigma as a Performance Measurement System