Power BI Tutorial For Beginners | Create Your First Dashboard Now (Practice Files included)
ฝัง
- เผยแพร่เมื่อ 29 มิ.ย. 2024
- 👉 Join our popular FREE Power BI QuickStart course today: link.xelplus.com/yt-d-beginne... 👈 It's Quick, Easy & Packed With Value!
In just 20 minutes, you'll create your first Power BI dashboard and publish it online. Follow along with the downloadable files:
⬇️ DOWNLOAD the files I use in the video from here: pages.xelplus.com/powerbi-int...
📌 Key Tutorial Highlights:
▪️ Easy Installation: Learn how to quickly install Power BI from the Microsoft Store or powerbi.com.
▪️ Navigating the Interface: Get familiar with Power BI's welcoming screen, report tab, and essential features.
▪️ Data Import and Transformation: Import data from Excel or CSV files and use Power Query Editor for data cleanup and formatting.
▪️ Building Relationships: Understand how to create relationships between different data sets for effective analysis.
▪️ Interactive Reporting: Create dynamic reports with charts, tables, and slicers for insightful data visualization.
▪️ Time Intelligence Analysis: Perform year-over-year and year-to-date calculations without complex coding using Quick Measures.
▪️ Map and Line Chart Visualizations: Enhance your dashboard with geographical map charts and trend-tracking line charts.
▪️ KPI Tracking: Incorporate KPI cards to monitor key metrics at a glance.
▪️ Advanced DAX Formulas: Get a sneak peek into creating custom measures with DAX for deeper data insights.
▪️ Publish and Share: Learn to publish your dashboard online and share it with others or integrate it into Microsoft Teams.
⭐ If you're ready to become a Power BI Pro, join our "Fast Track with Power BI" 👉 www.xelplus.com/course/fast-t...
Power BI can feel overwhelming because it has so many different components. That's why I'll take you step by step and you can follow along with me by downloading my practice files. By the end of the video, you'll have created your first interactive Power BI dashboard which we'll publish to the web. I'll also show you how you can share your Power BI reports with others and how you can add your report as a separate tab in Microsoft Teams.
🌍 Join 400,000+ professionals in our courses: www.xelplus.com/courses/
00:00 How to use Microsoft Power BI - Tutorial for Beginners
00:30 Download and Install
00:55 Welcome Screen
01:26 Import Data to Your Report
02:24 Transform Data from Text/CSV Using Power Query Editor
05:11 Transform Data from Excel Workbook Using Power Query Editor
08:40 Join Tables with Relationships
10:34 Insert Chart with Slicer
14:03 Insert Tables with Quick Measures
17:24 Insert Map Chart
18:29 Insert Line Chart
18:57 Add KPI Chart to Dashboard
20:17 Save and Publish Report on Web
21:15 Share Report with Others
22:05 Wrap Up
🎬 LINKS to related videos:
- Excel Productivity for Lazy (but Smart) People: • Excel Productivity for...
- How Power Query Will Change the Way You Use Excel: • How Power Query Will C...
🎒 Get the Official XelPlus MERCH: xelplus.creator-spring.com/
➡️ Join this channel to get access to perks: / @leilagharani
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#powerbi
Grab the files I use in the video from here 👉 pages.xelplus.com/powerbi-intro-files
If you found this video helpful, you're going to LOVE my FREE Power BI QuickStart course: link.xelplus.com/yt-c-beginner-powerbi-freecourse 👈It's designed to get you results FAST, without the techy jargon.
Please where are the files ? Kindly help with location and direction thanks.
done😃
@@PreplyshortVid The link for file download is in the description of the video.
Hi Leila, I just got stuck when I try to graph
Quantity and noticed Sum Symbol missing
under loaded data set. What can be done to fix this?Awesome tutorial by the way
When I open the link for the files. Only one of them gets downloaded(Customer Master data). There is some error with invoice data. Can you check please?
Clear, unrushed pronunciation, can understand every word, unlike many other Power BI experts who speak too fast and crunch their words. It is actually rare to find such coaches on Power BI and other Microsoft software programs. Thanks!
As a very experienced user, I can wholeheartedly recommend Leila's training here.
I was just seeking to 'freshen up' from a beginner's point of view before helping to train someone. Her training was spot on with what it emphasized and how. She hits all the critical points clearly and does not stick to overly simplistic examples. She sets up the viewer for next steps and advanced work. I was very impressed & this helped give some pointers for my own training assignments. Thank you Leila. Great job!
So far the best tutorial for new users like me. Love the pace of your explanation.
I've wanted to use Power BI for a while and have watched many power BI videos on TH-cam and basically gave up because they made it so complicated, but this was by far the most easy to understand. I hope you do a many more
Finally It's "Power BI from Leila" and I am so glad that, now we can expect the same amazing teaching from her to learn it, just as other subjects covered before! Thank you and expecting more videos on all aspects of Power BI, keep them coming!😊👍
I'll do my best, Vijay 😊
V
Fuh
@@LeilaGharani bvndar bbc v'vv9'v8'vv
@@LeilaGharani bv
I am looking forward to your power BI online course , hope it will come soon. I enrolled your other online courses, the best $ i have ever spent in year 2021. Thanks for the teaching 😀.
Being a follower already from Excel tutorials I now make (I believe) the natural transition to Power BI tutorials. Indeed, I couldn't agree more how powerful and dynamic it is and how this solution brings the power to the end users (producer of report and reader) without being dependent on too much technical support for every single development of your own reports. So, thanks for this introduction and I take this chance to raise the good challenge of having more tutorials for Power BI and data analytics. Thanks again!
Very well done, Leila. Very much appreciated!! I had never, never, ever dared to start with Power BI without your help/support. Thank you Leila!
Hi what an awesome tutorial! i wasn't aware of this at all. All your tutorials are worth it. I personally Thank you for the effort you and the team behind this are doing. Wishing you best of luck and we will be hoping to see more from you.
No matter how many courses I have already taken on a topic, yours is always a MUST HAVE. Currently going through the Power Pivot and DAX course and am super excited to know that Power BI is on its way. I heard that a Financial Analyst course is in the pipeline too. That is simply amazing. Can't wait!!!
Wow, thanks!
What I like in Leila lessons that she explain very softly and in detailes. She is my lovely teacher in youtube
Thank you! 😃
Every time I watch your videos you blow my mind. I had no idea that Office apps were so powerful. Your videos on Excel make me see it in a whole new light. Power BI looks incredible. Honestly Microsoft needs you on their marketing team to make videos that show what the apps can do because they do a terrible job of it. Your videos have done more for me understanding the power of Office than anything else online so far. Thank you. :-)
Jerome don't learn microsoft bi from a woman, what is wrong with you?
🔥🔥🔥 what an awesome tutorial! This comes at the perfect time for me because I’m trying to learn Power BI to help me transition into data analytics. I hope you post more Power BI content soon. You’re a wealth of information. 🐐 status confirmed! 💯
٧٨٩ ٩
This was great! In 23 mins she covered what others accomplish in over an hour. I understand that there are different type of learners. In my case this works perfectly.
I just watched this video about Power BI and I have to say, I'm blown away by how powerful this tool is. Many thanks Leila , for the amazing job of explaining its capabilities and demonstrating its features with precision and expertise. I appreciate how engaging they were throughout the video, making it easy to follow along and understand the concepts. As someone who's been looking for a powerful data visualization tool, I can see why Power BI is such a popular choice. Thanks for sharing this informative and enjoyable video!
Hi Leila! May I suggest a specific session exclusively dedicated to the part of : data modeling (relationships between tables, etc...) and another one on managing data sources (best practices on updating data sources, dos and don'ts) because most of the tutorials out there are about how to create a report but then there's not much about maintaining it, improving it starting with our own data sources, etc... Thanks in advance for your consideration and service to the community - on my job as a project controller it has been helping me a lot!
Right course from right tutor on right time. Looking forward to explore more on power BI and other power platform products with the support of one of the powerful online tutor 😃
Leila you're becoming most outstanding lecturer for Microsoft apps tutorials. Microsoft learners community is ever grateful.
Just getting started with Power BI, please slow motion for us to follow suite.
More Love from Africa
Great timing! I was recently asked to create a dashboard and my first thought was Power BI but didn’t have any experience with it. Thanks to you, I have knowledge on where to start.
Leila, you have an incredible talent of thoroughly and clearly explaining this Power BI in simple terms. I appreciate your service.
Thank you. This has really been helpful. You have no idea of how many channels I have run through and finally your channel came along. It’s been great learning from you. Thank you ma’am. Unto the next video 🏃🏃
Great to hear!
Leila…..this is one of your very best videos! I had heard of Power Bi but never touched. I can’t wait to dive and see how this can improve my reporting and forecasting. Keep up the great work!
I swear, in this 20 minute tutorial, I feel more confident than I have in months with this. Now I’m ready to get more advanced. Thank you so much!!!
Wonderful!
You're such a great teacher ! Been watching many of your tutorials on Word & Excel and each and every time I'm impressed. You explain and show every step in such a logical and neat way. I can't thank you enough for your teaching and for all the very helpful tutorials on your channel !
Thank you Danielle for your support and your very nice comment!
I'm looking forward to being an expert on power bi please I need more clarification
@@LeilaGharani I really enjoyed the teaching and I need more clarification pls
Dear Leila, you are awesome, really a hard & heart working teacher as always. I admire your knowledge and soft presentation skills, love the video which you had shared on life story. Keep up the good work, Best Regards to you and your team.
Great tutorial. Thank you. I love how you explain the various options available at each step. It helps when we are trying to create our own reports. Also, it wasn't a dry tutorial as many of these are. Thanks again.
I hope you will release a new Power BI course series in the future, you're a great instructor, thank you so much 😊
The wait is over, I'm sure there will be more videos on power bi. This video is so explicit. Thanks as always Leila 🙏
Yes, more to come 😊
As an elementary school teacher, I'll probably never use this... or any other content on this channel, for that matter. I just can't stop watching these tutorials though. It's so entertaining and well explained. Good job!
Thank you, Leila! This is life changing for a financial analyst who only uses excel! I can't wait to build a beautiful report to my manager!
I find no words that can describe my thankfulness to you Ms. Leila.
I've learned a lot of wonderful things just from your channel.
Wish you all the best.
Finally Leila started using power bi 😅 , hope to see new tutorials so soon.
The right instructors are the key to learning. I learned more out of this video than an 8 hour class.
Clear, simple, clean and with the right amount of content for a beginner to get started.
I had to subscribe.
Thank you Leila for commencing to share video tutorials of Power Bi. I have been waiting for this since so long, the way of delivering is alway unique and easy to understand.
Great explanation for a beginner like myself ❤
Glad it was helpful.
Thank you for all your hard work! Everything is presented in a very understandable way and crystalizes into an amazing studying material. A quick question - as I'm a keen follower of your power courses, can we expect a decicated Power BI course in the future? I'm pretty sure there are many of us impatiently waiting for that one :) Thank you again!
You're very welcome, Štěpán! Power BI course is in the works and we're planning to release it end of this year.
@@LeilaGharani That's briliant, standing in a line already for that one :) Thanks again and keep up the great work!
It is really over due.
Just wow… when you teach, everything seems so simple… thanks a lot Leila for educating us…
Qui a dit que Microsoft et un PC n’étaient pas ergonomiques ? Perso j’adore. Merci Leila et je continue encore et encore à puiser un maximum d’idées et d’inspiration dans vos vidéos. Pro et agréable. Un super tandem !
Hi Leila
Finally ! When can we expect full fledge Power BI tutorial on Udemy or TH-cam. Eagerly waiting for it.
Thanks.
Leila you are awesome, thanks for explaining things simply, at a good pace, and with the aid of visuals
Leila, glad to see that you include Power BI in your training. Now i can leran little more than before with others vloggers.
I'm happy to follow you in TH-cam.
Thank you Leila for this tutorial. I just started working with Power BI, this video came at the best time. :) I will definitely practice with this files. Looking forward for more videos on the subject. :)
Many years ago, I saw a quote attributed to Albert Einstein, "If you can't explain it simply, you don't understand it." I think of that quote every time I watch a Leila video. Today's video is another perfect example. (Honestly, ... I'm envious of her 'talent' in that regard).
Power BI has been the #1 item on my Bucket List ... and although I have a loooooong way to go, this video and Sherpa Leila's other tutorials will get me started on my arduous trek ... but I am so looking forward to the trip.
Thank your ... thank you ... thank you (cannot say it enough times!)
My pleasure, Chris! I hope this will get you started on your BI journey.
This is awesome! Our institution is just getting PowerBI so this tutorial came out at the perfect time. looking forward to more tutorials on this!
Finally, Power BI Video from Leila, Thank you🙏... Looking forward to more such videos... thanks for teaching complex concepts in the most simple way possible...
Finally Leila version of Power Bi, even if have gotten what i'm looking for , from other sources , i still have to consult Leila! her version is the game changer!!! Thank you for all you do Leila
It was long waited. Thanks, that you finally talking on Power BI. Hoping you make us better in Power BI in future. Looking forward for more exciting tutorials.
No excuse not to learn such a powerful tool. Thanks Leila!
This was amazing, I've never used Power BI before, but this tutorial really taught me so much! Thanks!
Hi Leila,
Thank you so much!
You have no idea how much you have helped me during my academic journey with your videos.
God bless you 🎉
I've been skimming through videos and just didn't grasp Power BI. THIS VIDEO IS EVERYTHING!!! I will be watching all of your Power BI videos!!!! THANK YOU! ❤
I'm so glad!
This is one of the best "How to Use Power BI" videos I have watched...it was extremely helpful to use the download while I watched. Thank you for sharing your amazing knowledge with the masses, Leila! 🙏
Glad it was helpful!
Thank you leila for providing the basics on power bi, it really sounded interesting to me and i will definitely love to learn more about it.
Perfect video to get introduced to Power BI for excel Pros!
I always follow your videos, Thanks for the knowledge!
I really like your way of explainig stuff - clear, simple with right amount of details. Power BI is getting more and more popular so I`m looking forward for next tutorials from you. Thanks and best regards from Poland. :)
Amazing video, I installed Power BI and came here for learning. Now... back to work. Thanks!
Dear Leila, I learnt Power Query through your videos and have basic BI skills, but now thanks to your videos I will expand my skills further. You are brilliant, truly grateful
Absolutely brilliant! I've watched other PowerBI videos, this is the first I actually followed along with using the tool. Thank you very much!!!
Great to hear Chris!
This is really great. Exactly what you need to get started in a short amount of time. PLUS you can work along with it as she gives you the data she uses.
If someone got an error when applying the Date combination for columns Month,Day,Year is because your system has another date format (for example, i live in South America and Date is Day/Month/Year). Love the tutorial, love you Leila!!!
Thank you for this! I just followed your steps, although some options have moved around in the latest version, I was able to figure it out and get it done. Your videos are much appreciated.
I have no word for you, better if I say you "the Microsoft Angel". I have learnt a lot from your videos. Thank you so much.
You are an amazing talent and my go to teacher. Thanks to you sharing your knowledge I am successfully transitioning my career to the direction I wanted. 💐💐💐
Thank you so much Leila.. I am learning a new skill through your videos.. your videos durations and the method of teaching is very good.. every one can understand it..
Awesome, Concise explanations at the perfect pace! Thanks Leila!
I was literally waiting for PBI videos from you as you would provide all pro tips n tricks. Thanks and keep rocking 👍
The best tutorial I've seen on Power BI. Thank you!
Great stuff . Thanks Leila. Power Bi (DAX and M) are on my 2022 to do list.... Happy Holidays to you and your family as well as your team.
Same to you, Matt!
I was eagerly waiting for Power BI from your side. You explain so well.
Thank you so much 🙏🙏
My pleasure 😊
Thank you so much Leila, great tutorial (as always!) Don't know how you fit in sharing so much knowledge in such a helpful way. So grateful you do though 😃
Thank you so much, Marcus!
I have just started learning POWER BI. It is a very well prepared video. Your way of explaining is also very good. It was very useful to me. Thank you very much.
OMG I’ve been waiting for someone to cover this. Thanks so much.
Thank you Leila Gharani for the good stuff. You made learning PowerBI simple. Keep up the good work !!!
Thank you! 😃
This is a phenomenal video!! I'm a new auditor and will be needing to present my findings from initial research in an intelligent manner and my office actually has Power BI!! I can't wait to run through the rest of your PBI videos!! Thank you so much!!
Glad it was helpful!
It's really a clear explanation about power BI in this video & for beginners can easily understand the concept. Thank you
Thanks Leila for this. I have been listening to powerBI for quite some time now, and glad you shared this one, simple yet effective. Motivated me to download it and now am eager to start building the dashboard on powerBI.
Wonderful!
@@LeilaGharani Thanks, and it's the end of the day for me, and am glad to tell you I have created my first powerBI dashboard and it just took me 1/10th of the time I took while creating the same thing on excel. I was not aware it is that easy. Thanks again for letting us know this :)
Great content - It sure moved quickly ... I am glad its on youtube so I could pause, back up etc.
Now! this is a master class! I don't think anyone can do better!
Leila, I thank you so much for this video! I finally found tutorial and the good advices how should I use Power BI. Thanks a lot!
Mind blowing opportunities explained in a very encouraging and clear tutorial. Excellent video. Thanks!
Always crisp and clear. Thanks Leila💛
Awesome content. I learn a lot on power BI in less than 30mn. I will now try and build my first dashboard
Awesome. Very clear & thorough tutorial to help me get started with Power BI! (My head is SPINNING with ideas for the type of data I can easily aggregate & present through Power BI with my Teams.)
Great to hear!
Thank you Leila, indeed very easy to follow along. I use PowerBi but still found some really good shortcuts in your tutorials. I am sharing the link colleagues ! Saves me time to train them :)
Great to hear!
the quick measure thing is stunning, thanks alot!
Thanks for this Leila I'm big fan of how you are making us take the max of this with the minimum efforts,,, I say it again you are the best
Yay! Been waiting a long time to see some PBI videos on your channel! Between this and Power Query, this is where it’s at! Looking forward to more!
Hope it was worth the wait 😊
Thank you Leila. I've been flowing your videos on excel and i learned a lot with them. I hope do the same jorney on PowerBi. Waiting for more videos. :)
Very informative, awesome tutorial Leila!:) You are a true professional! I just wonder how many people are behind of creating such a wonderful material. Don't tell me please this is just yourself? Good luck. Greetings from Poland.
I have been waiting for a long time ago. Thank you so much for your value and detail about Power BI.
My pleasure!
I have to say, you did exceptional work on this video. Spot on. Straight to the point and covering a lot in a short time. And we get double for less time. BI and Query. It seems you also anticipated the various questions we would have. You put in much work into this. This is me saying we see it, and we appreciate it.
THANK YOU.
Most expected session from you. Please, teach us the complete power BI. Thank you for your efforts. 🤝🙂🙂💐💐
Just came across your channel for the 1st time and learnt the dashboaed in minutes. this is what i have been struggling to achieve for months. You are such a great teacher. Thank you for sharing your knowledge
It makes me happy to hear that! Great to have you aboard :)
Thanks leila, I start learning power query and Power BI from u 🥰 keep up the great work
Thanks a Ton, Leila. That was very informative and was so easy and quick. Looking forward to more BI vids from you. Love your work always!!!
Glad you liked it! More to come :)
Thanks a lot for this tutorial it was on point and very clear I watched some video before but, yours were the best. Thank You
I was waiting for this. You made my life easy. Thanks with lots of respect and love.
Thank you Leila for such informative videos.. looking forward for more videos on PBI.. I learnt a lot from your power query videos they are really helpful
Wonderfully explained in easy way. Thumb up for you!