The Premier Website for Data Warehousing and Business Intelligence

Data Analysis and Design Learning Path


Data Analysis and Design provides the foundation for delivery of BI applications. Analysis concentrates on understanding business needs for data and information. Design focuses on translating business information needs into data structures that are adaptable, extensible, and sustainable.

Core skills include information needs analysis, specification of business metrics, and data modeling. A solid understanding of data warehousing concepts, architectures, and processes is also essential.

Common roles in this area include:
  • Data Steward
  • Information Architect
  • Data Modeler
  • Source Data Analyst
  • Database Developer
  • Business Intelligence Architect
  • Metadata Administrator
  • Quality Administrator

Other courses of interest:
  • Enterprise Data Modeling for Business Intelligence
  • Dimensional Modeling Beyond the Basics
  • Data Quality for Data Warehousing: A Practical Guide
  • Applying Quality Concepts to Data Management
  • Integrating Data Warehouses and Data Marts Using Conformed Dimensions