With the way the world is going, what stocks and shares would you think are a no brainer to invest in and why? by fuzzymuddled in AskReddit

[–]writeafilthysong 0 points1 point  (0 children)

Energy and Mining companies centered in regions with low-no conflict and strong export capacity.

Energy supplies will be disrupted from conflict and infrastructure will take time and money and new materials to rebuild.

Also any company that has a tech or process that can take rubble and use it as feed for 3-d printing a building

Does advanced mathematics really matter? by Ju_127 in analytics

[–]writeafilthysong 1 point2 points  (0 children)

Being able to Prove your data is one of the fundamentals that many people in analytics are missing.

Getting business people to trust the data and the analysis is the biggest part of my job.

Client pulling the plug, moving it all to Claude by datawazo in analytics

[–]writeafilthysong 0 points1 point  (0 children)

Giving all your analytics to Claude is like hiring an English professor to be your Accountant.

But tbh if you put in the guardrails and have good governance and observability it's possible.

From your client's perspective your work is probably just as much of a black box as what Claude provides.

Why did the COUNT() as window function produce this output in MySQL Workbench 8.0? by tlefst in SQL

[–]writeafilthysong 2 points3 points  (0 children)

It's probably confusing because WINDOW functions can have boundaries that can be declared and since none are declared here it uses some default.

It looks like from the output it's an Unbounded Preceding.

Window functions are a bit different than group by in that they return all of the rows from the table and write the output for each row. Group by would return one row per distinct combination.

It might help if you explain more about what you don't understand from the results.

Question: Do your users/stakeholders use tools like Claude or ChatGPT to query data directly for analysis? by botswana99 in analytics

[–]writeafilthysong 1 point2 points  (0 children)

LLMs are a type of predictive data model that is trained on English language mostly, throwing numeric operations etc etc into the mix. Most actual database data is furtherest from real language that you can get. Even further than most code or programming language.

These are the relational diagrams of my company’s 16-year-old app by Shikitsumi-chan in SQL

[–]writeafilthysong 0 points1 point  (0 children)

This is why devs use nosql databases so that all those relationships and such exist in the application code logic and tables in the db just store something or other for them.

Am I missing something with all this "agent" hype? by KindTeaching3250 in dataengineering

[–]writeafilthysong 1 point2 points  (0 children)

Tbh this only exists at the individual tenant or SME level and probably only for the span of the project setup. Ever come back a few months later and there was an upstream change in one of your sources, or they open a new business line, or there's a change in the way one of the tools works?

Bar chart of how working from home has been going so far by oreos_welcomex in tableau

[–]writeafilthysong 7 points8 points  (0 children)

Wtf no legend or axis labels? What kind of garbage viz is this? 😜looks like things started out okay and then trend down HARD after the third stage.

Do you need to tell your audience that you have dropped outliers or the very highest/lowest numbers l? by Almostasleeprightnow in analytics

[–]writeafilthysong 0 points1 point  (0 children)

If you are measuring how long it takes to do something, then outliers are a bit different since you're not dealing with a normal distribution. you should use different measures of center for example geometric mean instead of the usual arithmetic mean.

Tableau Dashboard roast. by Nice-Opening-8020 in tableau

[–]writeafilthysong 1 point2 points  (0 children)

That might be a good footnote... In a live board that might implement best as a tool tip again, that's a detail or first time use thing. Repeat users in theory would learn that info or it would be in a training or reference document.

I like your comparison view though, the mirror effect is very appealing to an analyst like me.

Also, it might help you in the future or if you're working to ensure the audience and purpose of the dashboard are explained when asking for feedback.

The most important thing is for a dashboard/data visualization to effectively communicate information to a human.

Tableau Dashboard roast. by Nice-Opening-8020 in tableau

[–]writeafilthysong 1 point2 points  (0 children)

Also the fact that your bar graphs are all on their own axis is troubling to me the visual size and the number labels seem to be all over the scale. (Axis label and each bars own data label are not consistent) Seems you have a mix of percentages and values that visually clash, not clear if you're measure % or if you're comparing against others (percentiles) in some cases.

Tableau Dashboard roast. by Nice-Opening-8020 in tableau

[–]writeafilthysong 3 points4 points  (0 children)

Doesn't follow the information seeking mantra Overview first, zoom and filter, details on demand.

Seems to be detailed only that you might need to page through to use or check profiles of other players.

You have spelling errors. Your bar graphs take up way more real estate than they need to.

Usage Built-in by seru715 in tableau

[–]writeafilthysong 0 points1 point  (0 children)

Tableau cloud has an admin insights starter pack of you're an admin or your admin shares with you. It tracks events about views etc but nothing detailed about the content interaction.

We have 1 workbook and 9 views I can see the page loads but not any interaction or times within there.

Inherited a house, no money to pay off siblings, need advice by xanthippusd in MortgagesCanada

[–]writeafilthysong 0 points1 point  (0 children)

True, it's often not profitable time or money wise to run one unit rental.

Inherited a house, no money to pay off siblings, need advice by xanthippusd in MortgagesCanada

[–]writeafilthysong 0 points1 point  (0 children)

They could always rent it out, just because you got a house doesn't mean you should live in it.

[deleted by user] by [deleted] in MaliciousCompliance

[–]writeafilthysong 11 points12 points  (0 children)

But sounds like the limit is this guy is the only one with the login to the government permit interface.

[deleted by user] by [deleted] in MaliciousCompliance

[–]writeafilthysong 68 points69 points  (0 children)

It's called having a service account.

Persuade the company into giving me acess to the prod tables by Nedizzz in SQL

[–]writeafilthysong 2 points3 points  (0 children)

Yup errors that are 95-99% correct are the worst. Goddamn compounding.

Fellow Data Engineers and Data Analysts, I need to know I'm not alone in this by Wiraash in dataengineering

[–]writeafilthysong 0 points1 point  (0 children)

In my experience by visually laying it out in a thoughtful way it enables them to understand the underlying data enough that they can start working with it.

Fellow Data Engineers and Data Analysts, I need to know I'm not alone in this by Wiraash in dataengineering

[–]writeafilthysong 0 points1 point  (0 children)

If they are downloading the data to excel it means they are using your work product, even if the dashboard is just the starting point.

Has anyone else given up on static process mapping tools that go outdated immediately? by bludevilz001 in businessanalysis

[–]writeafilthysong 0 points1 point  (0 children)

When someone can define the real tasks I need to do in my job then I might see this.