Data Warehouse Fundamentals for Beginners – Udemy

(10 customer reviews)




What you’ll learn

  • Master the techniques needed to build a data warehouse for your organization.
  • Determine your options for the architecture of your data warehousing environment.
  • Apply the key design principles of dimensional data modeling.
  • Combine various models and approaches to unify and load data within your data warehouse.

If you are a current or aspiring IT professional in search of sound, practical techniques to plan, design, and build a data warehouse or data mart, this is the course for you.

During the course, you’ll put what you learn to work and define sample data warehousing architectures and dimensional data structures to help emphasize the best practices and techniques covered in this course. Each section has either scenario based quiz questions or hands on assignments that emphasizes key learning objectives for that section’s material. This way, you can be confident as you move through the course that you’re picking up the key points about data warehousing.

To build this course, I drew from more than 30 years of my own data warehousing work on more than 40 client projects and engagements. I’ve been a thought leader in the discipline of data warehousing since the early 1990s when modern data warehousing came onto the scene. I’ve literally seen it all…and written about the discipline of data warehousing in books such as the original Data Warehousing For Dummies ® , along with articles, white papers, and as a monthly data warehousing columnist. I’ve led global consulting practices delivering data warehousing (and its related discipline, business intelligence) to some of the most recognizable brand name customers, along with smaller-sized organizations and governmental agencies. My own consulting firm, Thinking Helmet, Inc., specializes in data warehousing, business intelligence, and related disciplines. I’ve rolled up my sleeves and personally tackled every aspect of what you’ll learn in this course. I’ve even learned a few painful lessons, and have built a healthy share of “lessons learned” into the course material.

In this course, I take you from the fundamentals and concepts of data warehousing all the way through best practices for the architecture, dimensional design, and data interchange that you’ll need to implement data warehousing in your organization. You’ll find many examples that clearly demonstrate the key concepts and techniques covered throughout the course. By the end of the course, you’ll be all set to not only put these principles to work, but also to make the key architecture and design decisions required by the “art” of data warehousing that transcend the nuts-and-bolts techniques and design patterns.

Specifically, this course will cover:

  • Foundational data warehousing concepts and fundamentals

  • The symbiotic relationship between data warehousing and business intelligence

  • How data warehousing co-exists with data lakes and data virtualization

  • Your many architectural alternatives, from highly centralized approaches to numerous multi-component alternatives

  • The fundamentals of dimensional analysis and modeling

  • The key relational database capabilities that you will put to work to build your dimensional data models

  • Different alternatives for handling changing data history within your environment, and how to decide which approaches to apply in various situations

  • How to organize and design your Extraction, Transformation, and Loading (ETL) capabilities to keep your data warehouse up to date

Data warehousing is both an art and a science. While we have developed a large body of best practices over the years, we still have to make this-or-that types of decisions from the earliest stages of a data warehousing project all the way through architecture, design, and implementation. That’s what I’ve instilled into this course: the fusion of data warehousing art and science that you can bring to your organization and your own work. So come join me on this journey through the world of data warehousing!

Who this course is for:

  • A business analyst, data engineer, or database designer, currently with little or no exposure to or experience with data warehousing, who desires to build a personal toolbox of data warehousing best practices and techniques.
  • After completing this course, you will be ready to begin working on real-world data warehousing projects, either with expanded responsibilities as part of an existing role or to find a new position involving data warehousing. Example positions include data warehousing architect, dimensional data modeler, ETL architect and designer, and data warehousing business analyst.

Course content

  • Welcome
  • Data Warehousing Concepts
  • Data Warehousing Architecture
  • Bring Data Into Your Data Warehouse
  • Data Warehousing Design: Building Blocks
  • Design Facts, Fact Tables, Dimensions, and Dimension Tables
  • Managing Data Warehouse History Through Slowly Changing Dimensions
  • Designing Your ETL
  • Selecting Your Data Warehouse Environment
  • Conclusion

10 reviews for Data Warehouse Fundamentals for Beginners – Udemy

  1. Donny Phan

    Super practical. Lessons are catered towards anyone looking to find work in this industry. It felt very comprehensive and gave me a broad understanding of the programming spectrum

  2. Madhav raj Verma

    Thanks for your great effort. i am fully satisfied with this course the way you teach and your explanation are very clear ,The content you provide in your course no one can do this at this price.

  3. Sachin Gupta

    I really didn’t want to leave a low rating as Angela is a great teacher. The 1st half of this course was terrific. The 2nd half was terrible. Under the justification of “teaching students how to figure things out on their own”, pretty much all videos and all explanations were dropped. You were just told what to do, given links to documentation and told to figure it out on your own. I understand doing that to some degree, but to revert to that entirely for nearly half the content barely makes this a course. It’s just a list of things for you to learn, then you’re left on your own to learn them. The 2nd half was so bad, especially the data science component, that I didn’t bother finishing the course.

  4. Vincent Beaudet

    Amazing 40 days course.
    Angela is a great teacher.
    The other 60 days are all about web developement, interacting with web pages, on your own with little to no explanations. I did not expect that at all. I wanted to learn more about software and scripting.
    This left me disappointed , confused and i started to doubt myself. Not a fun experience after the amount of effort i’v put in this course.

    Exercices format and explanations for the first 40 days were worth it tho.

  5. Ben K

    Not just an introduction to python, but really helps you learn fundamental aspects of python and coding in general. Some parts may require some knowledge on the subject (data science comes to mind) and there is quite some web development in the course. So, a few areas were not completely to my liking (I would have liked to see it done differently), but this course deserves the 5 stars in my opinion.

  6. Omid Alikhel

    I found the method a bit difficult when a code is written and then changed back to something different, with no enough explanation of how something happened and where it came from or a step by step explanation of why something is happening, i have no doubt in the instructors talent, but we are beginners!

  7. Alica Cverdeľová

    I love this course, Angela explained it very easily and clearly from the beginning, but I loved her 1 minute final videos, which ended later: What a pity.
    BUT I felt a little disappointed now with the project Day 39/40. Where I was maximally lost, I could not come out of where to look for anything and it was poorly explained and the biggest mistake was that there were no videos with explanations, I think it was quite a complicated project where many things were used and no explanation, only the final results. And they carried a few things in the projects before, so I had her project run once and it showed her the mistake as well as me, so in that case you have to leave it at that and what else is a shame. It’s hard to do a project when you don’t see what’s going on there.
    I’m a little worried about the next few weeks, and I hope it won’t be a waste of time.

  8. Szymon Kozak

    I think that the course tutor is really good in giving right information to learn at the right time. Thanks to this fact, my understanding of coding in python after 29 days of learning is above my expectations.

  9. Begoña Ruiz Diaz

    Ha sido la mejor elección que podría haber hecho.

  10. Vaibhav Sachdeva

    I want to thank Angela for making such an amazing course. It really helped me explore more things with python.

Add a review

Your email address will not be published.