+ Post New Thread
Page 6 of 7 FirstFirst ... 234567 LastLast
Results 76 to 90 of 101
MIS Systems Thread, The MIS Challenge & Market Analysis in Technical; It shows this, it shows the numbers gained since the last year....
  1. #76

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    It shows this, it shows the numbers gained since the last year.

  2. #77
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,081
    Thank Post
    812
    Thanked 353 Times in 277 Posts
    Blog Entries
    60
    Rep Power
    280
    Ahh yes, silly thing is that's the column I've been paying more attention to in the summary then the % change! >.<

    Point still stands though, I don't trust the contents of the % change column because it shows skewed figures for new arrivals.

  3. #78

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    Quote Originally Posted by CAM View Post
    Ahh yes, silly thing is that's the column I've been paying more attention to in the summary then the % change! >.<

    Point still stands though, I don't trust the contents of the % change column because it shows skewed figures for new arrivals.
    Agreed. Although I suspect it is the interpretation on the column, the figures are not skewed... ironically the issue is they SHOULD be!

  4. #79

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,388
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    The way you'd do it is to group them together, so Capita vs the rest of the market - then the rest of the market split up - then you might compare the new entries separately with each other - ie in the first year, how many did they get vs other providers.

    The problem is your now putting your own spin on the data and your making it user specific - the key to remember is Graham has put the raw data forward. That's step one, step two will be getting a good method of adding your spin on the data and something that is accessible. It's no good me building something in BI tool if the only people who can use it are suppliers!

  5. #80

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    Raw data is in the spreadsheet... I want people to be using it! I worked too long and hard for it to go to waste!

  6. #81
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,081
    Thank Post
    812
    Thanked 353 Times in 277 Posts
    Blog Entries
    60
    Rep Power
    280
    Sweet I'll have a play with it tonight. Got SQL Express at home not used yet.

  7. #82

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by matt40k View Post
    The problem is your now putting your own spin on the data and your making it user specific .....
    errm... stats IS​ spin they'd be useless data without it

    As for the new entrants, i also don't agree with high % - it is undefined, so needs to be asterisked with a footnote added as it would be in accounting documents.
    I'd rather see just the absolute number shown with an asterisk or highlight to indicate it's total current numbers, and the next stat to be % of total market, so it at least has some thing to compare to.

    A good stat to monitor over time would be total schools with a new entrant, if there are more than one, and see this figure over time, assuming the supplier base keeps increasing.

    Side note: Links to challenge detail and analysis added to First Post for quick reference.
    Last edited by vikpaw; 31st March 2014 at 04:02 PM. Reason: painfully embarrassing typo

  8. #83
    scholarpack's Avatar
    Join Date
    Jul 2010
    Location
    UK
    Posts
    191
    Thank Post
    12
    Thanked 30 Times in 20 Posts
    Rep Power
    38
    How come your stats have Capita at +553? when these stats have Capita at -138? Everything else appears to be in sync across the two.

  9. #84

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Spin?

  10. #85

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    FYI I have taken the page down temporarily while I go back through all the steps... again...

    There are notes plastered all over this that says this is info from the DfE, as well as the extreme difficulty in marrying up 21000 records 4 times (those darn schools open and close doesn't help!). I did say this was to be used as a rough guide, so I must admit I'm a little ticked off to see all this moaning about it.

    I'll go back through the process from the raw data tonight/tomorrow (i'm know the process isn't perfect to date, but i'm buggered if I am gonna marry 84000 records manually... the new process should be a little more accurate )

    So apologies chaps, will be back available again tomorrow for you to moan at some more

  11. #86
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,081
    Thank Post
    812
    Thanked 353 Times in 277 Posts
    Blog Entries
    60
    Rep Power
    280
    No-one is moaning, just adding input to improve it.

  12. #87

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    Thanks @CAM (although I beg to differ, perhaps the difference between picking holes and moaning is a different in my book! )

    Anyways, I have gone back through all the information and gone through the merging steps again, a huge task I might add! I have found that the process isn't flawless given that the data from all four years, plus the information in Edubase (where school details are kept) is not all there, which is what was throwing off the calculations when merging. If i had one difinitive source of information on all of the schools, this would have been easier (plus, schools have closed/opened since 2010! And will continue to close and open).

    Upshot, the figures are much more accurate, and by comparison are aligned with other references. One my say why bother, and just used the other sources... feel free to, it is all the same data! I guess it depends on how details you actually want the data... LA and School historical level...

    The website page will be back live again in the next 20 mins.

  13. #88

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    Update: this week I have had 3 more suppliers contact me with intent to supply responses, really great news! Big thanks to all who do who take time out to support the community with this project.

    In other news, the survey is now available for download from the website for any school or LA who may wish to use some or all of it in their own procurements... Why reinvent the wheel! Completely free and unrestricted to use, although out of courtesy it might be nice to acknowledge it's use, but more importantly get in touch to let us know if it wad useful and how you got on with your procurement!

    There is also a resources section for any and all free resources we discover out there surrounding data and information management.
    Last edited by GREED; 8th April 2014 at 08:25 AM.

  14. #89

    Join Date
    Mar 2008
    Location
    Derby
    Posts
    20
    Thank Post
    0
    Thanked 6 Times in 5 Posts
    Rep Power
    14
    @GREED - quick question/piece of feedback on one of the questions on the survey:

    "Assuming you follow all Data Protection policies, where is the UK is the data stored?"

    My understanding is that the data protection act says the data should stay in the European Economic Area, rather than the UK. For example Amazon don't have any UK data centres, but they do have them in Ireland. For reference: Sending personal data outside the European Economic Area (Principle 8) - ICO

    The way that question is phrased definitely implies that in order for a supplier to comply with the data protection act the data should be stored in the UK.

    Thanks,

    Nick

  15. #90

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    Nick

    Thanks for your feedback. I will edit this later, although the meaning will be the same. Note for suppliers, please answer this question in your own survey as appropriate (if any of you read this!!).

SHARE:
+ Post New Thread
Page 6 of 7 FirstFirst ... 234567 LastLast

Similar Threads

  1. the edugeek coven
    By russdev in forum Jokes/Interweb Things
    Replies: 20
    Last Post: 20th June 2007, 10:23 AM
  2. BBQ Season watch out here come the edugeekers
    By alonebfg in forum General Chat
    Replies: 29
    Last Post: 8th May 2007, 10:12 AM
  3. Replies: 6
    Last Post: 20th March 2007, 09:19 AM
  4. The EduGeek annual Christmas message
    By Dos_Box in forum General EduGeek News/Announcements
    Replies: 8
    Last Post: 26th December 2006, 01:53 PM
  5. Following the EduGeek Conference North 2006...
    By Ric_ in forum General EduGeek News/Announcements
    Replies: 2
    Last Post: 24th April 2006, 07:28 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •