Design and Build a Data Warehouse for Business Intelligence Implementation, Certificate | Part time online | Coursera | United States
2 days
Duration
Free
Free
Unknown
Tuition fee
Anytime
Unknown
Apply date
Anytime
Unknown
Start date

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 the 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. 

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.

Skills You Will Gain

  • Data Warehousing
  • Microstrategy
  • Data Warehouse
  • SQL

Programme Structure

Courses included:

  • Course Overview
  • 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
    • 2 days

Start dates & application deadlines

You can apply for and start this programme anytime.

Language

English

Delivered

Online

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.

Tuition Fee

To always see correct tuition fees
  • International

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

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

You can choose from hundreds of free courses, or get a degree or certificate at a breakthrough price. You can now select Coursera Plus, an annual subscription that provides unlimited access.

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!