Build a Data Warehouse
Business insights come from both structured and unstructured data.
Book This 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
Book Your Workshop
Onsite Workshops offer an easy way to accelerate your project. If you are unable to do the project yourself, and a Guided Implementation isn’t enough, we offer low-cost onsite delivery of our Project Workshops. We take you through every phase of your project and ensure that you have a road map in place to complete your project successfully.
Book NowModule 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. |
|