Kinnekt TV
Kinnekt TV
  • 39
  • 76 281
Interquartile Ranges and Outliers in Power BI
Using DAX to create interquartile ranges (IRQ) for anomaly detection.
The video contains a:
- Introduction to IQR
- Example of real world impact of outliers
- Summary of IQR in our data set
- Creating IXR in DAX
DAX Functions used in this video
- PERCENTILE.INC
- CALCULATE
- MEDIAN
Переглядів: 4 174

Відео

Creating histograms in Power BI
Переглядів 3,8 тис.2 роки тому
Using histograms to model and improve your data analysis. This video will show 3 ways to create histograms and managing bins in Power BI, plus how to use the Group functionality to consolidate qualitative data. Using the following Power BI functions: (DAX) SWITCH Custom Visuals Group (Data)
Rolling Averages in Power BI
Переглядів 2702 роки тому
Create valuable insights in your analysis: Rolling averages (or moving averages) allow you to smooth data to form trend indicators This will cover the following Power BI Functions (DAX) CALCULATE (DAX) AVERAGEX (DAX) DAYSINPERIOD (DAX) GENERATAESERIES I will also show how to use a variable and a what if parameter
How to extract over 30000 rows from Power BI
Переглядів 6 тис.2 роки тому
A simple hack to extract more than 30000 records from Power BI. Power BI has a 30k limit on the number of records it allows you to extract Video covers: POWER BI DESKTOP DAX STUDIO VISUAL ANALYZER Power BI Tutorial for Beginners
Using TOPN to calculate the mode (average) in Power BI
Переглядів 2,1 тис.2 роки тому
Quick video on how to use TOPN DAX function to calculate the mode average. DAX Functions Covered: TOPN MINX ADDCOLUMNS AVERAGE MEDIAN
Correlation Coefficient in Power BI
Переглядів 11 тис.2 роки тому
How to calculate the correlation coefficient in Power BI The following functions are demonstrated in this video: (DAX) QUICK MEASURES
Data quality profiling in Power BI
Переглядів 2,2 тис.3 роки тому
Please hit like and subscribe! Quickly analyse your queries and provide a quick way of being able to report this information back to your report consumers.
Create Calculation Groups using Tabular Editor in Power BI
Переглядів 4833 роки тому
Build more efficient measures using Calculation Groups in Tabular Editor Tabular Editor link: www.sqlbi.com/tools/tabular-editor/ thanks to bensound.com for the music
DAX Academy - Time Intelligence and Cumulative Measures in Power BI
Переглядів 3643 роки тому
Getting into time intelligence within Power BI and building cumulative measures to drive deeper analytics in your data
Show and Hide Slicers in Power BI using Bookmarks
Переглядів 5 тис.3 роки тому
Leave more room for your visuals and have the slicer view optional that is triggered by your user
DAX Academy - Dynamic meaures in power BI using SWITCH
Переглядів 3283 роки тому
Give your users control of the reports with the ability to choose which measures are featured in a visual using the DAX SWITCH function
DAX Academy. Dynamic TOPN Filters using RANKX in Power BI
Переглядів 1 тис.3 роки тому
Using RANKX to create a user friendly dynamic filter to show top and bottom records only. Your report consumers will thank you for it! Here's the previous vide to get you going with RANKX: ua-cam.com/video/Mo4Q27fC2lU/v-deo.html
DAX Academy Ranking with RANKX
Переглядів 1883 роки тому
This video will walk you through the RANKX DAX feature and drive insights into your data Link here on how to build your data model and best practice ua-cam.com/video/Vg89lY7gGSk/v-deo.html For a small investment you can but the data sets and practice along, please visit the website at www.kinnekt.co.uk
Efficiently build measures in Power BI with this simple advice
Переглядів 4653 роки тому
A quick video to get you thinking about your approach to creating measured in your data model and how a simple approach can save you a lot of time. How to group your measures together in measure table: ua-cam.com/video/HxQYvJSvo_o/v-deo.html
Power BI star schemas and best practice data modelling
Переглядів 2533 роки тому
How to approach the design of your data model, applying the star schema and multiple fact tables. - Optimise your models - Reduce the size of your models - Improve user experience Power BI Star Schema Documentation docs.microsoft.com/en-us/power-bi/guidance/star-schema How to build a date table in DAX ua-cam.com/video/UXMjAewVB2k/v-deo.html How to build a date table in Power Query ua-cam.com/vi...
Power Query Quick Tour - Why you don't need to know M
Переглядів 513 роки тому
Power Query Quick Tour - Why you don't need to know M
Power BI and M - Learn your way around Power Query Advanced Editor first
Переглядів 1083 роки тому
Power BI and M - Learn your way around Power Query Advanced Editor first
Parameters in Power BI
Переглядів 933 роки тому
Parameters in Power BI
Create a row for each date between a date range in your query in Power BI
Переглядів 2243 роки тому
Create a row for each date between a date range in your query in Power BI
Power query date table with a function triggered automatically
Переглядів 1353 роки тому
Power query date table with a function triggered automatically
Power BI how to automate refresh of Excel - Power Automate
Переглядів 7363 роки тому
Power BI how to automate refresh of Excel - Power Automate
Power BI how to automate refresh of Excel - Schedule Refresh
Переглядів 6 тис.3 роки тому
Power BI how to automate refresh of Excel - Schedule Refresh
Power BI how to automate refresh of Excel - connect to SharePoint
Переглядів 2,7 тис.3 роки тому
Power BI how to automate refresh of Excel - connect to SharePoint
Vlookup in Power Query - How to lookup columns from other tables
Переглядів 9 тис.3 роки тому
Vlookup in Power Query - How to lookup columns from other tables
Power BI Organise tables with folders
Переглядів 2943 роки тому
Power BI Organise tables with folders
Power BI Neatly Arrange Your Measures for Easy Access
Переглядів 653 роки тому
Power BI Neatly Arrange Your Measures for Easy Access
Power BI Basics Date slicer to filter on multiple date columns part 2
Переглядів 8 тис.3 роки тому
Power BI Basics Date slicer to filter on multiple date columns part 2
Power BI Basics Date slicer to filter on multiple date columns part 1
Переглядів 11 тис.3 роки тому
Power BI Basics Date slicer to filter on multiple date columns part 1
Power BI Basics Visual Drill Downs and Hierarchies
Переглядів 543 роки тому
Power BI Basics Visual Drill Downs and Hierarchies
Power BI - Getting started with calculated columns and measures
Переглядів 833 роки тому
Power BI - Getting started with calculated columns and measures

