University of Colorado System
Design and Build a Data Warehouse for Business Intelligence Implementation
University of Colorado System

Design and Build a Data Warehouse for Business Intelligence Implementation

Michael Mannino
Jahangir Karimi

Instructors: Michael Mannino

13,332 already enrolled

Included withCoursera Plus

Gain insight into a topic and learn the fundamentals.
4.6

(287 reviews)

31 hours to complete
3 weeks at 10 hours a week
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
4.6

(287 reviews)

31 hours to complete
3 weeks at 10 hours a week
Flexible schedule
Learn at your own pace

Details to know

Earn a career certificate

Add to your LinkedIn profile

Assessments

5 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Placeholder

Build your subject-matter expertise

This course is part of the Data Warehousing for Business Intelligence Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • 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
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 6 modules in this course

Module 1 introduces the objectives and topics in the course and provides background on the case and software requirements. The capstone course is organized around a realistic case study based on the business situation faced by CPI Card Group in 2015.

What's included

3 videos9 readings

Module 2 presents the requirements of the first part of the case study involving data warehouse design. To provide a context for the case study, you can listen to an executive interview with a CPI Card Group executive.

What's included

1 video4 readings1 assignment

Module 3 presents requirements for the second part of the case study involving data integration. To provide a context for the case study, you can listen to executive interviews with executives from CPI Card Group, First Bank, and Pinnacol Assurance.

What's included

3 videos7 readings3 assignments

Module 4 presents requirements for the third part of the case study involving analytical queries and summary data management.

What's included

1 video4 readings1 assignment

This module continues on the top job responsibilities of BI analysts by focusing on creating data visualizations and dashboards. You will first learn the importance of data visualization and different types of data that can be visually represented. You will then learn about the types of basic and composite charts. This will help you to determine which visualization is most effective to display data for a given data set and to identify best practices for designing data visualizations. In lesson 3, you will learn the common characteristics of a dashboard, the types of dashboards, and the list of attributes of metrics usually included in dashboards. Finally, in lesson 3, you will learn the guidelines for designing a dashboard and the common pitfalls of dashboard design. You will need to use MicroStrategy Desktop Visual Insight to design a dashboard for a Financial Services company in a peer-evaluated exercise.

What's included

2 videos4 readings

This is an extension of Module 5. The peer assessment from module 5 is moved to module 6 to give you more time completing the assignments in prior modules as well as for you to do your peer assessment in this module.

What's included

2 videos1 reading1 peer review

Instructors

Instructor ratings
4.4 (16 ratings)
Michael Mannino
University of Colorado System
4 Courses231,383 learners
Jahangir Karimi
University of Colorado System
2 Courses53,185 learners

Offered by

Recommended if you're interested in Data Analysis

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 287

4.6

287 reviews

  • 5 stars

    73.61%

  • 4 stars

    20.13%

  • 3 stars

    2.43%

  • 2 stars

    1.04%

  • 1 star

    2.77%

TD
5

Reviewed on Jun 27, 2023

PN
5

Reviewed on Dec 8, 2016

RT
5

Reviewed on Oct 8, 2017

New to Data Analysis? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions