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, dashboard 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?
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 – Certified Data Management Professional. This training prepares for the CDMP specialty exams Data Warehousing & BI, Data Modeling and/or Data Integration & Interoperability. Supplemented with the CDMP exam Data Management Fundamentals, the CDMP Master certificate can be obtained. This also requires “years of experience”.
In the training we explain the concepts behind and components of a data warehouse.
• 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
• 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
Data Management professionals who wish to gain an overview of the Data Warehousing and Data Integration disciplines and those seeking professional recognition and certification for Data Management, including: Data Stewards, Data Engineers, Business Intelligence & Data Warehouse Team Leaders, Developers & Architects, Data Modellers, Developers, Data Architects and Analysts, , Business Analysts, Database Administrators, Project / Program Managers, IT Consultants, Data Governance Managers, Data Quality Professionals.