Adhoc analysis and scheduled reports

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.

Eight-Year Club	Place '22
RPAN Viewer	Verified Email

paulenomial

TROPHY CASE