3.81 out of 5
3.81
178 reviews on Udemy

Data Warehousing and Business Intelligence for Managers

Manage Data Warehousing and Business Intelligence Developers and Projects
Instructor:
Samori Augusto
787 students enrolled
English [Auto-generated]
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

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

Introduction

1
Introduction

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

2
About the Course

Course sections and benefits of the course.

Traditional Data Warehousing

1
The Story So Far...

Introductory story that leads us through the data warehouse path.

2
What is Data Warehousing

Where it fits, vs BI and BD

3
Why build a Data Warehouse
4
Basic DW Diagram
5
The Iron Triangle and Data Warehousing
6
The Data Journey
7
Data Warehousing Quiz #1
8
Data Warehousing Quiz #2

Data Warehousing Quiz #2

9
Data Warehousing Quiz #3

Data Warehousing Quiz #3

10
Summary
11
Introduction to Data Modeling
12
Introduction to SQL
13
SQL Quiz

SQL Quiz

14
Kimball Dimension and Fact Modelling
15
Bonus Lecture: Creating a Simple Dimensional Data Model

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

16
Bonus Lesson 1 Quiz

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

17
Inmon Relational Modelling
18
Big Data Modelling
19
Data Modeling Quiz

Data Modeling Quiz

20
Architecture
21
Summary
22
Introduction to Extract, Transform, Load
23
Bonus Lecture 2: Preparation For the ETL

Preparation For the ETL

24
Extracting Data
25
Transforming Data
26
Loading Data
27
Bonus Document 1: Things to Keep In Mind About the ETL

Additional information about ETL development

28
Bonus Lecture 3: ETL Testing

A few notes on ETL testing

29
ETL Quiz
30
ETL Quiz #2

ETL Quiz #2

31
Bonus Quiz #2: Playing Well With Others

How an Enterprise Data Warehouse should begin.

32
Bonus Lecture: Interview Preview
33
Bonus Lecture: Interview with a Data Architect
34
ETL Tools
35
Summary
36
Introduction to Business Intelligence
37
BI Tools
38
Managing Report Development
39
Summary
40
The First Final Project

Transitioning to Modern Data Warehousing

1
Bonus: State of Data Warehousing in 2017

A look at current data warehousing.

2
Data Lakes - Part I

High level introduction to Data Lakes for Data Warehouse Managers

3
Data Lakes - Part II

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

4
The BI/DW Project Manager in the Data Lake World

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

5
Real-Time Reporting
6
What's Streaming?
7
Fools Rush In...To Real-Time
8
Do Some Research into Distributed Architectures
9
The Traditional Data Warehouse -- 24 Hour Latency
10
Quick Reaction to Unelaborated Requirements
11
Requirements Redux
12
Last Look At Requirements
13
Lambda in the Cloud
14
Lambda On-Premises
15
Helpful Documentation
16
Organizing the Data Lake
17
Challenge Time: You Tell Me

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

Conclusion

1
What You've Learned
2
Epilogue

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

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.8
3.8 out of 5
178 Ratings

Detailed Rating

Stars 5
58
Stars 4
70
Stars 3
35
Stars 2
9
Stars 1
6
bcc877da1b6703f53c80b4b9d434db65
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
3 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion