I'd like to acknowledge that I haven't been super excited about the visualization side of presenting enterprise data until right now. PowerBI, Tableau, Excel... didn't care because the customer also didn't really have any clue, and won't, really, ever. The model and governance were where my excitement and core contribution occurred because the customer has a near total blindspot to those risks and required advocacy. I was this many days old when I finally cared about and took an interest in the front end of this product. These tactics will drive engagement and care for the BI consumer on a personal level. Thank you.
This is great stuff, been doing this for years! As a UI/UX designer also, it’s easier said than done. I believe a lot people struggle with creating a clean app like report from my experience. A nice feature I would like to see with bookmarks to enhance the App like feel, is to allow a bookmark to change its state when another button/action occurs. Example: Closing a drop down page navigation menu after a user selects a page to navigate to. Currently the bookmark just stays active and the nav stays open when you go back to the home page.
Agreed that would enhance things a bit to affect state of other items. Not aware of that coming in the future though :( here's hoping. One thing I always struggle with from a design perspective is the overall look and concept. I typically pull off of what others have done from an inspiration perspective. I imagine others struggle with the same as they aren't design experts.
LOVE this video. People think that building a power bi report happens entirely in power bi. While you definitely have the means to draw every line/shape in power bi, your users will suffer. The same tools exist in almost every other MS product so if you put a little effort into planning it can make the user experience SO much better.
@@GuyInACube Really appreciate the work you do. These are things that past generations of designers/engineers wouldn't provide because they felt their value was in the things they already figured out, not the next thing they were going to figure out. Likes and views can't adequately capture the difference you make when someone is unsure about whether they can do something or not and in less than 10 minutes you open their minds and empower them, especially when you do it for free. Stay effective!
Have just been updating a major organisational report set to standardise the background (lots of visuals to cut/paste keep aligned and out the way of the real dynamic stuff) - such a faff!. Never thought to powerpoint all this. GREAT and thanks for simplifying my day today!!
YES! it can absolutely bring down the complexity within the actual Power BI report as you don't have to mess with all the shapes and text boxes and things floating on top of another...
Using PowerPoint to create backgrounds is so much easier. I just grab our corporate PowerPoint templates, save them as jpegs and load in the slide background I want in my reports. Then follow photography rule of 3 for slide layout to make it aesthetically pleasing.
I have seen the PP being used to develop backgrounds in the past but never gave thought to the cost savings in terms of visuals overhead. Nice! I can also see this as a useful method to prototype layouts to present to end users for feedback prior to development. Thanks as always!
I just learn everyday with you guys, AMAZING! I created a dashboard sometime ago for a client that I had to divide in 3 sheets due to the volume of information, especially because it has map features. Your idea is a great solution for that problem, thank you so much!
👍 Additionally, using an SVG file (instead of PNG) helps maintaining the graphic quality even when zoomed. Ruth discussed in her recent video (ruclips.net/video/ex5Bh79RWrE/видео.html) using an SVG for background to address her fuzzy image issues (she uses Adobe XD, but PowerPoint can export to SVG as well).
Firstly Thanks for the video I have a question regarding drill through "Is there any chance to keep selective filters(should pass only certain filters not all) when we drill through to another page?"
Baking text into the background image is an accessibility no-no. Consider grouping the visuals and providing a title / alt-text for the group to help vision-impaired consumers navigate the report.
There will still be the potential challenge of perf consequences. But also goes to the point of keeping it clean and simple to maintain accessibility and maintain good performance.
First of all awesome design!!! For the info panel, instead of actual bookmarks, wouldn’t page navigation from buttons (after creating separate pages) make the setup easier. What are your thoughts?
You could but i don't think it's as clean or intuitive. The info panel is specific to this page. And allows for an icon button that is obvious for the end user. Your thought is definitely an approach you can take though.
I'm having problems getting the pictures for the info panels to fit the page property. I save as jpg fit to page and go from corner to corner with it and it's smaller so when I bring by data forward it's shifted. Sorry this is super new for me. Any ideas what I'm doing wrong? Thanks for the awesome videos.
I really like this video.... I'm not great at the "visual" design aspects.. I admit it.. But also admit that the Visual experience for the user is soooo very important. Report pages need to be clear, clean and engaging.. Thanks for the ideas.. now I have to go do some work!!! LOL
But you don't need to use PowerPoint... any tool that can create the Image file in PNG format is good to go... PowerPoint is a basic, easy to use and very widely available.. The one think in PowerPoint I'd like to see is the "slide size" be in the same format as the Power BI settings.. Power BI goes by px but PowerPoint is in inches..
@@jrbrosius …and then when you have lots of reports that have different visuals but which you want to maintain consistent styling across, you can spend lots and lots of time creating loads of bespoke PNG images. And then have to spend more time modify them when the user wants an update, or your branding changes, or you want a different mobile layout….
This is cool, but you know what would be also great? Version control and changelog. When you work with plenty of datasets, this starts to be a massive struggle. I know it's not directly related to powerbi, but powerbi also isn't standard software from this point of view
good, nice, great... Apart from that I want to use PBI for advanced analytics including complex DAX KPI measures. However, management level prefers this sort of fancy dashboarding... I know you guys do serious PBI stuff on Saturdays.
I'd say this is serious Power BI stuff 😁 Having a great usable approach to your reports can improve the end user experience and allow you to tell a good story. Not to mention helping to educate users and to potentially hide things not need initially to help with performance and reduce confusion.
I kind of like the idea, but question the efficiency of creating the background in PowerPoint. Doesn't that mean that every time the report changes, you will need to re-edit the background image in PowerPoint?
@@Jedibenuk Yes, I wasn’t referring to updating the dataset. I do like the end result of this technique, but it seems like it would take a lot of extra work during an iterative report development process possibly with weekly or more frequent layout and design changes.
If there are updates to the static items in the background or wanted to change the layout a bit - yes you would need to update the PowerPoint item to update the background image. You'd have to do that regardless if you are altering the layout. Just a question of where you want to spend the effort and how that translates back to the overall report. I'd still rather have that baked into the background image than having different shapes/text box elements that bloat the number of visuals.
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
I'd like to acknowledge that I haven't been super excited about the visualization side of presenting enterprise data until right now. PowerBI, Tableau, Excel... didn't care because the customer also didn't really have any clue, and won't, really, ever. The model and governance were where my excitement and core contribution occurred because the customer has a near total blindspot to those risks and required advocacy. I was this many days old when I finally cared about and took an interest in the front end of this product. These tactics will drive engagement and care for the BI consumer on a personal level. Thank you.
This is great stuff, been doing this for years! As a UI/UX designer also, it’s easier said than done. I believe a lot people struggle with creating a clean app like report from my experience.
A nice feature I would like to see with bookmarks to enhance the App like feel, is to allow a bookmark to change its state when another button/action occurs. Example: Closing a drop down page navigation menu after a user selects a page to navigate to. Currently the bookmark just stays active and the nav stays open when you go back to the home page.
Agreed that would enhance things a bit to affect state of other items. Not aware of that coming in the future though :( here's hoping.
One thing I always struggle with from a design perspective is the overall look and concept. I typically pull off of what others have done from an inspiration perspective. I imagine others struggle with the same as they aren't design experts.
LOVE this video. People think that building a power bi report happens entirely in power bi. While you definitely have the means to draw every line/shape in power bi, your users will suffer. The same tools exist in almost every other MS product so if you put a little effort into planning it can make the user experience SO much better.
Exactly. It also didn't take very long to put this together if you are familiar with the clicks.
@@GuyInACube Really appreciate the work you do. These are things that past generations of designers/engineers wouldn't provide because they felt their value was in the things they already figured out, not the next thing they were going to figure out. Likes and views can't adequately capture the difference you make when someone is unsure about whether they can do something or not and in less than 10 minutes you open their minds and empower them, especially when you do it for free. Stay effective!
Making the most efficient use of space available in a clean, user-friendly way! Love it!
So sneaky to use static pictures. LOVE IT! Great video. thank you for the ideas!
Very nice, would have like to see you handle the red and yellow panels as smoothly
Have just been updating a major organisational report set to standardise the background (lots of visuals to cut/paste keep aligned and out the way of the real dynamic stuff) - such a faff!. Never thought to powerpoint all this. GREAT and thanks for simplifying my day today!!
YES! it can absolutely bring down the complexity within the actual Power BI report as you don't have to mess with all the shapes and text boxes and things floating on top of another...
Absolutely great to see how a high-end report like that is pulled together! That's for sharing. I'll be very much passing this onto my team! 👏👏
Amazing! Just a few clicks and you can put this together. Didn't take very long at all.
Thanks for another nice video, you guys helped me a lot during my student days! A few months ago I got my first job as a data analyst :)
Outstanding! Congrats on getting the data analyst job! All the best in your career! 👊
Using PowerPoint to create backgrounds is so much easier. I just grab our corporate PowerPoint templates, save them as jpegs and load in the slide background I want in my reports. Then follow photography rule of 3 for slide layout to make it aesthetically pleasing.
BAM 👊
I have seen the PP being used to develop backgrounds in the past but never gave thought to the cost savings in terms of visuals overhead. Nice! I can also see this as a useful method to prototype layouts to present to end users for feedback prior to development. Thanks as always!
Great idea. I'll definitely be using this in my reports.
Great to here! 👊
Amazing report ideas. I will steal this for a challenge I am currently working on 👍❤!!!!
BAM! go for it!
Excelent video, please share more content on the topic!
great video Adam. thanks for sharing!
Appreciate you watching it Cristian! 👊
I just learn everyday with you guys, AMAZING! I created a dashboard sometime ago for a client that I had to divide in 3 sheets due to the volume of information, especially because it has map features. Your idea is a great solution for that problem, thank you so much!
This is brilliant stuff! Thanks for taking the time to put this together. So glad I came across this video and your channel. Subscribed.
👍 Additionally, using an SVG file (instead of PNG) helps maintaining the graphic quality even when zoomed. Ruth discussed in her recent video (ruclips.net/video/ex5Bh79RWrE/видео.html) using an SVG for background to address her fuzzy image issues (she uses Adobe XD, but PowerPoint can export to SVG as well).
Great point! thanks for calling that out!
Power BI doesn't handle custom fonts on SVGs though 😒
This is great and thank you for the good job
Great report!) Thank you!
Appreciate that! 👊
Love it! Crisp and new learnings in every video . Thanks
Beautiful, great idea
Firstly Thanks for the video
I have a question regarding drill through
"Is there any chance to keep selective filters(should pass only certain filters not all) when we drill through to another page?"
Where can i get these PNG images?
Thanks for validating my current philosophy on building visuals in PBI.
For the info button where you define terms since that is static, could you make that in power point as well? Then just display the image?
simply brilliant!
Appreciate that Hananto! 👊
Very nice! Clean and intuitive. Any thoughts on how you could incorporate some of these principles in mobile versions of a report page?
Baking text into the background image is an accessibility no-no. Consider grouping the visuals and providing a title / alt-text for the group to help vision-impaired consumers navigate the report.
The background images break the high contrast viewing modes too. :-(
great points! I need to be more mindful of those items. Appreciate you both calling that out.
There will still be the potential challenge of perf consequences. But also goes to the point of keeping it clean and simple to maintain accessibility and maintain good performance.
This is brilliant
Appreciate that ! 👊
I loved the layout!!
Awesome Patrick
First of all awesome design!!!
For the info panel, instead of actual bookmarks, wouldn’t page navigation from buttons (after creating separate pages) make the setup easier. What are your thoughts?
You could but i don't think it's as clean or intuitive. The info panel is specific to this page. And allows for an icon button that is obvious for the end user. Your thought is definitely an approach you can take though.
Hi can I get the background design for this report. This is amazing stuff.
Anyway you can share that power point slide?
Absolutely Bananas!!
YES!!! 👊
VERY cool!
Thanks Bryan! 👊
I'm having problems getting the pictures for the info panels to fit the page property. I save as jpg fit to page and go from corner to corner with it and it's smaller so when I bring by data forward it's shifted. Sorry this is super new for me. Any ideas what I'm doing wrong? Thanks for the awesome videos.
I really like this video.... I'm not great at the "visual" design aspects.. I admit it.. But also admit that the Visual experience for the user is soooo very important. Report pages need to be clear, clean and engaging.. Thanks for the ideas.. now I have to go do some work!!! LOL
You are in good company Ray! This isn't that complicated though - which I really like.
Amazing!
Hi Adam: I was wondering if you can provide a pbix file. That will help learning much better
I was loving this right up to the point you said ‘create it in PowerPoint’ 😂
But you don't need to use PowerPoint... any tool that can create the Image file in PNG format is good to go... PowerPoint is a basic, easy to use and very widely available.. The one think in PowerPoint I'd like to see is the "slide size" be in the same format as the Power BI settings.. Power BI goes by px but PowerPoint is in inches..
@@jrbrosius …and then when you have lots of reports that have different visuals but which you want to maintain consistent styling across, you can spend lots and lots of time creating loads of bespoke PNG images.
And then have to spend more time modify them when the user wants an update, or your branding changes, or you want a different mobile layout….
@@jrbrosius you can actually type something like "1250px" or "720px" in PPT and it will accept it.
Thanks love from India
This is cool, but you know what would be also great? Version control and changelog. When you work with plenty of datasets, this starts to be a massive struggle. I know it's not directly related to powerbi, but powerbi also isn't standard software from this point of view
I'm with you on that! I'm hopeful that will get better over time. It is very much needed.
good, nice, great... Apart from that I want to use PBI for advanced analytics including complex DAX KPI measures. However, management level prefers this sort of fancy dashboarding... I know you guys do serious PBI stuff on Saturdays.
I'd say this is serious Power BI stuff 😁 Having a great usable approach to your reports can improve the end user experience and allow you to tell a good story. Not to mention helping to educate users and to potentially hide things not need initially to help with performance and reduce confusion.
This is really bananas :)
Yes!!! 👊 Glad you agree!
Brilliant guys, thanks for sharing the secret
I kind of like the idea, but question the efficiency of creating the background in PowerPoint. Doesn't that mean that every time the report changes, you will need to re-edit the background image in PowerPoint?
Change as in update the information dataset? No. Change as in add a new measure that you want to show? Yes.
@@Jedibenuk Yes, I wasn’t referring to updating the dataset. I do like the end result of this technique, but it seems like it would take a lot of extra work during an iterative report development process possibly with weekly or more frequent layout and design changes.
If there are updates to the static items in the background or wanted to change the layout a bit - yes you would need to update the PowerPoint item to update the background image. You'd have to do that regardless if you are altering the layout. Just a question of where you want to spend the effort and how that translates back to the overall report. I'd still rather have that baked into the background image than having different shapes/text box elements that bloat the number of visuals.
@@GuyInACube For you, I will give it a try 😀 Don't want to be too negative since I definitely appreciate all of your content!
Bananable staff!!! Tnx
This is Banana, I love it
Oh, I'm copying this baby.
I d rather use tooltips in info buttons to display when hoovering
like to whoever did that bananas animation.
PacmanXGhostbusters 👻🔥
Clean, high performance designs there. Power BI is a resource hog and every meg of RAM counts on lower spec machines.
Gotta save every pixel 👊
🤯🤯🤯
Кулуг виро!