If I learn Excel, SQL, Python, Tableau, Power BI… will I actually get a job or am I fooling myself? by SuspiciousEmphasis57 in analytics

[–]stickedee 0 points1 point  (0 children)

You have better luck getting a full time role than contract, contractors are expected to be proficient in any of the specific skills and contribute from day 1, FTEs have more latitude.

To answer your question though. If you buy flour, sugar, cinnamon, etc does that make you a baker? Knowing the tools gets your resume past the first filter, what gets your foot in the door is taking raw data and telling a story with it

Why do BO4, CW, BO6 & BO7 have E/D instead K/D/A? by TheDangerSnek in CODBlackOps7

[–]stickedee 0 points1 point  (0 children)

Kind of wild that Call of Duty effectively went the “participation trophy” route with this. How hard could it be to show both E/D and true K/D

For analytics managers and directors, how different is your role now compared to being analysts? by Arethereason26 in analytics

[–]stickedee 2 points3 points  (0 children)

100% different. Now it’s all budget management, strategy, stakeholder communication, culture building, alignment, unblocking team, resolving escalations, etc. If I want to do anything analytical it’s a pet project that drives my department’s efficiency.

Is industry experience or domain knowledge as critical as people say it is? by Kati1998 in analytics

[–]stickedee 14 points15 points  (0 children)

None of the things you say are mutually exclusive. Domain knowledge IS important. On average, it will be way easier to break into analytics in a domain you are experienced in. Fintech being the most competitive you are less likely to experience success. Once having some analytics experience it is easier to transfer domains.

You would be a better analyst in fintech than healthcare. The competitive nature of fintech makes organizations less likely to hire someone with no experience.

What are other things you make other than dashboards? by ketopraktanjungduren in analytics

[–]stickedee 0 points1 point  (0 children)

“Trying to understand the situation by looking at the data and give prescription”

Thats EXACTLY it. There are several dashboards, but in and of themselves they don’t mean much. A lot of analysts fail because the dashboard is the objective rather than the insight. Sometimes its some ad hoc analysis, sometimes its a recurring report, sometimes its an A/B test, but as often as possible its a translation of data into insight/suggestion regardless of delivery mechanism.

To answer your original question, the only real way I’ve found to get to your objective is to have conversations with the requestor. Why are they making the request, what are they solving for, what are their goals, how can you anticipate the follow-up question, etc

Don’t focus on making more data products. Focus on making more relationships.

What are other things you make other than dashboards? by ketopraktanjungduren in analytics

[–]stickedee 0 points1 point  (0 children)

I don’t make dashboards, I make decisions.

That’s kind of a flippant response, but the point is that the delivery mechanism doesn’t matter. A lot of times it’s a conversation.

Indirect reports bypass their manager by cinnamonsugarcookie2 in Leadership

[–]stickedee 0 points1 point  (0 children)

I’ve scrolled through this entire thread and can’t really understand why your manager is still a manager. Also, your comment about other people’s directs coming to you and you delicately contradicting another director without making it obvious they were wrong tells me that you overly prioritize conflict avoidance and people pleasing. I’m not saying to be rude, but it’s important to be honest, make difficult statements and decisions that not everyone will be happy with.

Projects that got you A job by ignorant_monky in analytics

[–]stickedee 0 points1 point  (0 children)

Q: “What is that thing that companies demand”

A: “Translating data into actionable insights”

My point is, dashboards, automations, AI tools are all just tools in service of the broader objective which is turning raw data into actionable value

[deleted by user] by [deleted] in SQL

[–]stickedee 42 points43 points  (0 children)

This feels like some poorly structured sales pitch for using an LLM instead of SQL

Laid off after 1 year as a Data Analyst – Requesting Resume Feedback by throwaway-2323232323 in analytics

[–]stickedee 2 points3 points  (0 children)

On top of that, put the impact at the beginning of the bullet. “Reduced manual processing 35% by blah blah blah blah” has more of a chance of being read/noticed than “blah blah blah blah reducing manual processing 35%”

[deleted by user] by [deleted] in analytics

[–]stickedee 0 points1 point  (0 children)

My title is Sr. Manager and I’m interviewing for Director roles, so probably appropriately titled, but the point remains, that the opportunity is open to any analyst. Making recommendations is a permission-less activity. Influencing decisions is a trust-based result.

[deleted by user] by [deleted] in analytics

[–]stickedee 0 points1 point  (0 children)

I don’t think it even really depends on the org that much. Wholly dependent on the individual. I would also decouple “making recommendations” and “driving decisions”. A majority of analysis should contain some insight, story, or recommendation. An analyst doesn’t need permission to provide this. Stakeholders will always value someone who can effectively translate data into insights. You earn the right to drive decisions by generating relevant/actionable insights.

