EMEA Learning Operational DatawareHouse
- Dimensional model design for EMEA Learning Datawarehouse that will be used in subsequent BAM and BI projects.
- ETLs development in MS SSIS over SQL Server 2008/2014 R2 SP2. Staging area, normalization and business information load on the multidimensional data model in the DWH from leading market Learning Tools for several customers.
- Creating and exposing DWH model using Microstrategy Architect to cover business requirements and operational data analysis to provide Business Intelligence artefacts for Internal Learning SBUs.
- First proposal delivery to the business teams with Microstrategy reports and dashboard to provide business and performance analysis in the agreed key areas.