Data Warehouse Concepts, Design, and Data Integration
This is the second course in the Data Warehousing for Business Intelligence specialization. Ideally, the courses should be taken in sequence.In this course, you will learn exciting concepts and skills for designing data warehouses and creating data integration workflows. These are fundamental skills for data warehouse developers and administrators. You will have hands-on experience for data warehouse design and use open source products for manipulating pivot tables and creating data integration workflows. In the data integration assignment, you can use either Oracle, MySQL, or PostgreSQL databases. You will also gain conceptual background about maturity models, architectures, multidimensional models, and management practices, providing an organizational perspective about data warehouse development. If you are currently a business or information technology professional and want to become a data warehouse designer or administrator, this course will give you the knowledge and skills to do that. By the end of the course, you will have the design experience, software background, and organizational context that prepares you to succeed with data warehouse development projects.
In this course, you will create data warehouse designs and data integration workflows that satisfy the business intelligence needs of organizations. When you’re done with this course, you’ll be able to:
- Evaluate an organization for data warehouse maturity and business architecture alignment;
- Create a data warehouse design and reflect on alternative design methodologies and design goals;
- Create data integration workflows using prominent open source software;
- Reflect on the role of change data, refresh constraints, refresh frequency trade-offs, and data quality goals in data integration process design; and
- Perform operations on pivot tables to satisfy typical business analysis requests using prominent open source software
None
Syllabus
Syllabus - What you will learn from this course
Week 1
Data Warehouse Concepts and Architectures
Week 2
Multidimensional Data Representation and Manipulation
Week 3
Data Warehouse Design Practices and Methodologies
Week 4
Data Integration Concepts, Processes,and Techniques
Week 5
Architectures, Features, and Details of Data Integration Tools
FAQ
When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
Reviews
The course could be less-detailed. Besides open source ETL tools, other big players (e.g. Informatica, SAP DI, etc.) should be mentioned as well.
Great introduction to DW concepts! Assignments are a little tedious and quizzes ask trivia questions sometimes but overall a solid syllabus.
Great course. It mimics real life case. However, the time required to complete assignments is much more than stated. The assignments are great though, I learned a lot from those.
Great course! The only issue, and the reason for 4 starts instead of 5, is that (1) the integration software was hard to install and get working correctly and (2) the course materials are out of date.
