Highlights
Tuition fee
Free
Free
Unknown
Tuition fee
Free
Free
Unknown
Duration
21 days
Duration
21 days
Apply date
Anytime
Unknown
Apply date
Anytime
Unknown
Start date
Anytime
Unknown
Start date
Anytime
Unknown

About

The Design and Build a Data Warehouse for Business Intelligence Implementation offered by Coursera in partnership with University of Colorado System is part of the Data Warehousing for Business Intelligence Specialization

Visit programme website for more information

Overview

In response to business requirements presented in a case study, you’ll design and build a small data warehouse, create data integration workflows to refresh the warehouse, write SQL statements to support analytical and summary query requirements, and use the MicroStrategy business intelligence platform to create dashboards and visualizations.

In the first part of the Design and Build a Data Warehouse for Business Intelligence Implementation course offered by Coursera in partnership with University of Colorado System, you’ll be introduced to a medium-sized firm, learning about their data warehouse and business intelligence requirements and existing data sources. You’ll first architect a warehouse schema and dimensional model for a small data warehouse. 

Key facts

  • You’ll then create data integration workflows using Pentaho Data Integration to refresh your data warehouse. Next, you’ll write SQL statements for analytical query requirements and create materialized views to support summary data management. For data integration workflows and analytical queries, you can use either Oracle or PostgreSQL. 
  • Finally, you will use MicroStrategy OLAP capabilities to gain insights into your data warehouse. In the completed project, you’ll have built a small data warehouse containing a schema design, data integration workflows, analytical queries, materialized views, dashboards and visualizations that you’ll be proud to show to your current and prospective employers.

Build your subject-matter expertise

  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate

Programme Structure

Courses include:

  • Data Warehouse Design
  • Data Integration
  • Analytical Queries and Summary Data Management
  • Data Visualization and Dashboard Design Requirements
  • Wrap Up and Project Submission

Key information

Duration

  • Part-time
    • 21 days
    • 10 hrs/week

Start dates & application deadlines

You can apply for and start this programme anytime.

Language

English

Delivered

Online

Campus Location

  • Mountain View, United States

What students do after studying

Join for free or log in to access our complete career info list.

Academic requirements

We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.

English requirements

We are not aware of any English requirements for this programme.

Other requirements

General requirements

  • To obtain additional information about the program, we kindly suggest that you visit the programme website, where you can find further details and relevant resources. 

Tuition Fee

To always see correct tuition fees
  • International

    Free
    Tuition Fee
    Based on the tuition of 0 USD for the full programme during 21 days.
  • National

    Free
    Tuition Fee
    Based on the tuition of 0 USD for the full programme during 21 days.
  • Coursera Plus: Subscribe to build job-ready skills from world-class institutions.
  • $59/month, cancel anytime or $399/year with 14-day money-back guarantee

Funding

Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You'll be prompted to complete an application and will be notified if you are approved. You'll need to complete this step for each course in the Specialization, including the Capstone Project. 

Other interesting programmes for you

Our partners

Design and Build a Data Warehouse for Business Intelligence Implementation
-
Coursera

Wishlist

Go to your profile page to get personalised recommendations!