Concepts, Design and Modelling for Extended Data Warehousing ONLINE
Details
Purpose: This course provides an overview of the full Data Warehouse lifecycle – front-end, back-end and it includes concepts such as Data Governance, Data Lakes, Traditional DW, Big Data, Cloud and more.
The full lifecycle of a Business Intelligence / Data Warehouse project is covered and after completing this comprehensive course Practitioners will be armed with sufficient knowledge to guide them through the process of designing Business Intelligence / Data Warehousing solutions.
Approximately one and a half days are allocated to Dimensional Modeling.
Guidelines are provided on how to complement and extend the lifespan of existing Data Warehouses by positioning the role of Data Lakes and other modern concepts.
This is a technology independent course that teaches sound principles, to be applied
no matter what technology is used. Technologies and role players in the BI space are mentioned where applicable. The main focus is to convey concepts and strategies for efficient design and modeling of a framework for implementation, using
any tools of choice.
Who should attend:
Business Intelligence Project Managers
-
- Business Intelligence Analysts
- Data Warehouse Practitioners
- Data Scientists
- Database Administrators
- Data Warehouse Developers
Outline
Topics:
- Prerequisite for successful BI
- Formulating a Business Intelligence Information Strategy
- Discussing an Achitectural Approach
- Traditional and Modern techniques in perspective
- Business Requirements Analysis
- Where to start
- What and Why of Data Warehousing
- Extended Data Warehouse Architectures
- Design framework
How to:o Implement a Data Warehouse Project
- Project Phases: Business, Technical, Implementation
- The Dimensional Modeling Lifecycle
o Design and Model a Data Warehouse
- Design Principles: Introduction
- Design Principles: Expanded
o Build and Deploy a Data Warehouse
- Back-room vs Front-room
- ETL concepts
- Various types of analytics
- New waves
o Big Data, Hadoop Eco System
o Data Lake and Lakehouse
o Data Lakes, where it fits, pitfalls, Data Lake Players
o Significance of Meta Data, Data Catalogues
o The Cloud: service models – SaaS, PaaS, Iaas, XaaS
- Real Life Lessons
- Futuristic views
- Additional resources
Speaker/s
Having trained in excess of 1000 people in the concepts of Data Warehousing and Business Intelligence we have established ourselves as a reliable, skilled and highly knowledgeable source for the transfer of information and training.
Special Offer
Schedules
No. of Days: | 5 |
Alicornio Africa’s training services and consulting covers the entire spectrum of business intelligence, data warehousing, data profiling and data integration.
Alicornio Africa has established itself as a source of reliability, proficiency and professionalism when it comes to the transfer of knowledge and skills. Our technology independent courses taught by our experienced hands-on presenters are highly rated.
The comprehensive data warehouse course content has been designed to educate and empower both the layman and business intelligence practitioner alike.Alicornio offers practical courses, which aim to simplify the process and take the complexity out of these potentially complicated subject areas.
Having trained in excess of 1000 people in the concepts of Data Warehousing and Business Intelligence, we have established ourselves as a reliable, skilled and highly knowledgeable source for the transfer of information and training.
Our courses:
- Data Warehouse Overview for Executives
- Concepts, Design and Modelling for Extended Data Warehousing
- Business Analysis for Analytical Systems