Data Management, Warehousing, and Visualization

2.5 credits

CIS 467 builds an understanding of system data design to enable analytics as well as the concepts and tools necessary to leverage system data to meet an organization’s analytics needs. The course covers MySQL programming skills for data retrieval, including writing and executing queries; updating, inserting and deleting database records; creating views; and writing user-defined functions and stored procedures. CIS 467 also introduces a conceptual framework for analytics activities surrounding data warehousing, including creating ETL code to transform and transport data from a transitional database into a data warehouse for further analysis. Finally, students will use Tableau to design and create data visualizations and dashboards, both for exploratory data analysis and effective communication.