Description:

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.

Outcomes:

After completing this class, students should be able to:

• Describe the role of Business Intelligence in organizations
• Describe the components of a Business Intelligence solution
• Describe the role of a data warehouse
• Create reports from data in a data warehouse using current reporting software tools
• Create a multi-dimensional database
• Create reports from data in a multi-dimensional database using current reporting software tools
• Describe the capabilities of Analytic Software tools
• Use analytic software to create interactive displays and analyze data from multi-dimensional databases
• Develop Key Performance Indicators (KPI) for an organization
• Use advance analytic tools including decomposition charts, performance maps and perspective views