Want a BEAUTIFUL Power BI Report? Start here!

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
- Yooo! - Yooo! What's up? I'm Adam. - I'm Mara. - And in this video, Mara is gonna show us how we create beautiful reports. Mara, thank you so much for joining us. For the folks that don't know who you are, tell us a little bit about yourself. - I'm Mara. I used to work at Microsoft, so we were colleagues before and now ex-colleagues. In the meantime, I kind of went on a solopreneurship journey, and I've set up my own company. And I'm doing now consulting, like online courses and all of that, all related to Power BI (bell dinging) and more specifically design, because frontend is definitely my thing. (chuckles) - [Adam] Amazing. And you've got your own YouTube channel, Data Pears. Definitely go check that out. - Yep. - All right, Mara, you made a bold statement before we started recording, saying that after you show what you're gonna show, even someone like me will be able to create beautiful reports, right? - Hopefully, yes. - Okay. All right. So, okay, where do we start (upbeat music) with creating those beautiful reports, like for someone that doesn't know anything about doing this? I just throw a table on a report. What do we do? - Okay, so first of all, don't throw tables. Please don't do that. Yeah, think properly about what you're supposed to be showing and what are the business goals and what is the goal of that report. If you want a table, I mean, you might as well just use Excel, don't use Power BI in that case. (chuckles) - Well, but I'm gonna put the table in the report page so I can export it to Excel. - Uh, no. (Adam laughing) (Mara laughing) No, you should definitely not do this. - Okay. - Before we actually start about talking about all the design stuff, just, yeah, be mindful of what are your goals with that report and what you should be showing, what kind of insights you should be showing in that report. And once you do that, then you can start thinking about the design, the charts that are going to put in your report and all of that. And that's what I want to share with you today. - All right, Mara. Enough of all this talking, you know how we like to do it here on "Guy in a Cube." Let's do what? - Okay. - Let's head over to your machine. - The first thing that I want to share with you is how do I get ideas for the designs that I create in Power BI. For example, this is Dribble, and it's amazing. It has like loads of different layouts that you can get inspiration from. This is like very easy to use. You can just search by dashboard, and you can even add like green or blue or whatever. And then this will give you like a bunch of like ideas for your layouts and even like for color schemes and everything. The reason I like to go to these websites is because there are a bunch of things that you should consider like the white space or the space between the visuals. And once you get your ideas from here, it's very, very easy to replicate this either in PowerPoints or Figma, which is the tool that I use. And you have Freepik, which is pretty much the same thing. And as you can see, very nice layouts and color schemes and everything so you can totally replicate some of these elements or even the layouts in your own reports in Power BI. - All right, Mara, that's amazing. And I love the fact that I don't have to think about those technicalities of the colors and the spacing and all that. Like someone already did that hard work, and now I just have to try and replicate that. - Yeah. One of the other things that I want to mention is those layouts, they have like their color scheme and everything, and, of course, you probably will have your own color scheme that you have to use from your own company. And it's pretty easy to adapt that, usually those layouts, to whatever color scheme that you need to. So in terms of the colors, if you want to get very creative, you can always use like a color palette generator. And this will basically remove the barrier (chuckles) of you having to be creative on your own. And you can just generate the color scheme and then just put all these HEX codes on your report in Power BI. You can customize your theme. And also there is another one that I like. This one actually is my favorite. You can extract themes from an image. So for example, I'm going to get an image of a report, imagine this one, it's an example that I took from Dribble. And as you can see, it gets like all the colors for you. - Ooh. - I mean, how easy is this? - Oh my goodness. - And you can just move the thing around, and it'll basically generate the color palette based on the image. So now you have your color scheme so you have half of the work done in terms of design. - Mara, that is amazing. I've used that site before, but, yeah, I didn't know. Like that makes it so easy to get the colors that you want to go after if you've got that theme. - Yes. - What else do you have for us? So we've got some layouts, we've got colors. Then what? - Like I said, you have to build the layout itself, right? - [Adam] Yeah. - You can use something like PowerPoint, but I do use Figma. You can use it to do mock-ups for like web applications or mobile applications or Power BI reports. - [Adam] Ah. - So imagine this, I got it from Dribble. I even have here the website. And this was kind of like the original layout, right, which is not Power BI. But based on this, I managed (indistinct) like a layout that uses kind of the same concept in terms of design, but in Figma. Again, you can do this in PowerPoint, even though PowerPoint is probably not as flexible as Figma, I would say. But as you can see, you can build pretty cool stuff. There is another example. This one looks so nice. I loved it. As you can see, you don't even have to be very creative. - Wow. It's really the same. (chuckles) And it's not that hard. (bell dinging) I mean, it might sound a little bit scary, but believe me, it's not that hard to learn and to start building stuff in Figma. - All right, Mara, that is amazing. I love that you can use those tools. For folks watching though, don't get scared by that, right? As Mara mentioned, you can use PowerPoint. We did a video not too long ago about just using PowerPoint to create a basic background. And all you're doing, Mara, just to be clear, is you're creating the background image that you'll use in the report, right? - Yeah. Once I have everything done in Figma, you can export that layout as like an image, as an SVG image, and then you just import it back into Power BI. - Amazing. - And then basically you just, yeah, have the layout and just build your charts on top of it, format your charts, and, yeah, everything should work - Amazing, amazing. - And look beautiful. - All right, Mara, that was amazing. So it's given me a lot of ideas of, I'm gonna go play around with some of those things now. So thank you so much for sharing that. If this topic interests you and you wanna learn more, go check out this video that Mara did talking about four report tricks that are gold. Like you need to know them. So go learn more over there and check out her content. It's amazing. Mara, thank you so much for being with us. As always, I appreciate it. For everyone else, thank you so much for watching. Keep being awesome, and we'll see you in the next video.
Info
Channel: Guy in a Cube
Views: 69,383
Rating: undefined out of 5
Keywords: business analytics, business intelligence, data analytics, data visualization design, introduction to power bi, learn power bi, mara pereira, mara pereira power bi, microsoft 365, power bi, power bi beginner to pro, power bi dashboard, power bi demo, power bi desktop, power bi desktop tutorial, power bi for beginners, power bi reports, power bi tutorial for beginners, power bi visual design, power bi visualization
Id: pKkav_W-jiQ
Channel Id: undefined
Length: 6min 21sec (381 seconds)
Published: Thu May 11 2023
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.