We may earn an affiliate commission when you visit our partners.

Data Warehousing for Business Intelligence

Michael Mannino, Jahangir Karimi, and A.W. Lukens

Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics.

This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You’ll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the final Capstone Project, you’ll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

Help others find Specialization from Coursera by sharing it with your friends and followers:

Facebook

Copy Link

What's inside

Five courses

Database Management Essentials

(0 hours)

Database Management Essentials provides the foundation for a career in database development, data warehousing, or business intelligence. In this course, you will create relational databases, write SQL statements, create entity relationship diagrams (ERDs), and analyze table designs.

View more details for this course

Data Warehouse Concepts, Design, and Data Integration

This course teaches data warehouse design and data integration workflows. Students will gain hands-on experience designing data warehouses and using open source products for manipulating pivot tables and creating data integration workflows. They will also learn about maturity models, architectures, multidimensional models, and management practices. By the end of the course, students will have the knowledge and skills to become data warehouse designers or administrators.

View more details for this course

Relational Database Support for Data Warehouses

Relational Database Support for Data Warehouses explores SQL for business intelligence, relational database management systems for summary data, storage architectures, scalable parallel processing, data governance, and big data impacts. Assignments can use Oracle or PostgreSQL.

View more details for this course

Business Intelligence Concepts, Tools, and Applications

(0 hours)

This course provides an overview of business intelligence technologies and their role in supporting decision making. Students will learn about data warehouses, online analytical processing, and visualization techniques. The course is intended for business and computer science students, IT professionals, and anyone with career interests in business intelligence.

View more details for this course

Design and Build a Data Warehouse for Business Intelligence Implementation

(0 hours)

The capstone course features a real-world case study that integrates your learning across all courses in the specialization. In response to business requirements, you’ll design and build a small data warehouse, create data integration workflows, write SQL statements, and use the MicroStrategy business intelligence platform to create dashboards and visualizations.

View more details for this course

Save this collection

Save Data Warehousing for Business Intelligence to your list so you can find it easily later:

Save

Time

61 hours

Level

Advanced

Via

Coursera

Institution

University of Colorado System

Instructors

Michael Mannino

Jahangir Karimi

A.W. Lukens

Level

Advanced

Share Specialization from Coursera

Facebook

Link

Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.