Become a Data Warehouse Consultant

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

INTRODUCTION


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

Rishabh Pugalia | 🔗 Linkedin Profile

4.8 Average Rating | 💬 839 Reviews |

🎓 12,589 Classroom Students |💡 40,000 Students Online

ex-KPMG, ex-J.P. Morgan | Chartered Accountant

Taught 12k+ participants across PwC, EY and Deloitte over last 10 years

I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time)

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 2020. 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, Uber, Tata Group, Rio Tinto use these video courses to excel at work.


Course Curriculum


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

FAQs


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!