INSITE Education

 

INSITE: Center for Business Intelligence and Analytics supports education at the University of Arizona in the areas of courses, online education and outreach.

Case Studies

INSITE works with data and business intelligence software companies to bring hands-on tools for MIS students to use as they work on business projects in the classroom. Explore the work we’ve done with businesses like Jaspersoft and Ataccama.

View Case Studies


Courses

INSITE faculty teach or advise courses that include MIS 531 Enterprise Data Management, MIS 586 Big Data Analytics, and MIS 587 Business Intelligence. 

Level

Graduate

Description

This course introduces the student to fundamentals of database analysis, design, and implementation. Emphasis is on practical aspects of business process analysis and the accompanying database design and development. Topics covered include: conceptual design of databases using the entity relationship model, relational design and normalization, SQL and PL/SQL, web based database design, and implementation using Oracle or some other modern Database Management Systems. Students are required to work with a local client organization in understanding their business requirements, developing a detailed set of requirements to support business processes, and designing and implementing a web based database application to support their day- to-day business operations and decision making. Students will acquire hands-on-experience with a state-of-the-art database management system such as Oracle or Microsoft SQLServer, and web-based development tools. This course is also offered via the Online Master's in MIS program.

Units

3

Instructor(s)

Faiz Currim

Level

Graduate

Description

The amount of data in our world has been exploding, resulting in what is popularly known as Big Data. At least three major forces are driving the interest and growth in Big Data (1) a rapid increase in the amount of data being generated on the internet, (2) the evolving strategy of firms to collect data from sources both internal and external along the entire product and process lifecycle, and (3) the phenomenal growth of social media, mobile applications, and sensor based technologies as well as the Internet of Things. All of these forces are generating a flood of data which is increasing in volume, variety and velocity.

The objective of this course is to introduce students to Data Science techniques to collect, process, visualize and analyze all kinds of “Big Data”. It will provide training to those interested in becoming Data Scientists. The course will delve into Web analytics and students will be exposed to tools such as Google analytics and participate in a Google Online Challenge to compete for awards. Topics related to network analysis techniques will be covered in detail where students will learn how to construct, mathematically analyze and visualize different types of networks. Additionally, students will also learn about using MongoDb, Hadoop, and executing map-reduce jobs to process and analyze large datasets collected from social media sites such as Twitter, Youtube, and Facebook.

Units

3

Instructor(s)

Sudha Ram

Level

Graduate

Prerequisite(s)

MIS 531 Enterprise Data Management or equivalent database course

Description

The objective of this course is to give students a broad overview of managerial, strategic and technical issues associated with Business Intelligence and Data Warehouse design, implementation, and utilization. Topics covered will include the principles of dimensional data modeling, techniques for extraction of data from source systems, data transformation methods, data staging and quality, data warehouse architecture and infrastructure, and the various methods for information delivery. Critical issues in planning, physical design process, deployment and ongoing maintenance will also be examined. Students will learn how data warehouses are used to help managers successfully gather, analyze, understand and act on information stored in data warehouses. The components and design issues related to data warehouses and business intelligence techniques for extracting meaningful information from data warehouses will be emphasized. The course will use state-of-the-art data warehouse and OLAP software tools to provide hands-on experience in designing and using Data Warehouses and Data Marts. Students will also learn how to gather strategic decision making requirements from businesses, develop key performance indicators (KPIs) and corporate performance management metrics using the Balanced Scorecard, and design and implement business dashboards. This course is also offered via the Online Master's in MIS program.

Units

3


Online Education

INSITE supports the MISonline program's Business Intelligence and Analytics Certificate, which provides a broad overview of managerial, strategic and technical issues associated with business intelligence and data warehouse design, implementation, and utilization. 

The Business Intelligence (BI) and Analytics Certificate, offered through the MIS Department's Online Master's in MIS program, is designed for IT professionals, project managers, business analysts and marketing analysts and researchers.

Anyone involved in analyzing data to make business decisions will benefit from this three-course graduate level program. It helps you define, establish, and distinguish yourself professionally as you gain the skills and techniques needed to design, build, and deploy solutions to deliver more data to more people across an organization.