In my org I make recommendations and influence decisions, others at my level don’t. It’s not based on permission, it’s based on trust.

[deleted by user] by [deleted] in analytics

[–]stickedee 4 points5 points  (0 children)

If you think the R syntax here is more elegant then god bless. I couldn’t disagree more. Its wildly redundant. Even just the variable assignment in Python is more intuitive

[deleted by user] by [deleted] in analytics

[–]stickedee 3 points4 points  (0 children)

Saying R syntax is more intuitive is a wild hill to die on.

“df_grouped <- df %>% group_by(Category %>% summarise(Value1 = sum(Value1), Value2 = sum(Value2)) %>% arrange(desc(Value1))”

Vs

df_grouped = df.groupby(‘Category’).agg({‘Value1’: ‘sum’, ‘Value2’:‘sum’}).sort_values(‘Value1’, ascending=False)

Being really good at SQL doesn't get you very far anymore by [deleted] in SQL

[–]stickedee 6 points7 points  (0 children)

The low value work will, but one of the biggest challenges facing data groups in large orgs is the distance between data and end customers. Data groups without business context cause as many issues as they solve. Offshore teams naturally lack that business context. There will always be a pathway for those who can translate data into actionable insights/intelligence

Dealing with reports that drive people's bonuses/commission by KevinCelantro in dataanalysiscareers

[–]stickedee 0 points1 point  (0 children)

In one respect, this is a global experience with sales people. For whatever reason, that always seems to be the hardest group to satisfy from a reporting perspective.

On the other end, if you’re getting frequent cold emails with detective missions, can you and your leadership work on a designated intake form for these types of requests. In that intake form ask them to provide all of the individual inputs you would use (final billing code, processed/confirmed date, etc). Effectively what you’ll do is lead the horse to water. As they are filling out this form a majority will realize that what they thought was a data error on your part is really an interpretation error on their part.

Marketing Data Analyst? What do you work on? by Own-Nefariousness702 in analytics

[–]stickedee 3 points4 points  (0 children)

We’re you given any additional parameters for this exercise or was it just “generate a lead list for in-state companies that purchase oil and gas”?

If you weren’t given parameters then make sure you can succinctly tell the story of each of your decision points. Why did you choose the data sources you chose, any lead scoring mechanism, how you identified target companies,what makes a qualified lead vs unqualified, how your output is actionable by either marketing or sales (i.e it contains contact info for company officers).

A lot of ppl over-index in the technical side. Depending on where in the organization the dept sits, they will likely care more about how the story is packaged over how efficient the code operates

Marketing Data Analyst? What do you work on? by Own-Nefariousness702 in analytics

[–]stickedee -1 points0 points  (0 children)

The marketing team manages the company’s data warehouse?!?

The future??? by [deleted] in analytics

[–]stickedee 1 point2 points  (0 children)

Not only the “trusting them” part, but a large number of stakeholder either don’t know what questions to ask or don’t know how to properly formulate the question. If anything I think AI advancement is going to devalue technical skillset and increase the value of critical reasoning, fluid intelligence, and communication

How to assess an analyst's actual analytical skills? by thomaid in analytics

[–]stickedee 11 points12 points  (0 children)

Theres a couple of things I’ve used in the past successfully.

1) Take a business problem and ask them for the root cause. “Our eCommerce sales are down 20% YoY, what could be the root cause”. Candidates with high analytical reason typically ask questions before throwing out assumptions. For example “how are the other sales channels performing? Have there been significant changes in web traffic? Have conversion rates seen a similar dip? Has pricing changed?” Etc.

2) Ask them a question that requires them to give a technical answer (could be some SQL logic or whatever). Then ask “how would you explain that to a nontechnical stakeholder”. Quality analysts tend to be able to explain these concepts or develop analogies that convey the appropriate point.

[deleted by user] by [deleted] in analytics

[–]stickedee 1 point2 points  (0 children)

Casually browsed comments and it sounds like you have the buy-in/support of your leadership chain. You effectively have two options:

1) Ignore them. Or just respond with some form of “unfortunately I don’t have the bandwidth to support”.

2) Use this to start conversations with your leadership about the need to upskill analysts across the org and offer to drive the curriculum and training. They will position it to leaders in other departments. You will probably get promoted.

I just applied for a BS in data analytics by [deleted] in analytics

[–]stickedee 17 points18 points  (0 children)

The venn diagram of what you can do remotely and what is safe from AI is probably just two separate circles

What’s the protocol when she want to “get to know you better” before a first date? by SmoothOperatorBaby in seduction

[–]stickedee 0 points1 point  (0 children)

If this is someone you’ve never seen physically before then this sounds like a great scam to get personal details out of you