Power BI - Visualizing Outliers

No video

Power BI - Visualizing Outliers - Part 1

Рет қаралды 27,305

Nathan Patrick Taylor

Күн бұрын

Пікірлер: 33

@lisagalley 5 жыл бұрын

This was great. Hope to see more Power BI tips from you.

@qiancasper 3 жыл бұрын

It's really helpful for my current situation. Now I'm learning how to to implement this into realistic job flow

@NPT 3 жыл бұрын

Awesome to hear Casper!

@gauravsukhadia638 2 жыл бұрын

Same here learning how to implement this into real business problem. 🙂

@shreyakhullar2919 4 жыл бұрын

Excellent description of outliers...Thanks !!

@jazzista1967 6 жыл бұрын

Great explanation of outliers..will use this technique at work..

@NPT 6 жыл бұрын

Thanks jazzista1967, glad to hear the explanation is useful. 😀

@jazzista1967 6 жыл бұрын

Thanks for posting. Just subscribed to your channel. Your outlier technique gave me an idea on how to detect differences in my accounting accruals specially on the swings of values month over month! Great channel.

@feng3625 3 жыл бұрын

very wonderful piece. Thank you very much!

@NPT 3 жыл бұрын

You're welcome Feng!

@rauljimenez5485 4 жыл бұрын

Great explanation and tools!! Another interesting analysis could be the cost per sq.ft The cost could be related to the size, but looking at it as $/sq.ft might be more meaningful. I know this is just an explanation of the tools, just sharing the thought. Thank you very much for the video, it is very useful!!!

@NPT 4 жыл бұрын

Great observation Raul! I'm glad you find the videos helpful.

@brandonwarfield5611 9 ай бұрын

Finally found something I understand but can't use because app no longer exist in power bi. 😭😭

@pedja2518 2 жыл бұрын

Great video! Thnx

@NPT 2 жыл бұрын

Glad you liked it!

@a.amiracle2579 4 жыл бұрын

Great explanation, thank you!

@dashbyron8548 3 жыл бұрын

you probably dont give a shit but does any of you know a method to log back into an instagram account? I somehow forgot the login password. I would love any tips you can offer me.

@coengiovanni4769 3 жыл бұрын

@Dash Byron Instablaster =)

@dashbyron8548 3 жыл бұрын

@Coen Giovanni I really appreciate your reply. I found the site through google and I'm waiting for the hacking stuff now. Seems to take quite some time so I will reply here later when my account password hopefully is recovered.

@dashbyron8548 3 жыл бұрын

@Coen Giovanni it did the trick and I actually got access to my account again. I'm so happy:D Thank you so much, you really help me out !

@coengiovanni4769 3 жыл бұрын

@Dash Byron glad I could help :D

@angelmaravilla4708 Жыл бұрын

That visual (Power Bi Outliers Detection) is not longer available in Power Bi, do you knwo why or what can I do to get it??? PD: Great video

@user-ug5wk2cv5f Жыл бұрын

Outliers detection plot is not present in power bi

@guustvandijck4505 5 жыл бұрын

Hi Nathan! Great post. Just one question; I´m actually just interested in the outliers and would therefor like to use this visual as a drillthrough/ filter for another visual. So I would like to press on the datapoint of a particular outlier, so that it filters a table that is in the same page. Do you know if this is now possible? Really looking for the interaction with other visuals here...

@toshiehabu4755 3 жыл бұрын

To be able to use the Outlier detector, the PowerBI has to install 3 packages. But I couldn't DMwR install. So it didn't work. DmWr seems removed from R. Does this visual (Outlier detector) still work?

@jaydobya 4 жыл бұрын

How were you able to have a non-aggregated column in your measure formula ?

@solomonrobert67 5 жыл бұрын

Excellent description of Outliers. Have learnt a new stuff which will help me. Have a doubt here in the DAX you have written for ZScore. The DAX starts with ([Market Value]) which do not have a table mentioned to it. I have an exactly similar scenario which I am writing the same DAX. But unable to execute it. I get the below error: ZScore = ('PSC_Tokyo MoU'[Deficiency Count] - AVERAGE('PSC_Tokyo MoU'[Deficiency Count]))/STDEVX.S('PSC_Tokyo MoU'[Deficiency Count]) Error: Too few arguments were passed to the STDEVX.S function. The minimum argument count for the function is 2 Can you please help?

@NPT 2 жыл бұрын

I'm sure you've worked it out by now. But it looks like you need to add the table reference to the STDEVX.S function. Maybe like this... STDEVX.S(RELATEDTABLE(PSC_Tokyo MoU), PSC_Tokyo MoU[Deficiency Count])

@suryasurya3905 6 жыл бұрын

Hi need help on DAX,I have a data of columns names as ,student name and status(pass/fail).so need to calculate the pass% and fail% for total ppulation of students with the use of dax funftion.Can any one help me to get the dax function.

@NPT 6 жыл бұрын

Hi Kamesh, since you already have the pass and fail status, I would do a count of each status as a separate measure and then use the measure to divide by a COUNT of all records. So one measure that counts PASS, another that counts FAIL, and then use the results as the numerator over the total count.