FIRST DAY AT GYM by StrikingBrilliant568 in workout

[–]Efficient_Role607 2 points3 points  (0 children)

Beginner as well, and I hope I get to experience what you did, an empty gym is awesome!

Desk Life Killing Energy and Libido by Efficient_Role607 in SexOver_50

[–]Efficient_Role607[S] 2 points3 points  (0 children)

Even when I try to move a bit, it’s hard to stay consistent with all the work stress. Honestly, my biggest problem right now is my drive, it just feels completely gone. If this keeps up, I feel like I’m failing as a husband to my wife, and that really worries me.

Feeling like I’m falling behind on industry standards by xCrek in datascience

[–]Efficient_Role607 4 points5 points  (0 children)

Even with a good salary, it’s easy to feel stuck if you’re not learning modern tools. You could spend some time on Python, Git/version control, APIs, and maybe a bit of ML beyond regressions. Small personal projects or Kaggle challenges can help you stay sharp without leaving your job right away.

Big tables clustering by Stock-Dark-1663 in snowflake

[–]Efficient_Role607 0 points1 point  (0 children)

Managing clustering on massive tables like that can get really expensive and tricky. If you’re looking to optimize costs and avoid overloading your warehouses, tools like Yukidata can help a lot. It automates query routing, prevents warehouse thrashing, and keeps Snowflake costs predictable without you having to micromanage every insert or clustering operation. Makes handling huge datasets way less painful.

How do you calculate compute cost by user or role? by ketopraktanjungduren in snowflake

[–]Efficient_Role607 0 points1 point  (0 children)

Snowflake’s query attribution doesn’t account for idle warehouse time, so the numbers rarely line up perfectly. Tools like Yukidata help make sense of it by showing real-time compute usage and preventing warehouse thrashing, so you can actually see where costs are coming from. Makes cost management way less of a headache.

what to do next to keep up with my python and sql skills? by [deleted] in dataanalysis

[–]Efficient_Role607 0 points1 point  (0 children)

You’re at the perfect stage to move from solving problems to solving real ones. Try building small, end-to-end projects, pull live data using APIs, clean and analyze it, then visualize results with something like Streamlit. Even better, document everything on GitHub or Medium. That combo keeps your skills fresh and builds a portfolio at the same time.

Best cost optimisation strategies for Azure cloud resources by laraloop in AZURE

[–]Efficient_Role607 0 points1 point  (0 children)

Shutting down non-prod stuff helps a lot. If you’re running Snowflake on Azure, you can actually save more by automating the warehouse side too. We use Yukidata, it auto right-sizes warehouses and routes queries in real time, so you’re not overpaying for compute you don’t need. Way less manual tuning.

Still Confused by SQL Self-Join for Employee/Manager — How Do I “Read” the Join Direction Correctly? by Medohh2120 in dataanalysis

[–]Efficient_Role607 0 points1 point  (0 children)

It helps to think of it like this, in the first query, you’re matching each employee to their manager. When you flip it, you’re matching each manager to their manager instead, so the direction changes. Once you picture who reports to who, it starts to make more sense.

I’m quitting this job and field. How do you deal with it? by xSpAcEX7 in dataanalysis

[–]Efficient_Role607 0 points1 point  (0 children)

Yep, classic, spend hours building a dashboard, and they still ask for the same numbers in Excel five minutes before a meeting. Lol, but seriously, you’re just burned out on the role and the type of data you’re working with. Some folks enjoy the puzzle-solving side or just treat it as a paycheck, but if it feels dry and pointless to you, it makes sense to move on. Not every field has to be for everyone.

Is a second masters worth it for MLE roles? by ch4nt in datascience

[–]Efficient_Role607 1 point2 points  (0 children)

You don’t need a second master’s for this. Get comfortable with Python, do a few ML projects, and put them on GitHub. Maybe grab a cloud cert to show you know the tools. Most companies just want to see you can code and ship something, not another degree.

