Certificate in Business Intelligence: Building the Data Warehouse

Transform Raw Data Into Valuable Business Assets

collapse

Program Details

  • Location: Bellevue, Online
  • Duration: 8 months
  • Class Times: Days, Evenings
  • Cost: $3,297

Next start date

October 3, 2016

Get Details & Apply

About this Program


Business intelligence is a discipline that relies on ready access to a huge volume of stored data, sometimes referred to as a data warehouse. In this three-course certificate program, you’ll develop the conceptual knowledge and skills to create a midsize data warehouse. You’ll explore the entire life cycle of development, from defining business requirements to reporting and analysis. We’ll cover different aspects of data modeling and database design, and take a deep dive into the ETL (extract, transform and load) process. By the end of the program you’ll have completed your data warehouse and expanded your professional portfolio.

DESIGNED FOR

Database developers and administrators. Those who work on the business analysis side of BI should consider taking our Certificate in Business Intelligence: Techniques for Decision Making.

See Requirements

Video Overview

Two instructors from our business intelligence certificate programs explain how students can use the knowledge and skills they learn to advance their careers.

Duration 3:14

WHAT YOU’LL LEARN

  • Key terms and concepts of BI, including the snowflake and star schemas, project planning and project management
  • How to define project scope and essential business requirements
  • Best practices for using Microsoft SQL Server Integration Services to perform the ETL process
  • Methods for building a professional BI solution, including planning, documentation and reporting
  • Implementation, development and management of Online Analytical Processing (OLAP) Cubes

GET HANDS-ON EXPERIENCE

  • Create and refine a data warehouse
  • Execute a business intelligence project that includes the construction of OLAP Cubes on various data warehouses

Program Overview

Complete the courses listed below to earn the certificate. You may be able to take individual courses without enrolling in the certificate program; check the course pages for details.

Start Dates

Learning Formats

Classroom

Attend class in person at one of our convenient locations. You’ll engage face to face with your classmates and instructors as part of a highly interactive curriculum. An online learning management system may be required to access some course materials and assignments.

Online

Courses are streamed online in real time from the classroom. You interact with your instructors and fellow students via chat, using Adobe Connect web conferencing software. Assignments and other course materials are delivered through Canvas, a web-based learning management system that also serves as a communications hub. For added flexibility, each quarter you may view recordings of up to 40 percent of your class sessions instead of attending in real time. You also can attend the classroom sessions in person if space is available.

Blended

Our special blended programs combine the convenience of online study with the vibrancy of in-person classes for a unique learning experience.

Not available for this program