Course Outline
- Basis, doelstellingen en toepassing van datawarehouse, datawarehouse-servertypes
- basisopbouw ETL-processen in SSIS
- basisontwerpgegevenskubussen in een Analysis Services: meting groepsmeting
- dimensies, hiërarchieën, attributen,
- ontwikkeling van de projectdatakubussen: berekende maatregelen, partities, perspectieven, vertalingen, acties, KPI's,
- Bouwen en implementeren, een partitie verwerken
- de basis XML / A: Partitionering, processen en algemene incrementele, partities verwijderen, aggregatieprocessen,
- basis MDX-taal
Requirements
Kennis van Windows, basiskennis van SQL en relationele databases.
Getuigenissen (5)
Duidelijke uitleg met goede voorbeelden, zodat ik mij kon identificeren met mijn eigen vakgebied.
Elaine Vermeulen - Sandoz BV
Cursus - Alteryx for Developers
Machine Translated
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
Angelito Aguilar - Metrobank
Cursus - Introduction to SQL Server 2012 Integration Services (SSIS)
I enjoyed the exercises session the most as I get to understand how to apply. Would definitely enjoyed it more if there are more combination exercises :)
Joan Ng
Cursus - Data Preparation with Alteryx
Use cases were awesome! and Ray involved each and every one of us in each use case.
Zara - Trench Ltd
Cursus - Alteryx for Data Analysis
team work