Hey there! Sign in to join this conversationNew here? Join for free

I'm a Data Analyst for TSR - AMA! Watch

    • TSR Group Staff
    • Thread Starter
    Offline

    19
    ReputationRep:
    TSR Group Staff
    (Original post by Supersaps)
    How much do you sell our data for to get companies to pay for targeted advertising?


    Let's be honest, this is your job.


    SS
    Ha, I don't do the selling... I provide the sales team with the data and they set the prices
    Offline

    21
    ReputationRep:
    (Original post by jenhasdreams)
    That sounds perfect for an entry role Excel and SQL are the main things I use. You're not looking for a job in Brighton are you? :lol:
    Nope, London area and Surrey
    Offline

    15
    ReputationRep:
    (Original post by jenhasdreams)
    Ha, I don't do the selling... I provide the sales team with the data and they set the prices
    At least you do the clever bit.
    • TSR Group Staff
    Offline

    11
    ReputationRep:
    TSR Group Staff
    (Original post by micycle)
    Do you know / need to use programming?

    How large is the TSR database / content server?
    On the top of my head our database is just shy of 500M rows, with about 450GB of data for what serves TSR, and we run it across 4 servers (totaling 68 Cores, 282GB RAM)

    Our reporting databases which @jenhasdreams crunches her numbers on are about 1TB data and we have two of these running.
    • TSR Support Team
    • Peer Support Volunteers
    • Clearing and Applications Advisor
    Offline

    21
    ReputationRep:
    TSR Support Team
    Peer Support Volunteers
    Clearing and Applications Advisor
    (Original post by adamstrawson)
    On the top of my head our database is just shy of 500M rows, with about 450GB of data for what serves TSR, and we run it across 4 servers (totaling 68 Cores, 282GB RAM)

    Our reporting databases which @jenhasdreams crunches her numbers on are about 1TB data and we have two of these running.
    :drool:
    Offline

    1
    ReputationRep:
    What's the highest repped post in this thread?

    http://www.thestudentroom.co.uk/show....php?t=4238456
    • TSR Community Team
    • Study Helper
    Offline

    20
    ReputationRep:
    TSR Community Team
    Study Helper
    Just bumping this thread because I need it for something.
    Offline

    16
    ReputationRep:
    What is the most dupe accounts found (on one IP).
    • TSR Group Staff
    • Thread Starter
    Offline

    19
    ReputationRep:
    TSR Group Staff
    (Original post by Captain Jack)
    Just bumping this thread because I need it for something.
    Hi Jack! What have I done now?
    • TSR Community Team
    • Study Helper
    Offline

    20
    ReputationRep:
    TSR Community Team
    Study Helper
    (Original post by jenhasdreams)
    Hi Jack! What have I done now?
    Given me lots of amazing stats
    • TSR Support Team
    • Very Important Poster
    • Peer Support Volunteers
    • Clearing and Applications Advisor
    Offline

    22
    ReputationRep:
    TSR Support Team
    Very Important Poster
    Peer Support Volunteers
    Clearing and Applications Advisor
    staaaats
    Offline

    2
    ReputationRep:
    (Original post by jenhasdreams)
    .
    Hello Jenhasdreams, I have a few questions.

    How many times has the word "Islam" and "Muslims" been typed

    Why does the website not block registered accounts made via proxies?

    What is your favourite food of all time?
    • Very Important Poster
    • Welcome Squad
    Offline

    21
    ReputationRep:
    Very Important Poster
    Welcome Squad
    (Original post by jenhasdreams)
    I did this thread a couple of years ago and got a fair bit of interest, so thought I'd re run it (plus, there's a prize at stake )

    I've been working at TSR for over 2 years now as a Data Analyst.

    Ask me about interesting site stats - what's the most repped post? How many people visit the site on results day? who's the best member of the CT?
    Or you can ask about how I got into my career, my qualifications, and what I enjoy about it!

    Please don't ask me:
    - how much I get paid
    - how much Captain Jack gets paid
    - moderation queries
    - mean things...
    Why does the post history under my stats only go as far back as 2012 when I have threads posted from 2011? This happens to be the case for many older users and I would like to see my older posts.
    • TSR Group Staff
    • Thread Starter
    Offline

    19
    ReputationRep:
    TSR Group Staff
    (Original post by UWS)
    Why does the post history under my stats only go as far back as 2012 when I have threads posted from 2011? This happens to be the case for many older users and I would like to see my older posts.
    We do store the posts still, but it seems like the search tool only pulls posts from a certain date. I don't know why this is, would need a techy answer.. Dez?
    Offline

    17
    ReputationRep:
    My most repped post pl0x
    • TSR Group Staff
    Offline

    18
    ReputationRep:
    TSR Group Staff
    (Original post by UWS)
    Why does the post history under my stats only go as far back as 2012 when I have threads posted from 2011? This happens to be the case for many older users and I would like to see my older posts.
    (Original post by jenhasdreams)
    We do store the posts still, but it seems like the search tool only pulls posts from a certain date. I don't know why this is, would need a techy answer.. Dez?
    The search index database is separate to the actual post database. I don't know why older data would be left out of the index, but I could hazard a guess at a couple of reasons - speed, efficiency or something along those lines being the most likely.
    • TSR Support Team
    • Peer Support Volunteers
    • Clearing and Applications Advisor
    Offline

    21
    ReputationRep:
    TSR Support Team
    Peer Support Volunteers
    Clearing and Applications Advisor
    Who has the best desk in the office? :holmes:
    • TSR Support Team
    • Clearing and Applications Advisor
    Offline

    21
    ReputationRep:
    TSR Support Team
    Clearing and Applications Advisor
    (Original post by Dez)
    The search index database is separate to the actual post database. I don't know why older data would be left out of the index, but I could hazard a guess at a couple of reasons - speed, efficiency or something along those lines being the most likely.
    Any chance of this decision being reversed? It's just bizarre not being able to search for old posts. The cons surely outweigh any possible gain in speed.
    • Very Important Poster
    • Welcome Squad
    Offline

    21
    ReputationRep:
    Very Important Poster
    Welcome Squad
    (Original post by Dez)
    The search index database is separate to the actual post database. I don't know why older data would be left out of the index, but I could hazard a guess at a couple of reasons - speed, efficiency or something along those lines being the most likely.
    I think we should be able to search for older posts though. There are a lot of valuable threads that may not pop up because of the limit
    • TSR Group Staff
    Offline

    18
    ReputationRep:
    TSR Group Staff
    (Original post by Snufkin)
    Any chance of this decision being reversed? It's just bizarre not being able to search for old posts. The cons surely outweigh any possible gain in speed.
    (Original post by UWS)
    I think we should be able to search for older posts though. There are a lot of valuable threads that may not pop up because of the limit
    It's not my decision, I don't work on search. The old search system is pretty ungainly to begin with to be honest though, so I doubt it'll get updated anytime soon.
 
 
 
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    Brussels sprouts
    Useful resources
    AtCTs

    Ask the Community Team

    Got a question about the site content or our moderation? Ask here.

    Welcome Lounge

    Welcome Lounge

    We're a friendly bunch. Post here if you're new to TSR.

    Groups associated with this forum:

    View associated groups
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

    Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

    Quick reply
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.