Design and Build a Data Warehouse for Business Intelligence Implementation, Certificate | Part time online | Coursera | United States
1 months
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 official 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
    • 1 months

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 1 months.
  • National

    Free
    Tuition Fee
    Based on the tuition of 0 USD for the full programme during 1 months.

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. 

Studyportals Tip: Students can search online for independent or external scholarships that can help fund their studies. Check the scholarships to see whether you are eligible to apply. Many scholarships are either merit-based or needs-based.

Our partners

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

Wishlist

Go to your profile page to get personalised recommendations!