Build a Data Warehouse
Business insights come from both structured and unstructured data.
Onsite Workshop
Modernizing the data warehouse environment without a plan can result in:
- Rework due to poor alignment with business pains or opportunities
- Wasted investment and further complication of the data environment
- Increased business frustration and more instances of shadow IT for data analysis
Developing a clear business case and roadmap for data warehouse modernization leads to:
- Stronger IT understanding of the business’ primary drivers
- Clearly defined use cases for data warehouse modernization
- A deployment that does not require overhauls every year
Module 1: Assess the Current Data Warehouse Environment
The Purpose
- Discuss the general project overview for data warehouse modernization.
- Establish the business and IT perspectives of the current state.
Key Benefits Achieved
- Holistic understanding of the current data warehouse.
- Business user engagement from the start of the project.
Activities: | Outputs: | |
---|---|---|
1.1 | Review data warehouse project history. |
|
1.2 | Evaluate data warehouse maturity. |
|
1.3 | Draw architecture diagrams. |
|
1.4 | Review supporting data management practices. |
|
Module 2: Explore Business Opportunities
The Purpose
- Conduct a user workshop session to elicit the most pressing needs of business stakeholders.
Key Benefits Achieved
- Modernization technology selection is directly informed by business drivers.
- In-depth IT understanding of the business pains and opportunities.
Activities: | Outputs: | |
---|---|---|
2.1 | Review general trends and drivers in your industry. |
|
2.2 | Identify primary business frustrations, opportunities, and risks. |
|
2.3 | Identify business processes to target for modernization. |
|
2.4 | Capture business ideas for the future state. |
|
Module 3: Review the Technology Landscape
The Purpose
- Educate IT staff on the most common technologies for data warehouse modernization.
Key Benefits Achieved
- Improved ability for IT to match technology with business ideas.
Activities: | Outputs: | |
---|---|---|
3.1 | Appoint Modernization Advisors. |
|
3.2 | Hold an open education and discussion forum for modernization technologies. |
|
Module 4: Define Modernization Solutions
The Purpose
- Consolidate business ideas into modernization initiatives.
Key Benefits Achieved
- Refinement of the strategic direction for data warehouse modernization.
Activities: | Outputs: | |
---|---|---|
4.1 | Match business ideas to technology solutions. |
|
4.2 | Group similar ideas to create modernization initiatives. |
|
4.3 | Create future-state architecture diagrams. |
|
Module 5: Establish a Modernization Roadmap
The Purpose
- Validate and build out initiatives with business users.
- Define benefits and costs to establish ROI.
- Identify enablers and barriers to modernization.
Key Benefits Achieved
- Completion of materials for a compelling business case and roadmap.
Activities: | Outputs: | |
---|---|---|
5.1 | Validate use cases with business users. |
|
5.2 | Define initiative benefits. |
|
5.3 | Identify enablers and barriers to modernization. |
|
5.4 | Define preliminary activities for initiatives. |
|
5.5 | Evaluate initiative costs. |
|
5.6 | Determine overall ROI. |
|