Become a Data Warehouse Consultant

Learn the concepts of Enterprise Data Warehouse (EDW), Architecture, Data mart, Dimensional modeling (Facts, Dimensions, Keys, Schema).


The demand for experts of Business Intelligence (BI), Machine Learning and Big Data, have risen significantly in the last five years. In this context, there are two job roles, whose importance have grown too:

  • ✓ Data Warehouse Architect
  • ✓ Data Warehouse Consultant

Data warehouse architects (DWA) construct information systems that make a company’s data easily available for analysis. After examining a company’s possible data sources (internal and external), DWA design a plan to integrate, centralize, protect and maintain them. This allows analysts and BI specialists to access critical information in the right place, at the right time. This analysis is critical for timely decisions. In short, Data architects do not analyze data. Instead, they make it available to others.

Several Business Intelligence tools help answer these questions by providing data driven insights. The warehouse adds its value behind the scenes. Its job is to provide data to the high-profile BI tools and applications with which users interact.

Professionals often start as a Database Administrator (DBAs) and or entry-level programmers. With experience, they gain more understanding how data is stored.

What’s covered in the course?

The course lays a solid foundation on Data Warehousing introduction, BI context, Data warehouse architecture and Data mart concepts. The course then focusses on Dimensional Modeling (Facts, Dimensions, Keys, Schema).

Your Instructor

Rishabh Pugalia
Rishabh Pugalia
Worked with KPMG, and became a Chartered Accountant Traded Interest Rate Futures, and then worked with J.P. Morgan (Fixed Income)

After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2021. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Flipkart, Uber, Tata Group, etc.

  • Trained 30K+ professionals through
  • 150K+ Online Students

Course Curriculum

  Download Important Support files for Learning Enterprise Data Warehouse
Available in days
days after you enroll


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!