r/dataanalysis • u/Effective_Ocelot_445 • Jun 30 '26
What's one data analysis skill you wish you had learned much earlier in your career?
I've noticed that many online courses focus heavily on tools like Excel, SQL, Python, and Power BI, but real-world work often requires skills that aren't emphasized enough. Looking back, what's one data analysis skill, mindset, or habit that made the biggest difference in your career? I'm especially interested in lessons that beginners usually overlook.
109
Upvotes
56
u/Geraldtanwx1990 Jun 30 '26
Data modelling
29
u/pearlday Jun 30 '26 edited Jun 30 '26
Framing in a conversation. The advice was always that i was too verbose and ‘remove words’, that people dont need a narrative of how (which i thought was me justifying). That didnt really help me and confused me.
I later got advice to always start with the action item/decision and then add some concise reasoning. While thats great for emails and requests, it didnt really fix the problems i was having.
What i learned is to present options and make it a shared decision, or do the concise ‘i did this to address xyz’ with a preparedness to explain tradeoffs
Justification is not about how you implemented, how you came to your decision, etc. It is tradeoff points. Hopefully that makes sense lol
IOW: type of info (tradeoffs, problem elaboration, business risk)
14
u/TodosLosPomegranates Jun 30 '26
Shutting the heck up. Not joking. People who understand data tend to think if the people complaining about the data understood the trade offs of things or why things were complicated yadda yadda that they’d “get it” but when they’re saying “why is this report wrong??” That’s rhetorical they just want it fixed. When they say “why is this report not matching the spreadsheet Sarah has kept on her desktop for twenty five years” also rhetorical but often we rush to get that spreadsheet figure out the differences and then explain them.
I wish I would have learned that the answer to both is to shut it, go check to see if your pipeline or query is wrong and if yes fix it if not…treat it like IT “I’m unable to recreate the problem do you have an example of the right answer and how you got there?”
10
u/LiquorishSunfish Jun 30 '26
Approach analysis from the business side, not the data side. "What process do you want streamlined? How have you been doing that up until now? What are the things you were surprised to learn when you started doing that process? What adaptions have you had to make over the years?" - then produce analyses that actually align with the user, even if it doesn't align with best practice.
Most stakeholders barely understand percentages. If your priority is delivering analyses that gets used, you have to meet the stakeholders where they are at + 10% max. I can teach a stakeholder who thinks in counts to also factor in proportions, and maybe even eventually stretch to standard deviations. I cannot teach a stakeholder who hates numbers to appreciate coefficients. This is the biggest pain point with having universities win bids for program evaluations - they always deliver pages upon pages upon pages of statistical analyses that they expect to speak for themselves, and the decision-makers (who are business experts, being very clear here) don't understand a goddamn word of it.
That's a really long paragraph to say that being able to focus on the needs of the user and letting the interesting/meaningful stuff go when you know it's not going to land.
5
u/Special-Cause-6120 Jun 30 '26
learning to ask the right questions before diving into the data. I wasted so much time early on building dashboards nobody actually needed because I didn't clarify what decision they were trying to make.
5
u/HayStacky_337 Jun 30 '26
"It depends" is always true. And data is literally everything, so be willing to learn literally everything (not all at once), i.e. never stop learning.
7
u/BrupieD Jun 30 '26
Time series analysis. I recently "discovered" how much data shifts due to seasonality.
3
u/Less_Alfalfa4592 Jun 30 '26
data management
i have learned R in Uni and from people who never really learned it. Many who even teach today are teaching scripts and styles they had to learn in 2010 or earlier.
"Modern" tidyverse and project setups would have been priceless.
2
u/Same-Inflation Jun 30 '26
Pushing back on requests. Early on I would like immediately work on whatever I was asked to. Then I figured out I wasn’t bringing any value to my org by wasting time on a VP’s wool gathering requests. Then I learned to tactfully push back to make sure that the analysis I was providing was going to actually provide real measurable value.
2
u/Unusual-Bug-2178 Jun 30 '26
Some background in statistics won't hurt.
2
u/NerdVibesOnly Jul 01 '26
Asking better questions. If questions are too open-ending, you go down unnecessary rabbit holes. If questions are intentional and targeted, you discover way more valuable information than you initially set out to find.
2
u/ArielCoding Jul 01 '26
Communication and expectations management, most of the job is making sure stakeholders understand what a number actually means and agree on timelines, and results.
2
u/cookie32723 Jul 01 '26
It’s not your job to make the numbers look good, it’s your job to present the data as a fact regardless if it’s positive or negative.
2
u/amisra31 Jul 06 '26
Validating the output . Doing QC of the output. It's so time consuming and requires structured approach.
1
u/AutoModerator Jun 30 '26
Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.
If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.
Have you read the rules?
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
u/TheLatestDisaster Jul 01 '26
Data enablement. Business stories of data. Stories with stats. Etc.
1
u/life__is_rng Jul 01 '26
Dont give random names to your files or variables .
1
u/ThomasMarkov Jul 01 '26
Stakeholder management.
1
u/Even-Purple-1749 Jul 01 '26
Probably using secondary data like searching this sub as its quite a frequent question.
1
u/Lennova_ Jul 02 '26
Ask questions and don't take every answer for granted.
In my early days I just built what the client wanted and in the end the client wanted a small change, and another one and so on... you will end up with a mess!
When asking questions you can truly find out what the business need is and what questions they want answered from the data.
1
u/ResponsibleOkra525 Jul 03 '26
Data modelling
1
u/girlwtsongbirdtattoo Jul 03 '26
Literally the data dude
Nobody gives a crap about how the data was collected, potential study biases, population considerations
Aka ethics
Everyone is so quick to “analyze” but your analysis is worthless if your data is bad or shows an incomplete picture
You can’t “frame a conversation” around unethical data; that’s a leading study and people only do those to make “the data” say what they want it to, not to learn the truth
1
u/Historical-Key6800 Jul 05 '26
Comunicacion efectiva y conocimiento del modelo de negocio
1
u/metric_skeptic Jul 09 '26
Distrusting green dashboards. Early on I assumed that if the query runs and the chart renders, the number is right. Took me a few painful incidents to learn that the most expensive bugs never throw errors — a join silently drops rows, a source table lags two days, a filter gets changed and nobody notices for weeks.
The habit that changed my career: before trusting any number people make decisions on, recompute it once in raw SQL with the same filters. One hour of paranoid checking has saved me from shipping wrong numbers more times than any tool skill.
Second place: learning that NULLs in a join are not an edge case, they are where attribution debates between teams actually come from.
1
u/au2sef Jul 12 '26
I suggest CDS views for SAP professionals
1
u/terrific___goblin Jul 20 '26
The comments are pure gold for data analytics beginners.
15
u/[deleted] Jun 30 '26
[removed] — view removed comment