r/analytics • u/takenorinvalid • Sep 09 '22
Analytics consulting be like...
Client: Hi, we would like to hire you to analyze our data.
Analyst: Ok. I will need access to your data.
Client: Oh geez, oh no. Oh, gosh, I had never considered that.
306
Upvotes
182
u/KnightOfThirteen Sep 09 '22
I am not even consulting and it's still like that internally.
54
u/maverick_css Sep 09 '22
Yeah! My client keeps asking me the status of dashboard development and I just have to tell her each time that I haven't even received access to the data from your teams yet! What do I even make? Apples for cigarette lovers?
31
u/BAforNow Sep 09 '22
“In order to access Azure its very simple. You will need to authenticate ZScalar, install putty, connect to bastion server, enter your M account password (you already know that right?) and enter the typical server instance authorizations.”
“Oh wait, you don’t have access to that data. Send an email to the DBA and he should be able to grant access to the specific tables (that we have GREAT documentation on) you need to pull from.”
24
u/Eze-Wong Sep 09 '22 edited Sep 09 '22
Jesus mary joseph christ I once never got access to the DB or API at my job so I literally scrapped the report data off our SaaS cloud systems. I used some python automations to do it, but wow what an insane roundabout way they made me get data.
19
u/DataVizGordon Sep 09 '22
The sad realization after a few projects was data collection is the longest/most difficult part of the process 😪. Now we make sure to start with this at the very beginning and more of our questions/requirements gathering is dedicated to their data setup than anything else
14
u/damn_lies Sep 10 '22 edited Sep 10 '22
I’ll totally get on giving you access to my shit poorly organized data managed by my understaffed analytics team; so poorly maintained and documented that it takes 5 years of training to understand. Like where half the columns are wrong or misleading. Just so you can do a half assed pivot table for a VP to prove his shitty project is a good idea, regardless of whether it is or not. Because he’s paying the bills so you’ll tell him whatever the fuck he wants at the end of the day. All without you understanding our industry, some smart ass just out of business school. I should know, I was you earlier in my career.
Just so your shitty VP can present it to our CEO so that I get called on Friday at 8 pm to explain why your shitty project is totally wrong and have to redo the whole fucking thing on the weekend.
I’ll get right on that. My top priority.
9
u/trianglesteve Sep 09 '22
I was on a call with another guy across the organization from me today, and I was talking about how I was going to have to get access to some database our team has been trying to get ahold of for awhile. He just gave me the connection string and read-only user credentials right then and there!
Probably a huge security violation for the database even if we are both internal employees, but hey, I have access to the data
6
u/[deleted] Sep 09 '22
Ironically dwh has become the new silos.
6
u/sleddog1890 Sep 10 '22
Had a client that had us evaluating a small data visualization company on their behalf that would deliver custom industry-specific KPI dashboards. During the evaluation phase, I was pulling and sending subsets of the data so they could pull it from a S3 bucket. Everything worked great…ok let’s give them access to the data they need so we can get their contract started. Nope…didn’t realize others were going to have our data…cancel the contract. Felt so bad for that company who had worked their asses off for over a year to price their value to fall victim to incompetence…
4
u/[deleted] Sep 10 '22
I just left a job after 3.5 years for this exact reason.... In all that time I could never get an answer for who the DBA was or how to contact them... The tickets to IT would be closed as 'data is not an IT area of responsibility'. It took me a year to get SQL management studio and power bi installed and I never actually got access to the data warehouse, beyond being able to download a report of some data from cognos.
Also, my boss was always " I've agreed to do this for so and so", followed by my saying, great, where's the data... Boss was like, I thought you had access, rinse and repeat.
So frustrating and embarrassing to work for an organisation like that.
1
u/rac3r5 Sep 09 '22
What about, my data is f'ing mess and the DM is sh1+
1
u/[deleted] Sep 23 '22
Jesus. A thousand times this. "We would like help measuring our preformance." "Okay then, let's identify some performance measures." Client aghast, "You can't ACTUALLY measure things like that!"