Beginner to PRO Data Analysis with Power BI - Full Length Course (with sample files!)
698,381
Published 2022-02-15
✅ How to load and clean-up data with Power BI
✅ How to build a data model in Power BI
✅ Using DAX & Power Pivot to build measures and calculations
✅ Creating and changing visuals
✅ Answering business questions with Power BI
✅ Understanding trends & creating forecast in Power BI
✅ Customizing visuals & interaction effects
✅ Creating a comprehensive sales performance report
✅ Saving and publishing the Power BI files
✅ Updating and data refresh process
✅ Additional resources to learn and master Power BI
~
DOWNLOAD THE FILES:
====================
👉 If you want to follow-along:
✅ Blank data file (for following along): files.chandoo.org/pbix/pb-sales-data-blank.xlsx
✅ Extra data file (for testing the refresh process): chandoo.org/wp/wp-content/uploads/2022/02/extra-da…
👋If you want completed files:
✅ Completed file pack (unzip for all the files): chandoo.org/wp/wp-content/uploads/2022/02/data-ana…
POWER BI LEARNING RESOURCES:
=============================
1 Page PDF on Power BI learning resources - chandoo.org/wp/wp-content/uploads/2023/05/Resource…
Download Power BI Desktop software - powerbi.microsoft.com/en-us/desktop/
~
VIDEO TIMESTAMPS ⏱👉
======================
Use these timestamps to access individual chapters of the video. For best results, watch the video from start to finish.
0:00 - Welcome to Data Analysis with Power BI Course
1:50 - Power BI Desktop (how to get it)
2:50 - Power BI Desktop Screen Explained
4:42 - Sample Data file explained
5:58 - Loading data into Power BI
7:24 - Setting up the data model in Power BI (star schema)
9:30 - Creating our first charts in Power BI
10:38 - Fixing data problems (data clean-up with Power Query)
13:16 - Adding "amount by sales persons / team" chart
13:53 - Interactive nature of Power BI
15:21 - Fixing "blank" team problem
16:33 - Saving Power BI workbooks
16:48 - Analyzing Sales Peron Performance in Power BI
17:52 - Adding "Measures" with DAX in Power BI
20:06 - Using Slicers to filter visual / page level data
20:41 - Formatting the visuals
22:22 - Adding more "measures"
25:00 - How to setup conditional formatting on the visuals
26:32 - Adding "WOW" factor to the report
28:11 - More visuals & controlling the interactions
31:04 - Adding "titles & logos" on the report
33:01 - How to do "trend analysis" in Power BI
36:02 - Forecasting Power BI
37:44 - How to save & publish Power BI reports
39:45 - Refreshing with new data
41:10 - How to learn more about Power BI?
1 Page PDF on Learning Power BI 📃💻👇
==================================
Download the 1 pager from here - chandoo.org/wp/wp-content/uploads/2023/05/Resource…
More Power BI related Videos for you 👉
=================================
1️⃣ Power BI vs Power Query & Power Pivot - Awesome example - • The truth about Power BI (and how to ...
2️⃣ Power BI Analyst Job - what is it like? - • Talking to my wife about her Power BI...
3️⃣ Example Power BI report & how it compares with Excel - • I made the SAME Dashboard in both Exc...
4️⃣ Create a variance chart in Power BI - • How to make variance chart in Power B...
⏩ Power BI videos on the channel - Full Playlist - • Introduction to Power BI - What is it...
~
Thank you and happy learning. 😀🌞🌻
#PowerBI #Data
All Comments (21)
-
The best video I have ever watched using power bi to anlyz a date. Thank U Chandoo
-
This guy is 13x microsoft MVP and yet still giving away free content. Absolute legend.
-
No trash talking, No wasting time, A to Z point by point explanation. This guy is gem
-
By also joining his paid trainings, I hope Chandoo will always combine sharing his skills both free and paid. I would never have entered the paid content had I not learned first through free tutorials. This is the part of digitalisation of the world that I love. Thank you Chandoo, for providing us with this mix of educational content.
-
I am a certified Power BI professional and loved the way you incorporated many different PBI capabilities in one video.
-
Dear Chandoo... your way of 'teaching'..'training'..'demoing'..'presenting'.."knowledge sharing" is amazing...not everyone gets such qualities, and ones with qualities may not share.. you are a master tutor.. you deserve a lot of credit., please keep sharing and shaping the future.. best wishes and thanks a ton!
-
I learnt more in this session in 45 mins than any other Y tube course on Power bi. Lots of variety and detail hints.
-
Chandoo is my guru for advanced Excel techniques and now, seeing this video on Power BI he provided to the public, I must say: many thanks, dear Chandoo! You share the best articles on both Excel and Power BI! You are super! Thanks again.
-
As always and comparing to Excel mastering, Chandoo is giving us his best, sharing his knowledge and helping us to advance in the learning process. Thanks a lot dear Chandoo! You are super!
-
Ima life science guy working as a Business Analyst for a Healthcare Data Company. Always had a feeling that learning tech and advanced tools isn’t that easy. But you have changed my entire perception. 🤝Thank you my friend !
-
My good brother thanks so much for this massive content. Honestly your teaching is perhaps shaping me on the right path, much love 😍. Being a Data Analyst is what I'm passionate of. 🙏
-
Superb! I use Tableau and wanted to learn Power Bi quickly and I must say one can not find a better video on it on youtube. Many thanks Chandoo and May you be blessed with lots of happiness and recognition in your career and life...
-
You are the best Instructor ever. I just found you today as I had to do a last minute preparation for a data analyst interview. You really helped me. I have subscribed, liked and share the word. keep it up.
-
Just learning Power Bi ahead of my new job. Fantastic resource. Clear, educational, and powerful. Highly recommend.
-
Excellent course on Power BI. Moderately paced and clearly explained. Thank you for the effort.
-
Your videos are to the point and the information you are giving is so crisp and very easy to understand... I watched your videos with full information. Never feel like skipping even for 10 seconds.
-
This video is just so useful... I remember going through a DA course on linkedin and most of the things didn't make sense to me in that course. Watching this video resolves all my doubts in less than an hour 😂🤞
-
I have been following Chandoo for a very long time now. I also be benefited from his free Excel tips and tricks . This is another awesome video on Power BI. Wishing you all the very best. Thanks Chandoo.
-
In portuguese: esta é a melhor aula de Power BI que já vi. Objectivo, claro e simples. Parabéns e obrigado @Chandoo, por partilhar o seu conhecimento.
-
Thank you so much for making it so much easier to learn for people who already have the basic knowledge of DV tools. Best video!