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 inhuman)
    Oh wow, long time ago.

    What is the most negged post (if that is still available to see)?

    Who do you report to?
    Yeah alright don't rub it in

    The most negged post is http://www.thestudentroom.co.uk/showthread.php?p=29244508. You can't see the score anymore but it had 823 neg rep.

    I report to http://www.thestudentroom.co.uk/member.php?u=2795454... it's not letting me tag him for some reason. Don't post in his AMA though whatever you do
    • TSR Community Team
    Offline

    19
    ReputationRep:
    TSR Community Team
    (Original post by jenhasdreams)
    x
    What is the best/most interesting statistic you've ever been asked to come up with?
    Online

    21
    ReputationRep:
    What do you do?????
    Online

    21
    ReputationRep:
    How many A*s have been achieved by TSR users
    • Very Important Poster
    • Welcome Squad
    Offline

    21
    ReputationRep:
    Very Important Poster
    Welcome Squad
    How many trolls are there on TSR?
    • TSR Group Staff
    • Thread Starter
    Offline

    19
    ReputationRep:
    TSR Group Staff
    (Original post by UWS)
    How many trolls are there on TSR?
    Assuming we ban them all... then we ban 30 users a day (blimey)
    • TSR Community Team
    • Welcome Squad
    Offline

    20
    ReputationRep:
    TSR Community Team
    Welcome Squad
    (Original post by jenhasdreams)
    I had a bagel with vegan cream cheese, avocado and tomato - supplied by TSR! Nom nom.

    Your most repped post is http://www.thestudentroom.co.uk/show...php?p=64973935 closely followed by http://www.thestudentroom.co.uk/show...php?p=65016735 :lol:

    The best CT member is the sadly departed Puddles the Monkey . If that's not allowed, then I suppose it's Pickles. I don't really want to give him that satisfaction though.

    I love problem solving so enjoy a good bit of investigation into all the masses of data we have about the site, and finding the answer to an issue! Especially if it's something we can change on the site and has a quick positive impact.
    (Original post by iEthan)
    Thank you now I know!

    I miss Puddles the Monkey a lot… and her endless battle with the site permissions. D: Ah, Pickles is a good guy I suppose. Puddles is better though, so I'll allow you that one.

    It sounds like such a cool job. And your breakfast sounds delicious!!
    Thanks jenhasdreams - you're the best

    iEthan - :eek: "I suppose"
    • TSR Group Staff
    • Thread Starter
    Offline

    19
    ReputationRep:
    TSR Group Staff
    (Original post by RK)
    What is the best/most interesting statistic you've ever been asked to come up with?
    What words in a thread title get the most number of replies on average?

    The words in Life forums are:
    AMA
    Ask
    Anything
    Girls
    Guys
    TSR

    :lol:
    • TSR Support Team
    • Peer Support Volunteers
    Offline

    21
    ReputationRep:
    TSR Support Team
    Peer Support Volunteers
    (Original post by Pickles)
    Thanks jenhasdreams - you're the best

    iEthan - :eek: "I suppose"
    ok, fine! You are a good guy

    Spoiler:
    Show
    ...sometimes
    • TSR Community Team
    Offline

    19
    ReputationRep:
    TSR Community Team
    (Original post by jenhasdreams)
    What words in a thread title get the most number of replies on average?

    The words in Life forums are:
    AMA
    Ask
    Anything
    Girls
    Guys
    TSR

    :lol:
    But not 'me'?
    Offline

    7
    ReputationRep:
    Who hands out the most cards and bans? :ninja:
    • TSR Group Staff
    • Thread Starter
    Offline

    19
    ReputationRep:
    TSR Group Staff
    (Original post by TSR-Exam)
    Who hands out the most cards and bans? :ninja:
    Ha, the out of hours moderation team. Moderation is their only thing they do on site though.
    • TSR Group Staff
    • Thread Starter
    Offline

    19
    ReputationRep:
    TSR Group Staff
    (Original post by RK)
    But not 'me'?
    No... perhaps that's used more often in other thread titles with less replies and brings down the average
    Offline

    12
    ReputationRep:
    how any threads are here are not about islam, penis size or counting to a million ?
    Offline

    3
    ReputationRep:
    (Original post by jenhasdreams)
    I've been working at TSR for over 2 years now as a Data Analyst.

    Ask me about interesting site stats
    Do you know / need to use programming?

    Why aren't more statistics publicly available?

    Do you ever visualise data?

    Are IP addresses of posters logged?

    Why does TSR require a data analyst?

    How mathematical is your job?

    How large is the TSR database / content server?
    Offline

    21
    ReputationRep:
    I'd be interested in a data analyst role but I wonder what the typical requirements are. I have a compsci degree, I did SQL at uni and in my spare time but how complex is the SQL normally used?
    • TSR Group Staff
    • Thread Starter
    Offline

    19
    ReputationRep:
    TSR Group Staff
    (Original post by Reformed)
    how any threads are here are not about islam, penis size or counting to a million ?
    Approx 6 (inc this one)
    • TSR Group Staff
    • Thread Starter
    Offline

    19
    ReputationRep:
    TSR Group Staff
    (Original post by micycle)
    Do you know / need to use programming?
    I mainly write SQL, that's pretty essential. I also use VBA and I've taught myself basic Python to automate some tasks such as pulling data from our ad server API and Google Analytics API

    (Original post by micycle)
    Why aren't more statistics publicly available?
    Do you mean TSR data specifically? We have some big figures publicly aavailable here http://tsrmatters.com/facts-and-figures/ What sort of things do you want to know?

    (Original post by micycle)
    Do you ever visualise data?
    All the time! A graph is generally much easier to understand than a table full o'numbers.

    (Original post by micycle)
    Are IP addresses of posters logged?
    Yes, the forum isn't anonymous

    (Original post by micycle)
    Why does TSR require a data analyst?
    Because we're a very big site, we get millions of users a month, so need someone dedicated to it. We want to make sure we're making the right decisions for our users and clients (we rely on advertising revenue) than just blindly going ahead with projects

    (Original post by micycle)
    How mathematical is your job?
    I know all the numbers, even ones like 5435535886. It's mainly logic and problem solving, although I have a Maths degree it's not all that complex

    (Original post by micycle)
    How large is the TSR database / content server?
    one for adamstrawson, perhaps.
    Offline

    15
    ReputationRep:
    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
    • TSR Group Staff
    • Thread Starter
    Offline

    19
    ReputationRep:
    TSR Group Staff
    (Original post by shawn_o1)
    I'd be interested in a data analyst role but I wonder what the typical requirements are. I have a compsci degree, I did SQL at uni and in my spare time but how complex is the SQL normally used?
    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:
 
 
 
  • 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
    Brexit voters: Do you stand by your vote?
    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

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