Build THIS! Report DESIGN in Power BI | FULL TUTORIAL
Вставка
- Опубліковано 22 лип 2024
- Come and build this report with me step by step! It is a full tutorial for report design in Power BI :)
In this video I show you the steps I take to make your Power BI report look like an app. In this complete walkthrough you not only learn about app like design called Neumorphism, but many other visualization tricks around bookmark navigation and kpi cards.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
01:23 Building the main visualizations
07:04 Adding dynamic welcome text
08:46 Creating a summary panel with user images
14:18 Designing the background and placeholders in Power Point
26:10 Using the APP like design in Power BI
28:42 Creating a bookmark navigator to switch between date hierarchy levels
39:24 Finishing touches
43:58 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on UA-cam: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX - Наука та технологія
If you are interested in taking your Power BI Design Skills to the Next Level check out my 4 weeks program: my.datatraining.io/pages/powerbidesigntransformation
You are genius brother, please do make videos on Canvas powerapps too , so that we make great ui
Am I blind or your 4-week program costs 2700 (two thousand and seven hundred) EU?
@@nikakalichava8012 no, you are not 🤣🤣🤣 better you just practice step by step with few sets of data and learn by yourself
how I find dataset
@@danish1794 the files are in the link. you have to register
Bas, your visual skills are next level, and so is your video production. 👍
Thanks for the effort you put into this. I'd love to see a video like this on theme creation for consistent branding.
Questions:
Do you use the format painter to speed up the formatting of similar visuals?
Have you used the Export option in PowerPoint instead of Save As? (it means you can keep a formatting file with multiple pages, as it lets you choose to select just the current page to export)
I randomly came across your channel and as a Power BI expert, I can honestly say that everything is butter smooth and very informative.
Keep up the great work !
Fantastic content. The contrast between the out of the box look and your finished report is jaw dropping. I've got so many ideas and tips to take away. Thanks again :)
You are killing it with these videos.
This dashboard is just wow!
Thanks for showing up this design!
Thanks Zaafir, glad to hear you like it!!!
@@HowtoPowerBI where do we get the dataset from
thankyou for this , took me 2 hours and still just did 80% ! Amazing production and pace
In all the Power BI videos I’ve watched (and there have been MANY), this is the first one to give the “Good morning user” measure. Love it! I’m going to add to my reports tomorrow morning 🤣 Great video!
I am really happy finding you with your most interesting and highly educative videos on Power BI. I learn and get motivated with each video you post and would like to appreciate your time and effort in this. Thank you.
One of the best Power BI tutors on UA-cam.
How to Power BI is my go to channel for any Power BI lessons, tips and tricks etc. Thank for the good work, keep it up.
Yey!!! Thanks Theo, totally made my day :):):)
Wow, I'm blown away. You have just changed the way i will do my visualizations going forward.
This is brilliant, Bas. Made me revisit and revamp some cluttered dashboards to try and get that slick app-like look that users love. Thanks and keep up the great work!
Definitely would like to see more videos around report design! I think it can be easily overlooked by report creators but all the more important for the end user.
Appreciate all the effort that went into Bas!
Totally agree the impression you get from the design standpoint, is very important. Probably also increases the frequency and time spent on the report
how get the same dataset for practice ?
@@HowtoPowerBI Dear Sir , can we Have the data set for the above example so we can best play with the visuals
@@engineeringtechnology3113 pbix file is in the download link .. see description
Thats possible with that file
Man, these mini visuals on the cards are genius.... Amazing work.
This is great Bas, the dashboard looks amazing. Some stamps for myself:
9:00 that quick explanation on how to add profile pictures was great
30:00 bookmark navigator is also really cool. it's a little embarrassing that in 2022 the slicer still wont even allow you to change fill color for selected values, this can be an alternative in some use cases
37:00 Constant line! Another easter egg I had never seen before.
where can i get that dataset
These types of videos are priceless. So many techniques to learn from you along the way. Love watching you work.
Thanks Peter :):) very happy to see your positive comment :):):)
Your channel and Alberto Ferrari have the best content in terms of Power BI. Kudos! Thank you! ❤️
Best 44minutes on UA-cam for me. Just 2 request: make more videos like this and walk us through the data preparation too. Maybe 2 separate video one for the visual and one for the data preparation
Love your idea. Definitely worth it.
If only I've discovered your channel before.... !!! But it's not to late, you're are really brilliant. Thanks a lot for sharing with a humble way
Looks so easy when you're doing these visuals.
This is just amazing.
Really appreciating your videos 👏🏾👏🏾
Thanks a loot :):)
This is amazing! Thank you for sharing. It would be great if you started from the beginning and showed us how you collected and organized your data.
Bro. You have no idea how much impact you have to us who are new to this.
Highly appreciate. 😱😱
Awesome 😎 glad it is helpful!
Dude, I would like to see more videos like this, you did amazing, thanks for the tips!
Thanks 😊 ill keep it in mind, more is in the works
Finally a power Bi tutorial to beautify your reports! Thank you!
I saw that list of measures and my jaw dropped!! That would take me a month to get that many to actually work 50% of the time. You are amazing!
:):) these measures are not as difficult as they look like. You can do it!! ✌️
Saw one of your video 2 weeks ago. Totally hooked. i love power bi and want to get a job as data analyst and these "recreation" makes it looks like i have years of experience
Welcome to the channel, happy to hear you like it!!! All the best ✌️
Speachless...in just one vedio learnt so much , adding tooltip, shadow, bookmark , and use of analytic tool ...is just WoW. Thanks you for creating such an intresting and short video. Plase do creats more video like this.
Thanks Deepti for your kind words! It is really nice to hear that it is useful:):)
This is really awesome, Bas! A great demo of combining the powers of Power BI & PowerPoint 😀👏
Thanks Bare :)
Seriously a great video - tons of great content, presented in a clear and concise manner 100%. Subscribed.
Love the shading details in ppt. Redid a few templates today showed it to the boss and they loved it!
I went with a dark theme but was asked to change it to light theme. Either way it looks good.
That’s awesome Brandon! Glad it worked out :) I also like dark themes a lot but most orgs prefer 💡
I can't believe I only just have decided to watch your videos. This is absolutely amazing! I am now on binge watching crusade to see them all. Thank you so much for the tutorials.
Silly question possibily but I am a complete PP noob - how did you choose the two tiles, when i tried i kept on dragging the big at the back too... finally used selection pane but it looks like there is an easier way.
'CTRL A' might work as that selects everything on the page
Literally implementing your tips at work and it makes everyone happy. Keep them going, you are of great help !! a very good teacher
Great to hear Ewen! :)
You keep surpassing my imagination, this is amazing! Looking forward to more! ❤
Outstanding walk through! Straight to the point but also still engaging. Also, shout out to your background design with the lighting in your set up.
Glad to hear you like it! Thanks for the comment on the setup:) some ppl say it looks SciFi…
Wow!! This was amazing!! Subscribed and I would love to see more of these!
Great stuff! I loved the use of the constant line and turning off the responsiveness.
Question: on 31:33 you see the scrollbar in the chart and it doesn’t show all the dates. How can you make it show all the dates?
So many tips compacted in one video! Great video! Thanks for sharing!!!
Wow. Well, I must say this has to be one of my favorite UA-cam channel. Just saying. Anyone disagree? This was very informitive and I could only image the types of reports I can now build based on this info. Thanks alot!
Thanks a lot and good luck in building 🔥 reports :)
Excellent tutorial, thank you, this is exactly what I needed. Love Power BI but miss CSS when styling, this provided some work arounds that I will start using today!
thanks!! 🙂 that would be amazing to be able to use css for styling. This custom visual however gives you already a bit more control through html -> www.html-content.com/ .. maybe something you wanna check out
Thank you for the instructional video. I am only at the initial stage of learning about PowerBi (Business Intelligence course behind me) and thanks to you I know how to present hard work in a clean and tidy report. Thanks to you, I want to keep getting to know the secrets of PowerBi. Thank you very much.
I am very happy to hear this! Keep it up!!! 💪👨💻
Absolutely fab video! There isn’t enough attention paid to report design and this video is so so helpful. Amazing ideas and tips and tricks thank you!
Thanks Amrita! Definitely, design helps with keeping users attention :):)
God bless you for this beautiful report and presentation. Your energy always motivate me that one day. I will attain this feat... Thanks
Dude you are the best, every single time I come here I learn something new, its unreal
Haha awesome Vinicius :) thats what I aim for :):)
Hey Bas! that was amazing stuff by you i have been watching your videos when i started learning power bi your finesse of making dashboards are impressive and you're the artist .......
Wow 😮 that's exactly what i'm looking for. Thanks for amazing tutorials
I'm so pumped about this design. Great tutorial, great pacing.
Hi Bas, great content (again)! Thank you! Quick question please, for the bookmarks creation part we should unmark the Data, right?
I´m from Brazil, I Loved your work, but i don´t have money enough to pay this course now. I´m gonna following you here on youtube.
Really fan of your Reporting skills. Great learning from each of your video.
Awesome video. I'd normally download a bunch of custom visualisations to try and achieve an aesthetic that doesn't look anywhere near as polished as what you've done. Keep up the awesome work!
:):) thanks a lot!!! gradient is already half of the success haha 😆 more videos like this coming
Really thanks for this Video. With using this Idea and Visual I tried to develop same kind of report in Power BI. Please help us to explore more.
Amazing video! Learnt so many things in just this one! Thank you Bas, you are awesome! In my native language "Bas" means "enough", but we won't have enough from you, keep these coming! 😊👍
Hahaha time to change the name?! Thanks a lit for the kind words!
Awsome man. Your videos are so great. When I want to find new ways to make an innovator dashboard I just have to see your videos. I am from Colombia and It's really easy understand you. Thanks bro, please don't stop ever of create these amazing videos 👍🏽
Wow thanks a lot for this encouraging feedback! :):) im not planning on stoping no worries, all the best to you and greetings from Germany!!!
Bas Bas Bas! Thank you for this one.
Cover so many things that haven't been covered in other videos online.
Great work amigo as always.
I have a feeling ill be referring back to this video a lot.
thanks Christopher :) i am planning to release soon more design videos so you have some choice in sharing :)
OH MY GOD!
THIS IS AMAZING!!!
I didn't think it would be so easy to create such a cool design.
I will be waiting for another video on this topic!
Thank you:)
:):) yesss its quite surprising what power point can do :) more is coming, no worries!
Thank you! This video is so detailed. I just want to know if markers you set are just linked to the person you had selected at that time.
Awesome ! would like to see the structure of the tables at the beginning how the data is laid out.
It’s an absolute out of the box video, many thanks.
The way you are explaining things even my grandPa Can easely learn PowerBi. Waouh! Keep it up and thanks much for sharing
Haha good one Cedrick! have you put this to your grandpa test? :)
@@HowtoPowerBI he is a data scientist and likes report design. Your videos will inspire him a lot hahaha (me included) 🙏✌️
You are an amazing tutor. If its anything related to Power BI that first search I look out always is your channel.
Thank you, really glad to read this!
Where is the dataset, i cannot find it on website...
If you have the link, please share 🥺
For me, you are the Bob Ross of Power BI.
Thanks for all your great ideas. ;)
Hahahah was recently watching him :):) is it the hair or the smile?
Hey Bas, This is Just Brilliant. Would like to see more design videos like this from scratch!!!
Thanks for the feedback much appreciated:)
This is amazing 👏 I want to see more videos. Thank you for always serving us with great content
Thanks Tosin :):) in making!
Loved the Visualization..and the minimalist theme.! Looks neat and very professional
Thanks a lot!!! ✌️
Love the content!!!! just one recommendation can you use Pointer Focus or some tool that shows the click location as you are going through a tutorial?. I'm finding myself having to pause and Rewind a lot because I can't see exactly where you are clicking thank you
This is some insane skill and ingenuity. Thanks for another great video
You are doing always an amazing job. You put so much effort, thank you! Could you please make a video for predicting future values(linear regression) such as sales?
Thanks! Will think about it, who knows :)
Instead of bookmarks for your line chart buttons, could you use the preview feature for field parameters?
you are taking Power BI to next level, awesome! thanks for sharing this...
:):) thanks!!
Thank you so much for this video... In one video learn so many things 🙂🙏
Wow! You've really taken visualisation to the level of art!! Thanks for sharing!
Thank you very much! 😊
@HowtoPowerBi this was a great lesson, I am using this currently in my reports. However, I am finding it difficult to keep the layout consistent with the background if I zoom in or out in Power Bi. Do you have any recommendations on how to keep the layout of say text boxes, kpi cards and charts in line with their respective background boxes while zooming in or out? Currently they work only at 60% zoom.
I really like your suggestion. My only concern is about the shadow arround the page when seen from workspace. Is there any workarround for that? (guess not)
Great thanks, surely blow my mind! Love it!!!🎉🎉
This is what I have been looking for! Thank you very much!
😎 awesome!!
Thank you. It was wonderful. I want more videos and more tips
Another excellent work 👏Baas. I always learn one or two things each time I watch your videos.
That’s awesome Tairu! Thanks 😊
We always would like to see videos like this. Keep the good work and thank you so much for spreading such knowledge.
Thanks Fouad :):) that’s awesome 😎!
App-like visual is Awesome!!! Liked, Subscribed and Bookmarked...
Awesome Gary!
Love your work! Keep the awesome videos coming. Question: my Power Point does not allow to save files to SVG. How do I correct this?
You are one of the best, i have suscribe immedialty. I learn a lot. Gob bless u
Thank you so much, buddy!! That's very useful. I never used PowerPoint to make templates, nice tip! Regards from Argentina!
Glad to hear that Matias! Power Point can be quite useful :)
Professional presentation in a sample way. Thank you.
Amazing video, thank you very much!
Beyond the design (which is ace!), I'd be intersted in seeing a "prequal" video showing the sources you'd use to capture the data (steps, hr etc) and how you'd go about creating the data model.
This would be helpful to me as well. Does anyone know if this has been done yet?
Amazing... just amazing... these videos are on another level and takes an intermediate user like me to learn more and strive for a more advanced level.
Glad you like it Alex more is coming :)
HI,
I used this in my report, working fine on the Power BI desktop, but not after publishing the report, like on the power bi desktop showing Good Afternoon but on power bi web showing Good Morning. Pls help.
I just discovered this channel today and I feel so lucky. Big Ups!
Yey! Let’s goooo
Hey Bas,
This is again best topic,best use of Microsoft tools,best report…!!!
Simply wow…!!!
Thanks a loot, power point is also a power tool, or?! ;)
Thank you so much Bas, this is lovely. I would appreciate if you can include blank files(Dataset) used in the video, so I can practice alongside.
Thanks! Dataset is not shared for this video
dude just love the way you explain and present !
Great, man! Cheers! Btw, what version of Power BI are we using? Thanks.
Hello Bas, The dashboard is excellent. Could you please provide guidance on the appropriate image size and how to prepare the data for the image URL? Thank you very much.
Hi BAS, its good to see your videos nice, every one is looking different, and different idea of presentation of thing in report.
Thanks Reddy :)
Hey Bas ! Thanks for the lovely tutorial. Quick question , in the photo you displayed , can I display the profile picture of the current connected user?
Great video. So many concepts explained in a really simple way... Well done.
Thanks 😊 Kostas
Is there anything that you cant do 😃 you are unimaginably amazing Bas! 🥰😘 awestuck.. my favourite thing is the way you innovate and with so much ease and structured explanations.. bravo ! 👌🏼🙌🏼
Omg 😊 thanks!! This ease of explanations takes a lot of cutting of the original footage ;)
@@HowtoPowerBI I can pretty well imagine that.. but that editing is to the perfection! Kudos to you Bas.. wish you hv some courses where you teach these and more
This looks great! I got one question.. When I export this to a svg file, the coloured bar on the left is changed to grey in the exported file. Do you maybe have any idea why that is? Thanks!
Fantastic! May I ask how did you get the dimUser measures? Thanks!
This was such a great video! More like this one would be MUCH appreciated!
Thanks for the feedback! More Is in making as we speak Brandon
Dude, you are crazy! You are absolutely smashing it :D
BAS, огромное спасибо за ваши ролики. Супер полезно, очень круто. Продолжайте пожалуйста!!!
thanks!