Freedom of information response

Data analytics

Publication date: 
Thursday 16 July 2020
Request: 

1. Within the local authority, what is your approach to data and analytics?

a. We have a defined, centralised data and analytics strategy, at senior level

b. We have department level approach - each department is responsible for analytics in their own areas: 

c. We don’t have a coordinated/defined approach.

d. Don’t know

2. Which department(s) within your local authority are responsible for the analysis and management of information and data? (Please specify)

3. What training is provided on how to use these tools/platforms? (see below examples)

a. We train all users using internally delivered courses

b. We train all users using third party courses

c. We invest in self-teaching materials (e.g. paid-for online manuals/ e-learning content)

d. We let users self-teach using resources they can find themselves

e. We do not train users and do not invest in training users

f. Other (please specify) 

4. How often is training provided on these tools and platforms?

a. Once a quarter

b. Once a year

c. As and when needed: 

d. Never

e. Other (please specify)

5. Which of the following data and analytics tools do you use? (tick all that apply)

Response: 

1. 

a. 

b. Yes

c. 

d. 

2. Individual departments are generally responsible for the analysis of their service area data from any relevant service specific systems. Corporate data analysis from wider corporate systems is analysed centrally from the specific corporate directorate (HR and Finance for example). We have a Corporate EDRMS deployed and a dedicated Information Management team that oversee the management of that system.

3. 

a. 

b.

c. 

d. 

e. 

f. We use a combination of a-d depending on user’s current experience/skills, their future requirements and their learning preferences.

4. 

a. 

b. 

c. Yes

d. 

e. 

5. 

Data warehouse / data store

ETL analytics

Dashboards and data visualisation

Microsoft SQL Server

MySQL

Oracle RDBMS

SAP HR

SAP CRM

SAP HANA

SAP (Other, please specify)

Microsoft Access

Microsoft Excel

Other (please specify)

None

Alteryx

Tableau Prep Builder

Pyramid Analytics

Microsoft SQL Server Integration Services (SSIS)

SAP Business Objects

Sybase

Informatica PowerCentre

Other (please specify)

None

Tableau Desktop

Tableau Server

Microsoft Power BI

QlikView

Qlik Sense

Pyramid Analytics

Logi Analytics

Looker

Other (please specify)

None

You are free to use any information supplied to you for your own use, including non-commercial research purposes. However, any other type of re-use, for example, by publishing the information or issuing copies to the public will require the permission of the copyright owner.

Where the copyright is owned by Thurrock Council, you must apply to the Council to re-use the information. Please email information.matters@thurrock.gov.uk if you wish to re-use the information you have been supplied. For information where the copyright is owned by another person or organisation, you must apply to the copyright owner to obtain their permission.

Request reference:
FOI 10054