Data Warehouse Concepts, Design, and Data Integration
Data Warehousing for Business Intelligence,
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
Get a Reminder
| Rating | 4.1★ based on 146 ratings |
|---|---|
| Length | 6 weeks |
| Starts | Jun 26 (47 weeks ago) |
| Cost | $79 |
| From | University of Colorado System via Coursera |
| Instructor | Michael Mannino |
| Download Videos | On all desktop and mobile devices |
| Language | English |
| Subjects | Programming Data Science Art & Design |
| Tags | Computer Science Data Science Data Analysis Design And Product |
Get a Reminder
Similar Courses
What people are saying
data integration
Students will be exposed to practical usage Pentaho software for data integration through a couple of examples and exercises.
High quality info for a well structured course Some good parts on data integration but the key sections on DW design and in particular the assignment are really poorly written.
Good learning for Data integration and ETL learning.
Excellent introduction to data cubes and data integration.
Give basic concept and practical experience in data cube designing and data integration.
Exercises and tutorials are very useful to complement lectures and help increase our skills in the domain.Tools deployment and connection (Oracle database on Virtual box and pentaho data integration) was a nightmare.
This course was full of issues related to the installation and use of Pentaho Pivot 4J and Data Integration.
T DULL Overall - great course giving possibility to learn working on tools such as Pivot4J and Pentaho Data Integration.
Particularly the Pentaho Data Integration software was a severe test for my peace of mind.
Read more
very good course
Very good course.
very good course For me this course is one of the most important in BI.
Good course This Course has given new life to me The quality of assignments is awful nice course very usefull A very good course.
very good course, after the course u will have a good understanding and grasp of data warehousing concept Great course :)
Read more
recommend this course
If you want to learn how to use Pentaho without previous experence, I do not recommend this course.
Thank you all Personally I don't recommend this course.
Read more
data warehouses
Enough content is provided to ensure a smooth introduction to data warehouses and proficiency in the important concepts of Extraction, transformation and loading.
I highly recommend it if you want to learn the concepts behind data warehouses.
This course provides the background and basic skills necessary understand and work with Data Warehouses.
Excelente curso Very nice introduction to databases and data warehouses.
Really good to get an understanding of enterprise level data warehouses.
Read more
install pentaho
As I highlighted already it took me 8 hours with a professional to install Pentaho... for what?
There are dozens of students trying to install Pentaho and failing.
Read more
more complex
UPDATE: The wording is a significant challenge, even when advancing into the more complex topics.
Real world data warehouse integrations are more complex than just inner joining the tables to drop those rows not found in the original tables.
Read more
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Warehouse Data Specialist $58k
Data Integration\\Warehouse Developer $62k
Data Warehouse Marketing $81k
Specialist - Data Warehouse $87k
Data Warehouse Analyst 3 $107k
Data Warehouse Consultant $115k
Data Integration Engineer| Data Warehouse $116k
Data Warehouse Analyst 2 $121k
Data Integration / Data Warehouse Architect $155k
Data Architect Data Warehouse $167k
Data Warehouse Architect u2013 for Enterprise Data Warehouse $187k
Data Warehouse Development $249k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | 4.1★ based on 146 ratings |
|---|---|
| Length | 6 weeks |
| Starts | Jun 26 (47 weeks ago) |
| Cost | $79 |
| From | University of Colorado System via Coursera |
| Instructor | Michael Mannino |
| Download Videos | On all desktop and mobile devices |
| Language | English |
| Subjects | Programming Data Science Art & Design |
| Tags | Computer Science Data Science Data Analysis Design And Product |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
