Data Modeling for Data Warehouse and Data Science training (English)
Opleidingsduur
2 dagen
Locatie
Cibit Academy BV (Iepenhoeve 9a, Nieuwegein)
Kosten
€ 1495
Data Modeling for Data Warehouse and Data Science training (English)
How do you get reliable decisions in your organization on a strategic, tactical and operational level? What is the role of a data warehouse in this? How do you integrate that with the NO-SQL world? Is the data in reports, dashboards and data science consistent? What methods and techniques do you need to build traditional data management and data science together? Which data modeling technique do you use?
Learn how to optimally set up the data architecture for Data Warehouse, Data Lake and Data Science in 2 days
Content and Program:
Data architecture ensures that information becomes available for use within Business Analytics and Business Intelligence. In this training you will learn how a data warehouse is built and can be adapted for your own organization, how you can integrate a data lake and which data modeling techniques can be used. After the training you have insight into what is needed to set up a data architecture and keep it up to date for a data warehouse, a data lake, a data vault or other data modeling techniques. Now and in the future.
In addition to the theory, ample time is spent on practical examples and exercises. This allows you to have a conversation in your own working environment about why a data warehouse is essential for integrated management.
Certification
Program
In the training we explain the concepts behind and components of a data warehouse.
Day 1: Methods and Techniques
- Introduction Data Management Body of Knowledge (DMBOK)
- Data Warehouse Architecture: Kimball, Inmon
- Data Integration & Interoperability
- Data Warehouse automation with Data Vault (Linstedt)
- Data Modeling: Relational, Dimensional
- ETL development
Day 2: Advanced modeling and implementation
- Advanced Data Warehouse Modeling: Slowly changing dimensions, Advanced dimensional modeling
- NO-SQL modelling: Graph, ColumnOriented, Key value stores, NLP
- Document & Content Management
- Test the data architecture
- Agile Data Integration projects using disciplined agile methods: Scrum, Extreme Programming, Lean Six Sigma and Kanban
Target Audience:
This training is intended for Data Management professionals who want to gain a solid overview of Data Warehousing and Data Integration disciplines, as well as for professionals seeking professional recognition and certification within the Data Management domain. The training is suitable for, among others:
- Data Stewards
- Data Engineers
- Business Intelligence & Data Warehouse team leaders
- Developers and architects
- Data Modellers
- Data Architects and Data Analysts
- Business Analysts
- Database Administrators
- Project and Program Managers
- IT Consultants
- Data Governance Managers
- Data Quality Professionals
Prerequisites:
Participants are expected to have at least junior-level experience (approximately 3 to 5 years) within organizations. They work with data and/or information products, or are about to start working in this domain.
Thanks to the differentiated approach of the training, it is also well suited for professionals at a medior level (approximately 5 to 10 years of experience).
After completing this training, you will be able to:
- Explain and apply the key concepts and components of a data warehouse.
- Compare different data warehouse architectures (such as Kimball and Inmon) and make well-founded design choices.
- Analyse data integration challenges and design appropriate solutions.
- Create and evaluate relational and dimensional data models.
- Apply advanced data warehouse modeling techniques, including Slowly Changing Dimensions.
- Position NoSQL modeling techniques within the overall data architecture.
- Understand the relationship between Data Warehousing, Data Lakes and Data Science.
- Ensure data quality and consistency across reports, dashboards and analytics.
- Effectively support and assess agile data integration projects.
- Contribute to a robust and future-proof data architecture within your organization.
Examen en Certificering
Certification – Certified Data Management Professional (CDMP)
This training prepares you for the CDMP specialty exams
Data Warehousing & BI, Data Modeling and/or
Data Integration & Interoperability.
When supplemented with the CDMP exam Data Management Fundamentals, the CDMP Master certificate can be obtained. Please note that obtaining the Master level also requires relevant years of professional experience.
Er staan op dit moment geen trainingen gepland. Heeft u vragen of bent u op zoek naar een specifieke training? Neem dan contact met ons op — we helpen u graag verder.
Persoonlijk advies?
Berad Çelik | Cibit
Accountmanager
T. 0302308900
E. b.celik@cibit.nl
STEL MIJ EEN VRAAG →
Persoonlijk advies?
Frank van Rooijen | Cibit
Directeur
T. 06-47193074
E. f.vanrooijen@cibit.nl
STEL MIJ EEN VRAAG →
Persoonlijk advies?
John Maessen | Cibit
Account Manager
T. 0302308900
E. j.maessen@cibit.nl
STEL MIJ EEN VRAAG →What makes cibit unique?
- We combine deep expertise in data management and data architecture with a strong understanding of organization, culture and collaboration.
- Our trainings are based on international standards (such as DAMA-DMBOK), always translated into day-to-day practice.
- We approach data not only from a technical perspective, but also from governance, processes, roles and responsibilities.
- Our trainers are consultants and vice versa, ensuring that theory is directly connected to current real-world experience.
- We work with recognizable real-life examples and case studies from various sectors.
- The training accommodates different experience levels through a differentiated approach.
- Participants do not only learn how things should work in theory, but especially how to apply them concretely within their own organization.