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.
▸ Related Article:
Find the Right Data Program for You DESIGNED FOR
Professionals with some SQL and database experience who want to develop and expand their skills in the design and implementation of databases and BI infrastructure. Those interested in BI data analysis should consider taking our
Certificate in Data Analytics: Techniques for Decision Making.
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.
Play WHAT YOU’LL LEARN
Methods for building professional end-to-end BI solutions, including planning, documentation and reporting
How to choose between architectures when building an advanced analytical BI solution
Key terms and concepts of BI (snowflake and star schemas, OLAP, dimension and measures, and more)
Best practices for using Microsoft SQL Server, Integration Services and Analysis Server
How to assess implications for data scale and security
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
Projected job growth for database architects in Washington state (2020–2030)
Average salary for database architects in the U.S. (2021)
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.