* Identify and gather requirements
* Design the dimensional model
* Develop the architecture
* Design the relational database and OLAP cubes
* Develop the data maintenance applications – Extraction, Transformation and Load (ETL)
* Develop analysis applications
* Test and deploy the system
* You need to be half DBA and half MBA to do this successfully!