Course Detail
Units:
3.0
Course Components:
Lecture
Description
The data generated from ongoing operations of businesses and not-for-profit enterprises continues to grow. Using the data to diagnose problems and assess opportunities is becoming more and more of a competitive advantage in today's business environment. Before analysis can take place, existing data must be modeled in ways that facilitate reporting. This course briefly presents the data models of existing operational systems and then contrasts those models to dimensional models used in data warehouses and analytic processing engines. Business reporting needs are analyzed, data warehouses are modeled based on the reporting needs, and then SQL is used to create and populate tables based on dimensional models. Once in place, the data warehouse is used as a backend for a reporting tool to create reports that answer business questions.