Data Warehouse Development Process
Learn the specific aspects of the Data Warehouse Development Process
Updated on Oct, 2024
Language - English
Development ,Data Science,Big Data
Lectures -64
Duration -3.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Data is a new asset for the enterprises. And, Data Warehouse stores the data for better insights and knowledge using Business Intelligence. The development of an Enterprise Data Warehouse has more challenges compared to any other software project because of the
Challenges with data structures.
The way data is evaluated for its quality.
Complex business rules/validation.
Different development methods (various SDLC models like the fall model, V model, Agile Model, Incremental model, and Iterative model)
Regulatory requirements for various domains like finance, telecom, insurance, Retail and IME.
Compliance with third-party governing bodies.
Extracting data for various visualization purposes.
In this course, we talk about the specific aspects of the Data Warehouse Development process taking real-time practical situations and how to handle them better using best practices for sustainable, scalable and robust implementations.
Goals
- Understand various stages in the Data Warehouse development process.
- Various processes like the Waterfall model, V model and Agile methods.
- Specific aspects of the Data Warehouse development process.
- Importance of the various phases and the practicality of each phase.
- Overview of various issues and Project Management issues to be considered in the Data warehouse and Business Intelligence projects.
Prerequisites
- Basics of Data Warehouse Concepts.
- Terms and terminologies used in Data Warehouse and Business Intelligence projects.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Practical Exercises, Documents and Material
01:37
01:37
Different Categories of Data Warehouse Implementations
1 Lectures
Keywords/Terms used in this course
5 Lectures
Methodologies used for Data Warehouse Software Development
2 Lectures
Waterfall Model
11 Lectures
V Model
3 Lectures
Agile Model
5 Lectures
Other SDLC Models
1 Lectures
Which model to choose for the available models?
1 Lectures
Practical Implementation Steps
1 Lectures
Project Planning
6 Lectures
Requirements
8 Lectures
Design
7 Lectures
Build and Develop
5 Lectures
Deploy
1 Lectures
Maintenance and Operations
1 Lectures
Review of the completed tasks
3 Lectures
Production Support and Maintenance
1 Lectures
Instructor Details
Inf Sid
Business Intelligence Consultant and Trainer with 14+ years of extensive work experience on various client engagements. Delivered many large data warehousing projects and trained numerous professionals on business intelligence technologies. Extensively worked on all facets of data warehousing including requirement gathering, gap analysis, database design, data integration, data modeling, enterprise reporting, data analytics, data quality, data visualization, OLAP.
Has worked on broad range of business verticals and hold exceptional expertise on various ETL tools like Informatica Power center, SSIS, ODI and IDQ, Data Virtualization, DVO, MDM.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now