+ Reply to Thread
Page 1 of 4 1 2 3 ... LastLast
Posts 1 to 10 of 34
  1. #1

    katyperryfan

    MarillionFan has more data than eek

    MarillionFan's Avatar
    Join Date
    Jul 2005
    Location
    Glen Coe
    Posts
    29,980
    Thanks (Given)
    14
    Thanks (Received)
    64
    Likes (Given)
    55
    Likes (Received)
    281

    Default Skills for a Data Analyst

    Should a Data Analyst have SQL Skills. Thats the question?

    Because in my company, every f-cking data analyst they have can only use Excel!!! 30% can use Access!!!!!

    There's f-cking spreadsheets everywhere. They dont even have the sense to use the SQL Business Views provided to them via OLE DB or ODBC links!

    In the US they keep saying that SQL is an IT function and they only need people to put numbers together, but frankly I've got idiots trying to work out, how to get 200,000 rows into a spreadsheet.

    What does the panel think?
    What happens in General, stays in General.
    You know what they say about assumptions!

  2. #2

    Prehistoric

    thunderlizard has no reputation


    Join Date
    Jul 2005
    Posts
    5,804
    Thanks (Given)
    0
    Thanks (Received)
    1
    Likes (Given)
    0
    Likes (Received)
    5

    Default

    "every f-cking data analyst they have can only use Excel!!! 30% can use Access!!!!!"


    A good data analyst would be able to spot the inconsistency there.

  3. #3

    Double Godlike!

    Moscow Mule is too good to be a permie

    Moscow Mule's Avatar
    Join Date
    Mar 2007
    Location
    London
    Posts
    10,580
    Thanks (Given)
    0
    Thanks (Received)
    10
    Likes (Given)
    0
    Likes (Received)
    10

    Default

    The next time somebody leaves their computer logged in, move one of their more important spreadsheets to a different folder. That should screw them up for a couple of days.
    ‎"See, you think I give a tulip. Wrong. In fact, while you talk, I'm thinking; How can I give less of a tulip? That's why I look interested."

  4. #4

    I post more often than I breathe

    BrilloPad - scorchio!


    Join Date
    Aug 2006
    Posts
    74,662
    Thanks (Given)
    1615
    Thanks (Received)
    895
    Likes (Given)
    1615
    Likes (Received)
    1326

    Default

    At ClientCo most of the credit business, until 2 years ago, was 50% spreadsheets. The other half was mysql - it was fun when they reached 4gb!

    They still use alot of excel/mysql now...

  5. #5

    Godlike

    Sockpuppet has no reputation

    Sockpuppet's Avatar
    Join Date
    Oct 2006
    Posts
    7,412
    Thanks (Given)
    0
    Thanks (Received)
    3
    Likes (Given)
    0
    Likes (Received)
    3

    Default

    Quote Originally Posted by MarillionFan View Post
    What does the panel think?
    Your right.

    I'd say 80% of my job is data analysis. I need to know the numbers before I decide on the warehouse sizing.

    Most of the analysis I look at won't fit in excel either 2003 or 2007 so SQL skills are a must.

    Any data analyst that doesn't know SQL is not a decent analyst what the point only being able to (potentially) analyse 65,536 rows?

    You could blow their fuzzy minds by suggesting they write their own tools. I've got some perl scripts that get driving distances between UK postcodes (thanks google maps) which allows me to work out pricing models etc. Thats decent analysis.

  6. #6

    Contractor Among Contractors

    MrRobin has no reputation

    MrRobin's Avatar
    Join Date
    Jun 2007
    Posts
    1,862
    Thanks (Given)
    0
    Thanks (Received)
    0
    Likes (Given)
    0
    Likes (Received)
    0

    Default

    I agree, any self respecting data analyst should be able to write SQL, or at the very least, know how to link up tables in an Access query using the Wizard/GUI.

    Any company that keeps all their data in all manner of spreadsheets and other files needs a decent analyst and warehouse developer to come in a sort it all out.
    It's about time I changed this sig...

  7. #7

    Godlike

    BoredBloke is good enough for Jehovah!

    BoredBloke's Avatar
    Join Date
    Jul 2005
    Location
    whereever the work is
    Posts
    6,746
    Thanks (Given)
    4
    Thanks (Received)
    8
    Likes (Given)
    2
    Likes (Received)
    33

    Default

    Quote Originally Posted by MrRobin View Post
    Any company that keeps all their data in all manner of spreadsheets and other files needs a decent analyst and warehouse developer to come in a sort it all out.
    That's what they did when I was at BP. They tracked $100m of worldwide IT spend using spreadsheets and there wasn't a database anywhere in sight. I wrote them a simple access tool which took their data from SAP and produced the reports their finance bods spent ages doing. However the reports from SAP and via my tool would never match the finance ones because the people in finance would reallocate the money offline without ever fixing it at its source. So the whole thing died - perhaps because my thing did their job in a few seconds instead of the days this huge team took to colour in Excel sheets.

    I wrote them another excel based tool to pull in all their financials relating to their projects spend. I wanted a database but they said they couldn't have one for political reasons!!

    We had another guy in the office who was tasked with matching up expenses in 2 datasets. He didn't know about vlookups and the like. He estimated it would take him about 4 days for each month he was looking at (we were in month 6 at that time). My Access database did the whole thing in a couple of seconds and produced their excel report out of the other end.

    I've never seen an organisation so dependant on Excel

    I want to learn SQL server and the like but struggle to find the time. I use SQL in my VBA but I cheat as I tend to build the query in the query builder and then hack the resulting SQL statements so that I can throw variables at it in VBA.
    Rule Number 1 - Assuming that you have a valid contract in place always try to get your poo onto your timesheet, provided that the timesheet is valid for your current contract and covers the period of time that you are billing for.

    I preferred version 1!

  8. #8

    Contractor Among Contractors

    MrRobin has no reputation

    MrRobin's Avatar
    Join Date
    Jun 2007
    Posts
    1,862
    Thanks (Given)
    0
    Thanks (Received)
    0
    Likes (Given)
    0
    Likes (Received)
    0

    Default

    Quote Originally Posted by TonyEnglish View Post
    However the reports via my tool would never match the finance ones because the people in finance would reallocate the money offline without ever fixing it at its source.
    This is uncanny..... I've had the exact same gripe just a short while ago. Had a note asking why my figures didn't match finance, after lots of digging, was because they bastardise the centralised datawarehouse in their own offline version.

    Quote Originally Posted by TonyEnglish View Post
    We had another guy in the office who was tasked with matching up expenses in 2 datasets. He didn't know about vlookups and the like. He estimated it would take him about 4 days for each month he was looking at (we were in month 6 at that time). My Access database did the whole thing in a couple of seconds and produced their excel report out of the other end.
    Oh dear... what a useless scrote. Well, that's why we can charge plenty

    Quote Originally Posted by TonyEnglish View Post
    I want to learn SQL server and the like but struggle to find the time. I use SQL in my VBA but I cheat as I tend to build the query in the query builder and then hack the resulting SQL statements so that I can throw variables at it in VBA.
    There's nowt wrong with that. I often do the same... I could write the base myself, but what's the point if some wysiwyg will do it for you and then you edit the params in. Easier still if you learn a bit of TSQL @variables
    It's about time I changed this sig...

  9. #9

    Faqqed Off

    TheFaQQer is NOT a disguised employee

    TheFaQQer's Avatar
    Join Date
    Oct 2006
    Posts
    30,794
    Thanks (Given)
    100
    Thanks (Received)
    631
    Likes (Given)
    975
    Likes (Received)
    1131

    Default

    Quote Originally Posted by MrRobin View Post
    Oh dear... what a useless scrote. Well, that's why we can charge plenty
    A true contractor would have said they could do it in two days, done a script to do it in a few seconds, and spent the rest of the time on CUK.

    <Your signature goes here>

  10. #10

    Super poster

    KathyWoolfe has no reputation

    KathyWoolfe's Avatar
    Join Date
    Jun 2007
    Location
    Edinburgh
    Posts
    2,170
    Thanks (Given)
    0
    Thanks (Received)
    3
    Likes (Given)
    0
    Likes (Received)
    3

    Default

    Quote Originally Posted by TheFaQQer View Post
    A true contractor would have said they could do it in two days, done a script to do it in a few seconds, and spent the rest of the time on CUK.

    They do....and they are
    It's Deja-vu all over again!

+ Reply to Thread
Page 1 of 4 1 2 3 ... LastLast

Posting Permissions

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

Content Relevant URLs by vBSEO 3.6.0 ©2011, Crawlability, Inc.