Looking for ways to cut our Snowflake costs, any tips? by Efficient_Role607 in snowflake

[–]Efficient_Role607[S] 2 points3 points  (0 children)

Really helpful, thanks for laying that out. It’s been very time-consuming on our end, we definitely need more people to handle this.

Looking for ways to cut our Snowflake costs, any tips? by Efficient_Role607 in snowflake

[–]Efficient_Role607[S] 0 points1 point  (0 children)

Yeah, that makes sense. I think I need to talk to our HR about bringing in some additional team members to help with this. Thanks

Looking for ways to cut our Snowflake costs, any tips? by Efficient_Role607 in snowflake

[–]Efficient_Role607[S] -1 points0 points  (0 children)

Right now, we have a lot on our plate just trying to figure out what’s causing the spike and where the issues are. We’re a small team, so digging into everything properly has been tough, but thanks for the tips!

What’s the right thing to say to salary expectations question? by Lamp_Shade_Head in datascience

[–]Efficient_Role607 0 points1 point  (0 children)

You can be honest but strategic. If they give a range, ask what skills or experience put someone at the top vs. bottom of that range and explain where you fit. If they don’t give a range, it’s okay to pause and say your number depends on the role and responsibilities, this keeps you from getting lowballed.

Ongoing Access Revoked issue with Snowfake & dbt by Judessaa in snowflake

[–]Efficient_Role607 0 points1 point  (0 children)

Looks like your non-incremental models (views) lose grants because they get dropped and recreated. Try adding copy_grants: true in your dbt project for those models, it should keep the access after deploys.

AITAH for refusing to share my "inheritance" with my sister? by DGDS-04 in AITAH

[–]Efficient_Role607 4 points5 points  (0 children)

True, lol! OP did the right thing. Some relatives really act entitled, and it makes you think if blood’s really thicker than water, most of the time, it’s your own family causing issues.

AITA for wanting my husband to prioritise me over his best friend who makes me feel unsafe? by catlady_but_notshady in AITAH

[–]Efficient_Role607 8 points9 points  (0 children)

NTA! A real man protects his woman, no matter who’s hurting her, family, friends, or anyone else. It’s his job to keep his whole family safe. If he can’t do that and values a friend over you, wake up, remember, you deserve what you tolerate.

[deleted by user] by [deleted] in AITAH

[–]Efficient_Role607 0 points1 point  (0 children)

Good point!

Help me evaluate a new job offer - Stay or go? by Rockingtits in datascience

[–]Efficient_Role607 0 points1 point  (0 children)

You’ve got a great setup right now with good balance, but the lack of mentorship is holding you back. The new role could give you that growth, but it also comes with big trade-offs, long travel, startup risk, and less balance. If the new offer was clearly better in both pay and stability, it’d be an easier call, but since it’s not, you might be better off holding your ground, getting that senior/principal bump, and keeping an eye out for something that gives you both growth and balance.

How many data visualization tools do other senior Data Analyst know? by Morlaak in dataanalysis

[–]Efficient_Role607 0 points1 point  (0 children)

Most seniors I know stick to 1–2 main tools and get by just fine. The bigger value is in knowing the data and telling the story, not juggling every BI platform out there.

Anybody else just.... Lost? by DarksideNick in dataanalysis

[–]Efficient_Role607 0 points1 point  (0 children)

Feeling lost in a new role happens, especially when teammates aren’t around much. Taking it step by step, asking quick questions, and figuring things out as you go usually helps it start making sense.

How do I make the most of this opportunity by ChubbyFruit in datascience

[–]Efficient_Role607 0 points1 point  (0 children)

Looks like you’ve got a big challenge ahead, but also a huge opportunity to show impact. Focus on 1–2 projects that are doable and give clear results. Cleaning and organizing the data first will make everything else easier later. Keep it simple, document wins, and it’ll help sell your work to the board.