Data Warehousing and Business Intelligence for Managers
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
Introduction to the course, whom it's for, and highlights, and who I am.
Course sections and benefits of the course.
Traditional Data Warehousing
Introductory story that leads us through the data warehouse path.
Where it fits, vs BI and BD
Data Warehousing Quiz #2
Data Warehousing Quiz #3
SQL Quiz
An additional lecture shwoing how to create a dimensional data model based on a very simple example.
Quiz corresponding to Bonus Lesson 1 on the simple dimensional model example
Data Modeling Quiz
Preparation For the ETL
Additional information about ETL development
A few notes on ETL testing
ETL Quiz #2
How an Enterprise Data Warehouse should begin.
Transitioning to Modern Data Warehousing
A look at current data warehousing.
High level introduction to Data Lakes for Data Warehouse Managers
Continuing the high level introduction to Data Lakes for Data Warehouse Managers
What the Data Warehousing Project Manager can do to help the organization take full advantage of a Data Lake.
I put up a diagram and you explain the diagram, in a video. Best one gets posted.
Conclusion
This is the end. My beautiful friend. This is the end.
