Introducing the 3-30-300 rule for better reports

  Рет қаралды 26,101

SQLBI

SQLBI

2 ай бұрын

A simple approach that you can apply to improve your reports and dashboards, not only in Power BI.
Article and download: sql.bi/840130?...
How to learn DAX: www.sqlbi.com/...
The definitive guide to DAX: www.sqlbi.com/...

Пікірлер: 63
@matthiasg.4941
@matthiasg.4941 Ай бұрын
"There is a difference between a report that looks nice and a report that is useful" I 100% agree.
@mathew9665
@mathew9665 2 ай бұрын
Excellent video - one of the major problems for fast growing companies is ensuring good quality feedback and engagment
@nazarenoman
@nazarenoman Ай бұрын
Hola. Es espectacular el conjunto de enseñanzas del video y lo simple que lo hacéis. Con vosotros siempre se tiene algo así. Muchas gracias por todo lo que personas como yo estamos aprendiendo con vosotros.
@Adrian-jg1pg
@Adrian-jg1pg Ай бұрын
Great tips, grazie Kurt ! You bring SQLBI to a whole new level 👌😊
@huseyinburaktasci1638
@huseyinburaktasci1638 Ай бұрын
Excellent tutorial Kurt! Thanks to your clear guidance, it was easy to grasp how the reports could be more efficient and effective. Thank you for the content. Much appreciated!! Big fan of you guys :)
@miqueldespuig
@miqueldespuig 2 ай бұрын
It’s just incredible how you make easy to understand (not to do) what you should be focusing on when designing reports. Thanks @Kurt and @SQLBI for the insights. This is a video I’ll watch again and again
@narayanawindenberger7396
@narayanawindenberger7396 2 ай бұрын
Really solid examples of action-based dashboard. Great work. I'm always refining my approach to understanding the action that clients take based on the data; I'm definitely bookmarking this video.
@leppyr64
@leppyr64 2 ай бұрын
Admittedly it seems I'm 6 months late (life happens), but welcome Kurt Buhler! Your Data Goblins Blog helped me out greatly over the past couple years. I really appreciate how this content is presented. It's important to take the time to get to know what the users of a report want. Too often we get bogged down in getting the next report out only to find later that the people who wanted it don't use it. The information presented here shows that taking more time and care to create an effective report is better for everyone. I related so much to the "data dump" report. Keep up the fantastic work!
@yppahpeek
@yppahpeek 2 ай бұрын
Excellent video! My brain is buzzing with ideas as my team move towards PBI reporting. I'm going to show them this video
@ronaldtijssen7492
@ronaldtijssen7492 2 ай бұрын
Wat een geweldige video weer. Toevallig was ik gisteren met een collega in gesprek over dit onderwerp en besloten we dat we hier iets mee zouden moeten gaan doen. Perfecte timing dus. Complimenten over de manier waarop je presenteert, rustig en af en toe wat herhaling om de boodschap nog duidelijker over te brengen.
@KurtBuhler
@KurtBuhler 2 ай бұрын
Heel erg bedankt! Dit is ook iets dat ik persoonlijk heel belangrijk vind.
@ZiggyBoon
@ZiggyBoon 2 ай бұрын
Where I work we use the Faberge Organic Shampoo rule from the 70s TV commercials. An executive asks a question, and his or her direct reports will email 2 of their direct reports, who will email 2 of their direct reports, and so on and so on and so on ... and then the executive gets 4 different answers 3 weeks later. I think the 3-30-300 rule is MUCH better!
@mtavassoti
@mtavassoti 2 ай бұрын
😂 so true
@josephansah
@josephansah 2 ай бұрын
Sounds so simple but very useful and effective. Thank you.
@joaomarcoseliasmatias9156
@joaomarcoseliasmatias9156 2 ай бұрын
Amazing approach, Kurt! It's important to do not forget the main objective of the calculations that we put hard work on. If our internal or external customers are not able to gather the critical business information required, so our job wasn't done in the most efficient way! I wonder, is there any project, personal or not, that you are engaged in? I want to know people that are dived into this knowledge. Let me know if you have!
@edwinarchico439
@edwinarchico439 2 ай бұрын
Outstanding topic, real life business scenario, thank you very much for this video ❤
@aditiiyer3476
@aditiiyer3476 2 ай бұрын
Thank you, Kurt, for sharing the video and article. Very well explained.
@MartinGonzalez-jr7ro
@MartinGonzalez-jr7ro 2 ай бұрын
Muchas gracias Kurt. Excelente contenido!. Me encantó el final: "Enjoy making reports"
@scramiro1
@scramiro1 2 ай бұрын
More content like this! I loved one video from Curbal which explained the importance of identifying the screen size of users in order to choose the layout of the report
@KurtBuhler
@KurtBuhler 2 ай бұрын
Thanks! Much, much more on the way :)
@emilmubarakshin49
@emilmubarakshin49 2 ай бұрын
fabulous summary of good report design, thank you!
@saiendeavours2154
@saiendeavours2154 2 ай бұрын
Very useful information for report developers. Thanks😊
@In_a_state
@In_a_state 2 ай бұрын
Good video, and you're a good presenter! Thank you
@eduleira8516
@eduleira8516 2 ай бұрын
Good advice. i'll keep that in mind for my next power bi designs
@ahmadmohamadmohamadalmanza7342
@ahmadmohamadmohamadalmanza7342 2 ай бұрын
Thanks very much for the great explanation and tips it was very informative ‏‪
@mtavassoti
@mtavassoti 2 ай бұрын
Great video. Thanks. My comment is that data analysts should be more confident and challenge those who ask for everything on one page if the mission is to inform people and make decisionsul using PBI. Often, more senior employees who don't know new technologies well enough request things in a format that's not practical and that has to change.
@KurtBuhler
@KurtBuhler 2 ай бұрын
Yes challenging users is important, I agree. There needs to be push and pull to achieve a result that's more well-sculpted to a possible solution in the "problem space". It's also how better learning and understanding happens, I think.
@louism.4980
@louism.4980 2 ай бұрын
This is GOLD, thank you so much! :)
@EduardoBettoni
@EduardoBettoni 2 ай бұрын
Thank you Kurt, excellent rule to apply!
@hasnainakram1530
@hasnainakram1530 2 ай бұрын
Great insight, really helped me to learn new thing today :)
@vijaykrishnan4151
@vijaykrishnan4151 2 ай бұрын
This is really good. Thank you for sharing.
@chandreshkumarjaiswal8341
@chandreshkumarjaiswal8341 2 ай бұрын
Thank you for such good content
@davidcurtin4360
@davidcurtin4360 2 ай бұрын
Fantastic video! Always easy to forget about the audience/customer! I will keep this practice in mind thankyou! Could you do a video about best canvas size? These examples all seem to use more pixels then default
@KurtBuhler
@KurtBuhler 2 ай бұрын
Thanks David, indeed I typically use 1080 x 1920 for desktop in most scenarios, unless A4 or Letter is required. It's good you ask, I should mention / discuss this in a future video.
@Qweertyyuiiop
@Qweertyyuiiop 2 ай бұрын
Another banger. Great job!
@Sokolovjean
@Sokolovjean 21 күн бұрын
Excelente, Boas dicas, Parabéns!
@jsniezycki
@jsniezycki 2 ай бұрын
Realy useful, thank you!
@randallevans150
@randallevans150 2 ай бұрын
Very Insightful!
@adalvenonsucesso
@adalvenonsucesso 2 ай бұрын
Congratulations, very good content!
@user-bq8co8kj6m
@user-bq8co8kj6m 2 ай бұрын
Excellent.Thanks.👏👏👏👏
@ThepExcel
@ThepExcel 2 ай бұрын
really great vdo. thx a lot
@FTM73
@FTM73 2 ай бұрын
Very good. Thanks
@VictorHugo-bd3bf
@VictorHugo-bd3bf 2 ай бұрын
This is gold; thank you so much, Kurt. I'm curious how you created the visualization at the bottom right, precisely the exclamation mark.
@KurtBuhler
@KurtBuhler 2 ай бұрын
Thank you Victor, the visualization in the bottom-right is a table that uses conditional formatting to display an icon. You can control it in the format settings for tables: Cell Elements> Series: Select your column > Icons: Enable > Style: Scroll down and select the style you like, this one uses X / ! / check. There's also other approaches to do this with custom icons, but this is how I achieved the result in this example.
@persianweavers2820
@persianweavers2820 2 ай бұрын
Well done! 🙏
@ajaaskelainen
@ajaaskelainen 2 ай бұрын
Great video! Loved it ❤
@michaelt312
@michaelt312 2 ай бұрын
Five minutes in a report and I'm being asked if they can export it to Excel.
@KurtBuhler
@KurtBuhler 2 ай бұрын
Export to Excel is regularly a part of the conversation (*edit to fix spelling). It's a big topic, and it's possible that it is a defined endpoint in the user journey. That's why you have things like "Live Connected Tables". For instance: 1. Users might get an overview that they're on target 2. Breakdown to see which customers and areas are off 3. Use drillthrough to get details-on-demand for those customers; i.e. see at a material level what products are off. -- It's perfectly valid if a user prefers to do this in Excel. -- They can use live connected tables or analyze-in-excel to get that data and focus only on those customers (instead of playing where's waldo with numbers and wasting time to get that info). So the report still served a purpose and delivered value. They don't have to use the report for the entire process to get their answers if it doesn't work best for their needs or preferences.
@huqsami
@huqsami 2 ай бұрын
Thanks 🥰
@edgardkami3138
@edgardkami3138 2 ай бұрын
Useful !
@moxie1189
@moxie1189 2 ай бұрын
Amazing tutorial, Kurt. Would you consider making the pbix available for download?
@KurtBuhler
@KurtBuhler 2 ай бұрын
We have the PDF available, but we will make this PBIX available after some other articles which will explain certain techniques that are used, here, otherwise it might be difficult to understand (and deconstruct) how certain things are done, and we don't want to confuse anyone. I also need time to convert this thin report example (which uses my "Data Goblins Dataset") to a thick report example that has some baked-in sample data.
@GuiSaviolo
@GuiSaviolo 2 ай бұрын
What do you guys recommend on doing when the process is not too clear even to the business people, therefore they don't even know the questions they are trying to answer. Any tips?
@KurtBuhler
@KurtBuhler 2 ай бұрын
That's a very good question, and a space that I personally like to occupy. One assumes in this space that the business has self-awareness that they don't understand the problem space or process, which is already a very good step. There needs to be some kind of workshopping or investigative phase where you work collaboratively with some business subject matter experts to define the process, scope, and problem, before discussing how one might address this. I personally believe that unless you're already heavily embedded in the business, you can only achieve this with regular engagements with business or even witnessing/participating in the process -- i.e. leaving the data for a bit to see things from the user / customer's point of view.
@allabout1135
@allabout1135 Ай бұрын
Good video and and agree with idea in behind, but what about Power BI tool it self? Is it easy to learn? Is it clear with what to start learn Power BI? Is it intuitive and how many exceptions in functionality need to keep in mind when You start to use it. So what is 20/80 needed to know in Power BI to get in average knowledge? Can be applied rules like 3/30/300 to Power BI tool it self? Sorry for to much questions above but its not fair that to create something simple and easy to read by going through madness to create it.
@ianallen13
@ianallen13 13 күн бұрын
This is great! Question: How many main 'questions' should a report be able to answer or should it focus on?
@KurtBuhler
@KurtBuhler 2 күн бұрын
It always depends, there's no one answer to that. Generally, you want to try to focus on 2-3 key problems or questions per report page, but this is more of a "gut thing" than a "brain thing" if you get my meaning. I generally try to focus in on a single concrete business process.
@alexkim7270
@alexkim7270 2 ай бұрын
At 19.49, can you share what visual you used to design the left card panel please?
@KurtBuhler
@KurtBuhler 2 ай бұрын
New card visual and line chart. There are three charts that are part of the same group. The slicer is the new slicer button visual. Note that the "new" visuals are in preview, because they still have some issues and are under active development. They have more flexibility to achieve "elegant" designs, however, I also find that they take a very long time to format...
@kifpowerbi
@kifpowerbi 2 ай бұрын
Not all people are aware of AOP, could you please explain what is AOP?
@KurtBuhler
@KurtBuhler 2 ай бұрын
AOP stands for "Annual Operating Plan", and it's a common annualised business target for measuring performance. In this example, it's used as a target that the business defines at the beginning of the year for their different customers, regions, and product types. Throughout the year, (in this example) the business updates their AOP with monthly forecasts (FCST) that might adjust that target to better reflect the current context.
@Pakaamtbencho
@Pakaamtbencho Ай бұрын
The faster u create the file the stringent deadline will become.💀💀
Filter context in DAX explained visually
24:40
SQLBI
Рет қаралды 19 М.
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 53 М.
路飞太过分了,自己游泳。#海贼王#路飞
00:28
路飞与唐舞桐
Рет қаралды 42 МЛН
Stay on your way 🛤️✨
00:34
A4
Рет қаралды 31 МЛН
小丑把天使丢游泳池里#short #angel #clown
00:15
Super Beauty team
Рет қаралды 28 МЛН
Using atomic design in report and model development
17:34
Improve data labels with format strings
21:21
SQLBI
Рет қаралды 9 М.
Default your Date Time Slicer Selection to a Current Period in Power BI!
10:30
Build a Slicer Panel in Power BI Like a PRO
20:40
Your Own KPI
Рет қаралды 65 М.
Use CONCATENATEX to Create Smart Visuals in Power BI
20:02
Storytelling with Data | Dashboard Build Demo
13:41
Maven Analytics
Рет қаралды 56 М.
3 Power BI Visuals You Haven't Seen Before!
17:19
How to Power BI
Рет қаралды 39 М.
How to Create Outstanding Power BI Reports (A Must Watch!)
14:11
Happy little accidents with the Power BI Card Visual
8:47
Guy in a Cube
Рет қаралды 35 М.
#MadeByGoogle ‘24: Keynote
1:20:56
Made by Google
Рет қаралды 1,3 МЛН
Частая ошибка геймеров? 😐 Dareu A710X
1:00
Вэйми
Рет қаралды 6 МЛН
Мой новый мега монитор!🤯
1:00
Корнеич
Рет қаралды 7 МЛН
Bluetooth connected successfully 💯💯
0:16
Blue ice Comedy
Рет қаралды 3,7 МЛН
Что делать если в телефон попала вода?
0:17
Лена Тропоцел
Рет қаралды 4,3 МЛН