Data Warehousing and Business Intelligence for Managers
3.9 (47 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
270 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Warehousing and Business Intelligence for Managers to your Wishlist.

Add to Wishlist

Data Warehousing and Business Intelligence for Managers

Learn everything you need to manage a team of Data Warehousing/Business Intelligence and ETL Developers on a project
3.9 (47 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
270 students enrolled
Created by Samori Augusto
Last updated 3/2016
English
Current price: $10 Original price: $25 Discount: 60% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Manage a Data Warehousing and project
  • Manage an ETL team
  • Present Data Warehousing topics to their clients
View Curriculum
Requirements
  • Have experience with IT projects
  • Download the open version of Pentaho, but do not install it yet
  • Download Power BI and Power Query
  • Download the community version of Informatica (you will need a PC to run Informatica)
Description

Data Warehousing and Business Intelligence for Managers prepares you for the many data warehousing projects that are underway or scheduled to begin in both federal and private 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 eneterprise 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 who want to understand one of the largest 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, PDF downloads, and a dive into two pieces of important software that will help familiarize you with data warehousing. 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!

Over 1.5 hours of material!

New material will be added periodically to this course.

Once you register, you will have LIFETIME ACCESS to this course.

Who is the target audience?
  • This DW/BI course is for Project Managers who have no experience with DW/BI projects
  • This DW/BI course is for Project Managers with no experience of ETL work
  • This DW/BI course is for Project Managers who have previously managed IT projects
  • This DW/BI course is not for Developers looking to learn ETL
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 27 Lectures Collapse All 27 Lectures 01:34:33
+
Introduction
1 Lecture 01:52

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

Preview 01:52
+
Data Warehousing
7 Lectures 28:14

Introductory story that leads us through the data warehouse path.

The Story So Far...
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
+
Data Modeling
7 Lectures 25:36

Introduction to SQL
01:38

SQL Quiz

SQL Quiz
1 question

Kimball Dimension and Fact Modelling
08:45

Inmon Relational Modelling
02:22

Big Data Modelling
02:05

Data Modeling Quiz

Data Modeling Quiz
1 question

Architecture
04:02

Summary
00:31
+
ETL
6 Lectures 16:12
Introduction to Extract, Transform, Load
03:38

Extracting Data
02:41

Transforming Data
01:26

Loading Data
03:03

ETL Quiz
1 question

ETL Quiz #2

ETL Quiz #2
1 question

ETL Tools
04:34

Summary
00:50
+
Business Intelligence
4 Lectures 13:43
Introduction to Business Intelligence
05:35

BI Tools
04:05

Managing Report Development
03:26

Summary
00:37
+
The Project
1 Lecture 08:01
The Final Project
08:01
+
Conclusion
1 Lecture 00:55
What You've Learned
00:55
About the Instructor
Samori Augusto
3.9 Average rating
47 Reviews
290 Students
2 Courses
Project Manager and Microentrepreneur

Samori Augusto was a programmer in another life, a dotcom bubble survivor, and is now a certified Project Management Professional who has worked for a decade in Data Warehousing and Business Intelligence. Along the way he's experimented with entrepreneurship in the dotcom bubble and just microentrepreneurship from home. The best way to trick Samori into doing something is if it involves music, writing, or data and small businesses. He is now, unfortunately, back to just one over-excited/bored strange kitten.