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
4.5 (15 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.
142 students enrolled
Instructed by Samori Augusto IT & Software / Other
$19
$20
5% off
Take This Course
  • Lectures 27
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

Course 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.

What are the 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)

What am I going to get from this course?

  • Manage a Data Warehousing and project
  • Manage an ETL team
  • Present Data Warehousing topics to their clients

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
01:52

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

Section 2: Data Warehousing
01:28

Introductory story that leads us through the data warehouse path.

04:41

Where it fits, vs BI and BD

Why build a Data Warehouse
Preview
03:13
Basic DW Diagram
01:58
The Iron Triangle and Data Warehousing
11:20
The Data Journey
04:52
Data Warehousing Quiz #1
1 question
1 question

Data Warehousing Quiz #2

1 question

Data Warehousing Quiz #3

Summary
00:42
Section 3: Data Modeling
Introduction to Data Modeling
Preview
06:13
Introduction to SQL
01:38
1 question

SQL Quiz

Kimball Dimension and Fact Modelling
08:45
Inmon Relational Modelling
02:22
Big Data Modelling
02:05
1 question

Data Modeling Quiz

Architecture
04:02
Summary
00:31
Section 4: ETL
Introduction to Extract, Transform, Load
03:38
Extracting Data
02:41
Transforming Data
01:26
Loading Data
03:03
ETL Quiz
1 question
1 question

ETL Quiz #2

ETL Tools
04:34
Summary
00:50
Section 5: Business Intelligence
Introduction to Business Intelligence
05:35
BI Tools
04:05
Managing Report Development
03:26
Summary
00:37
Section 6: The Project
The Final Project
08:01
Section 7: Conclusion
What You've Learned
00:55

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Samori Augusto, Data Warehousing Project Manager

Samori Augusto was a programmer in another life, a dotcom bubble survivor, and is now a certified Project Management Professional and Certified ScrumMaster, who has worked for a decade in Data Warehousing and Business Intelligence. He founded Intelligent Persona in 2015 to provide customer and target market research for entrepreneurs. He has six cats.

Ready to start learning?
Take This Course