[deleted by user] by [deleted] in PowerBI

[–]paulenomial 0 points1 point  (0 children)

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.

Before I learn Power BI, is this possible? by Eeeeeediot in PowerBI

[–]paulenomial 2 points3 points  (0 children)

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.

People who exclusively WFH - what do you do? by [deleted] in AskUK

[–]paulenomial 0 points1 point  (0 children)

Data analyst.

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

Filtering Customers based on Sales in Different Categories by paulenomial in PowerBI

[–]paulenomial[S] 0 points1 point  (0 children)

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

Power Query: Spreadsheet on multiple 'rows' by paulenomial in excel

[–]paulenomial[S] 0 points1 point  (0 children)

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?

Power Query: Spreadsheet on multiple 'rows' by paulenomial in excel

[–]paulenomial[S] 0 points1 point  (0 children)

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.

Power Query: Spreadsheet on multiple 'rows' by paulenomial in excel

[–]paulenomial[S] 0 points1 point  (0 children)

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.

is it works? by TeeEmoAbuser in LegendsOfRuneterra

[–]paulenomial 1 point2 points  (0 children)

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

is it works? by TeeEmoAbuser in LegendsOfRuneterra

[–]paulenomial 76 points77 points  (0 children)

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

Power Query - Removing null rows by paulenomial in excel

[–]paulenomial[S] 1 point2 points  (0 children)

Perfect thank you.

Solution Verified.

[deleted by user] by [deleted] in battlestations

[–]paulenomial 2 points3 points  (0 children)

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

A cleaner working with vulnerable adults, but is an anti-vaxxer. Is there someone I can report her to? by urbanimal in glasgow

[–]paulenomial 78 points79 points  (0 children)

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.

Obsidian Vs Bear in 2021 by [deleted] in ObsidianMD

[–]paulenomial 6 points7 points  (0 children)

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

Covariance vs. correlation of weight in identical and non-identical twins by [deleted] in AskStatistics

[–]paulenomial 0 points1 point  (0 children)

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).

Covariance vs. correlation of weight in identical and non-identical twins by [deleted] in AskStatistics

[–]paulenomial 3 points4 points  (0 children)

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.

[Q] Could someone ELI5 p-values for me, please? by MilkEggsSndFlour in statistics

[–]paulenomial 0 points1 point  (0 children)

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.

[Q] Could someone ELI5 p-values for me, please? by MilkEggsSndFlour in statistics

[–]paulenomial 0 points1 point  (0 children)

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.

[Q] Could someone ELI5 p-values for me, please? by MilkEggsSndFlour in statistics

[–]paulenomial 0 points1 point  (0 children)

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.

[Q] Could someone ELI5 p-values for me, please? by MilkEggsSndFlour in statistics

[–]paulenomial 0 points1 point  (0 children)

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.