The harsh reality of a Data Analyst job #shorts

The expectations when you start learning about data analytics are far from the reality of what actually happens on the field, let me explain why...

[georgek]

Me brewing coffee at 8am knowing I studied computer science to get paid to make pivot tables in Excel...

[Hawkfeet]

Why i feel that am listening to a bedtime story

Your voice is calm

[TaylorLincoln]

This is the most accurate information I’ve heard in a long time lol. Every single point is so true!!! ❤️

[emilyau]

Yesss Excel is basically the master shifu of data analysis

[stormglass]

Thank you!!! 15 years in BI, also mostly doing advanced SQL, Excel and prototyping to get the requirements right. As he said in the video a lot of time needed to get either access or the right data, because most of the time documentation is not available or outdated and the information you need is in the head of the functional managers. Also no installing software on corporate machines so you are usually stuck with Excel. A lot of companies think they are so innovative and in control, but in the end you're still doing a lot of adhoc requests. SSBI & Analytics is slowly gaining some footing here in NL. So, thank you for this video.

Edit: Something I had trouble with for a long time is people pressuring and stressing me to deliver because of specific deadlines. You work hard, long hours, do the impossible, and then the requester tells you that they totally forgot or it's no longer needed. Or you learn that the request has been laying for weeks on the requester's desk; even legal ones. After such a long time in the industry, I've learned to manage this much better by interrogating the requester basically regarding the deadline and managing expectations. Also, make sure everything has a paper trail (email). 🤟

[BummerSlug]

So true, I will add one final point, stakeholders will want to know everything, all in one visual, at all times, with 100% accuracy, aggregated every way possible. I love my job and all the people I work with over 15 years - but this has been the one thing I have not gotten used to just yet 😂

[ArtAndTechWithNicolas]

Video idea: how to add value to a business in X industry, as a data scientist/analyst.

[azeezakintonde]

Time spent in looking for data set is unimaginable

[TheQueenIsWithin]

I truly believe you. This reminds me so much of my experiences with financial audit. You can spend a lot of time prepping before you being the actual work.

[TheBigBenji]

This is so true, though I'm lucky in that most of my day is spent in Tableau. But there is a lot of working with clients on what questions they want answered, and a lot of the time they think they know what they want when in reality it's something totally different after speaking with them. Love this job though. Never want to give up this career.

[iNinjeek]

Your voice so soothing, it made me feel okay to calm down and listen quietly rather than blasting my volume LOl

[frederickdestinergolden]

I think I've finally found that perfect channel.
Thanks for the precise clarity bro

[julbeeyaren]

I love his voice. So calm and reassuring 🤧

[Everyone___]

I think it also depends on how big and mature (in terms of data) the company is

[SuperAwesomeReasons]

This is very accurate to my experience so far doing data and business analytics.

[karankaul]

Thanks for the info. Just save me from the unreal expectations.

[VisualsofAyan]

There are a lot of videos on YouTube for technical skills so if you create some videos on soft skills such as critical thinking, how to add value etc efc

[vish]

SO many people learn such advance tools but forget the real goat of analytics: Excel. You think you know excel until you start using it to solve problems, I was the exact same. I work as a analyst in a MSO company and let me tell you, please get good in excel first, you dont need to master it but you need to be intermediate at it to land an entry level job. Its very rare you will actually use a lot of python or sql in an entry level position

[Aima]

I manage to avoid using excel in my roll, mostly because I already spent 3 hours clensing my data using code that exporting to excel only to discover that the one date I need but didn't fully clense is stored as such a weird text string excel cannot convert it easily after half an hour of excel manipulation is deeply frustrating- but adding a fix 5 lines above where you were working is simple

[somenmaji]

i simply learned Ms excel and g sheet, got selected for hr analysis. want to point out that learning the other tools is really important