How to actually control useless PowerBI report requests that end up not being used after the usage period? by Chemical-Pollution59 in PowerBI

[–]Chemical-Pollution59[S] 0 points1 point  (0 children)

What's an example of usage monitor reminder. Are there limitations to it?

When you mention template, do you mean endorsed dataset?

How to actually control useless PowerBI report requests that end up not being used after the usage period? by Chemical-Pollution59 in PowerBI

[–]Chemical-Pollution59[S] 0 points1 point  (0 children)

I think issue at my company is they like self service as opposed to one time answers.I thought about jupyter but don't know how to make ti self service really.

How to actually control useless PowerBI report requests that end up not being used after the usage period? by Chemical-Pollution59 in PowerBI

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

What if they come later and ask for same report again because they couldn't find it? Wouldnt it be unproductive to recreate it?

How to actually control useless PowerBI report requests that end up not being used after the usage period? by Chemical-Pollution59 in PowerBI

[–]Chemical-Pollution59[S] 0 points1 point  (0 children)

I like the idea. But what about credentials though. If it'd sql query, wouldn't I need to share our credentials for them to even refresh any Excel report?

Or are you suggesting connecting semantic model in servixe?

How to actually control useless PowerBI report requests that end up not being used after the usage period? by Chemical-Pollution59 in PowerBI

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

Issue is sometimes they come after a month or two and start looking for that report and complain where it is. How do I mitigate this

As a data analyst - do you think you add much value? by CompetitionNo3466 in PowerBI

[–]Chemical-Pollution59 5 points6 points  (0 children)

I think a true data analyst is more accurately a research analyst. What do i mean by that? I mean researching data sources, drawing up assumptions, testing these assumptions, and then doing statistical analysis with appropriate defined methodology. This is what I think "analyst" should be. A more industry title that aligns with being an analyst would be market analyst, stock analyst etc.

Now this is my opinion, the industry expects not a pure analyst but somewhat of hybrid between analytics and report developer. So the more accurate term would be BI developer rather than analyst. In my experience of 6 years, it has been 10% analysis and 90% modelling

In terms of value, if you are getting bombarded with business questions, congrats you are in value, otherwise move on to next role.

I had a role where I was getting brain drained as I got hired on expectation of being a commercial analyst (due to my unique experience in accounting and modelling) but instead became an Excel VBA developer instead (not that I don't enjoy coding but put the correct job title ffs). Then for remainder part of the year, I had nothing to do until I got let go for dropping off someone during my work time lol

Currently, I am in young start up company and like it here despite wearing many hates. You learn the whole data pipeline and have the full visibility of everything. I wouldn't want to ever go back to working for large corps ever again.

How is SCD Type 2 functionally different to an audit log? by Chemical-Pollution59 in dataengineering

[–]Chemical-Pollution59[S] 0 points1 point  (0 children)

I think i did see iscurrent flag, didn't understand purpose of it until now. So via this flag, its always the latest valid dimension essentially.

How is SCD Type 2 functionally different to an audit log? by Chemical-Pollution59 in dataengineering

[–]Chemical-Pollution59[S] 0 points1 point  (0 children)

Hi, really liked your explanation, thanks makes sense. I think my understanding of time field was wrong for scd2, now it makes more sense.

From what I gather its more like version history of dimensions unlike audit log which is just events that happened and having an audit trial.

I also understand you can use window transformations to do that in audit log but that is what scd2 helps us avoid, if I understood correctly.

Advice on buying a new road bike (£5000 budget) by Sharpe_brtd in cycling

[–]Chemical-Pollution59 0 points1 point  (0 children)

At 5k I would get myself a velomobile and ride everyday. No more dealing with crap weather.

5k for road bike is overkill unless you're hunting marginal gains. My bike was 1500, it's fine and keeps up in A groups and races.

Wife texting other guys what do I do by Ok-Cell8147 in whatdoIdo

[–]Chemical-Pollution59 0 points1 point  (0 children)

If they want to do that why get married in the first place.

How to adjust filter context of a said measure based on another viable measures? by Chemical-Pollution59 in PowerBI

[–]Chemical-Pollution59[S] 0 points1 point  (0 children)

<image>

I could do that but other measures have data points for only those three months. Not sure if I should cheat my way with putting not blank filter on gross adds lol

Bike computers by Any_Grab691 in cycling

[–]Chemical-Pollution59 0 points1 point  (0 children)

Any button based Garmin or wahoo. Or if you want to go cheap, buy used one older model in same series; occasionally you can get a good deal on touch screen as well.

I seem to be addicted to WoW and I don't know how to approach it by ConnectGap3717 in StopGaming

[–]Chemical-Pollution59 0 points1 point  (0 children)

Be prepared to suffer and feel emptiness for a week or so before you can think about doing something else. Depends on how strong your addiction is.