About me - Russell Barber

Introduce yourself here after registering so people know which college you are from
Post Reply [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable
russellbarber
Posts: 2
Joined: Fri Nov 11, 2016 9:30 am
Forename: Russell
Surname: Barber
College Name: Hadlow Group
Position: Group Systems Development and Reporting Manager
LinkedIn Profile: https://uk.linkedin.com/in/russell-barber-2a385617
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

About me - Russell Barber

Post by russellbarber » Fri Nov 11, 2016 9:38 am

Hello - and thanks for setting up this resource.

I'm Russell Barber and I'm the Systems Development and Reporting Manager for the Hadlow Group - Hadlow College, West Kent College and Ashford College. I've been in the role for 4 months, and Unit-E is one of two MIS systems we use, so my knowledge of it is growing but limited...!

Previous education experience was working for a university and before that a local authority. Previous to that I worked as a software developer.

Skillset includes SQL, DB admin, Java, C++, C, SSRS/SSAS/SSIS and database warehousing and cubes. I'm currently working on a data warehouse so we can bring data in from the multiple different systems we use across the group and generate group-wide reports and cubes. I'd really be interested if anyone who has done anything similar.

User avatar
robinwilson16
Site Admin
Posts: 185
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
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

Re: About me - Russell Barber

Post by robinwilson16 » Fri Nov 11, 2016 1:59 pm

Hello Russell

Thanks for signing up and hope you find this forum useful.
I will keep adding things to it as and when I get the chance.

The data cubes sound really interesting and it is not something I have explored before so I would be interested to hear more about the advantages of that and how it works and performs, etc.

Robin

russellbarber
Posts: 2
Joined: Fri Nov 11, 2016 9:30 am
Forename: Russell
Surname: Barber
College Name: Hadlow Group
Position: Group Systems Development and Reporting Manager
LinkedIn Profile: https://uk.linkedin.com/in/russell-barber-2a385617
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

Re: About me - Russell Barber

Post by russellbarber » Wed Nov 16, 2016 9:40 am

Hi Robin,

Cubes are really useful in view data in different ways - groupings/aggregates etc. I'm sure I'm not alone in getting numerous requests for data that are only slightly different - can we have this grouped by site/age/etc.... Cubes let you do this (or let the user do this) really quickly on a verified dataset.

Russell

User avatar
robinwilson16
Site Admin
Posts: 185
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
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

Re: About me - Russell Barber

Post by robinwilson16 » Fri Nov 18, 2016 12:15 am

Yes that is very true!

Often we have reports already in existence but people always want to cut the data in a slightly different way requiring another query to be developed for the purpose.

I do feel it is something I should look at in more detail.

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
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

Re: About me - Russell Barber

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

Would be very interested in what you create and what others have done.
We haven't used SSAS but use tsql cubes for creating some datasets - particularly handy around SAR season.
We've managed to claw together data from finance, payroll and unitE to create a costing model showing income/costs by area. Took a while and involved lots of fixes as not everything links up but still not a bad indicator.

Post Reply
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

Who is online

Users browsing this forum: No registered users and 0 guests