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

Data Warehouse Development Process - Part 1

Inf Sid, ETL/Data Architect

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
31 Videos (2h 11m)
    • Different Categories of Data Warehouse Projects

      4:59
    • Data warehouse and Business Intelligence Glossary Part 1

      7:13
    • Data warehouse and Business Intelligence Glossary Part 2

      4:24
    • Additional Information on all the related keywords for the DW/BI projects

      1:15
    • What are Functional Requirements?

      2:52
    • What are Non Functional Requirements?

      4:27
    • The Software Development Process

      4:39
    • What are the widely used methodologies for Enterprise Data Warehouse Set up?

      3:33
    • What is the Waterfall Model and what are the different phases involved?

      2:20
    • What are the different phases in Waterfall model?

      1:43
    • What is the Requirements phase?

      6:12
    • What is the importance of the Analysis phase and how IT plays a part in this?

      2:22
    • What are the activities done during the Design phase?

      7:45
    • What are the activities done during the Coding phase?

      3:48
    • What are the activities done during the Testing phase?

      3:08
    • What are the activities in Operations and Maintenance Phase?

      4:26
    • Follow the POC (Proof of Concept) model for better results

      4:26
    • What are the advantages of using the Waterfall Model?

      2:59
    • What are the disadvantages of using the Waterfall Model?

      3:58
    • What are the different activities in the Verification phase?

      12:00
    • What are the different activities in the Validation phase?

      6:06
    • What are the advantages of the V Model?

      2:04
    • What are the disadvantages of the V Model?

      2:06
    • Iterative Model

      10:40
    • Incremental Model

      3:16
    • What is Agile Method?

      2:23
    • What are the advantages of Agile Model?

      5:04
    • What are the disadvantages of Agile Model?

      2:14
    • When to use the Agile Model?

      2:18
    • What are the other available models?

      1:33
    • Which model to choose for the Data Warehouse environment?

      4:24

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.

9

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