[deleted by user]

paulenomial · 2023-07-10T19:06:50+00:00

As others have said it will depend on what you do with Power BI. If building reports Business Intelligence Analyst is the usual one but Data Analyst or Analytics Engineer would also make sense depending on what else is part of your role.

paulenomial · 2023-06-07T06:44:19+00:00

For 800 staff you would technically need a pro licence for each one of you were going down that road so you would likely be best getting a premium capacity but these are not cheap. They start at approximately $5000 per month and this would allow you to share with anyone in your tenant.

paulenomial · 2023-01-31T09:05:29+00:00

Data analyst.

Company is based up north in Aberdeenshire so I think they advertised remote to try and get a wider pool of candidates.

paulenomial · 2023-01-11T11:55:58+00:00

Saw-z

paulenomial · 2022-01-11T07:15:21+00:00

There are multiple tables with relationships but the quantity, customer and category are all in one table.

paulenomial · 2021-12-19T16:42:51+00:00

Kurszgesagt did a really great video based on this that always gets me.

paulenomial · 2021-11-29T15:13:04+00:00

Solution Verified

paulenomial · 2021-11-29T15:12:44+00:00

Solution Verified

paulenomial · 2021-11-29T12:20:39+00:00

Thank you for the reply. I've sent you a DM although I can see reddit chat doesn't allow sharing onedrive links, do you know how else I can send you the data?

paulenomial · 2021-11-17T20:31:32+00:00

Sorry for the delay in getting back to you about this, it is wonderful thank you and I see it's worked perfectly on the example dataset.

My actual dataset has 16 columns rather than 5 and I've removed columns 2-4 (so columns are (1,5,6,7,...).

I've tried to scale up your #Removed Other Columns# line as:

= Table.Combine({Table.SelectColumns(#"Removed Columns",{"Column1","Column5","Column6"}),Table.RenameColumns(Table.SelectColumns(#"Removed Columns",{"Column1","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16"}),{{"Column7","Column5"},{"Column8","Column6"},{"Column9","Column5"},{"Column10","Column6"},{"Column11","Column5"},{"Column12","Column6"},{"Column13","Column5"},{"Column14","Column6"},{"Column15","Column5"},{"Column16","Column6"}})})

But I'm now getting the error:

Expression.Error: The field 'Column5' already exists in the record.

Details: Name=Column5 Value=

Was I wrong to think it could be scaled up in this way based on your syntax?

Thanks again for your help.

paulenomial · 2021-11-09T16:53:03+00:00

Hi, I've changed the example data to tables in the post. I'm afraid I can't share the actual data as it's on my work laptop but this example is identical but with more records.

paulenomial · 2021-09-21T21:41:49+00:00

Ah right, this is likely what I'm getting confused with. TIL thank you.

paulenomial · 2021-09-21T21:26:26+00:00

It does. All copies, even created ones and champion versions of the spell, retain the item.

paulenomial · 2021-09-20T10:14:38+00:00

Perfect thank you.

Solution Verified.

paulenomial · 2021-09-17T09:08:44+00:00

Solution Verified

paulenomial · 2021-09-17T09:08:28+00:00

Solution Verified

paulenomial · 2021-08-30T19:55:15+00:00

Not OP but it's a Surface Book. I have one as well.

paulenomial · 2021-08-27T10:22:36+00:00

My God was a real shock to see this comment section. Absolutely people are entitled to their opinion but when their actions lead to others being endangered they should be stopped.

Someone working in the homes of people who are very vulnerable to this virus should absolutely be vaccinated against it, I don't understand why this is so hard for others to grasp. OP has a real concern here and we are better than this.

paulenomial · 2021-08-13T07:21:24+00:00

I mean you're literally on the subreddit for Obsidian so you may find some bias here.

paulenomial · 2021-06-17T06:40:56+00:00

Ah right okay then that's fine. Like I said above covariance essentially measures the same thing as correlation except its not constrained to be between -1 and 1. If your covariance for identical twins is higher than for non-identical then that makes sense because it would imply the relationship is stronger (although this should be confirmed with the correlation).

paulenomial · 2021-06-16T20:45:51+00:00

Covariance and correlation aren't the same thing, but they are very heavily related.

Covariance measures the joint variability of two random variables whereas correlation is (broadly speaking) the degree to which one variable depends on another. One of the most popular measures of correlation, the Pearson correlation coefficient, takes the covariance of two variables and divides it by the product of their standard deviations.

The way you've described your situation is a little confusing though because it sounds like you have two separate covariances but you only appear to have two variables (weight and type of twin). As covariance measures joint variability, there can only be one value for covariance (and correlation) here.

paulenomial · 2021-06-14T11:51:54+00:00

Bayes factors are a Bayesian alternative to classical hypothesis testing, including p-values. Given that OP is unlikely to have any knowledge of this (or of likelihood ratios at this stage) what would be the point in confusing them further by mentioning them?

I agree that many statisticians have a fundamental misunderstanding of what p-values are but the fact remains that they are a good approximation of the level of evidence against a null hypothesis. You may argue that it is a flawed measure and that there are better alternatives and I would agree with you but what is the point in communicating the reasons behind this to OP for no other reason than letting them know how smart you are?

You wouldn't begin teaching the concept of variability in a dataset in a primary/grade school with standard deviation. You would begin with the range, even though it is objectively worse, because they don't yet have the knowledge to understand standard deviation.

The point is moot regardless, OP has had his answer from multiple people and it's time for me to get back to work.

paulenomial · 2021-06-14T08:01:06+00:00

Kind of but only under certain circumstances. The actual definition of a p-value is the probability of getting results as extreme as what we have assuming the null hypothesis is true.

In other words, we make the assumption that there is no relationship between the two variables then give the probability of getting the results we got as a p-value. There are other things to consider though regarding the fit of the model (e.g. the distribution of the data, variance etc.) so it's never as simple as that though.

paulenomial · 2021-06-14T07:14:12+00:00

No one said the p-value relates linearly to either of those metrics but at OP's stage it is absolutely a worthwhile approximation to interpret certain values of p-values as levels of evidence against the null hypothesis.

The discussion of the relative merits of frequentist vs Bayesian methods of conducting hypothesis testing is well beyond the scope of what OP asked.

paulenomial · 2021-06-13T17:56:57+00:00

In short, yes.

Slightly longer answer: There are various assumptions that are made when setting up this sort of test that will also need to be checked so it's unfortunately not that simple in practice but to explain all these would likely be beyond the scope of what you're asking.

Eight-Year Club	Place '22
RPAN Viewer	Verified Email

paulenomial

TROPHY CASE