Data Warehouse Development Process - Part 2 | Inf Sid | Skillshare

Data Warehouse Development Process - Part 2

Inf Sid, ETL/Data Architect

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
34 Videos (1h 44m)
    • What are the other SDLC Models?

      1:33
    • Which is the best model?

      4:24
    • Defining the scope for the requirements

      6:01
    • Determining the goals and objectives of the project

      2:26
    • The Implementation Strategy

      2:06
    • Resource Identification and Alignment

      3:37
    • Project Deliverable and Timeline

      1:35
    • Summary - Quick Recap

      1:28
    • What are needed for the Requirements?

      2:10
    • Who gathers the requirements?

      2:59
    • How to perform the interviews to gather the requirements?

      1:15
    • Common questions which are usually asked during the Interviews

      4:06
    • Common questions which Business can ask IT

      8:53
    • Review of existing documents and resources

      0:45
    • Analyze the existing sources

      4:35
    • Design of the logical data model

      1:32
    • Data Architecture

      2:15
    • Data Architecture - How the data is organized and structured for various phases

      5:25
    • Technical Architecture

      1:04
    • Technical Architecture - The Hardware and Software part

      4:07
    • Delivery Framework

      1:01
    • Design the ETL process and functions

      2:11
    • Infrastructure Setup

      1:47
    • Data Warehouse/RDBMS Setup

      0:46
    • ETL Setup

      2:49
    • OLAP and Reporting Setup

      0:58
    • Testing the data flow

      2:02
    • Versioning, Deployment and Production Release

      3:00
    • What are the activities done during the maintenance and operations?

      4:26
    • What went Right? and What went Wrong?

      4:35
    • Scoping and De-Scoping

      2:33
    • Application Usage Review

      6:37
    • Support and Maintenance

      7:46
    • Final Note

      1:34

About This Class

What Will I Learn?

  • Understand various stages in Data Warehouse development process
  • Various processes like Waterfall model, V model and Agile methods
  • Specific aspects of 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

Requirements:

  • Basics of Data Warehouse Concepts
  • Terms and terminologies used in a Data Warehouse and Business Intelligence projects

Description:

Data is the new asset for the enterprises. And, Data Warehouse store the data for better insights and knowledge using Business Intelligence. Development of an Enterprise Data Warehouse has more challenges compared to any other software projects because of the 

  • Challenges with data structures
  • The way data is evaluated for it's quality
  • Complex business rules/validations
  • Different development methods (various SDLC models like Water Fall model, V model, Agile Model, Incremental model, Iterative model)
  • Regulatory requirements for various domains like finance, telecom, insurance, Retail and IME
  • Compliance from 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.

2

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Inf Sid

ETL/Data Architect

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 r...

See full profile

Technology Data Science
Report class