КОМЕНТАРІ

  • @NikitaShilyaev
    @NikitaShilyaev Місяць тому

    thanks for the video! please increase the quality of your video - despite I chose 1080p60 I had difficulties to see the content on your screen

  • @mihaelavuc-vf8tt
    @mihaelavuc-vf8tt 3 місяці тому

    can you please paste the formula or explain the general criterias?

  • @shoaibrehman9988
    @shoaibrehman9988 5 місяців тому

    Gr8 idea its work , much easier in new release direct run in Dax query. Thanks

  • @Psyduck-Kz
    @Psyduck-Kz 6 місяців тому

    goatted, ty

  • @affyy04
    @affyy04 6 місяців тому

    Thanks for this helpful video. Could you please explain how to do this when we have to count rather than SUM??

  • @eli_d
    @eli_d 7 місяців тому

    This solution is spectacular. I scoured tutorials and message boards for hours and finally this made sense and works amazingly. Thank you!

  • @jkwa1
    @jkwa1 7 місяців тому

    Thanks for posting this video! really helped me at work

  • @mukktisbhuyan5943
    @mukktisbhuyan5943 9 місяців тому

    What if the we need to find mode for categorical non numerical column. I tried this Dax but it's not working. I need to apply it on response categorical column like within hour,within few hours,within day etc. Can you please help me. It's urgent.

  • @user-ju6hd9ij2s
    @user-ju6hd9ij2s 10 місяців тому

    The title says "slicer" but no slicer used on this video.

  • @hongthuongtran2027
    @hongthuongtran2027 10 місяців тому

    what does it means for the 0 in the formulas?

    • @ZdenekMoravecCZ
      @ZdenekMoravecCZ 9 місяців тому

      The {0} means "give me the first record of the result"

  • @kyokatsoma
    @kyokatsoma 10 місяців тому

    was there a link to the data?

  • @sameerhussain414
    @sameerhussain414 Рік тому

    Awesome ✨

  • @mf_rsr6621
    @mf_rsr6621 Рік тому

    Hi. How could you use a similar process in DAX Studio to extract the results of a PowerBI Matrix into a CSV file please? This is an awesome video - thanks for sharing :-)

  • @polcelpon1680
    @polcelpon1680 Рік тому

    the filters reset when you hide it again?

  • @ommm4169
    @ommm4169 Рік тому

    Thanks, for some reason it was not working for me even thogh i have applied to the letter.! can you think of any reason why it would not work?

  • @DeltaFootball
    @DeltaFootball Рік тому

    thanks boss! saved me some time

  • @CaribouDataScience
    @CaribouDataScience Рік тому

    Why doesn't BI come with histograms or boxplots?

  • @rubenvaneupen7327
    @rubenvaneupen7327 Рік тому

    I don't have bin as an option for my data variable.

  • @imanesidki5057
    @imanesidki5057 Рік тому

    good explanation, yet where are the data files?

  • @sushmaladkat2439
    @sushmaladkat2439 Рік тому

    I can't add Histogram Chart in my Power BI. Result is not showing the same histogram which you have used. There is only that 2nd option Histogram By PQ. Do you know why?

  • @kebincui
    @kebincui Рік тому

    Excellent Video👍. Thanks for sharing🌹.

  • @zamansshorts
    @zamansshorts Рік тому

    Hello! Thank you for great video. Also your voice sounds like Brett Goldstein's (Roy from Ted Lasso)!

  • @robertstewart614
    @robertstewart614 Рік тому

    Lifesaver - great contribution.

  • @muralichiyan
    @muralichiyan Рік тому

    Nice, but end user wants to download normal export how to do that

  • @BrianGarside
    @BrianGarside Рік тому

    Love this. Im working on a way to create Top level slicer to activate different groups of a Slicers with same functionality you showed in this video to show/Hide vs 1+groups. Is there a way to do that?

  • @spardagul3055
    @spardagul3055 2 роки тому

    This is very helpful!Thank you very much!

  • @jadellames438
    @jadellames438 2 роки тому

    Great video. But your audio is too low. I barely hear you even if I used my headset. I suggest if you can explain the concept behind your formula first before doing it. Illustration will be really helpful specially for visual learner like me. To be honest I barely understand what you do even if I repeat the video. Its probably due to my lack of knowledge. But tutorial are made for dumb people like me so please make your video easier to understand. Thanks

    • @kinnekttv2057
      @kinnekttv2057 2 роки тому

      Hi Jade, thanks for the feedback. I will take on-board

  • @ezmat2010
    @ezmat2010 2 роки тому

    Thanks a lot, this is really useful :)

  • @Nutflash1978
    @Nutflash1978 2 роки тому

    Thanks very useful

  • @hugodalmas5136
    @hugodalmas5136 2 роки тому

    Hi ! Just a question can you do something similar but in a published Power BI ? (and not on desktop version) Because I will not be the only one that need to export a large amount of data from my BI. Thank in advance !

    • @kinnekttv2057
      @kinnekttv2057 2 роки тому

      Hi Hugo, In the Power BI service, pro users can download 150k records ( 30k limit applies for free users). I am not sure if power automate can be used to connect to the dataset and extract. You can also connect Dax studio to the online service, here's a community post that helped resolve this... community.powerbi.com/t5/Service/DAX-Studio-live-connection/m-p/1627160

  • @asoka9009
    @asoka9009 2 роки тому

    Great feature! Quite helpful, looking forward for more tips...

  • @laxmanrao4554
    @laxmanrao4554 2 роки тому

    Thank you. I am working with a dataset that has daily order figures of a company for 2 years (order amount ranging from 1 to 200+). I applied this method and got lower gate outlier as 1 and upper gate outlier as 3.5 More than 50% of daily orders have order quantity > 100 ,, not sure if that is working as intended ?? Please advise

  • @yenikacarlex484
    @yenikacarlex484 2 роки тому

    Thanks for the video. What if there's no mode. With your formula, it will return the minimum value. What can I do if I want the maximum value rather.

    • @kinnekttv2057
      @kinnekttv2057 2 роки тому

      Hi, MAX function could get the maximum value.

  • @hussamalhunaiti4656
    @hussamalhunaiti4656 2 роки тому

    I love you u help me a lot <3

  • @pedja2518
    @pedja2518 2 роки тому

    Thank You! Great video!

  • @helenm-b3320
    @helenm-b3320 2 роки тому

    Excellent

  • @monicapereznogueras7383
    @monicapereznogueras7383 3 роки тому

    Excelent!!!

  • @sarsatheeshreddy3341
    @sarsatheeshreddy3341 3 роки тому

    Thank you so much it's really helpful.

  • @jethronong2076
    @jethronong2076 3 роки тому

    How do you go about it when the two dates come from two different tables?

    • @TexasCoffeeBeans
      @TexasCoffeeBeans Рік тому

      I have exactly the same question

    • @patlittleton1288
      @patlittleton1288 Рік тому

      @@TexasCoffeeBeans @Jethro Nong you should be able to just create a relationship to the date table for each one. It's actually simpler than what he is trying to do here.

    • @parkerwendt2216
      @parkerwendt2216 3 місяці тому

      @@patlittleton1288 It only lets you create one many to many relationship though

  • @joedeary2717
    @joedeary2717 3 роки тому

    Would like to see more on using pbi to manage data as in formal data governance programme

  • @VernHowChan
    @VernHowChan 3 роки тому

    thank you, this was useful. How would we profile with relationships of fields between tables though?

  • @pakipower
    @pakipower 3 роки тому

    Excellent!!! Really helped alot. Thanks and please do more such videos. Subscribed

  • @nikparkhaev9087
    @nikparkhaev9087 3 роки тому

    Thanks! very helpful

  • @ronlieuw5272
    @ronlieuw5272 3 роки тому

    Thanks for sharing. I used the technique as soon as I saw the video

  • @martinstasiuk2524
    @martinstasiuk2524 3 роки тому

    Great feature! Definitely helpful. Keep going with new tips.

  • @theresakurtz2888
    @theresakurtz2888 3 роки тому

    I wish we could also dynamically name the measure. On my report, I'm showing say Measure vs. Comparison in a graph. But both of those will change based on slicer selected. I can dynamically label the graph titles, no problem. But for the legend, all I can display is Measure and Comparison, which doesn't change per their selection. This is a bit confusing for folks. Any ideas about how to do that?

    • @kinnekttv2057
      @kinnekttv2057 3 роки тому

      Hi Theresa, yes there is a way using bookmarks. I am just editing a video that shows how bookmarks work but not for this exact purpose. It should be published shortly. If this doesn't help let me know and I can do a video to show you how

  • @theresakurtz2888
    @theresakurtz2888 3 роки тому

    Thank you. I can see lots of ways to use this.

  • @pedrohenriquecerqueira1803
    @pedrohenriquecerqueira1803 3 роки тому

    I didn't know I needed this function until seeing this video! Thank you!!

  • @pedrohenriquecerqueira1803
    @pedrohenriquecerqueira1803 3 роки тому

    Just what I was looking for!!

  • @SolutionsAbroad
    @SolutionsAbroad 3 роки тому

    Quick and easy tutorial, great job mate