Here's a BANANAS report design idea!

Подписаться 440 тыс.

Просмотров 42 тыс.

50% 1

There are many things you can do in a Power BI report that aren't super complex. Here are a few ideas to get you thinking! If Adam can do this, you definitely can! Shout out to Chris Hamill for this design!
Chris Hamill:
/ chrishamill17
Info Panel Video: • Help your Power BI rep...
Mastering Bookmarks: • Mastering Power BI Boo...
Custom Background: • Make your Power BI rep...
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #Report #GuyInACube

Наука

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

24 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 90

@adamziegele Год назад

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.

@GuyInACube Год назад

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.

@TheRahuligan 2 года назад

Making the most efficient use of space available in a clean, user-friendly way! Love it!

@jameshayes2941 2 года назад

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.

@GuyInACube 2 года назад

BAM 👊

@fpoester 2 года назад

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!

@HachiAdachi Год назад

👍 Additionally, using an SVG file (instead of PNG) helps maintaining the graphic quality even when zoomed. Ruth discussed in her recent video (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-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).

@GuyInACube Год назад

Great point! thanks for calling that out!

@Guiburgueir4 Год назад

Power BI doesn't handle custom fonts on SVGs though 😒

@erickelley7703 Год назад

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.

@MikeW589 2 года назад

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 2 года назад

Exactly. It also didn't take very long to put this together if you are familiar with the clicks.

@MikeW589 2 года назад

@@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!

@WarrenThrush Год назад

This is brilliant stuff! Thanks for taking the time to put this together. So glad I came across this video and your channel. Subscribed.

@samaguire1 2 года назад

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! 👏👏

@GuyInACube 2 года назад

Amazing! Just a few clicks and you can put this together. Didn't take very long at all.

@scobob 2 года назад

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!

@AKJohn88 2 года назад

Love it! Crisp and new learnings in every video . Thanks

@ameersuhelkhan4398 Год назад

Absolutely Bananas!!

@GuyInACube Год назад

YES!!! 👊

@yvonnewatkins5077 11 месяцев назад

So sneaky to use static pictures. LOVE IT! Great video. thank you for the ideas!

@veltmanos 2 года назад

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 :)

@GuyInACube 2 года назад

Outstanding! Congrats on getting the data analyst job! All the best in your career! 👊

@jonathanburgess8890 Год назад

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!!

@GuyInACube Год назад

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...

@raynip125 Год назад

Beautiful, great idea

@MrAszpic 2 года назад

Excelent video, please share more content on the topic!

@trisabiswas9375 2 года назад

I loved the layout!!

@rakeshkumarsharma195 Год назад

Awesome Patrick

@zinabutebeje6178 Год назад

This is great and thank you for the good job

@robbieausman1337 2 года назад

Thanks for validating my current philosophy on building visuals in PBI.

@cathrerinezetadrones3169 Год назад

Very nice, would have like to see you handle the red and yellow panels as smoothly

@alibrownster Год назад

Very nice! Clean and intuitive. Any thoughts on how you could incorporate some of these principles in mobile versions of a report page?

@cristian.angyal Год назад

great video Adam. thanks for sharing!

@GuyInACube Год назад

Appreciate you watching it Cristian! 👊

@zzota Год назад

Great idea. I'll definitely be using this in my reports.

@GuyInACube Год назад

Great to here! 👊

@joanjoan 8 месяцев назад

Amazing!

@joelngige5776 2 года назад

Amazing report ideas. I will steal this for a challenge I am currently working on 👍❤!!!!

@GuyInACube 2 года назад

BAM! go for it!

@ruslan.zakirov Год назад

Great report!) Thank you!

@GuyInACube Год назад

Appreciate that! 👊

@brypie04 Год назад

VERY cool!

@GuyInACube Год назад

Thanks Bryan! 👊

@akhilsaipatibandla9647 Год назад

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?"

@hanantoprabowo7341 Год назад

simply brilliant!

@GuyInACube Год назад

Appreciate that Hananto! 👊

@MattChandlersc Год назад

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?

@smartrose7997 Год назад

Thanks love from India

@jfm011 2 года назад

Hi can I get the background design for this report. This is amazing stuff.

@danielrunzer 2 года назад

This is brilliant

@GuyInACube 2 года назад

Appreciate that ! 👊

@jrbrosius 2 года назад

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

@GuyInACube 2 года назад

You are in good company Ray! This isn't that complicated though - which I really like.

@yelperalp 2 года назад

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.

@matthewhawkshaw3600 Год назад

The background images break the high contrast viewing modes too. :-(

@GuyInACube Год назад

great points! I need to be more mindful of those items. Appreciate you both calling that out.

@GuyInACube Год назад

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.

@brownlkt Год назад

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.

@AnnWong1 2 года назад

Brilliant guys, thanks for sharing the secret

@elizabethgrp Год назад

Anyway you can share that power point slide?

@richardcroft3676 2 года назад

I was loving this right up to the point you said ‘create it in PowerPoint’ 😂

@jrbrosius 2 года назад

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..

@richardcroft3676 2 года назад

@@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….

@HachiAdachi Год назад

@@jrbrosius you can actually type something like "1250px" or "720px" in PPT and it will accept it.

@visheshjjain 2 года назад

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?

@GuyInACube 2 года назад

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.

@adnanalam7200 Год назад

Hi Adam: I was wondering if you can provide a pbix file. That will help learning much better

@pavelandreev6023 2 года назад

Bananable staff!!! Tnx

@tanmayshinde7853 Год назад

Where can i get these PNG images?

@azharshaik21 2 года назад

This is really bananas :)

@GuyInACube 2 года назад

Yes!!! 👊 Glad you agree!

@vanlessing 2 года назад

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.

@GuyInACube 2 года назад

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.

@marekklucka4407 Год назад

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

@GuyInACube Год назад

I'm with you on that! I'm hopeful that will get better over time. It is very much needed.

@ahmedtareq5342 2 года назад

This is Banana, I love it

@biexbr Год назад

Oh, I'm copying this baby.

@Robay146 Год назад

PacmanXGhostbusters 👻🔥

@nikakalichava8012 Год назад

like to whoever did that bananas animation.

@chrisrucker9975 Год назад

🤯🤯🤯

@javiersolarirazabal7089 Год назад

I d rather use tooltips in info buttons to display when hoovering

@deanj5961 Год назад

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 Год назад

Change as in update the information dataset? No. Change as in add a new measure that you want to show? Yes.

@deanj5961 Год назад

@@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.

@GuyInACube Год назад

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.

@deanj5961 Год назад

@@GuyInACube For you, I will give it a try 😀 Don't want to be too negative since I definitely appreciate all of your content!