About This Program
Business intelligence analytics relies on ready access to large collections of well-structured data. In this three-course certificate program, you’ll learn how to build and manage the data structures and integration pipelines needed to power your organization’s business intelligence (BI) operations.
We’ll explore the entire life cycle of database development for both on-premise and cloud operations, including defining business requirements, creating and automating the data pipeline, and building operational reports. You’ll understand how to develop and manage data integrations across various types of databases — relational and non-relational and on-premise and in the cloud. You’ll master the ETL (extract, transform, load) process of migrating data from one data structure to another. Finally, you’ll learn to use the assistance of AI tools to build dashboards and reports to monitor and fine-tune your data integration processes and track performance metrics.
Designed For
Those with at least basic SQL and database experience who want to design and implement data structures and data integrations for BI operations.
▸ 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 integrations
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 for utilizing data ETL 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-premise and cloud)
Perform data integration with SQL, Python, Integration Services and Azure Data Factory
Create operational dashboards and reports using Excel, Power BI, Tableau and Jupyter Notebook
How It Works & Next Steps
Complete the courses in the order below to earn the certificate. To get started, visit the first course page to see upcoming offerings and register.
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
19.1%
Projected job growth for database architects in Washington state (2024–2034)
$144,914
Median salary for database architects in Washington state (2023)
Career-Ready Credentials
When you complete this program, you’ll earn a certificate and a digital achievement badge you can use to showcase your professional development. You’ll also earn achievement badges for each course you complete.
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.
This program is intended for professional development and is not designed to meet educational requirements for professional licensure or certification.
