Free chocolate and straight talk on facilities data integration !

2. Free chocolate and straight talk on facilities data integration! Tim Hansel, Julie Stines, & Theresa Thompson

3. A bit about Indiana University • 2008-2009 Facts (8 campuses): • Students: • 79,035 FTE • 101,727Headcount • Faculty & Staff: • 17,067FTE Faculty &Staff/ • 18,624Headcount • 825Buildings • 31,134,889 GSF building space • 4,878Acres • $2,712,464,294 Operating Budget

4. Facts and Figures – Square Feet

5. Facts and Figures – Student/Faculty FTE

6. Planning and Construction (as of 7/2008) Major Projects in construction (system wide) $363 million MajorProjects in planning and/or design $655 million Total $1.2 billion Each month we average 1,300 active projects in planning/design/construction (includes smaller in-house design/built projects)

7. Organizational Structure Vice President for Capital Projects and Facilities

8. FIMS- 10 years ago….. “Breaking down the barriers” Creating a Facilities Information Management System MMS CAD/CAFM GIS

9. “Breaking down the barriers”Our main barriers... Technology People Data

10. “Breaking down the barriers”FIMS Data Flow Process Team: • Formed in July, 1994 • CHARGE: Define facilities data flow and distribution to accommodate: • One set of accurate base plans • Archive of project files • Link to room inventory • Access for those who need it • make it easy to use • Expanded to include architects, engineers, physical plant staff

11. FIMS Vision

12. FIMS …today • PeopleSoft • Student Information System • Human Resources • Kuali • Financial Information System • Capital Asset Management • Pinnacle • Telecommunications GIS • Onbase • Document Management • IU Real Estate • Lease Management EH&S Electronic Procurementand Invoicing Center Risk Management/Fire Safety BIM

13. Kuali Open Source Software www.kuali.org 'When we say free, think free puppy not free beer.'Brad Wheeler, Indiana University

14. Focus shift • Administrative Systems: • Less about choosing one “do it all” software • More about integrating/interfacing appropriate software • IU data warehouse • Data-still in silos • Trend and need is toward modeling and using the data effectively across the “silos” for business intelligence and decision support. • Projections and Forecasting

15. Business Intelligence What is your capacity?

16. Teaching Room Utilization

17. Anyone using this model?

18. CEFPI Space Model Council of Educational Facility Planners International

19. Our Current Facilities Toolbox • BIM (Revit / NavisWorks) • CAD (AutoCAD/AutoCAD Map 3D) / SketchUp • CAFM (FM:Systems - linked CAD + SQL Server database) • CMMS (FacilityMAX by AIM) • EDMS (OnBASE) • GIS (ESRI site license / SDE environment/ArcGIS Server) • GPS (CORS station at Bloomington campus) • Project Bidding – online planroom (www.iuplanroom.com) • Project Collaboration (ProjectDox by Avolve) • Statewide Aerial Orthophotography and Pictometry obliques

20. CAD Master Library • Central source for architectural base plan • Project start up • Room number assignment

21. Facilities web front door www.indiana.edu/~fims

22. Serving our Customers

24. FM:Interact (CAFM)

26. Life Safety

27. Egress