Тёмный

Visualising Distributions in Power BI 

London Business Analytics Group
Подписаться 11 тыс.
Просмотров 66 тыс.
50% 1

We often want to visualise the spread of a set of numbers. This video shows how to build four charts in Power BI that do this: histogram, box & whisker chart and scatter plot and time-series chart. To achieve these charts, we need to bin (bucket) the numeric data, use a custom control, create calculated columns and measures.
If you would like to explore the example shown in this video, the data file and completed Power BI Desktop file are atgithub.com/MarkWilcock/lbag-o...

Опубликовано:

 

1 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 29   
@PaulEBrownbill
@PaulEBrownbill 3 года назад
Excellent explanation, easy to follow, thanks Paul
@mshparber
@mshparber Год назад
Jitter = RAND() is simply GENIOUS!!!! Respect!!!!
@LondonBusinessAnalyticsGroup
Thanks Michael!
@tonymiller225
@tonymiller225 3 месяца назад
Try to improve your vocabulary beyond the moronic catchcry 'respect' and learn how to spell while you're at it
@michaelyounes29
@michaelyounes29 3 года назад
Fantastic explanation and demonstration!
@LondonBusinessAnalyticsGroup
@LondonBusinessAnalyticsGroup 3 года назад
Glad you enjoyed it!
@infinger2006
@infinger2006 Месяц назад
Probably pedantic for many, but I loved the day of week sorting / key use.
@elahehsamandi914
@elahehsamandi914 Год назад
Thank you, It was very helpful!
@nausitran
@nausitran 5 месяцев назад
great explanation, thanks for sharing
@okusai
@okusai 2 года назад
Sir, that was superb. Thanks so much.
@LondonBusinessAnalyticsGroup
@LondonBusinessAnalyticsGroup 2 года назад
Most welcome!
@CL-me3ip
@CL-me3ip 10 месяцев назад
Thank you so very much!
@reemak3249
@reemak3249 2 года назад
Brilliant!
@aumschultz1750
@aumschultz1750 4 месяца назад
THIS IS AWESOME!!!!!!
@ing66923
@ing66923 3 года назад
Box Plots don't work. My "value" variable gets always summarized (as sum). Even if I select the option "don't summarize" for that column
@henrylamosdiaz765
@henrylamosdiaz765 2 года назад
excelent, gracias
@LondonBusinessAnalyticsGroup
@LondonBusinessAnalyticsGroup 2 года назад
Hi Henry, Glad you liked it.- Mark
@ahmed007Jaber
@ahmed007Jaber 3 года назад
thank you Paul for this love this one. couldn't find anything related to the visualisation that is following this. what is it called? bucketing and pinning data
@Dineshkumarnk
@Dineshkumarnk 2 года назад
Superb! can you also add like for which kind of data and insight expectation, particular chart should be used?
@paulchen3026
@paulchen3026 3 года назад
Is the histogram follow-up video ready to view? Can't wait to see it soon.
@juanneira7161
@juanneira7161 3 года назад
Great Video, We are still waiting for the next Histogram Video. I'm interested on Service Tickets Analysis
@LondonBusinessAnalyticsGroup
@LondonBusinessAnalyticsGroup 3 года назад
Hi Juan, We'll be doing a short video of histograms and grouping data in the next few months. - Mark
@ahmadz113
@ahmadz113 Год назад
Hey , I can't find your second video about histograms and strip graphs
@ChizurokeNnadi-rh5xj
@ChizurokeNnadi-rh5xj 10 месяцев назад
I can't find the "Details" field you added the dates to in 8:31 in my Power BI
@user-np8km1ib4b
@user-np8km1ib4b 4 месяца назад
I can't find the follow-up video promised at the end. Is it uploaded on the channel?
@Griffindor21
@Griffindor21 Год назад
Great tutorial! Instead of creating the "Day of Week" column, can we not just use the "Date Hierarchy" that Power BI creates when a column is of Date type?
@LondonBusinessAnalyticsGroup
Hi Marvin, The auto date time does not have a day of week level. - Mark
@hiteshjoshi3148
@hiteshjoshi3148 2 года назад
sir how to visualize age distribution.
@evelynchandia4898
@evelynchandia4898 2 года назад
how come my chart has few dots?
Далее
IQ Level: 10000
00:10
Просмотров 10 млн
Preparing a dataset for Machine Learning in Power BI
20:00
Normal Distribution (Gauss Curve) in Power BI (Part I)
14:24
Use scatterplots to find details in Power BI reports
25:49
Scenario (What If) Analysis with Power BI
19:55
Просмотров 11 тыс.
Power BI - Visualizing Outliers - Part 1
10:48
Просмотров 27 тыс.
Creating Groups and Histogram Bins in Power BI
5:51
Просмотров 50 тыс.
MASTERING Bar Charts in Power BI | No more Cut Labels
15:34
IQ Level: 10000
00:10
Просмотров 10 млн