Data warehouse is an architectural concept. This means – it is a type of architecture deployed for business intelligence solutions. Data Warehouses are built mainly to support strategic and tactical decision making, but they are also be used as a central trusted source of enterprise data within the organization for a variety of other data related usages.
Building a data warehouse mainly requires a team of professionals with both business and technical skills.
Business professionals with good understanding of various business processes can help in defining the data requirements. They understand the business problems and know how data can help the business to solve those problems. They define the data elements that should be present in the data warehouse.
They also define the functional aspects of data. This includes defining the data sources from which data should be acquired, defining the data quality guidelines, defining the frequency of data refresh, defining the transformation rules that need to be applied on data, defining how data should be standardised and homogenised across the enterprise etc.
Business professionals also help in defining the governance policies for the data warehouse, such that the data continues to remain secure, searchable, understandable and trustworthy.
Data warehousing projects need to put together a team of technical professionals with a variety of skills. They involve
- Data Warehouse architects to design the architecture for the data warehouse. They work with other enterprise architects within the organization to ensure that the solution adheres to architectural principles and policies.
- Technical project managers to manage stakeholders and manage cost, budget and resources.
- Infrastructure teams to deploy the environments for building the data warehouse.
- Data modellers to design the data model for the data warehouse, such that it is optimised for querying data.
- Source system analysts to create data mappings from source system to data warehouse.
- ETL developers to build ETL interfaces to load data into the data warehouse.
- Business Intelligence developers to build reports and visualizations for business users.
- Data quality team to implement data quality rules, data catalogs and data quality monitoring features.