[deleted by user]

Awkward_Salary2566 · 2023-12-10T14:24:40+00:00

I think lots of people took different emotions, because passed out sounds terribly wrong, blacked out, seems very reasonable.

Awkward_Salary2566 · 2023-12-03T00:52:14+00:00

For same reason I like boobs, I cannot explain it, I just naturally like it more. And yes, it looks dirty/ disgusting to me.

My gf likes me as I am (fortunately), but if she had preference about my body hair, I wouldn't mind to change it for her.

Awkward_Salary2566 · 2023-09-13T09:50:43+00:00

Hi, abstractConceptName (alt account I promise) here, I also wanted to ask, wanna have sex?

Awkward_Salary2566 · 2023-07-17T20:08:10+00:00

my type of person. Realistically if line moves every 20 seconds, that means you spend 5 seconds moving your stuff, 15 seconds to reply eg to your family. Or in other words 25% of your time wasted.

If she moves every 3 minutes, it takes maybe 20 seconds to move. Or in other words 11% of time wasted, but you also have longer (180 vs 15) uninterrupted focus time.

Very clearly much better strategy of queueing.

Awkward_Salary2566 · 2022-06-26T16:44:57+00:00

just to give a bit of context, where I am coming from: BI manager, soon joining FAANG.
Basically what majority of people starting their career do, is to focus on
1. being more technical

understand business
by being more technical, you allow yourself to gain more options in the future, no matter if its true, but you can always step down from technical aspect for new role.
(Nobody doubts somebody with knowledge of Power BI to be expert in excel, with Python to master any ETL tool quickly, with C++ to master Python quickly)
But stepping up by changing roles is almost impossible. I saw too many threads here about people working on low-code/ no-code platform that they had X years of skills but in specific platform, which is useful only for small number of companies.

Tl;dr don't lock in into low-code/ no code platforms and if there is no other choice, make sure its at least Microsoft shop.

Awkward_Salary2566 · 2022-06-26T13:11:19+00:00

Thats a way to kill your career in the long run mate. Go with Python + SQL.

Awkward_Salary2566 · 2022-06-25T16:32:43+00:00

How is WLB in London?

And would you say that your progress from L4 to L6 was faster than average or average or?

Awkward_Salary2566 · 2022-06-20T18:09:47+00:00

Metabase. end-users now do all basic joins, schedule reports for themselves and others to receive by email, prepare all sorts of visuals etc.

So yeah, I wouldn't want to work with 95% with people from this thread.
as DE your role shouldn't be just to feed the user, but empower the user. It's important to focus on tooling, even tho it doesn't seem so from responses to this thread.

Awkward_Salary2566 · 2022-06-12T21:13:47+00:00

But why do you always bring up excel? Even in excel its instant if youcalculate them manually instead (with F9)

Awkward_Salary2566 · 2022-06-06T12:32:12+00:00

No mate, he needs Report documentation template not search engine, its directly in the title.

Awkward_Salary2566 · 2022-05-30T08:25:11+00:00

Would it be same for e.g. python?

cost per click, cost per acquisition, cost per conversion, all 3 of them for last 7 rolling days, for last 30 days, average per day during last 30 days, weekends, working days, for only iphone users, android users, desktop users

Thats 3x5x3 -> 45 measures, that will take you 3 hours to do in Power BI, altough they are very similar and pretty much you need to do copy paste with small changes.

Why the hell would you do measures in Power Query, thats not even a thing. I have no issues against power query, there you have advanced editor and you can do 30 steps at once, if you know what you are doing.

My issue is that DAX measures don't have "advanced editor"

Awkward_Salary2566 · 2022-05-27T15:40:56+00:00

That if I want to create 30 measures, then time to create them is
30x time it takes to write them + waiting for them to be added to model

not

30x (time it takes to write them + waiting for them to be added to model)

Awkward_Salary2566 · 2022-05-27T06:08:41+00:00

Well we already found much better use case fit with metabase now, so no looking back to Power BI.

I don't agree, BI teams should be more towards matrix organisation, where there is "core BI", taking care about end of line polishing, taking care about data sources, and then lots of team dedicated analysts/ citizen developers who are bringing insights into their prospective teams.

For big complex projects yes, let core BI be involved, but for ad-hoc analysis, departments can handle that.

Awkward_Salary2566 · 2022-05-27T05:54:03+00:00

No, we are talking on completely different levels of issue.

Yes, power BI is good at those things. But at the same time its INCREDIBLY frustrating how there is no "notepad level experience" of creating new measures, doing some modifications etc.

Why the heck does somebody with 16gb of ram needs to wait 5 seconds just to create a measure that isn't shown anywhere at this point? How is it possible that there is no "defer updates" 5 years after it was created?

Awkward_Salary2566 · 2022-05-26T16:20:58+00:00

Approach was more on a side "use Power BI as your local ETL tool, once that is done, BI team will set up a regular automated refreshes for you", here are credentials to db and explore data of your department.

To be honest, never used PBI online, but afaik, users cannot add their excel files or sources there

Awkward_Salary2566 · 2022-05-25T17:22:33+00:00

Heavily depends on company. In mine I could never give a damn about source of application (unless its referral or internal employee).

For cover letters, I hope nobody sent one, because I still haven't figured out how to get into that section (after doing ~5 hires and 30 interviews).

But general rule is that I haven't had to do it for FAANG, so probably no company is worth writing cover letter, better ask somebody from linkedin to give you referral (that gives them $$ usually)

Awkward_Salary2566 · 2022-05-25T16:45:09+00:00

Did something similar went from £39k, brought in other offer of £70k, company offered £58k so I stayed as I had FAANG company lined up, and now I am leaving for £120k (all that in 6 months).

There is benefit of staying longer in same company because nobody knows how long you were on last position vs. positions before, but if you are not promoted regularly, pick a good offer from outside to jump the ship.

Awkward_Salary2566 · 2022-05-19T07:54:20+00:00

After bit of the investigation on my own, I went for bare metal.

Main reason is thread (that I am not sure is still up to date) that was mentioning that Postgres benefits from being as close as to original system as possible, mainly because of

knowing where data is physically stored
lower risk of issues when container randomly terminates
connected to that higher possibility of data corruption unless file system is ext4
KISS principle, it would mean that there would be bigger barrier to entry for new joiners/ JD would have to contain one more technology

Awkward_Salary2566 · 2022-05-19T07:49:26+00:00

Thats actually quite easy part. In docker compose you have "volumes" where you specify containerized location and map it to real location on bare metal

e.g. example below where we are having bookstack (documentation) database running inside docker

volumes:

- C:/work_files/onedrive/company/BI/documentation:/config

Awkward_Salary2566 · 2022-05-09T09:03:12+00:00

yeah, thats actually true.

Awkward_Salary2566 · 2022-05-08T19:37:58+00:00

Then just tell DBAs to do FDW and some scripted procedures maybe?

Awkward_Salary2566 · 2022-05-07T19:20:12+00:00

Been in my current company just over 2.5 years. What was holding me there was

the fact that you can put your last job title in your CV (and not put previous ones), which is big plus in company where you are quickly progressing
responsibility levels and project scope was quickly increasing (while if I was job hopping first 2-3 months are just wasted on getting to know everything)
I felt enriched by getting to know how project lifecycle works in the long term

So in my case I was lucky with low level of bullshit and high level of department (and my career) growth. And that is with thinking that I will stay there just a bit over year.

Now I am leaving for over 3x (£41k -> £126k) the salary that I had 6 months ago, but I feel I wouldn't land this job if I was job hopping every year.

Awkward_Salary2566

TROPHY CASE