ExistBI selected by a US & German Manufacturer for a Phase 1 Business Intelligence and Azure Cloud Data Warehouse Assessment which quickly moved onto a Phase 2 and Phase 3 implementation. We started with financial and sales data sources, followed by operational. Our team has been working with the German and US headquarters, creating a new Azure data warehouse by integrating data sources from each countries own data warehouse to create a single version of the truth for the entire Company. The project involved designing, implementing and maintaining a data warehouse on Azure using Azure Data Factory, Azure SQL Managed Instance, Azure Analysis Services, Power BI, and providing training to the company’s staff for using the new system.
Our Cloud Data Warehouse Consulting services help customers lay the foundations for a successful new Data Warehouse project using a phased approach, starting with a BI Assessment, see below:
1st Phase – BI Strategy & Planning Assessment
– Solidify the stakeholders vision and objectives
– Review EDW/DWH/BI environment and strategy
– Understand the current capability and scalability
– Risk management framework
Typical BI Assessment outcome deliverables, include:
– Requirement Analysis Document (including prioritization)
– Scope document
– Landscape overview (including dataflows)
– Target architecture
The 2nd phase involved translating detailed requirements into data structures that are scalable, resilient, extensible, and sustainable:
– Review and document existing data sources
– Analysis of existing reports, Key Performance Indicators & processes, data-mining needs
– Gap analysis on data sources
– Logical design of Data Warehouse
– Logical design of ETL architecture
The 3rd phase involved building a Cloud Azure Data Warehouse, transforming and loading the data:
– Physical design of databases and schemas
– ETL routines development
– Data profiling & testing bulk data (pre-load)
– Loading of historic data into Data Warehouse
– Data profiling & testing, including UAT
– Data automation tuning