Outlier Detection & Visualization in Power BI

No video

Outlier Detection & Visualization in Power BI - Advanced DAX

Рет қаралды 22,393

Enterprise DNA

Күн бұрын

Пікірлер: 28

@EnterpriseDNA 4 жыл бұрын

***** Related Links ***** Deep Dive Into Data Outliers - How To Discover And Analyze In Power BI Using DAX blog.enterprisedna.co/deep-dive-into-data-outliers-how-to-discover-and-analyze-in-power-bi-using-dax/ How To Evaluate Clusters In Your Data Using DAX Technique In Power BI blog.enterprisedna.co/evaluate-clusters-in-your-data-advanced-power-dax-technique/ Creating Dynamic Outlier Trigger Points - Advanced Power BI Analysis Technique kzfaq.info/get/bejne/kNd5na2pzM2on6c.html ***** Related Course Modules ***** Unique Analytical Scenarios portal.enterprisedna.co/p/unique-analytical-scenarios Webinar Series Resources portal.enterprisedna.co/p/enterprise-dna-webinar-series-resources Advanced Data Transformations & Modeling portal.enterprisedna.co/p/advanced-data-transformation-and-modeling ***** Related Support Forums ***** Outliers Help. Can’t See My Non-Outliers On Scatter forum.enterprisedna.co/t/outliers-help-cant-see-my-non-outliers-on-scatter/3874 Outlier Sales TY and Outlier Sales LY forum.enterprisedna.co/t/outlier-sales-ty-and-outlier-sales-ly/3119 Dynamic Grouping Into Quadrants forum.enterprisedna.co/t/dynamic-grouping-into-quadrants/4115 For more outlier detection queries to review see here….. forum.enterprisedna.co/search?q=outlier%20detection

@oladman9058 Жыл бұрын

Definitely a wow!

@EnterpriseDNA Жыл бұрын

Hi oladman, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

@barttitulaerexcelbart9400 6 жыл бұрын

Thank you Sam, great explained. Although I did not understand why COUNTROWS was in that long formula, 2x Filter, OK, but Countrows? You could even improve this model by letting the user select the borders of the outliers.

@xp00ch 4 жыл бұрын

It's effectively conditional logic for the CALCULATE. If you look closely you can see the > 0 at the end of the formula. So it's counting the rows returned where there are "passes" to the sales and profit criteria, if this is > 0 then it fires the CALCULATE on a row by row basis due to the FILTER ( VALUES

@NirRobinson 6 жыл бұрын

Thanks. Very insightful

@nacujo3985 6 жыл бұрын

Wow.... just love your videos. They are extremely useful and helpful!

@EnterpriseDNA 6 жыл бұрын

That's great, thanks for the feedback

@TheTrudyholguin 3 жыл бұрын

Awesome Sam! Much appreciated

@EnterpriseDNA 3 жыл бұрын

Hi Clamps 2litt, great that you found value in this video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA

@Marmit42424 6 жыл бұрын

Thank you!

@rrrprogram8667 6 жыл бұрын

Nice one Sam... really liked it...

@vida1719 6 жыл бұрын

Very interesting insight

@chiggywiggyable 5 жыл бұрын

I would like to know the formulas of each new measure you have created because we are trying something similar with our data. These formulas can guide us.

@ackrite55 6 жыл бұрын

That was amazing! I have invested a week in trying to get R to work behind a locked down network so I could utilize some of it's features. But this approach totally alleviates a headache. Is there a Dax limitation where R could be called upon?

@EnterpriseDNA 6 жыл бұрын

I haven't really dived much in R so I can't say definitively, but DAX is incredible and I can find most of the things I've ever needed from an analytical perspective with DAX.

@sara_el.a 6 жыл бұрын

For my lab I measured the absorption for 1 sample 5 times (5-10-15-20-25 minutes). I did this for 10 different samples (different concentrations). How do I determine if I have outliners? I already made a regression line where I can clearly see that I do have outliers.

@josephkingston8079 4 жыл бұрын

Excellent video! Could the same thing be accomplished with conditional formatting?

@EnterpriseDNA 4 жыл бұрын

Hi Joseph - With new Power BI Versions, You can achieve this using Conditional Formatting with some custom measures, however you won't get the option to use Slicer. Regards, Enterprise DNA

@chiggywiggyable 5 жыл бұрын

what is the formula for total sales in this example.

@rajivgusain5725 5 жыл бұрын

Hi Sam I have a doubt why did the filter didn't calculate the other rows in the max and min of profit margins and sales in the outlier logic table. For instance when you typed the dax formula of profit margin > outlier logic(profit margin min) here it calculated 35% but not 0%

@EnterpriseDNA 5 жыл бұрын

Hi Rajiv, for help like this check out the Enterprise DNA Support Forum - forum.enterprisedna.co/search?expanded=true&q=Outlier

@bengislason8843 3 жыл бұрын

Any way to do this across a 3rd dimension? I am trying to wrap my head around this for an application where outlier thresholds are different based on another filtering table. I have integrated the filtering table portion but I want to summarize outliers across all fields in filtering table. Any thoughts out there?

@EnterpriseDNA 3 жыл бұрын

Hello Ben Gislason, thank you for posting your query onto our channel. Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful. Also make sure that you're subscribed to our KZfaq channel so that you don't miss out on any updates pertaining to the Power BI. Happy Learning!!! forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA