# Presentation: 532605

## Web-based Data Analysis in New York State

**NCES *****14******th****** Annual MIS Conference***

## Cast of Characters

**Cognos Corporation**
**Shara Bunis, Specialist, Education K-12**
**Mark Kilcawley, Senior Account Manager**
**James Waters, Technical Specialist**
**eScholar**
**Shawn Bay, CEO**
**New York State**
**Paulette Robichaud, Erie 1 BOCES**
**Bill Heppeler, CNYRIC**
**Dave Courtright, NERIC**

## Agenda

**(5) ****Welcome and opening comments**
**(15) An overview of the NYS RIC Project to date**
**where we were, getting collaboration **
**solutions implemented **
**results: how things are different **
**(5) EBI Market/Industry **
**(10) Cognos overview **
**(10) eScholar overview **
****************Break*****************
**(70) Data demonstration and specific applications**
**Title I, (to include training implications and using data for decision making)**
**State assessment cube (how data can be used by different types of school/district personnel)**
**Medicaid (Statewide data)**
**(5) Wrap up and Final Q&A**

## Welcome and Opening Comments

**Handouts**
**MIS Presentation slides**
**Multidimensional Analysis Tools**
**Data Reporting and Analysis: Unlock the Potential of your Data**
**A Case Study of Classroom Data Needs**
**Inquiry-Minded Schools: Opening Doors for Accountability **
**MCAS Testing Results Using Cognos**
**Top of the Class**
**Cognos Product Information (PowerPlay, Impromptu Web Reports, and Visualizer)**
**On-line Resource**
- _[DSSRECOURCES.COM ](http://www.dssresources.com/)_
**On-line Cognos Cubes**
**WNYRIC - **_[http://](http://dataview.wnyric.org/)__[dataview](http://dataview.wnyric.org/)__[.](http://dataview.wnyric.org/)__[wnyric](http://dataview.wnyric.org/)__[.org](http://dataview.wnyric.org/)_
**CNYRIC - **_[http://www.](http://www.cnyric.org/infosystems/software/cognos.htm)__[cnyric](http://www.cnyric.org/infosystems/software/cognos.htm)__[.org/](http://www.cnyric.org/infosystems/software/cognos.htm)__[infosystems](http://www.cnyric.org/infosystems/software/cognos.htm)__[/software/](http://www.cnyric.org/infosystems/software/cognos.htm)__[cognos](http://www.cnyric.org/infosystems/software/cognos.htm)__[.](http://www.cnyric.org/infosystems/software/cognos.htm)__[htm](http://www.cnyric.org/infosystems/software/cognos.htm)_
**NERIC - **_[http://](http://jee.neric.org/sysprog/Cognos.htm)__[jee](http://jee.neric.org/sysprog/Cognos.htm)__[.](http://jee.neric.org/sysprog/Cognos.htm)__[neric](http://jee.neric.org/sysprog/Cognos.htm)__[.org/](http://jee.neric.org/sysprog/Cognos.htm)__[sysprog](http://jee.neric.org/sysprog/Cognos.htm)__[/Cognos.](http://jee.neric.org/sysprog/Cognos.htm)__[htm](http://jee.neric.org/sysprog/Cognos.htm)_
**MHRIC - **_[http://www.](http://www.mhric.org/cognos/)__[mhric](http://www.mhric.org/cognos/)__[.org/](http://www.mhric.org/cognos/)__[cognos](http://www.mhric.org/cognos/)__[/](http://www.mhric.org/cognos/)_
**WFLRIC - **_[http://](http://cognos.edutech.org/)__[cognos](http://cognos.edutech.org/)__[.](http://cognos.edutech.org/)__[edutech](http://cognos.edutech.org/)__[.org/](http://cognos.edutech.org/)_
**MORIC - **_[http://www.](http://www.moric.org/ric/inspinfo.htm)__[moric](http://www.moric.org/ric/inspinfo.htm)__[.org/](http://www.moric.org/ric/inspinfo.htm)__[ric](http://www.moric.org/ric/inspinfo.htm)__[/](http://www.moric.org/ric/inspinfo.htm)__[inspinfo](http://www.moric.org/ric/inspinfo.htm)__[.](http://www.moric.org/ric/inspinfo.htm)__[htm](http://www.moric.org/ric/inspinfo.htm)_
**Nassau RIC - **_[http://www.](http://www.nassauboces.org/cit/d3/index.htm)__[nassauboces](http://www.nassauboces.org/cit/d3/index.htm)__[.org/cit/d3/index.](http://www.nassauboces.org/cit/d3/index.htm)__[htm](http://www.nassauboces.org/cit/d3/index.htm)_

## Beyond Systems and onto Decisions

**Irene DaMota**
**Principal, Roberto Clement High School, Chicago (2/17/2001)**
**‘...****I cannot wait to tell the world about solutions that are helping me to interpret hidden data relationships about my learners, powerful information that is going to couch the way we teach and the level of readiness and expertise our learners are acquiring on discreet concepts and learning themes.’**

## An Overview of the NYS RIC Project to Date

-  Where we were, collaboration
-  Solutions implemented
-  Results: how things are different

## EBI Market/Industry and Cognos Overview 

**Unlock the Potential of your Data**

## KOTO - King of the Obvious 

- Business is defined as having responsibilities.
- Success is the result of more good decisions than bad.
- Data by itself means nothing.
- Data does not discriminate - it treats all users the same.
- Data only becomes a valuable resource when it is maximized by users for decision making.
***Everybody within an organization relies on data!***

**KOTO - King of the Obvious **

## Enterprise Business Intelligence (EBI) 

**Enterprise Business Intelligence (EBI) **

**DB**

**Access**

**Flat**
**File**

_**DATA**_

- users

- users

- users

- users

_**ORGANIZATION**_

***Enterprise***
***Business***
***Intelligence***

**Reporting**

**Query**

**Analysis**

**Visualiz-ation**

## Components of EBI

**Reporting**
- Creating standard periodic reports (daily, weekly, or monthly).
- Specific formats – distributed electronically.
**Query**
- For asking questions of the database.
- The question asked is known.
**Analysis**
- Looking to investigate an issue.
- Not sure what to ask, but need a quick response.
**Visualization**
- Prefer visual view of data for quick assessment.
- Desire Key Performance Indicators (KPI) and scorecard capabilities.

**Components of EBI**

## COGNOS Corporation

- In business for 30+ years
- 2100+ employees
- 45 offices in 17 countries
- $500M+ annual revenue
- 1.8 million+ Business Intelligence (BI) licenses
- 29,000+ customers in over 60 countries
- 60% of the EBI market (industry leader)
***Why is this important?***
***	******	******	******.........******It’s about partnering!***

**COGNOS Corporation**

## eScholar Overview

**eScholar Overview**

## Data Anarchy

- School District Data Sources

## Anarchy - Transform & Standardize

- School Data Bus

## Anarchy – Transform  Store

- Relational Database
- Data Mart

## Anarchy – Transform – Store    USE

- Users

- Cognos

- RDBS

- School
- Data Bus

## eScholar

**eScholar**

- Users

- Cognos

- RDBS

- School
- Data Bus

## Tomorrow in the Crocodile Ballroom

**We invite you to come play with education data. You will be able to access, query and develop reports using Web-based education data. **
**Stop by and take advantage of this opportunity to speak one on one with us. Come by as your schedule permits or reserve your spot for a personal session now.**

**Demonstration **

## Break – 10 minutes

** ****Data demonstration and specific applications**
**Title I, (to include training implications and using data for decision making)**
**State assessment cube (how data can be used by different types of school/district personnel)**
**Medicaid (Statewide data)**
** ****Wrap up and Final Q&A**

**Break – 10 minutes**

## Tomorrow in the Crocodile Ballroom

**We invite you to come play with education data. You will be able to access, query and develop reports using Web-based education data. **
**Stop by and take advantage of this opportunity to speak one on one with us. Come by as your schedule permits or reserve your spot for a personal session now.**

**Demonstration **

## Wrap-up and Final Q & A

**Cognos Corporation – http://www/cognos.com**
**Shara Bunis, Specialist, Education K-12   shara.bunis@cognos.com   800-365-3968 x2618**
**Mark Kilcawley, Account Manager   mark.kilcawley@cognos.com   800-365-3968 x2639**
**James Waters, Technical Specialist   james.waters@cognos.com   904-556-7548**
**eScholar – http://www.escholar.com**
**Shawn Bay, CEO   sbay@escholar.com   914-989-2909**
**Ron Streeeter,   V.P., Decision Support Systems   rstreeter@escholar.com   914-989-2914**
**Eric Johnson,   V.P., Sales & Marketing   ejohnson@escholar.com   914-989-2910**
**New York State**
**Paulette Robichaud, Erie 1 BOCES   probicha@erie1.wnyric.org   716-821-7187**
**Bill Heppeler, CNYRIC   wheppele@cnyric.org   315-433-8317**
**Dave Courtright, NERIC   dwc@gw.neric.org   518-456-9051**

**Wrap-up and Final Q & A**