Page 1 of 1

About me - Alan Bradley

Posted: Mon Nov 14, 2016 2:59 pm
by AlanB
Hi,
I've been working at the Isle Of Wight College since leaving University... 15 years ago. Initially recruited as an IT Trainer, progressed into IT Support and then slid sideways into the Data Team where I'm employed as a systems developer.
Systems we use include: unit-e (advanced license, timetabling and registers, online applications), 4cast, proachieve, proobserve, chris21, symmetry, etrackr, smart assessor.
We've been using power bi dashboards since August 2016 and some custom web reporting solutions (ASP MVC)

Re: About me - Alan Bradley

Posted: Wed Nov 16, 2016 7:22 am
by robinwilson16
Hello Alan

Thanks for signing up!

I would be really interested to find out more about Power BI (and the ASP MVC bits of it) as have been asked to set up a KPI Dashboard where people outside MIS would be able to easily maintain their sections and Power BI looks like it might be a good way to do it.
Last year I created some SSRS reports and then set up a web page with iframes that pointed at the charts but the requirements changed many times throughout the year and it became very time consuming to keep updating it.

Hope you find the forum useful.
Robin

Re: About me - Alan Bradley

Posted: Thu Dec 08, 2016 11:04 am
by AlanB
Can empathise with the constant requirement changes : )

Power BI is much better than our previous dashboard system. Previously we had Dynastics but this was pretty expensive and a bit clunky. In Power BI creating dashboards is very simple - mostly drag and drop - and you can easily configure it to drill-down into the data or link to other reports. Particularly popular is the geo-mapping - e.g. attendance by home postcode district (no lat/long required). As well as being faster to develop - the end-user interface is also faster. Free to try : ) (I'm not on commission)
The ASP site is separate and more for looking into the detail but will include some key PI reports/alerts and forms for update requests. It was created to move away from using some very old MS Access dbs which need retiring. Dashboards link to the site for more detail. We don't use SSRS at all.

Would be interested in what others do for reporting (data direct from unitE or from some kind of snapshot, using which technologies), what access staff have to data and how they request changes - ALP amendments etc.

Re: About me - Alan Bradley

Posted: Fri Dec 16, 2016 12:48 pm
by robinwilson16
Hello Alan

Thanks for responding and sorry it's taken me a while to respond but I have been on holiday.

I have now managed to get Power BI set up and working and it seems to be working well. By entering the data into Excel spreadsheets and sharing these on OneDrive for Business and using these as the data sources, staff can update figures in Excel which then update the Power BI charts. My next task is to make it fit to 2 sides of A4!

SSRS has worked quite well too for self-service reporting but I need to clean up the report server a bit and remove some of the old reports on there.
It would be interesting to hear what others are doing.

Robin