Leverage Data for Mission-Driven Organizations November 7 2013

Leverage Data for Mission-Driven Organizations November 7, 2013

Using Ready. Talk • Chat and raise hand • All lines are muted • If you lose your Internet connection, reconnect using the link emailed to you. • If you lose your phone connection, re-dial the phone number and re-join. • Ready. Talk support: 800 -843 -9166 Your audio will play through your computer’s speakers.

You are being recorded… • This seminar will be available on the Tech. Soup website along with past webinar presentations: www. techsoup. org/community/eventswebinars • You will receive a link to this presentation, material, and links. • Twitter hashtag: #techsoup

Leverage Data for Mission-Driven Organizations With Nish Pangali, SAP Welles Hatch, City Year Probodh Chiplunkar, KPIT

Presenters Becky Wiegand Interactive Events Producer Tech. Soup Nish Pangali Head of technology CSR, SAP Welles Hatch Senior Vice President & CIO City Year Assisting with chat: Ale Bezdikian Probodh Chiplunkar BI, SAP HANA Sparta Consulting, KPIT

Today’s Agenda: • • Introducing Tech. Soup Corporate Social Responsibility at SAP Turnkey Data Solutions – Tech. Soup Donations Case Study of Leveraging Data: City Year Developer Wars Data Dashboards and Tips for Data Q&A

Who Is Tech. Soup? Tech. Soup is part of Tech. Soup Global, working towards the day when every nonprofit, library, and social benefit organization on the planet has the technology, knowledge, and resources they need to operate at their full potential.

Who Is Tech. Soup? • Tech. Soup is a 501(c)(3) nonprofit organization. • As of April 30, 2013, Tech. Soup Global has served more than 208, 300 organizations — including over 67, 000 organizations outside of North America. We have distributed more than 11 million software and hardware product donations and enabled recipients to save more than US$3. 61 billion in IT expenses in 56 countries around the world.

Who Is Tech. Soup? • Technology donations available through the Tech. Soup catalog: 401 • Number of donor partners for US programs, including Adobe, Cisco, Microsoft, and Symantec: 63 • Net. Squared Local monthly meetup groups around the world: 48 • Tech. Soup’s community blog and forums have participation from more than 50, 000 monthly NPO and library users. • Reach more than 200, 000 NPO, library, and philanthropy subscribers in the United States with our newsletters each month.

SAP’s Corporate Social Responsibility Turnkey Data Solutions for Nonprofits Nish Pangali

Corporate Social Responsibility Synergy for Positive Social Change SAP VISION Help the world run better and improve people’s lives CSR FOCUS Enhance education for underserved youth and propel emerging entrepreneurs to foster economic growth GUIDING CSR PRINCIPLES Note: figures as of May 2013 Leverage our core expertise • Engage multiple stakeholders • Create social impact • Generate lasting impact on SAP • © 2013 SAP AG. All rights reserved. 12

SAP Technology Framework Offered via Tech. Soup Just launched

SAP Analytics Solutions Offered in Partnership with Techsoup • Analyze data by creating and sharing graphical data visualizations from multiple data sources. Use Lumira’s data mining tools to pull immediate information for the purpose of grant writing and development • Design and generate reports from wide range of data sources. Reduce time producing reports to state and federal grantors • Create dynamic and interactive presentations using your organization's data. Data presentations to Advisory Board. Create future annual budgets based on hypothetical projection models

SAP E-Learning Courses Tap into SAP knowledge with self-paced e-learning courses that help you with report design and strategies, guide you through data processing, and offer tips for making your reports highly visual.

Additional Resources • SAP analytics donation offering: http: //www. techsoup. org/SAP • Access this and other Tech. Soup webcasts: www. techsoup. org/community/events-webinars • SAP Corporate Social Responsibility: http: //global. sap. com/corporateen/sustainability/corporate-social-responsibility. epx

Case Study: City Year Technology Strategy Summary Goals and BI Planning Welles Hatch, City Year

© 2013 SAP AG. All rights reserved. 18

Today 150, 000 Students served 247 Schools 2, 500 Corps members 24 Cities

At full scale, every day 900, 000 Students served 1, 200 Schools 14, 000 Corps members 38 Cities

City Year Core 4 Staff & corps members Performance & compensation Time tracking, payroll Financials, grant management Expense mgt, asset tracking School partners Contracts Corporate partners/donors Alumni & other constituents • • Students & performance data Programs Dosage and time Progress Monitoring Content & Collaboration • • Team sites Program portals Enterprise home page Project management cyconnect • • cychannel Relationships Services cyschoohouse • • • cyresource Organization

City Year Has Dual Sources Student Performance Demonstrating Impact • • • “Enrolling” students in interventions Tracking classroom grades with corps member coaching and mentoring time with students Coordinating review of results with teachers, other support Operational Excellence Enabling shared services • • • Hiring, onboarding and Staples orders consume inordinate resources Driving for transparency to support decisions Budgets are just the beginning, but those are hard enough

BI Challenges Collecting from schools • • • Monitoring for students getting back on track Evaluating corps member skills Working as a team with teachers to support students Aggregating nationally • • • Getting 25 locations on the same page How to avoid email as workflow Fidelity to the service model Single version of the truth • • • Moving off spreadsheets Establishing “systems of record” Native and cross-platform reporting The “how” of analysis • • • Building a reporting pipeline Certification for report writers/analysts Standardized methods for responding to requests

Q&A Contact Information: Welles Hatch, CIO +1 617 927 2567 [email protected] org

Developer Wars & Data Tips Probodh Chiplunkar Sparta Consulting, KPIT

KPIT ON, Canada Folsom, CA (US HQ) 8000+ people 410 m Revenue Iselin, NJ; Columbus, IN; Farmington Hills, MI; Newport, CA; San Francisco, CA; Beaverton, OR; Houston, TX; Austin, TX; Dallas, TX; Boca Raton, FL Hurst (UK) Paris Frankfurt Stockholm Munich Amsterdam Tokyo Seoul Shanghai Dubai Pune Noida Bangalore Hyderabad Chennai Gurgaon Mumbai Sao Paulo Sydney Johannesburg USA | UK | China | France | Germany | India | Japan | South Africa | South Korea Singapore | Brazil | Sweden | Netherlands |Canada | Australia | UAE 33 Offices in 16 Countries Automotive Manufacturing E&U Singapore

BI Best Practices • Business Skills – Clear workflow for business – Understanding of KPIs – User Expectations • Analytical Skills – Building intuitive workflows – Algorithms for aggregation – Slide/Dice, Predictive needs • IT Skills – Right Tools with right skills – IT Processes, Testing Governance – Quality of Data management

Q&A Contact Information: Probodh Chiplunkar, Partner +1 804 690 7906 [email protected] com

Q&A Please type your questions in the chat window.

Additional Resources • SAP Donation Program through Tech. Soup – Lumira Standard Edition – Crystal Reports 2011 – Crystal Dashboard 2011 • Creating Effective Reports with Crystal Reports 2011 (previously recorded webinar) • Remember Paint by Number? SAP Lumira: A Visual Treat for Reporting Data (Tech. Soup Blog)

Thank You to Our Webinar Sponsor! Ready. Talk offers dedicated product demos for Tech. Soup organizations 4 times per week. For more information: www. techsoup. org/readytalk