Certificate in Business Intelligence & Data Migration

Transform Raw Data Into Valuable Business Assets

collapse

Program Details

  • Location: Online
  • Duration: 8 months
  • Times: Evenings
  • Cost: $4,305

Next start date:

October 1, 2024

Get Details & Apply
Talk to an Enrollment Coach

About this Program


Business intelligence is a discipline that relies on ready access to a huge volume of stored data in well-structured databases. In this three-course certificate program, you’ll learn how to build and manage the databases and infrastructure for your organization’s business intelligence operations.

We’ll explore the entire life cycle of database development, from defining business requirements to analytical reporting. You’ll learn how to create, program and manage traditional relational and the newer non-relational databases, and we'll cover data migration techniques, or the ETL process — how to extract, transform and load data from one database to another. You’ll also learn how to build effective internal administrative dashboards and manage both on-site and cloud databases. All the material will come together in a comprehensive final project that you can add to your professional portfolio. 

DESIGNED FOR

Those with some SQL and database experience who want to develop and expand their skills in the design and implementation of databases and BI infrastructure.

See Requirements

Explore More: Interested in BI data analysis? Check out our Certificate in Data Analytics: Techniques for Decision Making — or find the right data program for you.

Video Overview

Randal Root, an instructor for the Certificate in Business Intelligence & Database Development, discusses the skills students will gain from this certificate for this in-demand field.

Duration: 02:43

WHAT YOU’LL LEARN

  • Best practices for developing, testing and deploying data migration
  • How to identify and choose between advanced analytical data architectures
  • Key terms and concepts of analytical data architectures (snowflake and star schemas, OLAP, dimension and measures, data lakes and more)
  • Best practices in utilizing data extraction, transformation and loading techniques and technologies

GET HANDS-ON EXPERIENCE

  • Architect, build, deploy and manage end-to-end BI solutions using a variety of technologies (SQL, NoSQL, on-site and cloud)
  • Create and refine data warehouses, ETL processes and reporting infrastructure
  • Implement BI projects that involve the construction of various data structures
  • Perform ETL with SQL, Python, Integration Services and Azure Data Factory
  • Create dashboard reports with Excel, Power BI, Tableau and Jupyter Notebook

APPLY FOR A SCHOLARSHIP

You may be eligible to apply for a UW Certificate Scholarship or Rotary Scholarship to cover most of the costs of this program. Scholarships are awarded based on financial need and the potential of the program to positively impact your career. For more information, see the Scholarships page.

Career Stats

25%

Projected job growth for database architects in Washington state (2020–2030)

$134,870

Average salary for database architects in the U.S. (2022)

Source: O*NET OnLine

OUR ENROLLMENT COACHES ARE HERE TO HELP

Connect with an enrollment coach to learn more about this offering. Or if you need help finding the right certificate, specialization or course for you, reach out to explore your options.

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.

Learning Format

Online With Real-Time Meetings

Online With Real-Time Meetings

Combine the convenience of online learning with the immediacy of real-time interaction. You’ll meet with your instructor and classmates at scheduled times over Zoom. Learn More »

Program Sessions

Online With Real-Time Meetings

Want to get the latest?

Sign up to get updates about this program, including info sessions and application deadlines.

  Get our email newsletter with career tips, event invites and upcoming program info.       Sign Up Now