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.7 (19 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.
173 students enrolled
Instructed by Samori Augusto IT & Software / Other
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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

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

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.


Section 1: Introduction

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

Section 2: Data Warehousing

Introductory story that leads us through the data warehouse path.


Where it fits, vs BI and BD

Why build a Data Warehouse
Basic DW Diagram
The Iron Triangle and Data Warehousing
The Data Journey
Data Warehousing Quiz #1
1 question
1 question

Data Warehousing Quiz #2

1 question

Data Warehousing Quiz #3

Section 3: Data Modeling
Introduction to Data Modeling
Introduction to SQL
1 question

SQL Quiz

Kimball Dimension and Fact Modelling
Inmon Relational Modelling
Big Data Modelling
1 question

Data Modeling Quiz

Section 4: ETL
Introduction to Extract, Transform, Load
Extracting Data
Transforming Data
Loading Data
ETL Quiz
1 question
1 question

ETL Quiz #2

ETL Tools
Section 5: Business Intelligence
Introduction to Business Intelligence
BI Tools
Managing Report Development
Section 6: The Project
The Final Project
Section 7: Conclusion
What You've Learned

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