Database Management Essentials is course 1 of 5 in the Data Warehousing for Business Intelligence Specialization.
Evaluate business needs; design a data warehouse; and integrate, and visualize data using dashboards and visual analytics. This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You’ll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the final Capstone Project, you’ll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience.
The University of Colorado plays a profound role in the lives of individuals, businesses and communities throughout Colorado, across the country and around the world. More than a half million alumni are leaders in business, science, the arts, health care and their communities, and they’re joined by some 15,000 more each year. In Aurora, Boulder, Colorado Springs and Denver, all four campuses are all for Colorado.