BUAD 5772 - Database Management and Visualization

Credits: (4) Prerequisite(s): BUAD5112 - Competing Through Business Analytics

This course covers fundamental topics related to the development and use of databases and database systems and best practices for data visualization. Organizations store data in two types of databases: operational and analytical. Operational database topics include: database requirements, entity relationship modeling, relational modeling database constraints, update anomalies, normalization, Structures Query Language (SQL), and data quality. Analytical database topics include: data warehousing concepts, dimensional modeling (star schemas), data warehouse/data mart modeling approaches, the extraction/transformation/load (ETL) process, online analytical processing (OLAP)/business intelligence (BI) functionalities and the data warehouse/data mart front end. Once data is cleaned and stored, data visualization is used to most effectively communicate information contained in the data. The course covers data visualization principles drawn from the fields of statistics, perception, graphic and information design, and data mining. Students will learn visual representation techniques that increase the understanding of complex data and models. Topics include charts, tables, graphics, effective presentations, and dashboard design