Master POWER BI in just 1 hour! From Zero to Hero 💥

Master POWER BI in just 1 hour! From Zero to Hero//
I'm thrilled to announce that I've been hard at work on an all-new Power BI full course, taking you from zero to hero. Whether you're completely new to Power BI or simply looking for a refresher, this is the perfect opportunity to master Power BI. I encourage you to dive into the Power BI content and kindly share your valuable feedback.
Found the Power BI content helpful, feel free to buy me a cup of coffee ☕👇
✅www.paypal.me/vizxlization
🥇 JOIN THE POWER BI DISCUSSIONS
✅Join the Business Intelligence Teammates Group on LinkedIn: / 12848133
✅Join the Business Intelligence Teammates Group on Facebook: / biteammates
📩NEWSLETTER
✅ Be one of the first to receive my high-quality tutorials in your inbox each week: www.vizxlization.com/subscrib...
⏳ RESOURCES
☑️Content File: drive.google.com/file/d/139xu...
0:00 Intro
2:27 Pre-requisites
3:08 Download the data from Finance Yahoo
4:54 Import the data into Power BI Desktop
5:51 Append queries
8:19 Create a calendar table
12:14 Create a relationship
13:27 Canvas settings
14:00 Add a theme
14:43 Insert a Power BI background
15:50 Create measures
24:57 Add visuals
55:10 Bonus: Add a customized date slicer
1:14:00 Publish the Power BI report to the PBI service
1:15:00 Share the report with your end-users
📚HIGHLY RECOMMENDED BOOKS (Affiliate links)
***The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition: 🔗amzn.to/3ldPLpk
***DAX Patterns (Second Edition): 🔗amzn.to/3fBKdnD
***Analyzing Data with Power BI and Power Pivot for Excel: 🔗amzn.to/3fDPLOd
***Beginning DAX with Power BI: 🔗amzn.to/3fDEe1k
***Storytelling with Data: A Data Visualization Guide for Business Professionals: 🔗amzn.to/3mfPcwE
***Storytelling with Data: Let's Practice! 🔗amzn.to/36c6Cot
***Information Dashboard Design:🔗 amzn.to/2V61o7h
📺RELATED VIDEO TUTORIALS
***Playlist with all my Power BI tutorials: • Master Power BI [English]
*** Playlist with all my Interviews: • Power BI Interviews wi...
[DISCLAIMER]: Some links included in this description might be affiliate links. I might receive a small commission if you purchase a product with those links. However, there is no additional charge to you! I appreciate your support and this will help me provide you with free content every week.
👋CONNECT WITH ME
LinkedIn 🔗 / nestoradrianzen
LinkedIn 🔗 / quipuanalytics
Twitter 🔗 / quipuanalytics
Facebook 🔗 / quipuanalytics
Instagram 🔗 / nestoradrianzen
Web 🔗www.vizxlization.com/
👊SUPPORT MY WORK
***Hit the thanks icon in any video and subscribe to the channel ▶ / nestoradrianzen
👨‍💻COURSES
*** Dismantling the Secrets of Power BI Desktop: vizxlization.thinkific.com/co...
🎧Song: Axol - Mars [NCS Release]
Music provided by NoCopyrightSounds
Free Download/Stream: ncs.io/Mars
Watch: • Axol - Mars | House | ...
#PowerBI #PowerBIFullCourse #vizxlization #nestoradrianzen

[@sravankumar1767]

Superb Nestor 🎉

[@NestorAdrianzen]

Glad you found this tutorial helpful. Cheers!

[@NestorAdrianzen]

Here you go! I'd love to hear your comments on this summarized Power BI full course. Enjoy!

[@zephrongamer9535]

Me alegra conocer mi primer panel de Power BI de su canal, fue realmente útil. Saludos desde Chile.

[@NestorAdrianzen]

Excelente. Saludos 👍

[@dr.vaibhavhase5979]

Thanks 🙏🙏

[@NestorAdrianzen]

Thanks for your support, Dr. Vaibhavhase!

[@huyuc6614]

