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.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
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 WarehousePreview
Basic DW Diagram
The Iron Triangle and Data Warehousing
The Data Journey
Data Warehousing Quiz #1
|Quiz 2||1 question|
Data Warehousing Quiz #2
|Quiz 3||1 question|
Data Warehousing Quiz #3
|Section 3: Data Modeling|
Introduction to Data ModelingPreview
Introduction to SQL
|Quiz 4||1 question|
Kimball Dimension and Fact Modelling
Inmon Relational Modelling
Big Data Modelling
|Quiz 5||1 question|
Data Modeling Quiz
|Section 4: ETL|
Introduction to Extract, Transform, Load
|Quiz 7||1 question|
ETL Quiz #2
|Section 5: Business Intelligence|
Introduction to Business Intelligence
Managing Report Development
|Section 6: The Project|
The Final Project
|Section 7: Conclusion|
What You've Learned
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.