For over twenty years, data warehouses have served organizations in the areas of data integration, provisioning, management, and information delivery. Use cases ranging from basic reporting to advanced analytics have been successfully implemented across a variety of industries by companies of many different sizes.
Due to rapid growth of non-traditional data sources, availability of new technologies and growing expectations of managers to compete on analytics, the traditional data warehouse is re-defined and presented within a broader modern context. A corporate data ecosystem is evolving and presents new opportunities for creating business capabilities that were not previously possible. Amidst these changes, the data warehouse continues to play foundational and integral roles within the expanding data landscape.
This 4.5 hour online course re-defines the scope of the “modern” data warehouse. The need for planning and the role of architecture are described and clarified, followed by a discussion about the challenges related to gathering useful information requirements. This is followed by a discussion of design approaches, development, testing and quality management techniques.
The true value delivered to the organization by a data warehouse depends on operational and service activities that leverage the data components previously implemented. It is through this combination of data and technology assets with managed operations and services that desired analytical and business capabilities are created. The design and implementation approaches of operations and services are provided to highlight this key requirement. The course material presents a full life cycle of the data warehouse including business context, scope, requirements, design, implementation and operations.
Building and Operating a Data Warehouse
Click - here - to download a more detailed outline of this course.
This exam tests knowledge and understanding of basic concepts, principles, and terminology of building and operating a Data Warehousing.
Number of Questions: 25
Time Limit: 50 Minutes
Passing Score: 70%
Once you pass the exam, you will receive a Certificate of Education documenting that you have demonstrated mastery of the topic. Further, the exam counts towards Certified Information Management Professional (CIMP) designation in the Business Intelligence and Data Warehousing tracks.
We recommend that you take detailed notes and review the course material multiple times before taking this exam. Click here to learn more about CIMP exams.