EMEA Learning Operational DatawareHouse

it_user314655 - PeerSpot reviewer
100 people affected
3 people managed
6 month project

Project Description

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.

Difficulties

Hard to meet schedule

Products Used

Technical Skills Used

  • Business Intelligence
  • Data Warehouse
  • Dimensional Modeling
  • ETL
  • SCD1, SCD2
  • Dashboards
  • SLAs, KPIs
  • Iasi (RO)47.166727.6
  • Barbera del Valles (ES)41.51592.12457