Data Warehousing and Business Intelligence for Managers
4.0 (251 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,042 students enrolled

Data Warehousing and Business Intelligence for Managers

Manage Data Warehousing and Business Intelligence Developers and Projects
4.0 (251 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,042 students enrolled
Last updated 11/2018
English
English [Auto]
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 3 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Manage an Analytics project
  • Manage an ETL team
  • Present Analytics topics to your clients
  • Talk intelligently about Data Warehousing and Business Intelligence
  • Talk intelligently about how Data Warehousing and Big Data fit together
  • Nod knowledgably when some smarty pants starts to show off about Data Lakes to you
  • Learn about a few common modern Analytics patterns
  • Understand at a high level the process an Engineering Team goes through to build an Analytics architecture
Requirements
  • Experience with IT projects large or small
  • Or: Experience with desktop or web Analytics tools (Power BI, Excel, Tableau, Domo, Lumira, etc.)
Description

Data Warehousing and Business Intelligence for Managers prepares you for the many data warehousing projects that are underway or scheduled to begin in large or small organizations. It's also an entryway into Big Data. If you've heard of data warehousing but never knew what it meant, this is the course for you. Have you always wanted to know what kind of enterprise software is made by Oracle, SAP, Informatica, Tableau, SAS, and even Microsoft?  The answer is Data Warehousing and Business Intelligence software, two categories of software that can even include one thing you probably have on your latptop right now: Microsoft Excel. 

The course is geared towards managers, but is also effective for non-techies or novices who want to understand one of the most important approaches to managing operations that organizations undertake, and that affects your life and your interaction with technology every day. The course is a series of video presentations, but also includes quizzes, a final project, and PDF downloads that will help familiarize you with data warehousing. 

Recent additions to this course include a greater exploration of Big Data, Data Lakes, and a little about cloud Big Data architecture. The course will continue to grow to explore more about the crossover and intersections between Data Warehousing, Business Intelligence, and Big Data (aka Analytics).

This course is quick to complete, giving you an overview of what you need most without going too deep for Data Warehousing novices. If you want a solid introduction to Data Warehousing and Business Intelligence, sign up for this course today!

3 hours of material

New material added periodically to the course

LIFETIME ACCESS to the course

Who this course is for:
  • This course is for Managers or Analytics novices who have limited experience with BI, Data Warehousing, and Big Data projects
  • This DW/BI course is not for Developers looking to learn ETL
Course content
Expand all 52 lectures 03:05:48
+ Introduction
2 lectures 03:56

Introduction to the course, whom it's for, and highlights, and who I am.

Preview 01:29

Course sections and benefits of the course.

Preview 02:27
+ Traditional Data Warehousing
31 lectures 01:54:17

Introductory story that leads us through the data warehouse path.

Preview 01:28

Where it fits, vs BI and BD

What is Data Warehousing
04:41
Basic DW Diagram
01:58
The Iron Triangle and Data Warehousing
11:20
The Data Journey
04:52
Data Warehousing Quiz #1
1 question

Data Warehousing Quiz #2

Data Warehousing Quiz #2
1 question

Data Warehousing Quiz #3

Data Warehousing Quiz #3
1 question
Summary
00:42
Introduction to SQL
01:38

SQL Quiz

SQL Quiz
1 question
Kimball Dimension and Fact Modelling
08:45

An additional lecture shwoing how to create a dimensional data model based on a very simple example.

Bonus Lecture: Creating a Simple Dimensional Data Model
04:59

Quiz corresponding to Bonus Lesson 1 on the simple dimensional model example

Bonus Lesson 1 Quiz
1 question
Inmon Relational Modelling
02:22
Big Data Modelling
02:05

Data Modeling Quiz

Data Modeling Quiz
1 question
Architecture
04:02
Summary
00:31
Introduction to Extract, Transform, Load
03:38

Preparation For the ETL

Bonus Lecture 2: Preparation For the ETL
02:08
Extracting Data
02:41
Transforming Data
01:26
Loading Data
03:03

Additional information about ETL development

Bonus Document 1: Things to Keep In Mind About the ETL
01:56

A few notes on ETL testing

Bonus Lecture 3: ETL Testing
02:14
ETL Quiz
1 question

ETL Quiz #2

ETL Quiz #2
1 question

How an Enterprise Data Warehouse should begin.

Bonus Quiz #2: Playing Well With Others
1 question
Bonus Lecture: Interview with a Data Architect
10:38
ETL Tools
04:34
Summary
00:50
Introduction to Business Intelligence
05:35
BI Tools
04:05
Managing Report Development
03:26
Summary
00:37
The First Final Project
08:01
+ Transitioning to Modern Data Warehousing
17 lectures 01:06:04

A look at current data warehousing.

Bonus: State of Data Warehousing in 2017
07:47

High level introduction to Data Lakes for Data Warehouse Managers

Data Lakes - Part I
02:33

Continuing the high level introduction to Data Lakes for Data Warehouse Managers

Data Lakes - Part II
08:12

What the Data Warehousing Project Manager can do to help the organization take full advantage of a Data Lake.

The BI/DW Project Manager in the Data Lake World
10:33
Real-Time Reporting
04:06
What's Streaming?
03:11
Fools Rush In...To Real-Time
01:08
Do Some Research into Distributed Architectures
03:27
The Traditional Data Warehouse -- 24 Hour Latency
02:48
Quick Reaction to Unelaborated Requirements
02:44
Requirements Redux
04:30
Last Look At Requirements
01:20
Lambda in the Cloud
03:10
Lambda On-Premises
02:23
Helpful Documentation
04:54
Organizing the Data Lake
02:14

I put up a diagram and you explain the diagram, in a video. Best one gets posted.

Challenge Time: You Tell Me
01:04
+ Conclusion
2 lectures 01:32
What You've Learned
00:55

This is the end. My beautiful friend. This is the end.

Preview 00:37