Become a Data Warehouse Consultant
Learn the concepts of Enterprise Data Warehouse (EDW), Architecture, Data mart, Dimensional modeling (Facts, Dimensions, Keys, Schema).
Enroll in Course
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 | 🔗 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.