Supporting the BI Analyst in further developing the DWH environment using SSIS and SQL Server 2016.
DW - Data Warehousing & Modeling
The project consisted of building a data warehouse/reporting solution in SQL Server/SSIS and Cognos BI. The KPI’s reporting solution was used for Finance Shared Service Center performance management and end-to-end process improvement.
The goal of the project was to have standard management report on functional level, with drill-down/drill through functionality to a number of predefined reports/dimensions.
Analysis/Design and Build of data warehouse and reporting environment of all Sales related reporting/analysis requirements.