Home

NASCIS OLAP User Guide 2014

1. 8 12 6 23 9 Drag and drop the Question you require into the rows Left click the question once it is in the column box and it will bring up a pop up menu Drag and drop the attribute to compare against for example Demographic Primary Client Group or Services Received into the column box You can left click the attribute once it is in the row box and un tick the box for missing Drag and drop the Row Distribution measure into the row section It will be displayed as Measures once placed This will then distribute the figures as a of the total for the responses for the age group For example the percentage of respondents in the 65 74 age bracket is 14 2 of the respondents who answered they were very satisfied for question 1 The above figure shows a completed view following the above method and the grid produced 30 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide An example view of user satisfaction by age demographic as a of Column Distribution Drag and drop the Question you require into the rows Left click the question once it is in the column box and it will bring up a pop up menu Drag and drop the attribute to compare against for example Demographic Primary Client Home AboutNASCIS DataResources NASCIS Library FAQs ContactUs Strategy Social care data ASCS Beta 2010 11 Published
2. gt Filters Service Type Residential Care X Area Multiple gt Year 2012 13 X k Year Columns Li Area sae Measures X le Client Type Views l Service Type i im Grid Chart Number of Service Users S Yorkshire amp Humber 19 05 2014 09 42 Filter Criteria Service Type Residential Care For additional information whenever filters are used the filters that have been applied to the query are displayed at the end of the query Please note that this only displays in the Grid layout and not the chart 21 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 5 Customising icons There are several icons at the top of the screen This section shows how they can be used Hovering over each icon provides a brief explanation u a Bar Chart P z Cal Comparator Groups 5 1 Exporting and copying data to Excel Data in the views i e charts and grids can be exported into a spreadsheet for further analysis Click on the Save current view to disk i e the first icon on the customising icon row and then click Open to view or Save the data The file is saved with an xls extension so it can be opened in any version of Microsoft Excel you are using Similarly you can copy the data to the clipboard second icon along and paste the contents into Excel The first screen s
3. Drag and drop area or an attribute from demographics from the left hand side field If you wish to look at a certain demographic in an area you can drag and drop area into the filters field and then click it to bring up a menu in which you select the area to filter by Drag and drop the Row Distribution measure from the left hand field into the rows Drag and drop the Question you require from the left hand field into the columns To interpret these results you should sum the percentage of people who responded to each answer of the question in the picture above this would be the sum of all of the respondents to I am extremely satisfied to am extremely dissatisfied and then use this as the percentage of people who responded to the survey Figure 5 above shows an example of response rate compared between different ethnic groups in the Croydon area of London 35 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 7 4 Non responses to survey options on NASCIS To check for non response to the survey questions in OLAP users should add non response to question non response to questionnaire and did not receive questionnaire options by the area category and applying the row distribution measure a sensible table will be produced The row totals will add up to 100 The same is applied when exploring non response by demographi
4. Health amp Social Care hscic Information Centre National Adult Social Care Intelligence Service NASCIS Online Analytical Processor OLAP User Guide Adult Social Care Statistics 000000000 Published October 2014 Version 3 0 1 Copyright 2014 Health and Social Care Information Centre Contents 1 Introduction 1 1 1 2 1 3 1 4 1 5 Purpose Background Access and authentication Browser performance User support 2 Accessing the System 2 1 2 2 2 3 2 4 2 5 The NASCIS Website The NASCIS Data Resources Login screen Selecting the required data set Selecting the required table from the data 3 The OLAP screen 3 1 3 2 3 3 3 4 Rows columns and filters Measures and dimensions Viewing pre release access data Query metadata 4 Building a query 4 1 4 2 4 3 4 3 1 4 3 2 4 3 3 4 3 4 Selecting rows and columns Changing between grid and chart views Filters Choose the required dimension to filter Drilling down to select a filter value The filtered chart Selected filters 5 Customising icons 5 1 5 2 5 3 5 4 5 5 Exporting and copying data to Excel Pivot the data Clear the data Toggle the view total Saving your query COON DD OD aatkr fp LH A mek ke N a a a O ans RAR a See e e o O O O NO N N O N N MN N NNDD a A AOD Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 6 Joint
5. Only available to Local Authorities as pre release data for management purposes 49 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 2012 13 May 2013 Update of JSNA Indicators June 2013 Initial 1 cut 2012 13 Referrals Assessments and Packages of Care RAP data Initial 1 cut 2012 13 Adult Social Care Combined Activity Return ASC CAR data Initial 1 cut measures from the 2012 13 Adult Social Care Outcomes Framework July 2013 Initial 1 cut 2012 13 Personal Social Services Expenditure PSS EX1 data Initial 1 cut 2012 13 Abuse of Vulnerable Adults AVA data Provisional 2012 13 Referrals Assessments and Packages of Care RAP data Provisional 2012 13 Adult Social Care Combined Activity Return ASC CAR data Provisional measures from the 2012 13 Adult Social Care Outcomes Framework Provisional 2012 13 Adult Social Care Survey ASCS data September 2013 Provisional 2012 13 Personal Social Services Expenditure PSS EX1 data Provisional 2012 13 Abuse of Vulnerable Adults AVA data October 2013 Final cut 2012 13 Personal Social Services Expenditure PSS EX1 data Final cut 2012 13 Abuse of Vulnerable Adults AVA data Final cut 2012 13 Referrals Assessments and Packages of Care RAP data Final cut 2012 13 Adult Social Care Combined Activity Return ASC CAR data Final cut measures from the 2012 13 Adult Social Care Outcomes Framework Final c
6. Social care related quality of life L Male Female lage 18 to 64 T Age 65 and over 1B Proportion of people who use services who have control over their daily life Male LC Female lage 18 to 64 Age 65 and over 1C 1 Proportion of people using social care who receive self directed support Client E Age 18 to 64 Physical Disability C Mental Health Disaggregation categories include Gender Age band Client Type Client and Carer 8 3 Regional and England measures Regional outcomes measures are not currently available for 2011 12 data England totals and outcome measures are subject to change and refinement 8 4 Unavailable measures The following outcome measures were unavailable for 2011 12 and 2013 14 when the carers survey data was unavailable 1D Carer reported quality of life 3B Overall satisfaction of carers with social services 3C The proportion of carers who report that they have been included or consulted about the person in care 3D The proportion of people who use services and carers who find it easy to find information about services carers element 38 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 9 Miscellaneous This user guide has been written to assist users who are new to the NASCIS OLAP and also as a point of reference as to how to perform bas
7. u ae o z Stacked Bar Chat E ii Measures a ili Distribution ili Distribution Unrounde ili Row Distribution Rows ili Row Distribution Unrot ili ihi Column Distribution U tz Year t Area L Questions 4 Survey Administration E t Demographics T Gender E Grid Chart 2010 11 Filters Drop attributes here to filter the data Q1 All X Measures X Columns Age Group All X Views am extremely satisfied am very satisfied uite 1 Overall how satisfied are you with the I am very dissatisfied care and support services you receive x y di stie am extremely dissatisfied z Did not receive a model questionnaire i Non response to the whole survey Non response to this question Q1 Overall how satisfied are you with the care and support services you receive Total Age Group 85 or 5 54 5564 65 74 7584 ver 96 22 38 5 2 7 3 98 10 5 9 6 9 1 8 5 216 35 42 5 6 7 4 96 13 1 14 3 14 6 11 6 14 4 29 3 2 47 58 8 5 98 11 4 12 5 9 5 E IS i L i ae 67 09 08 16 17 25 26 26 23 2 2 1 7 04 03 05 08 0 7 0 8 0 7 06 os T aA 0 3 03 03 sell ae i 0 2 0 2 08 03 ia as 05 0 6 0 4 a i 02 03 19 568 FA 35 8 29 2 18 2 65 1 3 0 3 12 6 38 7 32 6 P 452 46 1 48 4 53 4 57 2 58 4 52 6 33 03 04 0 6 0 9 1 5 26 25 1 9 18 230 5180 7890 40985 14075 14995 190
8. Client Type Views lz Service Type X They will be able to select restricted data and see whatever data is available to them during the pre release periods For security purposes the default view for all users is Published and any queries that are saved in the Published view will have to be recreated on Restricted Please see section 5 5 of this guide for further information on saving queries 3 4 Query metadata As further information about the query you have created a date and time of creation is placed on screen below the Grid Chart area Grid Chart Ophysical Disability BMental Health Learning Disability Other Vulnerable People Number of Service Users Number of Service Users Number of Service Users Number of Service Users Number of Service Users Number of Service Users Barnsley 204 3105 790 65 0 95 4060 Bradford 209 5785 945 130 20 140 7025 Calderdale 210 1905 650 55 0 85 2690 Doncaster 205 2655 ess 125 ol 120 4580 East Riding 214 5355 800 155 10 o 6820 Kingston upon Hull 215 5265 560 20 10 210 6125 Kirklees 271 3890 1045 105 5 20 9925 Leeds 212 6010 2200 215 15 285 8700 Yorkshire amp Humber t t gm sA N E Lincolnshire 218 2860 20 45 o o 2995 N Lincolnshire 217 2585 145 20 ol o 2760 North Yorkshire 218 12310 1250 180 10 30 13840 Rotherham 208 4180 280 75 o 25 4615 610 1190 135 o 180 2150 Wakefield 213 5210 270 115 5 435 6030 York
9. E North East North West South East South West West Midlands Yorkshire amp Humber Barnsley 204 Bradford 209 Calderdale 210 Doncaster 205 East Riding 214 Kinaston upon Hull 215 Buttons three to six expand and contract the levels The double arrows will open and close all the items with a next to them and show the next drill down level Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide Similarly if you click on selected measures and dimensions on the right side of the Work area a drop down list can be accessed to select particular values for the dimension e g to show Mental Health service users only from Client Type dimension Dimensions and measures that have been added to the work area have been greyed out for ease of use 3 1 Rows columns and filters Rows define the values in the rows of a grid and these values are displayed on the horizontal axis of charts Columns define the values in the columns of a grid Filters define the scope of the values to be included e g Only include councils in the East Midlands 3 2 Measures and dimensions Measures are the items that you are counting and will vary depending on the data set you are querying Example measures for the Social Care data include Number of Service Users No of service users per 100 000 population Change Year on Year and Distribut
10. MALE FEMALE PERSONS 18 64 18 64 18 64 18 PLUS 18 PLUS 18 PLUS 65 74 65 74 65 74 65 PLUS 65 PLUS 65 PLUS 75 84 75 84 75 84 85 PLUS 85 PLUS 85 PLUS 00 17 00 17 00 17 56 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide User Experience Survey UES Personal Social Services Survey of Adults receiving Home Care in 2008 09 Adult Social Care Survey Final 2012 13 Carers Survey Final 2012 13 Users wishing to see council level results from the survey can also access them from the HSCIC publication page and some headline England level analysis is available from our website Joint Strategic Needs Assessment JSNA Please refer to the Data Availability spreadsheet to see at what level and which measures are available for the data you want to view Safeguarding Adults Return SAR The Safeguarding Adults Return SAR collects information about safeguarding cases managed by Councils with Adult Social Services Responsibilities CASSRs in England It includes information about the adults at risk the types of risk experienced and the locations of the risk The 2013 14 reporting period is the first year of the SAR collection Before this time safeguarding data were gathered in the Abuse of Vulnerable Adults AVA collection which has now been discontinued Records are kept of all safeguarding cases and this information is submitte
11. NASCIS Online Analytical Processor OLAP User Guide 41 1st ACA Grouping Cumbria Northumberland Gateshead Newcastle upon Tyne North Tyneside South Tyneside Sunderland Hartlepool Middlesbrough Redcar amp Cleveland Stockton on Tees Durham Darlington Barnsley Doncaster Rotherham Sheffield East Riding Kingston upon Hull NE Lincolnshire N Lincolnshire North Yorkshire York Lancashire Blackburn Blackpool Staffordshire Stoke on Trent Herefordshire Worcestershire Shropshire Telford and Wrekin Lincolnshire Derbyshire Derby Leicestershire Leicester Rutland Nottinghamshire Nottingham Norfolk Suffolk Dorset Bournemouth Poole Cornwall Somerset Devon Plymouth Torbay 2nd ACA Grouping Bradford Calderdale Kirklees Leeds Wakefield Bolton Bury Manchester Oldham Rochdale Salford Stockport Tameside Trafford Wigan Knowsley Liverpool Sefton St Helens Wirral Halton Warrington Cheshire East Cheshire West and Chester Warwickshire Birmingham Coventry Dudley Sandwell Solihull Walsall Wolverhampton Northamptonshire Luton Essex Southend Cambridgeshire Peterborough Bedford Central Bedfordshire Isle of Wight West Sussex
12. OLAP User Guide An example view of the data in the same style as the published annex tables by area as a of row distribution rublsneaq v ae OB stacked Bar Chat 2010711 7 E ii Measures amp Filters Drop attributes here to filter the data ihi Distribution ihi Distribution Unrounde di Rows ihi Row Distribution Unroi Area Total x Measures X ili Column Distribution ili Column Distribution U Columns L Year Q1 All lL Area x L Questions Views lL Survey Administration E L Demographics t Gander im 4 gt Grid Chart 51 Overall how satisfied are you with the care and support services you receive a lam extremely lam very lam quite J am quite Iam very lam extremely gt Overall how sattsBed anv you satisfied satisfied satisfied 5 sas dissatisfied dissatisfied dissatisfied eae E tae eile ec i dissstisfied you receive Total GEast Row Distribution 23 2 37 7 29 2 67 20 0 7 05 2585 Midlands i 7 5 a 20 2 33 2 37 0 7 5 16 06 320 20 1 29 1 21 1 69 15 05 08 390 T ji 15 4 28 6 34 6 65 26 07 07 305 1 20 0 38 2 26 2 10 0 24 06 29 340 T ji Hertfordshire 8 bce 20 0 363 32 0 8 0 15 15 0 6 325 l ae 23 8 29 7 35 7 2 9 1 1 07 270 7 k A 17 6 37 3 248 7 5 1 1 07 1 1 280 26 3 24 5 318 55 14 05 03 365 f 27 6 26 4 25 8 6 5 23 06 0 9
13. 13 2014 15 The following outcome measures are unavailable for 2011 12 and 2013 14 1D Carer reported quality of life 3B Overall satisfaction of carers with social services 3C The proportion of carers who report that they have been included or consulted about the person in care 3D The proportion of people who use services and carers who find it easy to find information about services carers element 55 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide Population data ONS mid year estimates 2005 2006 2007 revised 2012 revised 2012 revised 2012 LA LA LA MALE FEMALE PERSONS MALE FEMALE PERSONS MALE FEMALE PERSONS 18 64 18 64 18 64 18 PLUS 18 PLUS 18 PLUS 65 74 65 74 65 74 65 PLUS 65 PLUS 65 PLUS 75 84 75 84 75 84 85 PLUS 85 PLUS 85 PLUS 00 17 00 17 00 17 2008 2009 2010 revised 2012 revised 2012 revised 2012 LA LA LA MALE FEMALE PERSONS MALE FEMALE PERSONS MALE FEMALE PERSONS 18 64 18 64 18 64 18 PLUS 18 PLUS 18 PLUS 65 74 65 74 65 74 65 PLUS 65 PLUS 65 PLUS 75 84 75 84 75 84 85 PLUS 85 PLUS 85 PLUS 00 17 00 17 00 17 2011 2012 2013 revised 2012 revised 2012 due to publish October 2014 LA LA LA MALE FEMALE PERSONS MALE FEMALE PERSONS
14. 219 4330 280 55 o 845 5510 Yorkshire amp Humber Total 78330 11255 1615 75 2555 93825 729745 134970 15115 825 15290 895940 4 Date 16 05 2014 15 32 Filter Criteria Ageband Age 65 and over Year 2012 13 This will allow you to determine when the query was run and what filters were applied to the query This information will tell you how up to date your query is so that you can re run the query if the OLAP has been updated 15 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 4 Building a query 4 1 Selecting rows and columns To define a report e g table to show Total Number of Service Users by Age e Left click on year and drag into filters this will automatically select the latest year Click into year to change the year range to an historical single date e Left click on Area and drag into the Rows box then click on Area Total in the Rows box and select Yorkshire amp Humber councils only e Left click on Number of Service Users from the Measures list on the left and drag the item across to the Columns box e Click on the symbol to expand Yorkshire amp Humber on the grid Home AboutNASCIS DataResources NASCISLibrary FAQs ContactUs Strategy Social care data RAP P1 Published v u ROB sacha S pr v Ll Comparator Groups E bh Measures Filter
15. 28 6 36 8 28 3 3 8 0 8 1 1 05 365 uti w istribution 5 Abele 25 4 45 29 2 70 21 07 1 4 285 Sheet 208 374 30 8 76 15 os 13 3585 N D g N 8 oO w N oa w osos Ha pesn Ro 23 9 24 9 26 9 6 0 14 0 4 05 3190 E s Row Distributii 298 23 9 26 5 6 0 24 06 1 0 8205 Row Distribution 25 5 25 9 29 0 62 22 os os 5780 25 2 28 9 28 4 au 16 07 09 5825 w Distribution 26 7 242 29 1 e 7 17 0 6 09 4g40 t j mrodshire amp lag Row Distribution 27 6 25 8 28 0 57 18 o5 08 4950 257 352 28 8 67 19 o7 1 0 49620 The above shows a typical view showing a question by area as in U1 Answers by Council of the annex tables that are published with the ASCS reports Drag and drop area from the left hand field into the rows Left click area once it is in the row box and you can select either the region or drill down into the region To do this click on the next to Eastern then click the select all button which is the first button on the left at the top Then click on the checkbox next to Bedfordshire 610 to deselect this council and click OK Drag and drop the Row Distribution measure from the left hand field into the rows Drag and drop the Question you require from the left hand field into the columns Left click the question once it is in the column box to bring up a pop up menu Click on the next to Q1 to drill do
16. New data available Final 2012 13 Referrals Assessments and Packages of Care RAP data and Give us your feedbac final measures from the 2012 13 Adult Social Care Outcomes Framework ASCOF are available to all users Included are updates to the Older People RAP Comparator and ASCOF standard reports 17 12 13 Your feedback is critical to the ongoing development and improvement of NASCIS Please provide us with feedback NASCIS has been updated to include final 2012 13 RAP data and final measures from the 2012 13 via our feedback form Adult Social Care Outcomes Framework ASCOF This data is available to all users and supports the 2012 13 Final Activity ASCOF and ASCS nuhliaatinne which haun alan haan ralaaend tadas conditio ibility Equality Freedom ofinformation Re use of data Copyright 2014 the Health and Social Care Information Centre All rights reserved 6 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 2 2 The NASCIS Data Resources NASCIS National Adult Social Care Intelligence Service 4 Health amp Social Care hscic piran Home AboutNASCIS Data Resources NASCIS Library FAQs ContactUs Strategy NASCIS Data Resources NASCIS Data Resources Additional Tools D gt NASCIS Online Analytical Processor 4a The NASCIS interactive Online Analytic Processor OLAP is an online service that provides quick easy and flexible acce
17. Other Own All Total Total Other Own All Total All Total Other Own All Total All Total Other Own All Total All Total All Total All Total All Total All Total Own All Total All Total All Total NASCIS Online Analytical Processor OLAP User Guide The Activity data from the PSS EX1 expenditure return is available as a downloaded Excel file on the PSS EX1 OLAP page 46 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 10 Data releases 10 1 Release summary 2008 09 The first phase of NASCIS was released on 17th July 2009 providing more timely and consistent management information together with access to the NASCIS library and range of analytical data resources The data resources include 2008 09 raw activity data for adult social care initially on a restricted basis alongside the historical data for 2005 06 to 2007 08 The second phase on the 28 August 2009 contained 2008 09 social care raw expenditure data within the analytical data resources initially on a restricted basis The data released on 30 September 2009 contained formally published provisional adult social care activity and expenditure data for 2008 09 The data released on 30 November 2009 contained a range of data and indicators from the Joint Strategic Needs Assessment JSNA core data set The data released on 28 April 2010 contained th
18. Referrals Assessments and Packages of Care RAP 2009 10 data was made available on a restricted basis to local authorities for management information purposes The data released on 15 February 2011 contained the formally published final adult social care expenditure data for 2009 10 This data includes the estimations and shows the final England figures for 2009 10 47 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide The data released on 8 March 2011 contained the final Abuse of Vulnerable Adults AVA data for 2009 10 available to local authorities only as management information only due to data quality issues A national summary was made available as a standard report The data released on 20 April 2011 contained the formally published final RAP 2009 10 data for 2009 10 and final NIS data for 2009 10 This data includes the estimations and shows the final England figures for 2009 10 2010 11 The data released on 17 June 2011 contained the raw data for ASC CAR data for 2010 11 and was released on a restricted basis to local authorities only for management information purposes only The data released on 15 July 2011 contained the raw data for RAP data for 2010 11 and was released on a restricted basis to local authorities only for management information purposes only The data released on 29 July 2011 contained the raw data for PSS EX1 data for 2010 11 and init
19. Strategic Needs Assessment JSNA 6 1 6 2 Background Some differences to other data in OLAP 7 User Experience Survey UES 7 1 7 2 7 3 7 4 7 5 Background How to create UES data views using NASCIS How to use NASCIS to check response rates Non responses to survey options on NASCIS Important information and limitations 8 Adult Social Care Outcomes Framework ASCOF 8 1 8 2 8 3 8 4 Background OLAP components Regional and England measures Unavailable measures 9 Miscellaneous 9 1 9 2 9 3 9 4 9 5 9 6 9 7 9 8 9 9 Default year Percentage measures Rounding and suppression Estimates Comparators Totals Population estimates Guidance updates Additional table notes 10 Data releases 10 1 10 2 11 Release summary Data currently available to view Functionality changes 26 26 26 28 28 30 35 36 36 37 37 37 38 38 39 39 39 39 39 40 41 42 43 43 43 47 47 52 58 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 1 Introduction 1 1 Purpose This document provides guidance on using the NASCIS interactive online analytical processor or OLAP It provides information to get a new user started rather than attempting to explain every possible report combination 1 2 Background The NASCIS OLAP is an online service that provides quick easy and flexible access to a wide range of soci
20. West Yorkshire 4 b Grid Chat 1750 Yorkshire amp Humber 2825 Wakefield 213 1205 View Name Mental heslth clients West Yorkshire Date 19 05 2014 11 11 Filter Criteria Client Type Mental Health Saved queries can then be accessed in the Views part of the OLAP Work Area These are area specific so any views saved for RAP P1 will only show when you are viewing the RAP P1 data The view name is also shown in the metadata underneath the grid table If you have access to the pre release data any views you have saved in Published will need to be recreated in Restricted as they will not transfer over between views 25 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 6 Joint Strategic Needs Assessment JSNA 6 1 Background Joint Strategic Needs Assessment JSNA is a process that helps identify current and future health and wellbeing needs of a local population informing the priorities and targets set by Local Area Agreements leading to agreed commissioning priorities that will improve outcomes and reduce health inequalities key JSNA indicators from the current dataset are provided through NASCIS covering domains including demography social and environmental context lifestyle and risk factors burden of ill health and services 6 2 Some differences to other data in OLAP e The Areas for which to view the JSNA data are split into Health a
21. and Standard Reports The user ID authentication will be administered by our Contact Centre Users can register for an account by completing the self registration form in which they will have to specify a username and password amongst other details such as name and email address Once registered and the account has been activated the user will then have secure access to the NASCIS Data Resources 4 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide Throughout the release cycle of data within NASCIS there are times where local authority users have pre release access to the data for management information purposes This is done to provide councils with up to date information however this data will either be part of the full set of data or still be going through formal validation checks Access to this data is strictly managed and must be applied for each year via an authentication process If you have any queries regarding the user registration process please use the HSCIC s Contact Centre on 0300 303 5678 or via email at enquiries hscic gov uk 1 4 Browser performance The latest version of Microsoft Internet Explorer 10 is not currently compatible with the current OLAP resulting in an inability to drag dimensions and measures as well as altering the layout of the page resulting in the tabs of the NASCIS site being pushed on to two rows This is something we will be a
22. m v Cl Comparator Groups B hi Measures Filters wi ili Per 10 000 Population Client Type Mental Health X lt ih Per 100 000 Population Rows i Distribution ii Year on Year Aroi Maloe k Year Columns l Area TE Ageband Measures X L Client Type Views l Service Type 4 Grid Chart OYorkshire amp Humber Published v ab O E Bar Chat m Cl Comparator Groups E b Measures a Fitters ili ili Per 10 000 Population Client Type Mental Health X lt ili Per 100 000 Population Rows ihi Distribution SES ih Year on Year silt k Year Columns lL Area Le Ageband Measures X Le Client Type Views Le Service Type 4 ir E gt ra Grid Chart Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 5 5 Saving your query This is a feature which has been added following the feedback from recent NASCIS User Workshops The Save View icon allows you to save the query you have built for future use 4 Published v W 8 BOS Bar Chat P v Cl Comparator Groups Elfeh Measures Fitters ili iii Per 10 000 Population Client Type Mental Health X ili Per 100 000 Population Rows ihi Distribution mea Mutiple X ili Year on Year 5 Year Columns z Area t Ageband Measures X W Client Type Views lz Service Type Mental health clients
23. password to login HSCIC staff are reminded that we are currently in the process of migrating to new hscic gov uk email addresses For now HSCIC staff will need to authenticate using their ic nhs uk email addresses if their email address is their username From your Health amp Social Care Information Centre account you can manage your details and preferences from one secure place by using the My Account feature Some tools contain data that will require authorisation before you can use them To find out more about us and our services access our website Terms and conditions Privacy and cookies Internet disclaimer Copyright 2014 the Health and Social Care Information Centre All rights reserved Username Password Sign in We use cookies to improve our website and your experience using it Without them parts of this site will not work If you need more information or want to change your cookie preferences please see our privacy policy Forgotten details Don t have an account Having trouble Contact us on 0845 300 6016 or enquiries hscic gov uk If you have forgotten your details you do not have to register again instead click the Forgotten details link 8 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide This will take you to a screen where you can request either your username password or both Health am
24. used for Social Care activity data such as RAP Referrals Assessments and Packages of care and ASC CAR Adult Social Care Combined Activity Return Each council has 15 CIPFA comparator councils which have been determined using nearest neighbours methodology This means for each council the 15 councils which are most similar based on a number of characteristics are included in its comparator group This results in each council having a unique comparator group Please note we have the comparator groups at 2009 and 2010 which reflects changes in the councils LA Council Type 1 Metropolitan Districts Principle Metropolitan Cities Shire Counties London Boroughs Inner and Outer and Unitary Authorities LA Council Type 2 Metropolitan Districts Shire Counties London Boroughs and Unitary Authorities Primary Care Trust PCT Office of National Statistics ONS Cluster Primary Care Trust PCT groupings are available to compare JSNA Indicator data Area Cost Adjustment ACA comparator groups The Area Cost Adjustment ACA comparator groups should be used for Social Care expenditure data from the PSS EX1 return For the ACA comparator groups each council has an ACA factor determined from a number of characteristics such as education police fire highways social care and geographic area Councils are then split into four ACA comparator groups which are shown below 40 Copyright 2014 Health and Social Care Information Centre
25. user satisfaction with the care services they receive The information available on NASICS compliments the published data in the reports as it also allows the user access to information on survey administration and non responses relative to demographic and area information This could be used by survey administrators to compare response rates among certain demographic groups for example The data for separate years are held on NASCIS as individual views 29 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 7 2 How to create UES data views using NASCIS An example view of user satisfaction by age demographic as a of Row Distribution Home AboutNASCIS DataResources NASCISLibrary FAQs ContactUs Strategy Social care data ASCS Beta 2010 11 Published a e OS stacked Bar Chat 2 2010 1 M E ii Measures Filters Drop attributes here to filter the data ihi Distribution ili Distribution Unrounde ili Rows ih Row Distribution Unror ii Column Distribution ili Column Distribution U Columns lz Year t Area lL Questions Views L Survey Administration E t Demographics T Gender ci ae Grid Chart Q1 All X Measures X Age Group All X v a1 Overall how satisfied are you with the care and support services you receive 1 18 4
26. 2 R1 R2 R3 R3 R3 R3 R3 R3 R3 R3 R3 A1 A1 A1 A1 A1 A1 A1 A1 A1 A5 A5 A5 A6 A6 A6 A6 A6 A6 A6 A6 A6 A7 A7 A7 A7 A7 A7 A7 A8 A8 A8 A8 A8 A8 A9 A9 A9 A10 A10 A10 A11 A11 A11 A11 A amp B A amp B A amp B A amp B P1 P1 P1 P1 P1 P1 P1 P1 P1 P2F P2F P2F P2F P2F P2F P2F P2F P2F P2S P2S P2S P2S P2S P2S P2S P2S P2S P4 P4 P4 P4 P4 P4 P4 P4 P7 P7 P7 P7 A amp B A amp B A amp B A amp B C1 C1 C1 C1 C1 C1 C1 C1 C1 C2 C2 C2 C2 C2 C2 C2 C2 C2 H H1 H H H1 H SD1 SD1 SD1 SD1 SD1 SD2 SD2 SD2 SD2 SD2 SD3 SD3 SD3 SD3 SD3 52 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide ASC CAR formerly SR1 2005 06 2006 07 2007 08 FINAL FINAL FINAL S1 SR1 Table 1 S1 SR1 Table 1 S1 SR1 Table 1 S2 SR1 Table 2 S2 SR1Table2 S2 SR1 Table 2 S3 SR1 Table 5a S3 SR1 Table 5a S3 SR1 Table 5a S4 SR1 Table 5b S4 SR1 Table 5b S4 SR1 Table 5b S5 SR1 Table 5c S5 SR1 Table 5c S5 SR1 Table 5c 2008 09 2009 10 2010 11 2011 12 2012 13 2013 14 FINAL FINAL FINAL FINAL FINAL S1 S1 S1 S1 S1 S1 S2 S2 S2 S2 S2 S2 S3 S3 S3 S3 S3 S3 S4 S4 S4 S5 S5 S5 S5 L1 L1 L1 L1 L1 L1 L2 L2 L2 L2 L2 L2 l1 l1 l1 l1 l1 l1 1iN 1iN 11N 1iN National Indicator Set NIS 2008 FINAL 2009 FINAL 2010 FINAL NI125 VSC04 NI125 VSC04 NI125 VSC0
27. 2 13 X Rows Area Multiple Y Columns Client Type Total X Measures X Views Physical Disability Mental Health Learning Disability Substance Misuse Other Vulnerable People Doncaster 205 East Riding 214 ci A 215 Kingston upon Hull 215 Kirklees 211 Leeds 212 GYorkshire amp Humber N E Lincolnshire 216 The list of Dimensions and Measures for selection as Filters Rows and Columns will be different for each social care data set that you are analysing The example above shows those used for the RAP data and shows a grid of the Total Number of Service Users broken down by Primary Client Type Aged 65 in Yorkshire amp Humber in 2012 13 The symbol against items shows that you can drill down to lower levels of detail for selection These are shown against measures and dimensions in the Work Area and also against certain items on the grids and charts If you click on the expand next level button all drill downs will be expanded to show the lower level The buttons here will select or deselect all the items within the selection window The left hand button will select them all the second button will deselect them You can also select or deselect Edit row axis items mmo 6 manually East Midlands Eastern London
28. 4 NI130 VSC17 08 09 NI 127 NI 127 NI130 VSC17 09 10 N1 128 VSC32 NI130 VSC17 09 10 NI132 VSC12 NI130 VSC17 09 10 NI135 VSC18 NI133 VSC13 NI132 VSC12 NI145 VSC05 NI135 VSC18 NI133 VSC13 NI146 VSCO07 NI136 VSC03 NI135 VSC18 NI149 NI145 VSC05 NI136 VSC03 NI150 NI146 VSCO07 NI145 VSC05 NI149 NI146 VSCO07 NI150 NI149 NI150 NI127 in 2010 has been calculated using a different definition and is therefore not comparable with previous years Please note that the 2010 data is the final publication of NIS as this has now been discontinued following the Coalition Government s announcement in October 2010 concerning the abolition of the National Indicator Set 53 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide Personal Social Services Expenditure PSS EX1 2005 06 2006 07 2007 08 2008 09 2009 10 2010 11 FINAL FINAL FINAL FINAL FINAL FINAL SSMSS SSMSS SSMSS SSMSS SSMSS SSMSS Unit Costs Unit Costs Unit Costs Unit Costs Unit Costs Unit Costs 2011 12 2012 13 2013 14 FINAL FINAL SSMSS SSMSS SSMSS Unit Costs Unit Costs Unit Costs Abuse of Vulnerable Adults AVA 2010 11 2011 12 2012 13 FINAL FINAL FINAL AVA Table 1 Alerts AVA Table 1 Alerts AVA Table 1 Alerts AVA Table 1 Referrals AVA Table 1 Referrals AVA T
29. 535 35380 13365 12310 47670 17185 30760 19235 14460 15130 31520 10515 15200 22340 17660 32850 25345 13735 12340 43135 16500 27470 18480 14350 13325 24045 9850 14950 21060 18215 29480 25010 81 10 8570 39565 15015 27570 17745 14720 Grid Chart Number of Service Users Number of Service Users 21470 13640 12800 15130 13325 31090 31435 30240 31520 24045 15270 14690 11315 10515 9850 18410 19530 17215 15200 14950 31935 20755 23740 22340 21060 22025 20705 19455 17660 18215 33805 33395 35535 32850 29480 SyYorkshire amp Humber mee a aian ie 14805 15160 13355 13735 8110 12375 12030 12310 12340 8570 52895 52865 47670 43135 39565 16505 16455 17185 16500 15015 36845 33815 30760 27470 27570 18720 19205 19235 18480 17745 14150 14020 14460 14350 14730 The above example shows the results of the use of the Pivot function on a grid 23 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 5 3 Clear the data The fourth icon along simply clears the current view creating a blank template to create a new query 5 4 Toggle the view total The icon fifth from the left of the Customising Bar allows you to switch or toggle the totals at the foot of the grid on or off with on highlighting the in orange Please see example below the first diagram shows totals on the second has totals turned off 7 Published v ae O ba Chat
30. 75 35495 anel 150860 Group or Services Received into the column box You can left click the attribute once it is in the row box and un tick the box for missing Drag and drop the Column Distribution measure into the row section It will be displayed as Measures once placed This will then distribute the figures as a of the total for the responses for the question For example the percentage of respondents who answered they were very satisfied for question 1 bracket is 13 1 of the total number of people aged 65 74 The above figure shows a completed view following the above method and the grid produced 31 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide An example view of user satisfaction by primary client type demographic as a Distribution Home AboutNASCIS DataResources NASCISLibrary FAQs ContactUs Strategy Social care data ASCS Beta 2010 11 u a amp O stacked BarChat GS 2010 11 k amp uiJMeasures A Filters Drop attributes here to filter the data ili ili Distribution Unrounde 1 Row Distribution Rows 1 Row Distribution Unrot x 1 Column Distribution AANA MEESE ihi Column Distribution U Columns t Year ma t Aren Age Group All X L Questions Views lL Survey Administration E t Demographics T Gender lad Ki a r
31. 85 30785 10555 10555 17950 17950 The column headers are grouped in boxes that show the subtotals of the relevant sections as well as the total of all the component parts If some of the components are removed such as More than 2 weeks and less than or equal to 4 weeks and More than 4 weeks and less than or equal to 6 weeks the final totals remain constant Grid Chart More than 6 weeks 7 Number of Service ice Number of Service Users 255500 255500 This works however your query is structured and provides a useful option for area comparisons Grid Chart More than 4 weeks and less than or equal to 6 weeks 640 435 159 159 75 75 1205 l 1935 28465 3190 3190 1145 1145 1935 30785 30785 17950 17950 314790 640 255500 255500 Council Region England e Council figure s above e Regional figure second from bottom row e National England figure last row This will enable you to do comparison work without returning all the figures It does not return a sub total for the selected areas 42 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 9 7 Population estimates The per 100 000 population and per 10 000 population measures in the NASCIS Online Analytical Processor are calculated using the relevant mid year population estimates from ONS Final social care data for 2013 14 uses 2013 mid
32. Client types have been relabelled People with Physical Disabilities is now Physical disability People with Mental Health problems is now Mental health People with Learning Disabilities is now Learning disability Alcohol Drug misusers is now Substance misuse Others is now Other vulnerable people Direct payments within Service Type has been renamed to Existing new Direct payments and Personal Budgets Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide P2S P4 P7 H1 C1 C2 60 Client types have been relabelled People with Physical Disabilities is now Physical disability People with Mental Health problems is now Mental health People with Learning Disabilities is now Learning disability Alcohol Drug misusers is now Substance misuse Others is now Other vulnerable people Direct payments within Service Type has been renamed to Existing new Direct payments and Personal Budgets Personal Budgets information is no longer collected as part of the P2S return Client types have been relabelled People with Physical Disabilities is now Physical disability People with Mental Health problems is now Mental health People with Learning Disabilities is now Learning disability Alcohol Drug misusers is now Substance misuse Others is now Other vulnerable people There have been some changes to the ethnicity subtypes White now includes Traveller of Irish heritage a
33. Grid Chart issi 5 75 850r Age Group a ver Total 26 8 5 42 11 6 i 3 6 95 07 22 0 2 0 6 51 Overall how satisfied are you with the care and foun vey denisa 0 0 02 support services you receive M n am extremely dissatisfied is 0 0 E 0 0 i T 0 1 03 Distribution Did not receive a model questionnaire i 4 7 1 p x 0 1 12 6 Distribution N to th hol ol Spons o e ole survey Bul r ja n a A 7 be Non response to the whole survey Rares Non response to this question s 05 18 Neblett J terns Distribution s i z m x 4 i it Qi Overall how satisfied are you with the care and support 43 j 8 12 7 28 9 450860 services you receive Total Distribution 16 9 52 6 Drag and drop the Question you require into the rows Left click the question once it is in the column box and it will bring up a pop up menu Drag and drop the attribute to compare against for example Demographic Primary Client Group or Services Received into the column box You can left click the attribute once it is in the row box and un tick the box for missing Drag and drop the Distribution measure into the row section It will be displayed as Measures once placed This will then distribute the figures as a of the grand total for the each component of the responses for the question For example the percentage of respondents who
34. Hampshire Portsmouth Southampton East Sussex Brighton amp Hove Wiltshire Swindon Kent Medway Towns Gloucestershire Bath amp NE Somerset Bristol North Somerset South Gloucestershire 3rd ACA Grouping Hertfordshire Oxfordshire Buckinghamshire Milton Keynes Bracknell Forest West Berkshire Reading Slough Windsor amp Maidenhead Wokingham Thurrock Barking amp Dagenham Barnet Bexley Brent Bromley Croydon Ealing Enfield Haringey Harrow Havering Hillingdon Hounslow Kingston upon Thames Merton Newham Redbridge Richmond upon Thames Sutton Waltham Forest Surrey 4th ACA Grouping Camden Greenwich Hackney Hammersmith amp Fulham Islington Kensington amp Chelsea Lambeth Lewisham Southwark Tower Hamlets Wandsworth Westminster City of London Isles of Scill Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 9 6 Totals There are some interesting features with the totals and what is displayed following the header box structure for example Grid Chart Number of Service 255 255 435 3380 3380 mekana 310 310 150 150 70 70 75 79 amp Humber 22195 22195 3190 3190 ns na 1935 1935 255500 255500 307
35. IS DataResources NASCISLibrary FAQs ContactUs Strategy Welcome to the NASCIS NASCIS Library NASCIS Data Resources Key Documents The National Adult Social Care Intelligence Service NASCIS provides an array of analytical and x a information resources allowing effective and timely analysis of Social Care data to aid activities such as The NASCIS Library contains links to the latest key planning performance management and service improvement to name a few documents to emerge in the Social Care field categorised under Statistics and Data Collections Policy Analytical resources include NASCIS interactive Online Analytical Processor JSNA data resources and Strategy and Performance Standard Reports Also included are links to POPPI PANSI and FLoSC tools developed by the Care Services Efficiency Delivery Programme Latest NASCIS News New data available Final 2012 13 Abuse of Vulnerable Adults AVA data available to all users Included are updates to the AVA Comparator standard reports 6 2 14 Useful Links The NASCIS Library contains a list of useful links to other agencies and organisations involved in Social Care i gt NASCIS has been updated to include the 2012 13 Final Abuse of Vulnerable Adults AVA data This data is available to all users and supports the 2012 13 Final AVA publication which has also been released today The AVA Comparator standard reports have also been updated with the 2012 13 Final AVA data
36. able 1 Referrals AVA Table 1 Completed Referrals AVA Table 1 Completed Referrals AVA Table 1 Completed Referrals AVA Table 2 Alerts AVA Table 2 Alerts AVA Table 2 Alerts AVA Table 2 Referrals AVA Table 2 Referrals AVA Table 2 Referrals AVA Table 2 Completed AVA Table 2 Completed AVA Table 2 Completed Referrals Referrals Referrals AVA Table 3 AVA Table 3 AVA Table 3 AVA Table 4a AVA Table 4a AVA Table 4a AVA Table 4b AVA Table 4b AVA Table 4b AVA Table 5a AVA Table 5a AVA Table 5a AVA Table 5b AVA Table 5b AVA Table 5b AVA Table 6a AVA Table 6a AVA Table 6a AVA Table 6b AVA Table 6b AVA Table 6b AVA Table 7 AVA Table 7a 7b AVA Table 7a 7b AVA Table 8 AVA Table 8a 8b 8c AVA Table 8a 8b 8c AVA Table 9 AVA Table 9 AVA Table 9 The 2009 10 data previously presented as restricted data in NASCIS has been removed and is now available as a formatted spreadsheet for all users to download 54 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide Adult Social Care Outcomes Framework ASCOF 2011 12 2012 13 2013 14 FINAL FINAL 1A 1A 1A 1B 1B 1B 1C 1C 1C 1E 1E 1E 1D 1F 1F 1F 1G 1G 1G 1H 1H 1H 11 2A 2A 2A 2B 2B 2B 2C 2C 2C 3A 3A 3A 3B 3C 3D 4A 4A 4A 4B 4B 4B 1D 3B 3C 3D 1D 3B 3C 3D next release see 2012
37. above displaying the currently available Social Care datasets For this example click on RAP from either the side menu or collections list 10 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 2 5 Selecting the required table from the data Home AboutNASCIS DataResources NASCISLibrary FAQs ContactUs Strategy a Social care data Social care data RAP asi RAP R A1 Referrals Assessments and Packages of Care data Final cut 2012 13 Data for earlier years is final AS R A6 Referrals data comprising Tables R1 number of people that go on to receive an assessment discontinued from 2008 09 R2 number of people AT dealt with at point of contact and R3 the number of contacts for new clients and the source of referral ic A1 A9 Number of existing clients that had a review completed by primary client type and age group Prior to 08 09 this table included new clients receiving A10 an assessment and the number of assessments terminated during the period From 2008 09 the number of new clients receiving assessments A11A should be taken from A6 A11B A5 P1 Number of new clients for whom assessments were completed in the period by primary client type cross tabulated with known or anticipated P2F sequel to assessment and age group A5 has been discontinued from 2008 2009 P2s H1 A6 P4 Number of new clients for whom assessments w
38. al care information It was developed by the Health and Social Care Information Centre HSCIC in conjunction with key partners The OLAP will enable users to undertake a wide range of analyses based on an authoritative common set of data for performance management and benchmarking purposes Users will be able to make selections view comparisons create tables and generate graphs in a flexible way It is an important means by which the HSCIC makes aggregated data available to the health and social care community It has a flexible graphical interface and is accessible via an internet browser It encompasses Fast navigation around screens and sub screens for experienced users Intuitive or explanatory navigation for inexperienced users Help facilities within the resource Granular security to ensure that users who are authorised to access Social Care data will not be able to access the other data domains All client PCs running Internet Explorer 6 and above over a broadband or better link will be able to access the reporting tool Other browsers may be used though minor visual defaults may result 1 3 Access and authentication Access to the NASCIS Data Resources will be made available to all users in the public domain by a self registration process on the Data Resources page Users accessing the NASCIS Data Resources require a Single Sign on username and password to login to the system This will give access to both the OLAP
39. answered they were very satisfied for question 1 in the 65 74 age bracket is 1 7 The above figure shows a completed view following the above method and the grid produced 32 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide The pop up menu displayed when clicking on an attribute Edit row axis items Q1 Overall how satisfied are you with the care and support services you receive v am extremely satisfied am very satisfied I am quite satisfied I am neither satisfied nor dissatisfied I am quite dissatisfied lam very dissatisfied v am extremely dissatisfied Did not receive a model questionnaire Non response to the whole survey Non response to this question Un tick the Did not receive a model questionnaire Non response to the whole survey and Non response to this question boxes as shown in figure 4 Omitting non respondents is the standard way to view survey data unless you want to check how many people failed to respond The table should automatically generate Any question or attribute can be substituted for the ones used Examples of use include checking to see levels of satisfaction among different ethnic groups client types or service users 33 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor
40. are Combined Activity Return ASC CAR data Initial 1 cut measures from the 2011 12 Adult Social Care Outcomes Framework July 2012 Initial 1 cut 2011 12 Abuse of Vulnerable Adults AVA data Initial 1 cut 2011 12 Personal Social Services Expenditure PSS EX1 data August 2012 Initial 2 cut 2011 12 Referrals Assessments and Packages of Care RAP data Initial 2 cut 2011 12 Adult Social Care Combined Activity Return ASC CAR data September 2012 Provisional 2011 12 Referrals Assessments and Packages of Care RAP data Provisional 2011 12 Adult Social Care Combined Activity Return ASC CAR data Provisional measures from the 2011 12 Adult Social Care Outcomes Framework ASCOF October 2012 Initial 2 cut 2011 12 Abuse of Vulnerable Adults AVA data Initial 2 cut 2011 12 Personal Social Services Expenditure PSS EX1 data November 2012 Provisional 2011 12 Abuse of Vulnerable Adults AVA data Provisional 2011 12 Personal Social Services Expenditure PSS EX1 data January 2013 Initial 3 cut 2011 12 Abuse of Vulnerable Adults AVA data Final 2011 12 Personal Social Services Expenditure PSS EX1 data February 2013 Final 2011 12 Referrals Assessments and Packages of Care RAP data Final 2011 12 Adult Social Care Combined Activity Return ASC CAR data Final measures from the 2011 12 Adult Social Care Outcomes Framework ASCOF March 2013 Final 2011 12 Abuse of Vulnerable Adults AVA data
41. by age band gender ethnic group and by disability living allowance incapacity benefits and guardianship for English local authorities Please note that both the POPPI and PANSI view only systems are now developed and maintained by the Institute of Public Care IPC POPPI and PANSI are primarily for use by local authority planners and commissioners of social care provision in England together with providers They are designed to help explore the possible impact that demography and certain conditions may have on populations aged 18 to 64 and 65 and over The NASCIS OLAP is one of a number of applications which can be accessed from this page Click on the NASCIS Online Analytical Processor link indicated by the red arrow 7 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 2 3 Login screen If you do not have an account you can register for one by clicking the Register button and following the on screen instructions Enter your username and password 4 Health amp Social Care hscic Information Centre Health amp Social Care Information Centre You have arrived at the Health amp Social Care Information Centre account sign in page Our accounts use a single sign on system This means you log in once to gain access to the Health amp Social Care Information Centre tools and web applications such as My HSCIC and iView Use your existing username and
42. c However it should be noted that the answer percentages within this table are not consistent with the published percentages as it takes into the account the total number of people who answered and did not answer the survey and so this will lower the percentage for people who answered the question despite the actual total number of answers for each being the same This data could be used to asses if certain areas ethnic groups or client types are more disinclined to answer the questionnaire 7 5 Important information and limitations NASCIS displays information relating to the primary and secondary client type demographic groups This is slightly different to the client type demographic group displayed in the published results which is composed of the combined primary and secondary client type data Due to this any grids made using primary or secondary client will not exactly match the client type data in the annex tables as these are a combination of the two groups The other known limitations not previously mentioned are that not all questions are able to be cross compared in a meaningful way and caution is needed to compare data between 2010 11 and 2011 12 due to different questions between years 36 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 8 Adult Social Care Outcomes Framework ASCOF 8 1 Background Adult Social Care Outcomes Framework ASCOF is a set o
43. d Chart Yorkshire amp Humber Yorkshire amp Humber Total Date 16 05 2014 15 32 Filter Criteria Ageband Age 65 and over Year 2012 13 The screenshot above is a working example of the main OLAP query screen using RAP P1 data The drop down menu allows user to navigate between tables within the same screen There are two sections to the screen e The top section marked by the red box is the Work Area It enables the user to build reports by selecting Measures and Dimensions from the left and dragging and dropping them onto the Filter Rows and Columns areas on the right e The bottom section marked by the purple box is where the resulting grids i e tables of data and charts i e graphical representations are displayed Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide Measures for selection selected items are greyed out Dimensions for selection a Biko Bar Chart e Measures 4 ili ili Per 10 000 Population ili Per 100 000 Population ih Distribution ihi Year on Year Le Year lL Area lL Ageband lL Client Type lz Service Type Grid Chart Bradford 209 Calderdale 210 a P Filters Users can select a council s comparator Gi Comparator Groups Ageband Age 65 and over x group Year 201
44. d to the HSCIC on an annual basis Each year of data will be made available in Excel spreadsheets Users will be able to access these spreadsheets using links which will appear below when the data become available SAR data is not currently available in the OLAP Available Data 2013 14 Final SAR data Deprivation of Liberty Safeguards MCA DoLS Data from the Mental Capacity Act Deprivation of Liberty Safeguards MCA DoLS returns The Mental Capacity Act Deprivation of Liberty Safeguards MCA DoLS provide a legal framework to ensure that people are deprived of their liberty only when there is no other way care or treatment can be provided safely The safeguards are intended to protect people from overly restrictive care whilst in a hospital or care home Where a DoL is believed to be occurring it must be assessed and authorised by a Council with Adult Social Services Responsibilities CASSR Records are kept of all applications and this information is submitted to the HSCIC on an annual basis Each year of submitted data will be made available in Excel spreadsheets DoLS data is not available in the OLAP Available Data 2013 14 Final DoLS data aggregated to CASSR level 57 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 11 Functionality changes The following has been added or changed within the OLAP since April 2010 to improve functionality and resolve any outstandin
45. ddressing in a future release however if you are using IE10 there is a solution that will enable the OLAP to work correctly On the IE10 address bar you will see a small icon for compatibility mode Clicking on this will enable compatibility mode and allow you to use the OLAP in IE10 without any further problems 1 5 User support The first point for user support on queries regarding the OLAP will be provided by the HSCIC s Contact Centre who should be able to answer most queries They can be contacted by phoning 0300 303 5678 or by emailing enquiries hscic gov uk You can also contact the HSCIC for support and information by clicking on Contact us which is shown at the top of each screen In some cases enquiries will then be passed to the Social Care team if they relate to the system or need input from the relevant expert on the Social Care data if the enquiry is data related Guidance notes and updated information will be made available on the NASCIS web site 5 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 2 Accessing the System 2 1 The NASCIS Website https nascis hscic gov uk The NASCIS OLAP is available on the NASCIS website simply click on the NASCIS Data Resources tab or section header to access data en En Health amp Social Care NASCIS Information Centre National Adult Social Care Intelligence Service Home AboutNASC
46. e 210 29 60 13 26 289 0 00 52 01 2 24 100 00 Doncaster 205 41 28 15 32 257 0 00 39 04 1 79 400 00 East Riding 214 21 96 11 81 3 19 0 12 62 46 0 47 100 00 pega 26 48 11 23 3 43 0 25 57 45 1 08 100 00 24 48 21 30 8 04 0 22 25 00 0 98 100 00 22 28 11 59 2 20 0 48 61 50 0 84 100 00 EYorkshire amp N E Lincolnshire 39 38 12 94 3 62 0 56 35 44 8 16 100 00 Humber 216 ssa 28 08 s21 oso 2232 216 100 00 Baas eet 24 48 12 14 3 70 0 28 57 02 2 37 100 00 22 52 14 92 3 03 0 22 47 73 1 58 100 00 25 74 15 95 6 55 0 47 48 24 2 94 100 00 Wakefield 213 31 74 13 92 3 83 0 08 49 65 0 78 100 00 37 08 19 20 5 72 0 41 24 53 3 06 100 00 Yorkshire amp ears 30 21 14 86 4 12 028 48 57 1 95 100 00 30 24 14 86 4 12 0 28 48 57 1 95 100 00 28 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide The OLAP will allow you to filter the dimensions for example to omit non respondents when looking at percentage distributions for a particular question Using the previous example simply click on the Q4 Total dimension in the Columns area and deselect those data items you do not wish to view e g non respondents to the survey or any number of the responses to the question itself Omitting non respondents from the percentage calculation is the standard way to look at survey data unless you are of course interested in how many people failed to respond Cross analysis often
47. e formally published final adult social care activity and expenditure data for 2008 09 This data includes the estimations and shows the final England figures for 2008 09 2009 10 The data released on 30th June 2010 contained the raw data for social care activity 2009 10 and was released on a restricted basis to local authorities only for management information purposes only The data released on 12 August 2010 contained raw expenditure data for 2009 10 and the 2 cut of activity data released on a restricted basis to local authorities only for management information purposes only as well as the formal publication of the provisional NIS indicators The data released on 30 September 2010 contained the provisional activity data which comprises of the 2 cut data and select estimations as well as an update of NIS Indicators NI149 and NI150 The data released on 30 November 2010 contained the provisional adult social care expenditure data with estimations of missing Including SSMSS data and a range of updated and new data and indicators from the Joint Strategic Needs Assessment JSNA core data set The data released on 28 January 2011 contained the formally published final Adult Social Care Combined Activity Return ASC CAR data for 2009 10 and indicators from the Joint Strategic Needs Assessment JSNA core data set as a public release The ASC CAR data includes the estimations and shows the final England figures for 2009 10 3 cut
48. efinition for these The gender split collected in previous years has been removed from the 2010 11 tables The gender information is now available in table A11 but is not split by ethnicity Ethnicity categories re organised for 2013 14 Client types have been relabelled People with Physical Disabilities is now Physical disability People with Mental Health problems is now Mental health People with Learning Disabilities is now Learning disability Alcohol Drug misusers is now Substance misuse Others is now Other vulnerable people Discontinued from 2012 13 Client types have been relabelled People with Physical Disabilities is now Physical disability People with Mental Health problems is now Mental health People with Learning Disabilities is now Learning disability Alcohol Drug misusers is now Substance misuse Others is now Other vulnerable people Discontinued from 2011 12 Discontinued from 2008 09 This is a new table for the 2009 10 RAP return Discontinued from 2012 13 This is a new table for 2010 11 RAP Return This table has been split in to 2 sections A and B in the OLAP A11 holds data previously collected in A6 Client types have been relabelled People with Physical Disabilities is now Physical disability People with Mental Health problems is now Mental health People with Learning Disabilities is now Learning disability Alcohol Drug misusers is now Substance misuse Others is now Other vulnerable people
49. ere completed in the period by ethnicity cross tabulated with known or anticipated sequel to assessment gender and age group P7A P7B AT SD1 Length of time from first contact to completed assessment for new clients whose assessments were completed during the period in time bands SD2 by referral category age group and primary client type SD3 A8 C1 Length of time from completed assessment to receipt of all services for new clients aged 65 and over for whom all services were put in place C2 during the period in time bands by primary client type A8 has been discontinued from 2011 12 A9 Length of time from first contact to first contact with client following referral This is for new clients who were contacted following referral during the period in time bands by age group and primary client type A9 has been discontinued from 2008 2009 A10 Number of Section 256 and self funded clients with completed assessments or reviews provided atthe expense of the CASSR during the period by age group and primary client type New for 2009 2010 This table was introduced in 2009 10 For 2011 12 this table will only collect data for self funded clients A11A Number of new clients for whom an assessment was completed during the period by gender and age group cross tabulated with known or anticipated sequel to assessment This table was introduced in 2010 11 A11B Number of new clients for whom an assessment was completed during the per
50. f outcome measures which have been agreed to be of value both nationally and locally for demonstrating the achievements of adult social care Nationally the ASCOF will give an indication of the strengths of social care and success in delivering better outcomes for people who use services Locally one of the key uses of the ASCOF is for benchmarking and comparison between areas The ASCOF is not a national performance management tool The ASCOF definitions handbook was first launched on 31 March 2011 and updated annually for the year of reporting Definitions handbook and supporting material can be found at https www gov uk government publications the adult social care outcomes framework 2013 to 2014 8 2 OLAP components Categories and measures a anog W Measures ii Numerator ii Denominator ii Outcome ii Base Ly Year ly Area lz Outcome ID Bar Chart Measures Numerator Denominator council systems only Outcome percentage is the main outcome measure for benchmarking Base surveys only Year financial years some indicators will not have data for 2011 12 2013 14 Area CASSR administration area 152 in England Outcome ID range of outcome indicators and levels of disaggregation 37 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide Outcome category disaggregation Edit row axis items gyva El 4A
51. feguarding Adults Return SAR Final validated data 2013 14 Deprivation of Liberty Safeguards DoLS return 4s cut measures from the 2013 14 Adult Social Care Outcomes Framework Initial 1 cut 2013 14 Personal Social Services Expenditure and Unit Costs data September 2014 Final validated data 2013 14 Deprivation of Liberty Safeguards DoLS return Final data from the 2013 14 Safeguarding Adults Return SAR Provisional 2013 14 Personal Social Services Expenditure and Unit Costs data Only available to Local Authorities as pre release data for management purposes Future Final release on 4 December 2014 for finance data Final release on 9 December 2014 for activity ASCOF and survey data 2014 15 New collections SALT and ASC FR replacing RAP ASC CAR and PSS EX1 51 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 10 2 Data currently available to view The table below shows the data currently displayed within the NASCIS OLAP tool as at October 2014 Referrals Assessments and Packages of Care RAP tables 2005 06 2006 07 2007 08 2008 09 2009 10 2010 11 2011 12 2012 13 2013 14 FINAL FINAL FINAL FINAL FINAL FINAL FINAL FINAL revised April 2011 R R R R R R R R R R1 R2 R1 R2 R1 R2 R1 R2 R1 R2 R1 R2 R1 R2 R1 R
52. g issues ASC CAR S1 S2 S3 S4 S5 L1 L2 11N RAP Al A5 58 Client types have been relabelled People with Physical Disabilities is now Physical disability People with Mental Health problems is now Mental health People with Learning Disabilities is now Learning disability Alcohol Drug misusers is now Substance misuse Others is now Other vulnerable people Client types have been relabelled People with Physical Disabilities is now Physical disability People with Mental Health problems is now Mental health People with Learning Disabilities is now Learning disability Alcohol Drug misusers is now Substance misuse Others is now Other vulnerable people Discontinued from 2011 12 Discontinued from 2012 13 Client types have been relabelled People with Physical Disabilities is now Physical disability People with Mental Health problems is now Mental health People with Learning Disabilities is now Learning disability Alcohol Drug misusers is now Substance misuse Others is now Other vulnerable people Discontinued from 2008 09 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide A6 A7 A8 AQ A10 A11 P1 P2F 59 There have been some changes to the ethnicity subtypes White now includes Traveller of Irish heritage and Gypsy Roma and this has altered the comparability of Irish and Other background so there is now a 2009 10 d
53. hot below shows a Paste as text option the second shows a Paste option which retains text wrap and merge cell formats I id s SL o File Home Insert Page Layout Formulas Data Review View n Ct Arial 10 As BF Y Ba Copy e EME E N Clipboard a Font a Alignme J26 R A a 9 re o S File Home Insert Page Layout Formulas Data Review View Developer A B C D E A X Cut z E 1 201071 2012 201213 Racos E Je jae BB r 2 Number of Number of Number of Pate ye nat painter B 7 27l Elar As H Merge amp Cen 3 Yorkshire Barnsley 1195 1175 1160 Clipboard ae 3 Annee 4 Bradford 1810 3075 1975 H24 5 Calderdale 880 870 810 7 EastRidm 2745 2705 2620 A b c D E s 1 2010 11 2011 12 2012 13 z ae 2r Number of Number of Number of 10 Leeds 21 2750 2565 2595 eS a 11 NELincol 1015 960 940 2 gso cs 12 N Lincolns 1230 1080 1105 3 See be LL lds 13 North York 2555 2400 2360 4 Bradford 209 1810 3075 1975 14 Rotherhar 1140 1270 1155 5 eee Ew sini 1m Pio 15 Sheffield 1840 1830 4940 6 Doncaster 205 1505 1530 1435 16 Wakefield 1500 1520 1465 7 East Riding 214 2745 2705 2620 17 York 219 745 695 695 8 Kingston upon Hull 215 1995 2010 1980 18 Yorkshire 24395 25475 23685 9 Kirklees 211 1500 1790 1445 19 Total 213235 213105 209170 10 Yorkshire amp Leeds 212 2750 2565 2595 20 Date HHHH 11 Eunnber N E Lincolnshire 216 1015 960 940 21 Filter Crite Service Type Residential Care 12 N L
54. ial NIS 2010 11 figures and was released on a restricted basis to local authorities only for management information purposes only The data released on 12 August 2011 contained the raw data for AVA data for 2010 11 and the second cut of raw data for ASC_CAR data for 2010 11 was released on a restricted basis to local authorities only for management information purposes only The data released on 29 September 2011 contained the 2 cut of raw data for RAP and PSS EX1 data for 2010 11 and third cut of raw data for ASC CAR for 2010 11 and was released on a restricted basis to local authorities only for management information purposes only The data released on 7 October 2011 contained the provisional release of NIS data for 2010 11 The data released on 3 November 2011 contained the provisional release of AVA data for 2010 11 The data released on 30 November 2011 contained the provisional release of RAP ASC CAR and PSS EX1 data for 2010 11 The data released on 3 March 2012 contained the final release of AVA data for 2010 11 The data released on 29 March 2012 contained the final release of RAP ASC CAR NIS and PSS EX1 data for 2010 11 48 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 2011 12 May 2012 Update of JSNA Indicators June 2012 Initial 1 cut 2011 12 Referrals Assessments and Packages of Care RAP data Initial 1 cut 2011 12 Adult Social C
55. ic queries on the system Every possible report combination is not described as it is likely that users will develop their own way of using the OLAP to get the reports they want Experimenting with the drag and drop process is encouraged to arrive at a point where the user can display the information in a way that best suits them 9 1 Default year Please note the default Year for running queries is the latest year currently 2013 14 as at October 2014 If you choose not to drag and filter the Year Dimension from the left hand menu then the grid chart will display the latest available data 9 2 Percentage measures The percentage measures are based on the underlying raw data not the rounded data as shown on the tables and charts 9 3 Rounding and suppression All numerical values presented in the OLAP tables with the exception of ASCOF data are rounded to the nearest five and may not sum to totals because of rounding Rounding of small numbers will mean that 0 may not be a true 0 as it may be a low number that has been rounded down For example 4 is rounded to 5 3 is rounded to 5 2 is rounded to 0 1 is rounded to 0 As of November 2010 values of five or less are no longer suppressed 9 4 Estimates Where councils have not provided complete information estimates have been made by calculating proportions based on data reported by councils who have provided a complete return These estimates have been used to prov
56. ide grossed up national figures for England but are not published at council level The OLAP table will display council estimated data as blank or missing National and Regional totals should be considered as estimates Details of the rounding and suppression rules applied to ASCOF data are shown beneath the OLAP grid on the ASCOF page 39 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 9 5 Comparators One of the key features of the NASCIS OLAP is the ability for the user to compare council data against its comparators There are a number of comparator groupings available as described below To select a comparator group first build your query on the grid by dragging dimensions and measures across selecting one council Then open the comparator drop down list show here B ae OO Ba Chat v ASCOF Data v ai Comparator Groups and select the comparator type you want and then the council of interest This will then display your chosen measures and dimensions for that council and its comparator group based on the comparator group type you have selected Please note comparator groups will not work if you are using the Area dimension as a filter Area must be placed in rows or columns Chartered Institute of Public Finance and Accountancy CIPFA comparator groups The Chartered Institute of Public Finance and Accountancy CIPFA comparators should be
57. incolnshire 216 N Lincolnshire 217 North Yorkshire 218 Rotherham 206 Sheffield 207 Wakefield 213 York 219 4 17 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide Published v u Grok a m v il Comparator Groups Bar Chart i Measures Stacked Bar Chart Dy op attributes here to filter the data ui Line Chart ihi Per 10 000 P peate ili Per 100 000 Population Rows ihi Distribution woa 1 Year on Year Year Multiple gt l Year Columns l Area Ageband Measures X Area Multiple X tz Client Type Views l Service Type 4 gt Grid Chart 20 000 15 000 10 000 LL _ R 5 000 0 2008 09 2009 10 2010 11 2011 12 2012 13 I Bradford 209 Number of Service Users Pii Leeds 212 Number of Service Users J York 219 Number of Service Users Represents data that is incomplete and therefore has been estimated These estimates are included in England and Regional totals Figures may not add up because of rounding 1 Regional and national totals may not be equal to the sum of the council level figures due to the use of estimates when a council did not fully complete the return 2 Values are rounded to the nearest 5 Line Charts and Stacked Bar Charts are also available to choose depending on the data you are viewing The above example shows a line chart displaying the number of service users in receipt of Ho
58. incolnshire 217 1230 1080 1105 13 North Yorkshire 218 2555 2400 2360 14 Rotherham 206 1140 1270 1155 15 Sheffield 207 1840 1830 1940 16 Wakefield 213 1500 1520 1465 17 York 219 745 695 695 22 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide Please note that because the file is saved via the NASCIS website you may get the following notice when opening the file The file you are trying to open Export xls is in a different format than specified by the file extension Verify the file is not corrupted and is from trusted source before opening the file Do you want to open the file now This happens as the file contains web space formatting however it is safe to proceed and click yes Once you have the file open you can save it with a different file name 5 2 Pivot the data The third icon allows the data in the chart or grid to be pivoted On a grid it swaps the dimensions in the Columns with the Rows and swaps the row values with the columns Grid Chart Yorkshire amp Humber Barnsley Bradford Calderdsle Doncaster 21470 15270 18410 31935 22025 33805 38620 14805 12375 52895 16505 36845 18720 14150 13640 31435 14690 19530 30755 20705 33395 36040 15160 12030 52865 16455 33815 19205 14020 13800 30240 11315 17215 23740 19455 35
59. iod by gender and age group cross tabulated with primary client type This table was introduced in 2010 11 This screen lists the various data sets within RAP and gives a brief explanation of the information available A shortcut is also available to each data set from the left hand menu The datasets include the latest provisional or final data plus historical data for 2005 06 onwards where available Each menu of data will show when a table was introduced or ceased within the time period of data available on OLAP Select P1 Number of clients receiving services during the period from the left hand menu this will take you to the main OLAP screen which is where you select the required data to build your report 11 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 3 The OLAP screen Home AboutNASCIS DataResources NASCIS Library FAQs ContactUs Strategy Social care data RAP P1 4 a Gh l Bar Chart v P1 Measures ihi ili Per 10 000 Population Ageband Age 65 and over X Year 2012 13 X ili Per 100 000 Population Rivera Work Area Measures amp i Distribution Dimensions are dropped Area Multiple X lt i ili Year on 7 ne into this area lz Year Columns righ Client Type Total x Measures x lL Client Type Views l Service Type v E Comparator Groups Filters Gri
60. ion Please note that the No of service users per 100 000 population measure is specific to the age band selected i e Age band 18 64 will use the 18 64 mid year population estimate for that year The total population figure used is for ages 18 and over Please note for any query to fetch back data for tables or charts a Measure must be present in your query this in effect tells the OLAP what data to show Measures should only be placed in ROWS or COLUMNS only not Filters Dimensions give meaning to the measures by allowing you to break the counts down For example allowing you to show Number of Service Users broken by Age Group Client Type Service Type etc Again these will vary depending on which data set you are analysing Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 3 3 Viewing pre release access data Local authority users who have pre release access to Restricted data in the OLAP will see an extra drop down box above their OLAP toolbar Published v ae oO Bar Chart v m x C Comparator Groups upisne ih Measures a Filters ili ili Per 10 000 Population ili Per 100 000 Population Rows ii Distribution ihi Year on Year l Year Columns Ageband Age 65 and over X lt Year 2012 13 X Area Multiple XX Area Ageband Client Type Total X Measures XX Le
61. it cost expenditure as only activity relating to the CASSR Councils with Adult Social Services Responsibilities care plan can be recorded and used in the unit cost calculation This change combined with the change to the definition of capital charges which applies to both own provision and provision by others means that the unit costs for 2007 08 can not be compared with previous years Personal Social Services Expenditure Gross Current Expenditure The Gross Current Expenditure calculation used is Total Expenditure excluding capital charges less all income other than client contributions Personal Social Services Expenditure Unit Costs Summary UCS If no service is selected the first displayed figure is from the Residential and Nursing Care for Older People service The Unit Costs Summary in the OLAP has now been revised so that numerator and denominator data for the average costs has been supplied This is available retrospectively for all available years Please note the overall totals for services are the figures for adults and older people in the relevant service and all totals are for per person per week unless otherwise stated The numerator for working out the unit costs is displayed in 000s and is highlighted as such The denominator for working out the unit costs in some cases has been divided by 52 to get the weekly cost These are Copyright 2014 Health and Social Care Information Centre NASCIS O
62. l Care Outcomes Framework ASCOF 3 Personal Social Services Expenditure SSMSS Please note that if no service is selected the default setting for SSMSS data will show Total Adult Services expenditure 43 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 44 4 Personal Social Services Expenditure Capital Charges In 2007 08 a change was made to the definition of capital charges to bring the PSS EX1 data in line with the 2006 Local Authority Accounting SORP Statement of Recommended Practice This means that Total Cost can not be compared historically Capital charges i e depreciation loss on impairment of assets amortisation of deferred charges and credit for amortisation of capital grants Credit for amortisation of capital grants is included for the first time and the previous element of notional interest is no longer being included within capital charges These changes were introduced by CIPFA in the 2006 Local Authority Accounting SORP Statement of Recommended Practice Further information about the effect of this change on the definition of total cost can be found in Section 2 Annex B of the 2006 Best Value Code of Practice BVACOP A new column has been added to record Grants to voluntary organisations against the appropriate service line to allow more meaningful unit costs for provision by others to be calculated Grants are now excluded from the un
63. li Upper 95 0 CI ili Lower 99 8 CI ii Upper 99 8 CI lL Period ly Area Indicator Theme H amp Please note that where the indicator is an actual figure this will show under the Numerator measure For further information please consult the metadata available in the JSNA section of the NASCIS website The most efficient way to view the indicators in the processor is by placing the Indicator theme dimension in Rows and the Area dimension in Columns It is recommended that you choose your specific area prior to dragging on Measures which will render the grid 27 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 7 User Experience Survey UES 7 1 Background The information available via NASCIS for Social Care User Experience Survey provides information on outcomes for users which can be used to contextualise some of the information provided from other returns For example Are the home care users identified via RAP happy with their home care service The UES data currently available in NASCIS is the Adult Social Care Survey Beta Survey of Adult Carers In England Home Care Survey 2008 09 The main difference to the other social care data is that the UES data is at individual level so any cross analysis of questions or demographics is possible i e you are not restricted to
64. marking purposes JSNA Guidance on how to use the Online Processor PSSEX gt NIS ae ASC CAR Adult Social Care Combined Activity Returns data including historic SR1 Tables 1 2 5a 5b and 5c Final cut 2012 13 Data for earlier years is USER SURVEYS final ASCOF Adult Social Care Outcomes Framework data Final data for 2012 13 Data for earlier years is final ASCS Beta The Adult Social Care Survey provides information about the self reported experiences of service users of adult social care Data for 2010 11 and 2011 12 are provided on a Beta basis for testing The most recent ASCS data are for 2012 13 and are available to download in a spreadsheet via the USER SURVEYS link Any comments on these data should be sent to usersurvey hscic gov uk AVA Abuse of Vulnerable Adults data Final 2012 13 Data for earlier years is final JSNA Access a range of data and indicators to support the Joint Strategic Needs Assessment JSNA PSSEX Personal Social Services Expenditure data Final 2012 13 Data for earlier years is final NIS The Social Care and Mental Health Indicators from the National Indicator Set Final 3rd cut 2010 11 data publically available Data for earlier years is final The National Indicator Set is being discontinued after 2010 11 RAP Referrals Assessments and Packages of Care data Final cut 2012 13 Data for earlier years is final USER SURVEYS Once you have logged on you will see the screen
65. me Care on the last day of the year for 3 councils from 2008 09 to 2012 13 taken from the RAP P1 table Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 4 3 Filters 4 3 1 Choose the required dimension to filter Home AboutNASCIS DataResources NASCISLibrary FAQs ContactUs Strategy Social care data RAP P1 Published v Wu 38 amp o ear Chat P v Gl Comparator Groups e Measures Filters ili EA e EET S Type Total ili Per 10 000 Population Service Type Total ili Per 100 000 Population Rows ili Distribution i Veen Ve Area Yorkshire amp Humber X k Year Columns l Area le Ageband Measures X k Client Type Views W Service Type Using the RAP P1 query remove year from filter and drop Service Type from the left into the Filters box 4 3 2 Drilling down to select a filter value Open the drop down list by clicking on the Service Type Total in Filters which will bring up a view like this Edit filter axis items Community Based Services Residential Care Nursing Care CASSR Residential Care D Independent Sector Select the required value e g Residential Care and click OK Additionally add Year to the Rows select 2012 13 and expand the Area to show all councils in Yorkshire amp Humber 19 Copyright 2014 Health and Social Care Informatio
66. n Centre NASCIS Online Analytical Processor OLAP User Guide 4 3 3 The filtered chart Social care data RAP P1 Published v ae oE Barcha vile pi E bh Measures th Number of Service Users Filters _ ili Per 10 000 Population Service Type Residential Care X ili Per 100 000 Population R ili Distribution _ ili Year on Year Area Multiple X Year 2012 13 X lL Year oo L Area l mns tz Ageband Measures X k Client Type lz Service Type O a Comparator Groups s 2012 13 2012 13 2012 13 2012 13 2012 13 2012 13 2012 13 2012 13 2012 13 2012 13 2012 13 2012 13 2012 13 2012 13 2012 13 a i Barnsley 204 Bradford 209 Doncaster 205 East Riding 214 Kirklees 211 Leeds 212 Calderdale 210 NE Lincolnshire 216 N Lincolnshire 217 North Yorkshire 218 Rotherham 206 Sheffield 207 Wakefield 213 York 219 Clicking on the Chart tab and selecting Bar Chart from the drop down chart menu will show your filtered data as above in this example Residential Care only 20 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 4 3 4 Selected filters Social care data RAP P1 Published v a no Bar Chat M G pi x al Comparator Groups El eu Measures i ili Per 10 000 Population ili Per 100 000 Population Rows ih Distribution i Year on Year
67. nd Administrative geographic areas whilst the Indicators are split by theme and sub theme e g Burden of ill health gt Cancer Each indicator also contains a code for the latest period of data that is available in the following format X e X shows the time period C is calendar year and F is financial year e shows the year so for example C11 is calendar year 11 2011 The Period dimension fig4 shows the data period for time series analysis This enables you to choose how far back from the data period you wish to view hence Latest Period 1 This is dependent on the availability of historical data for the indicator s in your query Fig4 Period 0 Measures a ly Period l Latest Period l Latest Period l Latest Period Ls Latest Period Ly Area lz Indicator Theme wns There are a number of measures available to complete your query again dependent on the information available The default setting for the JSNA indicators is Rate but where possible Numerator and Denominator are also available to show the underlying data Additionally statistical confidence intervals CIs are available where these have been calculated for any indicators 26 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide Fig5 Measures Measures a ili Rate ii Denominator ii Numerator ii Lower 95 0 Cl i
68. nd Gypsy Roma and this has altered the comparability of Irish and Other background so there is now a 9 10 definition for these The gender split collected in previous years has been removed from the 2010 11 tables The gender information is now available in table P7 but is not split by ethnicity Ethnicity categories re organised for 2013 14 This is a new table for 2010 11 RAP Return This table has been split in to 2 sections A and B in the OLAP P7 holds data previously collected in P4 The number of planned visits per week was removed from 2011 12 Client types have been relabelled People with Physical Disabilities is now Physical disability People with Mental Health problems is now Mental health People with Learning Disabilities is now Learning disability Alcohol Drug misusers is now Substance misuse Others is now Other vulnerable people Client types have been relabelled People with Physical Disabilities is now Physical disability People with Mental Health problems is now Mental health People with Learning Disabilities is now Learning disability Alcohol Drug misusers is now Substance misuse Others is now Other vulnerable people Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide SD1 e This was a new table for the 2009 10 RAP return SD2 e This was a new table for the 2009 10 RAP return e Ethnicity categories re organised for 2013 14 SD3 e This was a
69. new table for the 2009 10 RAP return PSS EX1 Incl SSMSS e Headline Adult services and accounting categories and now prefixed with a letter and number respectively to bring them in to the same order as they appear on the return e 2009 10 data contains the voluntary items which are published for the first time Unit Costs e Per person per week figures have not been collected in Summary 2009 10 the Services and headline figures for this year will appear to be blank Figures for lower levels are still available e For the November 2011 release Unit Costs has been reworked so that it now has numerator and denominator data available and this has been applied retrospectively to all years GENERAL e An expand button has been added to the selection options when a dimension is on build window e Dimension attributes now appear in the order of the return rather than alphabetical order Please note that this does not apply to the area dimension 61 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 62 Published by the Health and Social Care Information Centre Part of the Government Statistical Service For further information www hscic gov uk 0300 303 5678 enquiries hscic gov uk Copyright 2014 Health and Social Care Information Centre All rights reserved This work remains the sole and exclusive property of the Health and Social Care Information Ce
70. nline Analytical Processor OLAP User Guide Service Day care Direct payments Home care Meals 45 Service sub type Adults with learning disabilities receiving day care Adults with mental illness receiving day care Adults with physical disabilities receiving day care Older people receiving day care Adults and older people receiving day care Adults with learning disabilities receiving direct payments Adults with mental illness receiving direct payments Adults with physical disabilities receiving direct payments Older people receiving direct payments Adults and older people receiving direct payments Adults and older people receiving home care Adults with learning disabilities receiving home care Adults with mental illness receiving home care Adults with physical disabilities receiving home care Older people receiving home care Adults and older people receiving meals Adults and older people receiving meals Adults and older people receiving meals Adults and older people receiving meals Older people receiving meals Copyright 2014 Health and Social Care Information Centre Basis Per client Per client Per client Total Per client Per client Per client Total Per client Per client Per client Total Per client Per client Per client Total Total Total Total Total Total Total Total Total Total Total Total Per meal Per meal Per meal Total Total Provision Source
71. ntre and may only be reproduced where there is explicit reference to the ownership of the Health and Social Care Information Centre This work may be re used by NHS and government organisations without permission Copyright 2014 Health and Social Care Information Centre
72. p Social Care Information Centre Forgotten Details Please enter your username or email address tick the relevant checkbox es and click submit Username Or Email address Reset my password A Send my username o HSCIC staff are reminded that we are currently in the process of migrating to new hscic gov uk email addresses For now HSCIC staff will need to authenticate using their ic_nhs_uk email addresses if their email address is their username If you have forgotten the email address your account is registered under then contact us on 0845 300 6016 or enquiries hscic gov uk Terms and conditions Privacy and cookies Internet disclaimer Copyright 2014 the Health and Social Care Information Centre All rights reserved 9 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 2 4 Selecting the required data set Health amp Social Care NASCIS OS niormation Contre National Adult Social Care Intelligence Service Home AboutNASCIS DataResources NASCISLibrary FAQs ContactUs Strategy v Social care data Social care data ASC CAR see NASCIS Online Analytical Processor ASCS Beta The NASCIS interactive Online Analytic Processor OLAP is an online service that provides quick easy and flexible access to a wide range of social AVA care information enabling analysis based on an authoritative common set of data for performance management and bench
73. referred to as cross tabulation of questions is also possible using the OLAP Tool for example for the Home Care survey you could view whether or not seeing the same care workers Q8 from top to bottom affects overall satisfaction with home care services Q1 left to right across the top of the table Published v u 8 BO parchar v Home Care Surev Gi Comparator Groups l Age Group Filters Drop attributes here to filter the data lL Ethnic Group Iz Meals On Wheels Day Centre Rows ic Other Senices Area Leeds 212 X Q8 Total X K a1 k a2 Columns a3 Measures Q1 Total L a4 x x Kas Views L a6 k a7 te no z 4 gt Grid Chart am extremely am very am quite am neither satisfied am quite am very I am extremely non response to non response to satisfied satisfied satisfied nor dissatisfied dissatisfied dissatisfied dissatisfied the whole survey this question ee 3 26 2 20 0 78 0 00 0 06 0 00 0 06 0 00 0 12 same care workers No but nearly always see the same care 6 43 10 15 8 11 1 08 0 66 0 24 0 12 0 00 0 42 workers No hardly ever see Yorkshire amp Leeds 0 24 0 48 0 96 0 42 0 36 0 06 0 00 0 00 0 06 Humber 212 No 1 ee th 0 00 0 00 0 06 0 08 0 06 0 00 0 00 0 00 0 00 same care workers 0 00 0 00 0 00 0 00 0 00 0 00 0 00 61 50 0 00 whole survey 0 24 0 18 0 12 0 12 0 06 0 08 0 00 0 00 0 08 question The Adult Social Care User Survey provides information on service
74. s wi z ih Per 10 000 Population Year 2002113 ili Per 100 000 Population Rows ih Distribution Area Multiple X ihi Year on Year Loeis l Year Columns L Area hans Measures X kL Client Type Views lz Service Type Grid Chart Number of Service Users 6485 11600 210 4820 7220 soso Kingston upon Hull 215 8875 Kirklees 211 14470 a zs N E Lincolnshire 216 3950 N Lincolnshire 217 4085 _ 12445 8870 York 219 7220 Yorkshire amp Humber Total 139980 es aos 16 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 4 2 Changing between grid and chart views To change the view from grid table to a chart graphical click on the Chart tab A number of Chart types will produce different views depending on the data you are querying The screenshot below shows a Bar Chart Social care data RAP P1 a ae og jearchan vfa P1 x Lal Comparator Groups Published v El eu Measures Fitters uh j ili Per 10 000 Population Year 2012 13 X ili Per 100 000 Population Rows ihi Distribution TT ih Year on Year Reine l Year Columns lL Area Achaea Measures X W Client Type Views lz Service Type O Grid Chart Ai 20 000 Barnsley 204 Bradford 209 Calderdale 210 Doncaster 205 East Riding 214 Kirklees 211 Leeds 212 NE L
75. ss to a wide range of social care information gt NASCIS Standard Reports ciiil The NASCIS standard reports show different elements of adult social care data in a range of comparative thematic and profile reports D gt JSNA Access a range of data and indicators to suppor the Joint Strategic Needs Assessment All data in the Public view in the NASCIS online analytical processor and the NASCIS Standard Reports has been formally published and can now be used externally in accordance with Health and Social Care Information Centre rules on re use of data Data in the restricted view is made available as management information ONLY and cannot be used externally Please refer to the terms and conditions To apply for access to the restricted view please contact enquiries hscic gov uk gt POPPI Projecting Older People Population Information System For use by LA planners and commissioners for Social Care to explore the possible impact that demography and certain conditions may have on populations aged 65 and over gt PANSI Projecting Adult Needs and Service Information System For use by LA planners and commissioners for Social Care to explore the possible impact that demography and certain conditions may have on populations aged 18 64 AS Originally developed for the Care Services Efficiency Delivery Programme CSED part of the Department of Health the POPPI and PANSI systems provides population data
76. the way in which the proformas are constructed as in the other returns The data is available to view as counts and also as percentages although please bear in mind small numbers when looking at percentages e g where the query is based on 10 people each representing 10 Perhaps the most useful way of analysing the survey data is by looking at the percentage distributions for the survey questions or by sample demographics See example below for Q4 of the Home Care survey which asks home care users in the Yorkshire and Humberside region Do your care workers do the things that you want done F ph Measures Filters Drop attributes here to filter the data lz Area lz Method Of Collection lz Response to Survey Rows L Direct Payments lz Intensity of Care lL Gender Columns E aes Q4 Total X Measures X lz Meals On Wheels Views l Day Centre l Other Services ta n1 4 gt Published v Area Multiple gt Grid Chart They always do the They nearly always do the They sometimes do the _ They never do the things non response to the non response to this things want done things want done things want done want done whole survey question Distribution Distribution Distribution Distribution Distribution Distribution lee Distribution 34 64 Bamsley 204 13 18 3 69 0 08 48 91 1 51 100 00 Bradford 209 25 78 15 71 4 09 0 44 52 00 1 98 100 00 Calderdal
77. ut 2012 13 Adult Social Care Survey data Final cut 2012 13 Carers Survey data November 2013 Interim 2012 13 Referrals Assessments and Packages of Care RAP data Final cut 2012 13 Adult Social Care Combined Activity Return ASC CAR data Interim measures from the 2012 13 Adult Social Care Outcomes Framework ASCOF Final cut 2012 13 Adult Social Care Survey data Final cut 2012 13 Carers Survey data December 2013 Final cut 2012 13 Referrals Assessments and Packages of Care RAP data Final cut measures from the 2012 13 Adult Social Care Outcomes Framework Final cut 2012 13 Personal Social Services Expenditure PSS EX1 data February 2014 Final 2012 13 Abuse of Vulnerable Adults AVA data 50 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide 2013 14 May 2014 Update of JSNA Indicators June 2014 Initial 1 cut 2013 14 Referrals Assessments and Packages of Care RAP data Initial 1 cut 2013 14 Adult Social Care Combined Activity Return ASC CAR data Initial 1 ASCOF Initial 1st cut Adult Social Care Survey data for 2013 14 July 2014 Provisional 2013 14 Referrals Assessments and Packages of Care RAP data Provisional 2013 14 Adult Social Care Combined Activity Return ASC CAR data Provisional measures from the 2013 14 Adult Social Care Outcomes Framework ASCOF Provisional 2013 14 Adult Social Care Survey ASCS data First cut data 2013 14 Sa
78. wn to the question responses Click the select all button then un tick the Did not receive a model questionnaire Non response to the whole survey and Non response to this question boxes 34 Copyright 2014 Health and Social Care Information Centre NASCIS Online Analytical Processor OLAP User Guide Omitting non respondents is the standard way to view survey data as created in the annex table unless you want to check how many people failed to respond The table should automatically generate as the above image in alphabetical order of council Note you can select as many or as few of the areas and or question responses as you wish 7 3 How to use NASCIS to check response rates An example response rate view comparing response rates to question 1 between ethnic groups in Croydon Published v a ale OY stacked Bar Chat 2010711 m coumn vistnouton U Filters L Year T Aroa Area Croydon 721 X k Questions R M Rows E lz Survey Administration a EL Demographics Ethnic Group All X Measures X lL Gender le Age Group br Ethnic Group ar a X Le Sexual Identity Le Religion lL Primary Client Group lz Secondary Client Group a Views 4 Grid Chart NOES you r ive ra cll acne lam id not receive 8 Non response Non m qui lamauite lamvery lerremely model the whe ssa i zg dissatisfied questionnaire 7 7 06 04 06 122 66 2 1 0 1735
79. year population estimates 2012 13 uses the 2012 mid year population estimates and so on Mid year population figures are not available via the OLAP but may be obtained from ONS The latest mid year population statistical dataset can be sourced from http www ons gov uk ons rel pop estimate population estimates for uk england and wales scotland and northern ireland 201 3 stb mid 2013 uk population estimates html Population figures provided to us by ONS have not been weighted or age standardised 9 8 Guidance updates This user guidance will be updated throughout the NASCIS development cycle 9 9 Additional table notes 1 RAP Tables C1 and C2 Please note that there are two distinct age band dimensions on these tables for the ages of the carers and the ages of those cared for Please ensure you have selected the age band dimension that you require Additionally the Client Type on Age of person cared for is available by expanding the dimension and drilling down 2 NIS National Indicator Set Please note from Release 3 on 30 September 2009 the NIS displayed now includes indicators on Mental Health For the 2010 11 release of NIS data indicators NI128 NI132 NI133 and NI136 were dropped from collection Additionally NI127 was calculated using a new methodology and NI127 indicators for 2010 11 are not comparable with indicators from previous years The NIS data was not published in 2011 12 superseded by The Adult Socia

NASCIS OLAP User Guide 2014

Contents

Download Pdf Manuals

Related Search

Related Contents