It is a myth that Data Warehouse main purpose is for data analytics. When you are creating the business case for your Data Warehouse, you can include the following benefits, with only some of them belonging to the traditional analytics:
- Enterprise Reporting
- Offline Operational Data Store (refer ODS types ask a question)
- Data Analytics
- Data Mining
- Business Modeling
- Operational BI
As you design and scope your Data Warehouse, you should account for potential uses, which go beyond data analytics. This is how your Data Warehouse design will be influenced, if you are going for more broad-based applications:
- More granular data
- More Descriptive Attributes
- More Robust and scalable platforms
- Load and Job schedule Management
- Your Dimensional Model
- Your OLAP strategy
This topic is dealt in more detail in Data Warehouse is not for analytics. Design it for broader applications, in my portal Business Intelligence and Performance Management Institute .
