🙏🏼 Thanks @user-gk9of4bj4q More Power BI content coming soon. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html 10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html Cheers. Doc
Thanks Ryan. I will certainly make more videos on choosing the right visuals in Power BI. Here is the gist: 1. Choose visuals which simplify interpretation 2. DO NOT choose a visual just because it was used in Excel. 3. Educate the target audience about appropriate interaction and interpretation of the report. 4. DO NOT use heat maps. Most people get confused. 5. Always put data labels. 6. Avoid conical shapes ( pie charts). Rectangles are easier to compare (Treemap). 7. Use Maps - they are intuitive and insightful. 8. Do not use slicers with scroll bars. 9. Always add a Narrative visual to ensure uniformity of interpretation 10. Avoid custom visuals. 11. Always have a Reset Filters button (which is mapped to an unfiltered Bookmark). 12. Pay attention to contrast. Readability is most important. 13. Check if your report can be understood by color blind persons. 14. For crowded visuals , add Zoom Sliders. 15. Minimize pages. 16. If you are using Matrix (Pivot equivalent), use Conditional Formatting. 17. DO NOT cram too many visuals with small font size. 18. Cross check if your target audience is finally exporting raw data to Excel and making their own reports! 19. Comparison in horizontal direction (bar chart) is easier compared to vertical direction (column chart) 20. Mention relevant grand totals using Multi-card visual.
Thanks @unnikrishnansanthosh Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html 10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html Cheers. Doc
Thanks @biplabdasgupta for pointing out. Here is the sample file efficiency365.com/wp-content/uploads/2023/11/Ribbon-chart-sample.zip Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html 10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html Cheers. Doc
Thanks @backare171 Check out my other best practices videos as well. Task Management Best Practices - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html Cheers. Doc.
Thanks @ryan19899 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html 10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html Cheers. Doc
मस्त एक नंबर ....... More videos on Power BI❤
Big Fan of you
🙏🏼 Thanks @user-gk9of4bj4q
More Power BI content coming soon.
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html
Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html
Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html
Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html
Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html
10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html
Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html
Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html
Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html
Cheers.
Doc
What other charts do you recommend? Please make a series on this.
Thanks Ryan.
I will certainly make more videos on choosing the right visuals in Power BI.
Here is the gist:
1. Choose visuals which simplify interpretation
2. DO NOT choose a visual just because it was used in Excel.
3. Educate the target audience about appropriate interaction and interpretation of the report.
4. DO NOT use heat maps. Most people get confused.
5. Always put data labels.
6. Avoid conical shapes ( pie charts). Rectangles are easier to compare (Treemap).
7. Use Maps - they are intuitive and insightful.
8. Do not use slicers with scroll bars.
9. Always add a Narrative visual to ensure uniformity of interpretation
10. Avoid custom visuals.
11. Always have a Reset Filters button (which is mapped to an unfiltered Bookmark).
12. Pay attention to contrast. Readability is most important.
13. Check if your report can be understood by color blind persons.
14. For crowded visuals , add Zoom Sliders.
15. Minimize pages.
16. If you are using Matrix (Pivot equivalent), use Conditional Formatting.
17. DO NOT cram too many visuals with small font size.
18. Cross check if your target audience is finally exporting raw data to Excel and making their own reports!
19. Comparison in horizontal direction (bar chart) is easier compared to vertical direction (column chart)
20. Mention relevant grand totals using Multi-card visual.
@@efficiency365 Thank you so much
Thank you ❤
very informative, thank you for sharing
Thanks @unnikrishnansanthosh
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html
Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html
Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html
Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html
Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html
10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html
Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html
Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html
Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html
Cheers.
Doc
Absolutely, explained it very well in way that's will stored into the Brian memory.
Thanksgiving
Where is the sample file link in the description as mentioned in the video - Time stamp 0.11?
Thanks @biplabdasgupta for pointing out.
Here is the sample file
efficiency365.com/wp-content/uploads/2023/11/Ribbon-chart-sample.zip
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html
Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html
Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html
Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html
Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html
10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html
Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html
Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html
Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html
Cheers.
Doc
so sublime..!
Thanks @backare171
Check out my other best practices videos as well.
Task Management Best Practices - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html
Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html
Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
Cheers. Doc.
Nice video, Doctor
Thanks @ryan19899
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html
Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html
Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html
Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html
Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html
10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html
Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html
Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html
Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html
Cheers.
Doc
@@efficiency365 Thank you. Time for me to binge watch.