Home > Instructors > Mark Peco >

Data Warehousing Fundamentals
Data Warehousing Fundamentals - online training course
 
Alternative Views:


4-hour 30-min Online Course by Mark Peco
Single-user access license
Our Price: $445.00


Product Code: DW-02-A


Course Exam [Add $100.00]

Description Course Outline Exam Details
 

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.

Click to play Course Sneak Peek

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.

You will learn:
  • The components that define a data warehouse platform
  • What trends impact the modern data warehouse
  • To position the data warehouse platform in the big data era
  • Architectural options and considerations
  • Development options and approaches
  • The requirements gathering process
  • Necessary design activities
  • How operations and service processes enable business capabilities
This course is geared towards:
  • Data warehousing program and project managers
  • Data warehouse architects
  • Data scientists and analytics professionals
  • Big Data practitioners
  • Data warehouse designers and developers
  • Data warehouse maintenance and support specialists
  • Data integration and management practitioners
  • Anyone who is new to data warehousing

Average Customer Review: Average Customer Review: 4 of 5 4 of 5 Total Reviews: 8 Write a review.

  0 of 0 people found the following review helpful:
 
4 of 5 Course Review from 6/1/2021 January 14, 2024
Reviewer: Daniel-Marian Ridiche  
Good course, more examples would have helped.

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
4 of 5 Course Review from 4/29/2023 January 9, 2024
Reviewer: Lintu Rashid  
Allow for the PPT to be downloaded for offline access of the presentation and student preparation.

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
4 of 5 Course Review from 10/29/2022 January 9, 2024
Reviewer: Su Vogel  
3NF and 2NF mentioned as well as de-normalisation but terms not explained - had to google it.

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
4 of 5 Course Review from 5/30/2021 January 6, 2024
Reviewer: Paul Boltjes  
I found it a bit peculiar that in the beginning the impact of big data on the data landscape was stressed so much, and then all of a sudden the scope of the course was revised and big data appeared not to be in scope.

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
3 of 5 Course Review from 3/16/2021 January 6, 2024
Reviewer: Jeroen Van Dullemen  
A bit high level and copy of the Data integration course.

Was this review helpful to you?

View All Customer Reviews

Browse for more products in the same category as this item:

Instructors > Mark Peco
Instructors
Courses