What do data analysts DO?! Here's a project walkthrough for an entry level data analyst! This goes b

DA here, you skipped the part where: 1. Your boss never asks you a question that direct. It’s usually vague and you have to develop an interrogation technique to get that info out of them. 2. Oh wouldn’t it be so nice if all the data was in one table, never is, never clean, and has a bunch of acronyms that have 0 documentation. 3. Please, please do not just do a select * of everything, you see there are these things called querying/computation costs which will make your data engineer pull their hair out. 4. And finally, once you provide the analysis in a nice dashboard with filters and visuals, your boss will say “nice, can you get me that on excel”

Once you fetch the data..it can be fun building dashboards on tableau especially..love the user interface...turning all that data into colourful charts is awesome..

Yeh, but the reality is usually more like... "what were our sales numbers last year, the data's spread across 3 databases because of the tech migration last year, and Aaron in finance thinks there's been double tracking since we rolled out GA4, so can you iron that out and reduce the total to account for the average value of order returns, but only for new customers, from France."

The comment section is waaaay more informative than the video. Thanks for putting the video, i got soo many answers from the comment section

At this rate, I think I just want to flip burgers for a living.

Now if only entry level/ junior positions still existed

i came here to find out whether i wanna be a business or a data analyst, and i choose databases over human interactions every day ty, all i needed

ehhhhm nope, this kind of tasks would go to the junior data analyst to see if they can use a computer

Just.... ask the accountants for the figures.

Imagine all this data presented in Japanese corporate reports with explanations and business strategies. My job is to translate it all. I've had days where I could stop for 36 hours straight due to tight deadlines and suddenly having more work piled on. Most days are between 12 and 18 hours.

I am just switching my career into data analysis. I have started learning SQL, Power BI, Excel, and Tableau. This short video was helpful for me to know about the non-technological part of this job i.e., something not related to tools and answering "why" and not "how." I needed a mix of both. Subscribing the channel! 👍

Haha...here's a tip from a data analyst at a top 5 tech company. Literally, as part of my annual evaluation, 75% of my job is interacting with stakeholders. Learn softskills and be curious.

I'm working through a SQL workbook right now. My problem is my schedule is so hectic that I usually have a week or 2 on and a week or 2 off studying, and every time I go a few days off I feel like I forget everything.

Sounds like the career for me! I understand this is an entry level example but doing this from home sounds like bliss

This is exactly what i was looking for, thank you!

Or just log into your CRM and it’s literally in the sales dashboard which is the first thing you’ll see.

Lol leaving the payment info (credit card numbers) visible is top tier. Gonna go order me a new pair of boots!

great tip! Thanks for sharing your insights.

Yeah cause Oracle tables are always clearly named with logical joins

You missed the part where you realize this table has none of the variables your looking for, so you have to spend time investigating how these tables and fields are calculated. Then spend more time validating than actually generating the report. Oh yea, last step: realize the new variables you cane up with don't align with what youd expect to see in the validation phase so you return back the the analysis phase and repeat the process. One additional step for extra credit: Turn the project in to the necessary stakeholders, and get asked for additional requirements that are out of scope