Thank you for your 1 hours ^^ Does you have another practive from zero to hero?

[@NestorAdrianzen]

On KZbin, that's the only one so far. But I have a course on Udemy. Here is the link if you want to check it out: www.udemy.com/course/power-bi-desktop-the-basics/

[@chandrashekharmuktapur3493]

@nestor . One more small request. I am practising your videos and creating reports in power BI desktop. Can you teach us how to showcase our reports in our LinkedIn profile. So that it will help me to get the job soon . Also give us some useful tips on how to build proper LinkedIn profile for data analytics profile

[@NestorAdrianzen]

Chandrashekhar, Thanks for your suggestions. On September 27, 2023, I have a KZbin live session with Federico Pastor where we'll be discussing the idea of creating a Power BI portfolio. Here is the link if you'd like to attend: kzbin.infoxfY-hDucGLs?si=4FXcUyie7MM6wWc2

[@chandrashekharmuktapur3493]

@@NestorAdrianzen Thank you nestor. Your channel is very helpful for candidates who want to learn . Great work towards the community 👍

[@rainbow433]

💥👏👏Super brother. also pls upload the data set link

[@NestorAdrianzen]

Glad to hear that!👍

[@xeeshanahmad8757]

Hmmmmmm, Yummmmmy

[@NestorAdrianzen]

Cheers!

[@alishair0786]

The course files cannot be downloaded at the moment. Could you please make them available for download? Your assistance in this matter would be greatly appreciated. Thank you.

[@NestorAdrianzen]

Sorry about that. Try this link again: drive.google.com/file/d/139xuSeaG9DRyGrEcnCJJQrOj-qwgYtz9/view?usp=sharing

[@omarblades2238]

Hello Mr. Nestor, I am working through the video and firstly amazing job. I am a bit stuck because when I create my first area chart with "date" and "avg. stock price by year" my chart gives me a single point. I check the relationship and it looked similar to your own visually but under properties it shows "from tech to dates -> many to one relationship". I'm not sure if that's the problem but when i try to change it back. Would you be able to help me solve this problem?

[@omarblades2238]

I just figured it out, turns out my End date calculation was wrong, I was still using the .min instead of .max..haha

[@NestorAdrianzen]

Glad to hear that. Keep it up, Omar!👍

[@chandrashekharmuktapur3493]

@nestor. i have one doubt. you had appended 3 tables and given the name as Tech. but when we create a Avg stock price for each company , in that i didnt get this Tech[Adj Close] , what is the meaning of this adj close . please explain me. thank you

[@NestorAdrianzen]

@chandrashekharmuktapur, Thanks for stopping by. The "Adj Close" column header is the stock price. My bad, I should have renamed it to avoid any confusion. "Tech" is just the name of the new table/query that contains the 3 companies. When you append tables/queries, the column headers should be the same across all tables/queries. Please ensure that's this the case. I hope that helps!

[@chandrashekharmuktapur3493]

@@NestorAdrianzen Thanks for your reply. My doubt got cleared.

[@xeeshanahmad8757]

After Creating "Custom Period" Table 7D 15D 1M 6M YTD 1Y 3Y 5Y Max when you add "Order" Column , after that Sort by Column "Period" in Table view a Warning Message Appears "We cannot sort the "Period" column by "Order". There cant be more than one value in "Order" for the same value in "Period". Please choose a different column for sorting and updating the "Order" column. When you open Power Query editor and put numbers in "Order" Column, the column not shown in the table. Can I create that column in power query and put values.

[@NestorAdrianzen]

Make sure that the "order" values are unique for each period. When you use "Enter data", you are actually using Power Query. Once you create the table, click on "Transform data" in the Home tab to get into the Power Query interface. You can make any changes in the Power Query interface.

[@rainbow433]

"Is it correct that the growth percentage is 350% or 580%? I'm not sure why it would be that high."

[@NestorAdrianzen]

Yeah. It can be possible if the stock price fluctuations are abrupt. Double check your values in the data view in Power BI.

[@rainbow433]

@@NestorAdrianzen yes. Thankyou