About me - Alan Bradley

Introduce yourself here after registering so people know which college you are from
Post Reply
AlanB
Posts: 4
Joined: Mon Oct 17, 2016 9:09 am
Forename: Alan
Surname: Bradley
College Name: The Isle of Wight College
Position: Information Systems Developer

About me - Alan Bradley

Post by AlanB » Mon Nov 14, 2016 2:59 pm

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)

User avatar
robinwilson16
Site Admin
Posts: 184
Joined: Sun Oct 16, 2016 6:46 pm
Forename: Robin
Surname: Wilson
College Name: FEA
Position: MIS Consultant
LinkedIn Profile: https://www.linkedin.com/in/robinwilson16

Re: About me - Alan Bradley

Post by robinwilson16 » Wed Nov 16, 2016 7:22 am

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

AlanB
Posts: 4
Joined: Mon Oct 17, 2016 9:09 am
Forename: Alan
Surname: Bradley
College Name: The Isle of Wight College
Position: Information Systems Developer

Re: About me - Alan Bradley

Post by AlanB » Thu Dec 08, 2016 11:04 am

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.

User avatar
robinwilson16
Site Admin
Posts: 184
Joined: Sun Oct 16, 2016 6:46 pm
Forename: Robin
Surname: Wilson
College Name: FEA
Position: MIS Consultant
LinkedIn Profile: https://www.linkedin.com/in/robinwilson16

Re: About me - Alan Bradley

Post by robinwilson16 » Fri Dec 16, 2016 12:48 pm

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

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest