You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
-
Tableau ftw. I've been using it for years, it is superb. Sounds like it would be exactly what you need. Once you give it a go, you will never use Excel for visualising again.
I'm now dabbling with Alteryx to sort out and combine awkward datasets in preparation for visualisation in Tableau.
It's fun :)
Ah balls.
I just lost a big old post.
tl;dr
I work in the civil service and interact with a lot of local govt / other civil service agencies.
The technology isn't always there.
I'm giving information to someone who manages the survey tool which runs on .NET. We're building an SQL db. I will have access to this for one part of my job.
Data about people being ill is collected in this tool
http://hpzoneinfo.in-fact.com/
data is extracted (for "analysis") into Access and then charted etc in Excel. (because of familiarity and other people need to work on the same thing and resource).
It's a big step getting an SQL db. There's not much money.
In addition, the new system that's being rolled out/developed (SGSS (which i think is by BAe)) allows us to interrogate data online. However, this is slow. And the reports look rubbish. And you generate the data and then extract it and then have to fuck around with it in Excel.
However, you can connect to this by sql / through access/through excel.
This is slightly subversive as the team that are leading the development of this system want everyone to do it their way and ask them to build queries to build reports. Which would put my, newly joined, team in the line of the "efficiency and savings" gun.
The role I have is making data/information easy to read for people who don't have an interest/time/money/desire to invest in the doing things superfastandwiththelatesttech.
These people are nurses, EHOs, doctors, and other health care workers (who put the data into our system).
I don't want to be here forever, but I love gypsy life, I want to try and develop some skills on the job and use my interest in public health to make progress and hopefully, hopefully, get a job somewhere else.
sigh. that's depressing.