Campus Data Warehouse Q & A

What is Data Mining?

• Generally, data mining (sometimes called data or knowledge discovery) is the process of analyzing data from different perspectives and summarizing it into useful information - information that can be used to increase revenue, cuts costs, or both.

• Data mining software is one of a number of analytical tools for analyzing data. It allows users to analyze data from many different dimensions or angles, categorize it, and summarize the relationships identified.

• Technically, data mining is the process of finding correlations or patterns among dozens of fields in large relational databases.

http://www.anderson.ucla.edu/faculty/jason.frand/teacher/technologies/palace/datamining.htm

What is the Campus Data Warehouse?

Understanding Through Visual Analysis
Leverage the data collected within Infinite Campus to better understand results, see relationships and find patterns to make optimal decisions. Stakeholders can continue to leverage the embedded reporting and analysis tools for use across the organization within Infinite Campus or you can invest in Campus Data Warehousing to undertake enhanced reporting, analysis and visualization.  

Data from the Infinite Campus transactional system is exported to the Campus Data Warehouse so districts can use a visualization tool of choice for real-time decision making

Integrated Solutions
The integration of Campus Data Warehousing and Infinite Campus gives users the ability to:
•  Leverage the integrity and breadth of the transactional student data being collected at the point of data entry to populate the operational data store
•  Build complicated ad hoc queries via the data warehouse freeing the transactional system
•  Quick access to flattened views with no slowdown affect on the transactional system 

Key Features

• Leverage Campus Hosting and ARCC to manage the data warehousing server

• Scheduled backup of transactional data

• Cleans and checks data for undesired or inactive data

• Produces materialized views or tables from most Campus views

• Uses tables with indexes for efficient queries

What is Tableau?

Tableau Software is a provider of data visualization and business intelligence software. The company has 30,000 licensed users and several thousand customer accounts.

Tableau Products

Tableau Software offers three main products: Tableau Desktop, Tableau Server and Tableau Reader.

• Tableau Desktop is a software application that enables people to connect to a data source and create analyses and summaries of large amounts of data through a drag-and-drop interface.

• Tableau Server is a Web-based solution for sharing analytic visualizations across workgroups and organizations.

• Tableau Reader is a no-charge application that allows people to read Tableau workbooks created by Tableau Desktop.

How does it all fit together?

click on image for larger view

click on image for more Tableau examples

Helpful Links:

• Campus Data Warehouse Overview http://www.infinitecampus.com/pages/product_menu/district-edition/data-warehousing.php

• Tableau Software  http://www.tableausoftware.com/

• Computer Information Concepts http://www.cicesp.com/

• K-12 Data Mining Overview http://www.techlearning.com/article/13862

How can I find out more?

Contact ARCC via Campus_support@arcc.org or call Jim Livesay 218-723-1700 x121.