Data Warehousing and Business Intelligence for Managers

BY
Udemy

Mode

Online

Fees

₹ 499 2299

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course and certificate fees

Fees information
₹ 499  ₹2,299
certificate availability

Yes

certificate providing authority

Udemy

The syllabus

Introduction

  • Introduction
  • About the Course

Traditional Data Warehousing

  • The Story So Far...
  • What is Data Warehousing
  • Why build a Data Warehouse
  • Basic DW Diagram
  • The Iron Triangle and Data Warehousing
  • The Data Journey
  • Data Warehousing Quiz #1
  • Data Warehousing Quiz #2
  • Data Warehousing Quiz #3
  • Summary
  • Introduction to Data Modeling
  • Introduction to SQL
  • SQL Quiz
  • Kimball Dimension and Fact Modelling
  • Bonus Lecture: Creating a Simple Dimensional Data Model
  • Bonus Lesson 1 Quiz
  • Inmon Relational Modelling
  • Big Data Modelling
  • Data Modeling Quiz
  • Architecture
  • Summary
  • Introduction to Extract, Transform, Load
  • Bonus Lecture 2: Preparation For the ETL
  • Extracting Data
  • Transforming Data
  • Loading Data
  • Bonus Document 1: Things to Keep In Mind About the ETL
  • Bonus Lecture 3: ETL Testing
  • ETL Quiz
  • ETL Quiz #2
  • Bonus Quiz #2: Playing Well With Others
  • Bonus Lecture: Interview Preview
  • Bonus Lecture: Interview with a Data Architect
  • ETL Tools
  • Summary
  • Introduction to Business Intelligence
  • BI Tools
  • Managing Report Development
  • Summary
  • The First Final Project

Transitioning to Modern Data Warehousing

  • Bonus: State of Data Warehousing in 2017
  • Data Lakes - Part I
  • Data Lakes - Part II
  • The BI/DW Project Manager in the Data Lake World
  • Real-Time Reporting
  • What's Streaming?
  • Fools Rush In...To Real-Time
  • Do Some Research into Distributed Architectures
  • The Traditional Data Warehouse -- 24 Hour Latency
  • Quick Reaction to Unelaborated Requirements
  • Requirements Redux
  • Last Look At Requirements
  • Lambda in the Cloud
  • Lambda On-Premises
  • Helpful Documentation
  • Organizing the Data Lake
  • Challenge Time: You Tell Me

Conclusion

  • What You've Learned
  • Epilogue

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books