Everything you ever wanted to know about using URS

1. Everything you ever wanted to know about using URS Cenk Erdil, HMIS Manager Caitlin Madevu-Matson, SI Specialist Strategic Information Unit 22 May 2014

2. Rationale • You may recall past URS webinars • April 2012 • February 2013 • We are back by popular demand! • Your responses to the SI webinar survey in Nov 2013 • This webinar will be especially useful to • clinical and programmatic staff who do not routinely use URS, but would like to use the data to answer a variety of questions • URS is a valuable resource for ALL ICAP teams

3. Objectives • Provide a URS refresher on general data use • Basics • Dashboard • Reports Module • Answer your questions • A compiled list based on a recent survey

4. Background • Web-based, Scalable & Flexible • Globally accessible: • http://urs2.icap.columbia.edu • ICAP’s central data repository • Mainly used for two reasons: • Submit data for routine indicators • General data use

5. Background • URS general data use: • Up-to-date ICAP required indicator statistics • Monitoring progress to targets • Data reported to ICAP-NY, including: • Mostly ICAP-required indicators • Some indicators that are not ICAP-required

6. Login to URS • http://urs2.icap.columbia.edu A B C

7. Forgot Password

8. Login to URS • http://urs2.icap.columbia.edu A B C

9. Register for an Account

10. Report a Bug / Issue

11. Report a Bug / Issue

12. Overall Structure of URS

13. Overall Structure of URS

14. Dashboard - Definition

15. Dashboard - Tabs

16. Dashboard – Program Areas

17. Dashboard – Priority Indicators

18. Dashboard - Targets

19. Dashboard – Graphs and Tables A

20. Dashboard – Graphs and Tables A B

21. Dashboard – Graphs and Tables

22. Dashboard – Filters

23. Dashboard – Filters

24. Dashboard – Filters

25. Dashboard – Filters A

26. Dashboard – Filters B A

27. Dashboard – Filters B A C

28. Dashboard – Filters B A C D

29. Dashboard – Filter Example

30. Dashboard – Filter Example

31. Dashboard – Filter Example

32. Dashboard – Filter Example

33. Dashboard – Filter Example 2

34. Dashboard – Filter Example 2

35. Dashboard – Priority Indicators

36. Dashboard – Priority Indicators

37. Dashboard – Priority Indicators

38. Dashboard – Priority Indicators

39. Dashboard – Targets

40. Dashboard – Targets

41. Reports • Reports: provide users the ability to adapt how data are presented • Query: user-defined questions • Constructed indicator: user-defined calculated indicators that use formulas 1 2

42. Reports – New Query Variables 1 Funding source: can select all, or subset 2 Program area: can select all, or subset 3 Time period: Quarter and year 4 Indicators: Add or unselect - will be limited by what program areas are selected in #2

43. Reports – Add Indicators 3 2 1

44. Reports – New Query Variables 1 Funding source: can select all, or subset 2 Program area: can select all, or subset 3 Time period: Quarter and year 4 Indicators: Add or unselect - will be limited by what program areas are selected in #2 5 Organizations

45. Reports – Organizations Selection

46. Reports – New Query Variables 1 Funding source: can select all, or subset 2 Program area: can select all, or subset 3 Time period: Quarter and year 4 Indicators: Add or unselect - will be limited by what program areas are selected in #2 5 Organizations

47. Reports – New Query Options 1 Unit status: default is Active, all 2 Chart type: table or graph - Bar graph can be stacked 3 Grouping and series - How to show variables 4 Calculation: default is sum 5 Overall: option to have totals

48. Reports – Saved Queries 1

49. Reports – Saved Queries 2 3 4 1

50. Your Questions!