Web-based Data Analysis in New York State

1. Web-based Data Analysis in New York State NCES 14th Annual MIS Conference

2. 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

3. 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

4. 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 • On-line Cognos Cubes • WNYRIC - http://dataview.wnyric.org • CNYRIC - http://www.cnyric.org/infosystems/software/cognos.htm • NERIC - http://jee.neric.org/sysprog/Cognos.htm • MHRIC - http://www.mhric.org/cognos/ • WFLRIC - http://cognos.edutech.org/ • MORIC - http://www.moric.org/ric/inspinfo.htm • Nassau RIC - http://www.nassauboces.org/cit/d3/index.htm

5. 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.’

6. An Overview of the NYS RIC Project to Date • Where we were, collaboration • Solutions implemented • Results: how things are different

7. EBI Market/Industry and Cognos Overview Unlock the Potential of your Data

8. 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!

9. Enterprise Business Intelligence (EBI) DATA ORGANIZATION Enterprise Business Intelligence users Flat File users users DB Access users Reporting Query Visualiz-ation Analysis

10. 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.

11. 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!

12. eScholar Overview

13. Data Anarchy School District Data Sources

14. Anarchy - Transform & Standardize School Data Bus

15. Anarchy – Transform Store Relational Database Data Mart

16. Anarchy – Transform – Store USE School Data Bus Cognos RDBS Users

17. eScholar School Data Bus Cognos RDBS Users

18. Demonstration 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.

19. Break – 10 minutes After the Break: • 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

20. Demonstration 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.

21. Wrap-up and Final Q & A Contact Information: • 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