Data warehouses support organizational analysis

Data Warehousing Concepts

Aaren Stubberfield

Data Scientist

High-level life cycle

Planning - business requirements

1. Business Requirements:
   • Understanding the organizational needs
   • Personas:
     • Analyst & Data Scientist - collect requirements

Planning - data modeling

1. Data Modeling:
   • Planning and organizing on integrating data
   • Personas:
     • Data Engineer & Database Admins - design data pipeline
     • Analyst & Data Scientist - data business knowledge

Implementation - ETL Design & Development

1. ETL Design:
   • Implement data pipelines and ETL process
   • Personas:
     • Data Engineer & Database Admins - implement data pipeline

Implementation - BI Application Development

1. BI Application Development:
   • Setup business intelligence (BI) tools
   • Personas:
     • Analyst & Data Scientist - consult on BI tool setup

Support / Maintenance - Maintenance

1. Maintenance:
   • Make any needed modifications
   • Personas:
     • Data Engineer - modify as needed

Support / Maintenance - Test & Deploy

1. Test & Deploy:
   • Testing
   • Personas:
     • Analyst & Data Scientist - consult on BI tool setup
     • Data Engineers - deploy the data warehouse

Persona matrix

Life cycle step	Analysts	Data Scientist	Data Engineers	Database Administrators
Business Requirements	X	X
Data Modeling	X	X	X	X
ETL Design & Development			X	X
BI Application Development	X	X
Maintenance			X
Test & Deploy	X	X	X

Let's practice!

Data Warehousing Concepts