Data Modeling, Analysis and Visualization

Catalog description

This course introduces the student to the full arc of a data lifecycle in business analytics, from modeling, spreadsheet and database analyses through visualization. Students will build and use a relational database based on a data model and write queries in SQL to extract and prepare data for analysis. MS Excel is the most heavily used data platform in all of business. Students completing BTM 2500 will be able to apply an advanced Excel skillset to cleansing, organizing, consolidating data, and then analyzing and reporting results through visualization techniques. Finally, students will use software for data visualization.