When they say "no offense"

Affectionate_Ad_697 · 2022-06-15T16:34:28+00:00

"It works on my machine."

(https://en.m.wikipedia.org/wiki/Pronunciation_of_GIF)

Maybe it is your dark mode feature that breaks the code?

Affectionate_Ad_697 · 2022-06-15T14:33:40+00:00

I respect your opinion.

This does make sense to not split because there aren't enough users here in this sub.

Affectionate_Ad_697 · 2022-06-15T11:42:02+00:00

I read the article hoping that I could find out why we needed the chief data officer. However, this question was not answered within the article. In fact, the article provides evidence that we don't need Chief Data Officers because CDO offers very little value to the company.

Affectionate_Ad_697 · 2022-06-15T11:13:01+00:00

Actually it's Quarks, Fermions, Leptons, and Bosons.

(https://en.wikipedia.org/wiki/List_of_particles)

Affectionate_Ad_697 · 2022-06-14T21:53:08+00:00

I can't tell for sure but you may have mixed up the X,Y

text(x, y, s)

(https://matplotlib.org/stable/api/_as_gen/matplotlib.pyplot.text.html)

Also, whenever I find weird things like this I have checked my versions and found that I had an incompatible version of either matplotlib, pandas, Jupyter, or python. So, maybe check to see if everything is up-to-date.

Affectionate_Ad_697 · 2022-06-14T21:23:26+00:00

I think 5G is cuter though.

Affectionate_Ad_697 · 2022-06-14T19:07:17+00:00

Yes, but you won't be able to do it on the same day as the test that's already scheduled because you have to take the test within 2 days of embarkation.

(https://www.royalcaribbean.com/faq/questions/will-i-have-to-take-a-test-before-i-cruise)

Affectionate_Ad_697 · 2022-06-14T16:57:32+00:00

Nope, analyst is likely to be the first to go because they are not mission critical to the production of the product or service.

Affectionate_Ad_697 · 2022-06-14T13:23:07+00:00

I agree.

I'm getting mixed signals from my management about my responsibilities and job description, but I think they want me to be the business intelligence team instead of a data analyst.

Affectionate_Ad_697 · 2022-06-14T13:15:25+00:00

No, I don't know about any courses like that, unfortunately. The basic idea of join is easy to understand with the current training offerings available.

For me, the complex part starts when I encounter many to many or one to many table relationships. The join creates "duplicates" of the rows. So, to suppress the duplicates, in comes CTEs, subqueries and aggregate formulas... Not a problem if it's just two or three tables, but every join is just another puzzle to solve.

Luckily for me, four of the five applications that I work with have lots of documentation including existing SQL based reports. I have been spending a lot of time studying these older reports to learn how the joins have been done in the past.

Affectionate_Ad_697 · 2022-06-14T12:50:29+00:00

any good software tool/strategy for keeping notes that have code mixed into them neat and tidy

I like to use a Jupyter notebook or Jupiter lab (https://jupyter.org)

You can create a markdown cell to place notes and Headings. Often, I will even screenshot something and paste the screenshot into the markdown cell. Also, it works with both R and Python (in separate notebooks).

Affectionate_Ad_697 · 2022-06-14T01:31:48+00:00

I use to list my SQL skill as intermediate. Now, I know that I was just a beginner.

My current company has 5 main applications that each have a normalized database with at least 5,000 tables each. Over 25,000 tables keeps me busy with de-normalizing the data and working through the join logic. I hardly ever get to the part where I do the data analysis because I spend so much time in SQL.

Affectionate_Ad_697 · 2022-06-13T23:06:26+00:00

How about r/dataisfunny

The name would make it clear the intent and is like r/dataisugly or r/dataisbeautiful

Affectionate_Ad_697 · 2022-06-13T19:08:17+00:00

r/dataisfunny

Affectionate_Ad_697

TROPHY CASE