The BI Certificate provides a broad overview of managerial, strategic and technical issues associated with business intelligence and data warehouse design, implementation, and utilization. It will give you the fundamentals of database mining, analysis, design, and implementation with an emphasis on practical aspects of business process analysis and information delivery, completely online.

The certificate will help you identify data securing methods, align BI initiatives with strategic goals, model and analyze data for strategic decision making, and leverage productive analytical techniques that drive better risk assessments and business potential.

Business Intelligence and Analytics Certificate courses (three units each) include:

  • MIS 531 Enterprise Data Management
  • MIS 545 Data Mining for Business Intelligence
  • MIS 587 Business Intelligence

Outreach

An integral aspect of INSITE is to train the future Big Data workforce. To that end, the MIS Department and INSITE have collaborated to bring real-world classroom courses the help students prepare and embrace business intelligence analytics. Check out our Master's program:

View INSITE master's projects by year:

Aravind P Shankar 
Business Intelligence Implementation for MOSAIC

Deepika Nim 
Metrics Monitoring System (Freescale Semiconductor)

Hetal Mehta 
Report and Dashboard creation at Intuit

Jagadish Ramamurthy 
Sanofi Aventis –Scientific Knowledge Repository: Tucson Repository of Related Information (TURRI)

Jagdeep S Kalsi 
OPAL – An Event Monitoring and Analytics Infrastructure For Enterprise Performance Management 

Jiayun Zhao 
University College – Interdisciplinary Study Online Application System

Kalpesh Jain, Neha Sabharwal 
UNIVERSITY OF ARIZONA INSTITUTIONAL REPOSITORY – Repository Data Model 

Kunpeng Zhang 
Semantic Integration of Heterogeneous Biological Databases for Knowledge Discovery - ADRG

Nikunj Kshatriya 
W7 Model Application to Wikipedia Edit History - ADRG

Nivethitha Kumar 
Call Volume Tracker – Intuit SBG

Shankar Venkataraman 
A Product Selector for Freescale’s Sales and Marketing Team

Shirish Khandekar 
Course Management System for the Department of Mathematics

Sriram Srinivasan 
Eller MIS Student Career Management System

Vinod Nanthan 
ARIZONA RESPIRATORY CENTER – Data Quality issues with ARC Data

Harihur DeSilva 
IT process Provenance Tracking using the W7 Model

Vinayak Sambargi 
Compliance Reporting of Enterprise Applications with the IT Roadmap for Fidelity Investments

Sudakshna Sethuraman 
QuickBooks Enterprise Solution Sunsetting Program:OLAP reporting and Data Mart for Intuit

Regi Thomas 
WikiVote'08: Tracking Provenance on the Wikipedia using the W7 model

Sunil Vadgama 
OLAP Reporting for QUICKBOOKS ONLINE Customer Migration

Min Seong Kang 
A Data Object Warehouse for Rangelands West 

Srikanth Ramachandran 
A Volunteer Management System for the American Red Cross

Sandi Wenas 
A Web based System for Supporting the Internal Review Board at the University of Arizona

2005

Joseph Fortunato 
Fortunato's Catering Management System 

Pierre Geiger 
An Information System for World Care

Priyadath Guptan 
Tours and Travel Management Information System

Srini Venkataramani 
Developing the Tucson Help Portal at the Sanofi-Aventis Combinatorial Technologies Center

2004

AnnMaree White 
Spatio Temporal Data Visualization and Analysis

Merrick B. Richmond 
An Information Management System for Wildfire Related Tree-Ring Data

Dan Keltner 
Product Lifecycle Management: A Best Practices Analysis

Iljoo Kim 
An Information Management System to Support the Institutional Review Board (IRB) at the University of Arizona

2003

Robin Murphy 
A Web Application for Server Resource Management for Boeing Corporation

Kedar Thakker 
Interactive Spending Report Using Multidimensional OLAP Cube for Ventana Medical Systems

Jun Liu 
Implementation of DISTIL: A Conceptual Modeling Tool to Capture Spatio-Temporal Semantics

