ISOM-827 Data Warehouse and Business Intelligence
This course teaches students how to build and maintain data warehouses, and how to analyze and use this data as a source for business intelligence and competitive advantage. Students study data mining concepts, Big Data environments and analytics, and the use of analytics tools and methods for producing business knowledge. Topics include extraction, transformation and loading; decision support systems; text, web and data mining models as well as data presentation/visualization including dashboards, scorecards and various charts. Students build a data warehouse and practice the extraction and transformation process used to produce high quality data warehouses. Students will also experience Big Data storage and processing of Big Data. Students will use tools such as MS Excel, Tableau, Hadoop, Hive, Pig, Spark, and SAP Business Warehouse.