Explain the data warehouse distribution process

The data warehouse distribution process involves the following subsets of processes:

Step 1: Determine Business Objectives

Learn the requirements and objectives of the business and its owners and stakeholders and convert those requirements into quantifiable form. These quantifiable key performance indicators will then be your business objectives.

Step 2: Collect and Analyze Information

Ask questions, acquire various sales, CRM, and marketing reports(as needed), and then consolidate all this information into a structured format

Step 3: Understand core business processes

Once you have the data, you will be able to better understand the business processes and come up with core objectives you need to solve with data warehousing

Step 4: Initiate a conceptual data model

Create a conceptual model of the data after identifying the business processes. The next goal will be to determine the subjects expressed as fact tables and dimensions relating to the facts.

Step 5: Locate data sources and plan data transformations

Analyze core data sources and set to work on building the data pipelines and transformation models

Step 6: Set tracking duration

To process large amounts of data you need to optimize the time requirements. Since data warehouses track performance over time, the data should be available virtually forever. So a solution should be accounted for that.

Step 7: Start final implementation

Once the plan is developed, start allocating resources and scheduling tasks to get things in the pipeline.