Fan Li 
Defining Business Rules during Conceptual Database Design: An Automated Approach

Homa Rabiee 
Spatial and Temporal Relational Database Development for Hydrologic Data

Chun Q. Yin 
PET Information Management System (PIMS): A database System to Improve Clinical Operations and to Assist Decision-making for Southwest Positron Emission Tomography Institute

Wei Wei 
Biological Sequence Databases: A New Semantic Model for Sequence Data

2002

Sabah Currim 
Web Based Data Management for Public Land Grazing Management at the Walker Basin Allotment

Bum-Dong Kim 
Intelligent Query Interface for Geospatial Metadata Management

Zhiongxiang Xia 
Web Data Restructuring for the College of Social and Behavioral Sciences

Maneesh Arora 
Content Management in Enterprise Portals

2001

Armaity Billimoria 
Amazon.com: A Case Study of Using Information Technology for Strategic Advantage

Yan Jhang 
Customized Data Representation System Southwest Regional Earth and Science Application Center

Steve Lacroix 
NADM/MAT Knowledge Skills & Abilities Database

Dongwon Lee 
Semi-Autonomously Converting Relational Schema to Conceptual Schema

Daniel M. McDonald 
AGESAGO.com: Knowledge Sharing Applications to Facilitate Mesoamerican Research

Yun Wan 
Crossroads Online Catering System

Gang Yang  
Top Direct Access Project

2000

Hui Li  
A Self-Organizing Map Tool for Heterogeneous Database Schema Integration

Donna Harris  
Business Intelligence System for Ventana Medical Systems, Inc. 

Jongseo Kim  
Resource Harvesting in the Saguaro Digital Library

Jeffrey M. Abbruzzi 
A Reusable Development Framework for Web-based Applications

Jeff S. Perry 
The Wingspan Community Center's Online Membership, Donation and Events System

Lixin Sui  
A Dynamic Online Class Schedule System for DRA Software Training Company

Vaughn A. Hromiko 
The EllerNet and The OCD Company Contacts Management System

Abbas A Rangwala 
Measuring Business Value of Data Warehouse: A Survey of Industry Practices 

Amy Keltner 
Site Use Tracking System Regional Earth Science Application Center

Anuradha Iruku 
Retrieval and Storage of Remote Sensing Data on Snow Cover 

Brian M. Ellerman 
A Lotus/Domino-based Workflow Management System for Madden Media, Inc.

1999

Varsha Das 
Electronic Commerce for the University of Arizona

Edward 'Clarke' Hair 
"Help On Call" An Interactive Caller Database System

Guoxiang Wang  
Data management for Chilean Flora: A Dynamic and Semantic Online System

Kangsuk Kim  
The Development of an Interoperable Mediation System Architecture: An Ontology and Mediator-Based Approach

Yousub Hwang  
Implementation of Semantic Conflict Resolvers: A Production Rule-Based Approach 

Jie Liu 
SunBird International: An Electronic Commerce Database System

1998

Jing Chen 
Virtual Store System: A Relational Database Online Catalog

Ji-Yong Hwang  
The development of the Unifying Semantic Model Star (USM*) Tool in Java 

Victoria Fisher  
Library Information Systems Team HELPline Call Log Analysis

Kristian Aspelin  
Accessing Distributed MultiMedia Data Through Intelligent Agents 

Brad Scwartz  
Admissions Tracker: A system for the University of Arizona MBA programs office

Adva Ziv  
Database Connectivity: A JDBC Solution

Qiong Li  
Dynamic Image Data Management System Using Active Server Pages

Niranjan Manjeshwar  
Navigating the Unifying Semantic Model: Facility for Data Retrieval

Tom Casberg  
A Database for the Pima County Democratic National Party

Chuck Lai 
Database Analysis and Design for the Eller School MBA Program, Independent Study 

Brad Warezack  
Database Design for Big Brothers Big Sisters, Independent Study

Alvin Sebastian 
Freshman Year Center Information System 

1997

