Business Intelligence Courses & Descriptions
2011-2012
BUSIT 101 Effective Decision Making • 3 CR
Introduction to the development of systems designed to capture relevant data from all segments of an enterprise, to organize the data into a coherent structure and provide the means to analyze the data in order to make rational decisions.
BUSIT 105 Multi-Dimensional Analysis I • 5 CR
Provides an introduction to Business Intelligence solutions. Introduces the concepts and current methodologies for creating multi-dimensional databases. Students work with current server tools to create and browse multi-dimensional databases of various designs. Students learn to use reporting software and analytical software tools to analyze data and present findings. Prerequisite: DBA 130 with a C- or better or entry code.
BUSIT 110 Data Warehouse I • 5 CR
Introduces the concepts associated with the development of a data warehouse. Students apply the "Extract, Clean, Conform, and Deliver" process to organizational data and build the dimension and fact tables required in a data warehouse. Current server tools are used in hands-on exercises. Prerequisite: BUSIT 105 with a C- or better.
BUSIT 115 Data Mining I • 5 CR
Introduces the computer-assisted process of evaluating enormous sets of data to find previously undiscovered patterns, draw conclusions and then make decisions based on these patterns. Concepts are introduced and hands-on exercises used to apply the concepts using current software tools. Prerequisite: BUSIT 105 with a C- or better.
BUSIT 202 Dimensional Modeling • 5 CR
Dimensional modeling has been broadly accepted as the principle technique for data warehouse design. Students use a sequenced series of case studies and hands-on exercises to learn effective design principles for data warehouse development. Prerequisite: BUSIT 105 with a C- or better.
BUSIT 205 Multi Dimensional Analysis II • 5 CR
Concepts and techniques used in BUSIT 105 are expanded upon to create advanced, business-oriented solutions with multi-dimensional databases. Students learn the MDX language for querying multi-dimensional databases. Prerequisite: BUSIT 105 with a C- or better and PROG 140 with a C- or better.
BUSIT 209 Data Visualization • 5 CR
Introduces theory and concepts relating to the effective display of data with a focus on quantitative data. Concepts provide the basis for selecting, designing, and presenting graphs based on multi dimensional data. Current tools are used to graph the correct data, alert decision makers to problems, and display data geographically. Prerequisite: BUSIT 105 with a C- or better.
BUSIT 210 Data Warehouse II • 5 CR
Students build on the concepts and techniques learned in BUSIT 110 while focusing on ETL (Extract, Transform and Load) strategies and tools. Current server tools are used in hands-on exercises to help reinforce data warehousing concepts. Prerequisite: BUSIT 110 with a C- or better and PROG 140 with a C- or better.
BUSIT 215 Data Mining II • 5 CR
Expands on the concepts from BUSIT 115 using advanced tools and techniques available from the most current server tools. Students create Relational and OLAP mining models and evaluate the models to validate the accuracy and compare the predictive ability of the models. Prerequisite: BUSIT 115 with a C- or better.
2010-2011
BUSIT 101 Effective Decision Making • 3 CR
Introduction to the development of systems designed to capture relevant data from all segments of an enterprise, to organize the data into a coherent structure and provide the means to analyze the data in order to make rational decisions.
BUSIT 105 Multi-Dimensional Analysis I • 5 CR
Introduces the concepts and current methodologies for creating On-Line Analytical Processing (OLAP) databases. Students develop Key Performance Indicators and use hands-on exercises with current server tools to create, process, browse and secure data cubes of various designs. Prerequisite: DBA 130 with a C- or better, or entry code.
BUSIT 110 Data Warehouse I • 5 CR
Introduces the concepts associated with the development of a data warehouse. Students apply the "Extract, Clean, Conform, and Deliver" process to organizational data and build the dimension and fact tables required in a data warehouse. Current server tools are used in hands-on exercises. Prerequisite: BUSIT 105 with a C- or better.
BUSIT 115 Data Mining I • 5 CR
Introduces the computer-assisted process of evaluating enormous sets of data to find previously undiscovered patterns, draw conclusions and then make decisions based on these patterns. Concepts are introduced and hands-on exercises used to apply the concepts using current software tools. Prerequisite: BUSIT 105 with a C- or better.
BUSIT 202 Dimensional Modeling • 5 CR
Dimensional modeling has been broadly accepted as the principle technique for data warehouse design. Students use a sequenced series of case studies and hands-on exercises to learn effective design principles for data warehouse development and apply these principles to new situations. Prerequisite: BUSIT 105 with a C- or better.
BUSIT 205 Multi Dimensional Analysis II • 5 CR
Concepts and techniques used in BUSIT 105 are expanded upon to create advanced, business-oriented solutions with OLAP databases. Multi Dimensional Expressions (MDX queries) and Extensible Markup Language for Analysis (XMLA) are used to extract data directly and over the web. Prerequisite: BUSIT 105 with a C- or better.
BUSIT 209 Data Visualization • 5 CR
Introduces theory and concepts relating to the effective display of data with a focus on quantitative data. Concepts provide the basis for selecting, designing, and presenting graphs based on multi dimensional data. Current tools are used to graph the correct data, alert decision makers to problems, and display data geographically. Prerequisite: BUSIT 105 with a C- or better.
BUSIT 210 Data Warehouse II • 5 CR
Students manipulate a data warehouse programmatically, building on the concepts and techniques learned in BUSIT 110. Package storage, execution and configuration are managed using server management tools. Packages are backed-up and restored, and server activity and performance is monitored. Prerequisite: BUSIT 110 with a C- or better.
BUSIT 215 Data Mining II • 5 CR
Expands on the concepts from BUSIT 115 using advanced tools and techniques available from the most current server tools. Students create Relational and OLAP mining models and evaluate the models to validate the accuracy and compare the predictive ability of the models. Prerequisite: BUSIT 115 with a C- or better.
