Classes Offered:

Business Intelligence

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.

Students learn the fundamentals of database structure and SQL (Structured Query Language). They learn techniques useful for querying databases and they learn to apply their skills in realistic scenarios extracting data and organizing it into meaningful information. Students gain experience with database servers and client tools. Recommended: Familiarity with spreadsheets or databases. Recommended: Familiarity with spreadsheets or databases.

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: BUSIT 103 with a C or better and completion of ENGL& 101 with a C or better.

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.

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.

Description starting Summer 2015

This course introduces business analysis and business analysis areas of knowledge based upon the International Institute of Business Analysis (IIBA) Guide to the Business Analysis Body of Knowledge. Students learn business analysis terminology and the structure of business analysis tasks. Prerequisite: ENGL& 235, BUS& 101, and CMST 250.

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.

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.

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.

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.

Description starting Summer 2015

Students learn specific techniques for various business analysis tasks. They learn to apply these techniques to real world scenarios. Techniques are chosen based upon The International Institute of Business Analysis (IIBA) Guide to the Business Analysis Body of Knowledge and focus is on those techniques most commonly used. Prerequisite: BUSIT 150 Introduction to Business Analysis.

Allows specialized or in-depth study of a subject related to business intelligence where the topic is announced in the quarterly schedule. May be repeated for a maximum of 15 credits of different topics.

Allows specialized or in-depth study of a subject related to business intelligence where the topic is announced in the quarterly schedule. May be repeated for a maximum of 15 credits of different topics.

Allows specialized or in-depth study of a subject related to business intelligence where the topic is announced in the quarterly schedule. May be repeated for a maximum of 15 credits of different topics.

Allows specialized or in-depth study of a subject related to business intelligence where the topic is announced in the quarterly schedule. May be repeated for a maximum of 15 credits of different topics.