Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development Data Warehouse

Data Warehousing

An introductory course about understanding data warehousing, its architecture, flow, applications and modeling.
Rating: 3.4 out of 53.4 (180 ratings)
1,139 students
Created by The Art Of Service
Last updated 3/2015
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Be introduced to the data warehouse, its advantages and disadvantages.
  • Know the concepts, lifecycle and rules of the data warehouse.
  • Be informed of the importance and the techniques of data warehouse modeling.
  • Recognize the different applications of data warehousing.
  • Look forward to the future of the data warehouse.

Course content

9 sections • 66 lectures • 2h 53m total length

  • Preview00:30
  • Preview04:11
  • Preview04:47
  • Preview02:23
  • Disadvantages of Data Warehousing
    03:08
  • Benefits of Data Warehousing
    02:11
  • Concepts of Data Warehousing
    04:10

  • Introduction and Objectives
    00:37
  • Online Transaction Processing
    08:42
  • Data Store
    00:53
  • Data Mart
    03:24
  • Design Schemas
    07:58
  • Meta Data
    03:19
  • Data Webhouse and Data Warehousing Queries
    00:51
  • Extract, Transform, Load
    06:55

  • Introduction and Objectives
    00:25
  • Data Warehouse Lifecycle
    00:36
  • Design
    01:05
  • Prototype
    01:00
  • Deploy
    01:16
  • Operate
    00:30
  • Enhance
    00:34
  • Data Warehouse Cycle of Cycles
    00:30
  • First Loop
    00:38
  • Second Loop
    00:59
  • Third Loop
    01:46
  • Fourth Loop
    00:28
  • Related Factors
    03:21
  • Rules of Data Warehouse
    06:51

  • Introduction and Objectives
    00:25
  • Introduction to Data Warehouse Architecture
    00:41
  • Key Components
    06:07
  • Benefits of Data Warehouse Architecture
    01:18
  • Typical Architecture of Data Warehousing
    06:32
  • Common Architecture
    02:45
  • Data Warehouse Information Flow
    00:43

  • Introduction and Objectives
    00:24
  • Importance of Data Modeling
    03:17
  • Introduction to Data Modeling Techniques
    00:57
  • Entity-Relationship Modeling
    07:22
  • Limitations of ER
    02:06
  • Dimensional Modeling
    04:10
  • Benefits of Dimensional Modeling
    02:07

  • Introduction and Objectives
    00:25
  • Introduction to Data Warehouse Application
    02:40
  • Retail Industry
    03:34
  • Manufacturing and Distribution
    03:01
  • Bank
    01:47
  • Insurance Company
    03:33
  • Health Care Providers
    05:15
  • Government Agencies
    03:15
  • Internet Companies
    03:27
  • Telecommunications
    03:58
  • Sports
    00:58

  • Introduction and Objectives
    00:25
  • Challenges to Data Warehousing
    00:44
  • Ensuring Data Quality
    02:39
  • Ensuring Performance
    03:05
  • Testing the Data Warehouse
    02:01
  • Reconciliation of Data
    01:59
  • User Acceptance
    01:14
  • Future of Data Warehouse
    10:33

  • Data Warehousing Glossary of Terms
    3 pages

  • Final Exam
    1 page
  • Evaluation Form
    1 page
  • Conclusion - Final Lecture
    01:27

Requirements

  • Basic understanding of the IT industry
  • Knowledge of the English language

Description

Discover the latest data storage trend implemented by leading IT Professionals around the globe, known as Data Warehousing.

A data warehouse (DW) is a database used for reporting. The data is uploaded from the operational systems and may pass through an operational data store for additional processes before it is used in the data warehouse for reporting. This introductory course will discuss its benefits and concepts, the twelve rules which should be followed, the lifecycle of data that is warehoused, the flow and the architecture of data warehouse. It will also teach learners the applications of data warehousing, its challenges and its future.

Who this course is for:

  • Recent graduates looking to get a foothold in the IT Industry.
  • Finance professionals wanting to learn about Data Warehouses for reporting and analysis purposes, businesses looking to update and improve on data storage, analysis, and reporting processes.
  • IT professionals wanting to learn more about data storage, Data Warehousing modeling, or Data Warehousing applications.

Featured review

Sanele Maziya
Sanele Maziya
28 courses
13 reviews
Rating: 5.0 out of 5a year ago
Wow!, This is great. I am definitely taking another course. It is eye opening. I can already see how learning this course could greatly transform the way the management or executive picture my organization and the way we handle data.

Instructor

The Art Of Service
Quality education for Career Driven IT Professionals
The Art Of Service
  • 3.6 Instructor Rating
  • 3,526 Reviews
  • 15,192 Students
  • 53 Courses

What drives us?

In one word? YOU

You are front, center and behind every decision we make in our business.

  • You are starting out in the IT industry
  • You are serious about your career
  • You need certifications on your resume to get that first interview

For you we created the Foundation level courses as well as the Core Series for IT

  • You are an IT Professional with a proven career
  • You need to stay in touch with changes in the industry
  • You need to continue to show your value to the business to ensure your job is secure
  • You want to find out what else would make your IT career more solid

For you we created the Specialist and Intermediate level courses as well as the Core Series for IT

  • You are implementing Processes and methodologies in your company
  • You are managing a team of people and need to look good
  • You started your own business and are looking for template documents to ‘hit the ground running’
  • You need to present on a subject at the next team meeting and are not quite sure where to start

For you we created the Toolkits as well as the Core Series for IT


Our motto:
Every Career driven IT Professional needs to be able to afford quality IT educational materials to stay relevant in their job, irrespective of current position, budget or geographical location.

We do most of the work behind the scenes so that you can focus on your professional education and your career within the IT industry.

We see it as our job to ensure we give you the most up to date information you need to succeed in achieving that goal at a price-point that is makes it accessible to most professionals.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.