Prerequisite: None
One-Day Course
Preview Course Materials | Course Outline
Data is elemental to BI and DW systems. An adaptable, business-based data design is the key to sustainable value from these systems. Yet many BI and DW teams are challenged to achieve complete and accurate data designs. Many equate data analysis and design with data modeling and view it entirely as an IT responsibility. Good data designs, however, demand business knowledge and business participation. Getting the data right depends on intimate knowledge of what the data means and how that data is used. Business rules, definitions, and needs are essential inputs to data analysis and design. Business subject expertise is a critical factor for data analysis and design success.
Through this course you will gain an appreciation for the importance of business participation and expertise in data analysis and design processes. The course is designed to establish common concepts, understanding, language, and techniques that help business and IT people work together to achieve top-quality data design and implementation. Through improved communication, collaboration, and coordination you’ll achieve new levels of success in data analysis, design, and implementation activities.
You Will Learn:
- The activities and results of data analysis
- The activities and results of data design
- Relational data and dimensional data design techniques
- Logical and physical data design techniques
- Business roles, technical roles, and shared responsibilities in data analysis and design
Geared To:
- Teams of business and IT people with BI/DW projects; business executives and managers; business data stewards; business analysts; program and project managers; data architects; data modelers