Data Warehousing And Business Intelligence For Managers

Manage Data Warehousing and Business Intelligence Developers and Projects

Last updated 2022-01-10 | 4.2

- Manage an Analytics project
- Manage an ETL team
- Present Analytics topics to your clients

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

4 sections • 61 lectures

Introduction Preview 01:29

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

About the Course Preview 02:27

Course sections and benefits of the course.

The Story So Far... Preview 01:28

Introductory story that leads us through the data warehouse path.

What is Data Warehousing Preview 04:41

Where it fits, vs BI and BD

Why build a Data Warehouse Preview 03:13

Basic DW Diagram Preview 01:58

The Iron Triangle and Data Warehousing Preview 11:20

The Data Journey Preview 04:52

Data Warehousing Quiz #1

Data Warehousing Quiz #2

Data Warehousing Quiz #2

Data Warehousing Quiz #3

Data Warehousing Quiz #3

Summary Preview 00:42

Introduction to Data Modeling Preview 06:13

Introduction to SQL Preview 01:38

SQL Quiz

SQL Quiz

Kimball Dimension and Fact Modelling Preview 08:45

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

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

Bonus Lesson 1 Quiz

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

Inmon Relational Modelling Preview 02:22

Big Data Modelling Preview 02:05

Data Modeling Quiz

Data Modeling Quiz

Architecture Preview 04:02

Summary Preview 00:31

Introduction to Extract, Transform, Load Preview 03:38

Bonus Lecture 2: Preparation For the ETL Preview 02:08

Preparation For the ETL

Extracting Data Preview 02:41

Transforming Data Preview 01:26

Loading Data Preview 03:03

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

Additional information about ETL development

Bonus Lecture 3: ETL Testing Preview 02:14

A few notes on ETL testing

ETL Quiz

ETL Quiz #2

ETL Quiz #2

Bonus Quiz #2: Playing Well With Others

How an Enterprise Data Warehouse should begin.

Bonus Lecture: Interview Preview Preview 00:36

Bonus Lecture: Interview with a Data Architect Preview 10:38

ETL Tools Preview 04:34

Summary Preview 00:50

Introduction to Business Intelligence Preview 05:35

BI Tools Preview 04:05

Managing Report Development Preview 03:26

Summary Preview 00:37

The First Final Project Preview 08:01

Bonus: State of Data Warehousing in 2017 Preview 07:47

A look at current data warehousing.

Data Lakes - Part I Preview 02:33

High level introduction to Data Lakes for Data Warehouse Managers

Data Lakes - Part II Preview 08:12

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

The BI/DW Project Manager in the Data Lake World Preview 10:33

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

Real-Time Reporting Preview 04:06

What's Streaming? Preview 03:11

Fools Rush In...To Real-Time Preview 01:08

Do Some Research into Distributed Architectures Preview 03:27

The Traditional Data Warehouse -- 24 Hour Latency Preview 02:48

Quick Reaction to Unelaborated Requirements Preview 02:44

Requirements Redux Preview 04:30

Last Look At Requirements Preview 01:20

Lambda in the Cloud Preview 03:10

Lambda On-Premises Preview 02:23

Helpful Documentation Preview 04:54

Organizing the Data Lake Preview 02:14

Challenge Time: You Tell Me Preview 01:04

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

What You've Learned Preview 00:55

Epilogue Preview 00:37

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