Arundhati Guha 
Modeling Business Rules: Developing A Methodology And Software For Systematic Organization of Business Rules

Larry Ricker  
Internet Electronic Commerce Prototype

1996

Kay Woon Tay 
ETHNOS Systems Development Project

Keith A. Wilburn 
Organizational Challenges/Data-Based Solutions: A Case Study

Tim Hui 
A Unix Based Database Design Aid

Joki Leung 
Enhanced Techniques for Database Design

1995

Ying Lim 
Implementation of the Unifying Semantic Model Design Tool 

Youning Lin 
An Intelligent Tool for Schema Analysis and Integration: Methodology, Algorithm & Implementation

Emmanuel Y. Gutierrez  
Design antation of the USM/EOSDIS Schema Repository 

Doug Kroese  
The Undergraduate Programs Office Scholarship Management System

Noel Guttierez 
World Wide Web interface to Sybase for Scientific Data Management 

Curtis Strain  
Unibase Repository

Dan Stiles 
A Graphical Database Design Tool

1994

Kai-tsun Chang  
A Survey of Semantic Data Model Characteristics Desirable in a Computer: The Relational Representation of an USM Schema and Its Implementation

Arun Rajan  
FDEXPERT for Windows

Brian P. Jones  
The Temporal Agent: A Model for Temporal Data Normalization 

Daryn Crawford  
Synthesizer for Windows Version 2.0

Jose Chavez 
SQL VM Reference Manual

Ramesh Venkataraman 
Unibase Modeler: A Graphical Tool

David D. Brown  
A Survey of Semantic Data Model Characteristics Desirable in a Computer Integrated Manufacturing Data Model

1993

Neeraj Talwar  
Synthesizer for Windows

Theodoros Paschalides  
SQL/USM: Syntax and Semantics of a Query Based Language for the Unified Semantic Model

Manohar Mahadevan 
A Plasma Management System: for the Plasma Processing Industry

Aihua Hsiao  
USM Semantics-based fragmentation

Brian Henning  
Infrared Laboratories: Order-Entry System 

Min-Hwei Liu  
Conflict Classification and Resolution: Extension of UNIBASE Schema Integration Tool

Isabelle Mathon  
Automated Tools for Database Design 

K.C. Chang  
CD Library Compact Disk Accessing System

Yiannis Hepis  
A Graphical User Interface for Database Access 

Alan Fu  
A Relational to Hierarchical Database Query Translation Tool

1992

Marwan Mazhar Aiche 
The Unifying Semantic Model User Interface

Ruel L. Torres 
A Prototype Scientific Database Browser Implemented in a Windows Environment

Jean Kierstead  
The Catalina Methodist Day School Database Application

Ted Swanson 
IN TIME: Interactive Database & Prototype Development

Siroos Safaii 
Mainframe to PC Express Database Conversion

1991

Graig Roylance  
The Law Help Database System for Poore & Riddle Law Offices 

David Bean  
Database and Network Design for the Middle Eastern Studies Center

Jim Usry  
Telecomm: An Expert System for New Product Screening 

Avi Basu  
Unifying Semantic Model: Schema Integration Methodology

Kelly O'Neill  
Global Modeling in Distributed Database Systems

1990

James V. Nutley, Kaming W. Poon 
Telecomm - An Expert System For Telecommunication Products Screening

K. E. Fein  
Intelligent Query Interface for Geospatial Metadata Management

1988

Usha Balasubramanian 
Optical Data Storage Bibliographic Information

Mark R. Hall 
Animal Diet/Food Inventory System for the Reid Park 

1987

Clark L. Chastain  
A Benchmark of the Microcomputer Version of the Oracle Database Management System 

Stephen M. Curran  
Land Management Information System

Jaafar Husain  
INNOVATOR - An Expert System for New Product Launch Decisions 

Philip D. Cunningham  
Planning and Implementation Strategies for Automated Office System

Carter L. Frank 
ROTC Cadet Information System

Deanna M. Hicks  
Student Information Management System

Angelic Villarruel 
Family Housing Maintenance System

1986

Candan Bener  
Graduate Placement Information System