1. Requirement gathering (involved in face to face discussion with the
clients regarding what is their requirement)

2. Data modeling (where we fix the schema design for warehouse)

3. Data profiling

4. Data cleansing

5. ETL ( 1. Extracting the transactional data from the data sources into a
staging area 2. Transforming the transactional Data 3. Loading the transformed
data into a dimensional database )

6. Reporting 1. Building pre-calculated summary values to speed up report
generation 2. Building (or purchasing) a front-end reporting tool