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.
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)
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)
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
First 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