Beginner to PRO Data Analysis with Power BI - Full Length Course (with sample files!)

You asked for it. Here is a complete and in-depth course on how to use Power BI for data analysis. We are going to cover powerful & practical concepts like,
✅ 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-sal...
✅ Extra data file (for testing the refresh process): chandoo.org/wp/wp-content/upl...
👋If you want completed files:
✅ Completed file pack (unzip for all the files): chandoo.org/wp/wp-content/upl...
POWER BI LEARNING RESOURCES:
=============================
1 Page PDF on Power BI learning resources - chandoo.org/wp/wp-content/upl...
Download Power BI Desktop software - powerbi.microsoft.com/en-us/d...
~
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/upl...
More Power BI related Videos for you 👉
=================================
1️⃣ Power BI vs Power Query & Power Pivot - Awesome example - • The truth about Power ...
2️⃣ Power BI Analyst Job - what is it like? - • Talking to my wife abo...
3️⃣ Example Power BI report & how it compares with Excel - • I made the SAME Dashbo...
4️⃣ Create a variance chart in Power BI - • How to make variance c...
⏩ Power BI videos on the channel - Full Playlist - • Introduction to Power ...
~
Thank you and happy learning. 😀🌞🌻
#PowerBI #Data

[@masterexcel5762]

The best video I have ever watched using power bi to anlyz a date. Thank U Chandoo

[@Lyriks_]

This guy is 13x microsoft MVP and yet still giving away free content. Absolute legend.

[@irfanabbassi9202]

Being nice and generous is the best donation you can give to society for free

[@vishalbagade6480]

Yes. Only he is providing sample files.

[@johannaellison9113]

Yes he is a legend 👏👏👏

[@chandahmed1828]

Absolutely!

[@RiaMarliana]

Absolutely agree ❤

[@akhilkarthik3344]

No trash talking, No wasting time, A to Z point by point explanation. This guy is gem

[@lucia26]

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.

[@sonyse2t5]

I learnt more in this session in 45 mins than any other Y tube course on Power bi. Lots of variety and detail hints.

[@anuragsharma7331]

I am a certified Power BI professional and loved the way you incorporated many different PBI capabilities in one video.

[@Nick-eb7up]

Bro Kaha Se Ki Thi Aap Ne Power BI ki certification and What is the Fee?

[@chaitalibanerjee5459]

She means he gave Microsoft exam and got the certification

[@natynt227]

@@Nick-eb7up 165 $

[@omegaranger6654]

​@@Nick-eb7upmg ra😂

[@user-ix4fc3zv2n]

Just learning Power Bi ahead of my new job. Fantastic resource. Clear, educational, and powerful. Highly recommend.

[@luizklebermarinho]

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!

[@hearambasharma]

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 !

[@xornam3009]

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. 🙏

[@iraiarulniveda]

Excellent course on Power BI. Moderately paced and clearly explained. Thank you for the effort.

[@anilpillai9106]

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!

[@luizklebermarinho]

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.

[@preetichaurasia8059]

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.

[@anks0609]

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!

[@veronicaeyo3616]

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.

[@JunaidTahir]

Very effectively elaborated the key features of Power BI. Thank you Chandoo!

[@ItsWithinYou]

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...

[@xman3205]

Whatever ppl are saying about this guy is not enough. Awesome straightforward explanations without agenda

[@MrBlessed87]

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.

[@amanarshvlogs7241]

Best tutorial, coverd everything necessary in short time without skipping the details. Great work.

[@wayneedmondson1065]

Great lesson Chandoo! Thanks for sharing the replay and sample files. Thumbs up!!

[@eduardosilvestremangueze9104]

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.

[@sdsdsd0356]

Ah um brasileiro aqui, que ótimo mano:)

[@eduardosilvestremangueze9104]

@@sdsdsd0356 não sou brasileiro, sou moçambicano

[@hugopablo2500]

You don't know how much I appreciate people who make the. make to make this very helpful videos about learning Power BI. Thanks a lot.

[@literosy]

You are the best when it comes to tutoring and your contents are amazing. Thank you so much Chandoo for always bringing out the best in me.

[@Anuj.Rastogi]

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 😂🤞

[@MEETMEKANNAN]

You made Power BI so simple Bro; it was amazing, and this 45-minute video went like a minute.

[@rishikrsaw]

thank you chandoo..... from last 13-14 years you are helping other for free

[@sankarbalaji5782]

Thanks Chandoo, the Basic coverage is clearly clarified.

[@mkodan1]

Thank you Chandoo. You are so organized in your lessons

[@thekishorkhairnar]

You are the best... and genuine... Now I understood... there is scam, people charging 9 Rs for workshop giving nothing...

[@narcisotorrente6008]

Awesome Chandoo! This is pretty much a full scope introduction of Power BI and learning its Data Analytic platform. Thank you.

[@SaleemKhan-hm2br]

Dr. Chandoo. Fabulous and lovely to hear your expertise. Live long.

[@blinkglimpse9848]

You Sir have given the best PBI tutorial this far! Love how taught dax logic syntactically and making it so readable all of a sudden..it's amazing! You are truly a legend!

[@chandoo_]

Glad it was helpful!

[@fenomiladionahnaivoarilala6978]

The best teacher ever. Thanks for existing man

[@amitgurjar3014]

This was very easy to follow and apply in real-time while learning the concepts. Thanks Chandoo

[@waynemwangi9444]

Awesome video. Really benefit from learning the problem approach workflows.Thank you Chandoo.

[@fatokiadeola9114]

Amazing and well detailed video. All I need to do is to be consistent with Practice. Thank you @Chandoo

[@69nukeee]

This video is truly amazing! I followed it step-by-step, I could follow along easily and it is pretty spot on. Very well explained, engaging video. Bravo Chandoo, kudos!

[@BKSDA1]

Chandoo, as usual, your videos are a masterpiece. Your teaching and communication skills are off the charts. Congratulations, and thank you for putting so much time, effort and dedication into these tutorials. I am learning to become a data analyst and these all help heaps! YOU ARE A LEGEND!

[@flickhunter8900]

Indeed bro. HIs videos always to the point and very important stuff. As a beginner learning a lot from these videos

[@swaroopaj5647]

Abstract & precise video ! Thanks alot

[@MubarakEsha]

Have never seen easy and understandable power bi toturials like yours. You are and excellent.

[@hubaaltraining]

Thanks Chandoo! This has been a very useful tutorial. I have followed along and will definitely look into to the recommendations you provided on the resources PDF you shared.

[@darylsummers89]

Thanks for explaining the forecasting feature as well as displaying images via links!

[@chandoo_]

You are welcome Daryl.

[@adunbar22]

Very simple, informative and clear instructions. Thank you very much!

[@chandoo_]

Glad it was helpful!

[@Abhishekkumar-ls3ph]

you are amazing...you made this thing very simple and systematic..great job

[@MAG.experiences]

This is the best video tutorial on Power BI…! Thanks a lot, it was a great help.

[@satishk8799]

The best training video for Power Bi. Thank you Chandoo.

[@fokhrulislam2633]

Thank you Chandoo. My colleagues are excited to see your videos. We are learning. Keep it up.

[@lcntrdm7618]

This is amazing! Really big help. Thanks, Chandoo!

[@chandoo_]

You are welcome Dom... :)

[@yashmittal4744]

As always its an amazing experience learning from you. This is the first video I have ever watched on Power BI and I look forward to more videos from you.

[@chandoo_]

Great to hear!

[@miguelsuarez3198]

I am getting into data analitycs, this video is one of a kind. Thank U for sharing. The universe bless you!!!

[@astrokier]

Thanks Chandon for the video, very helpful indeed. I was wondering if PowerBI would be useful in a complicated routine including 1)adjusting stock levels 2) creating an excel sheet for ordering from x suppliers 3) analysis of data from these x suppliers 4) generate the cheapest for the full list into an excel spreadsheet 5)generate the cheapest amongst each supplier 6)an email function added inside of the PowerBI to email the individual supplier separately without sharing other information 7) repeat the process monthly by inserting new data based on the previous month usage. I’d be very grateful if you can have a video or help me to learn how to construct this please. Many thanks Chandon.

[@maabommalata]

Wow.. Great explanation and it just like any fresher can easily understand.. Good Work Chadoo.. Need more videos like this ..

[@ljensen9364]

Appreciate your teaching skills! Thank you!,

[@moorthysreedharan1734]

மி நன்றாக புரிந்து கொள்ளும் வகையில் உங்கள் கற்பித்தல் முறை உள்ளது. மிக்க நன்றி

[@okelnwaeze3343]

Thank you for the time and resources spent on this video.

[@takayokii1998]

I'm halfway through your video and I learned a lot already! Super thanks :)

[@reenap2286]

It's a step-by-step, very informative video about the PowerBi project. I added WordCloud to the visualization. Thanks, Chandoo. 🙂

[@nithin51988]

I have never user power bi ,but with this beautiful explanation given huge confidence...

[@arunrai2909]

You have got AWESOME technique of teaching!

[@brianfrias]

Another great video! For as much as I use Power Query in Excel, I am still new to Power BI. I always learn something new after watching your videos. Just goes to show that there is more then one way to tackle most tasks. Thanks Chandoo!

[@chandoo_]

You are welcome Brian... :)

[@lachhamanrajbanshi2862]

POWER BI CAN BE USED IN SQL???

[@eberebeulahorji9388]

Thank you very much Sir. You made this class worth it with really good explanations step by step. Thanks plenty.

[@sepubaxis4880]

One of the best tutorials i've found, nice

[@mohallyamarichetty6004]

Thank you so much for the detailed explaination. Awesome !!!!

[@thanveer95]

Thank you so much Chandoo. You explained it well.

[@jayeshladwa802]

Just awesome. Thank you for bringing your simple and interactive skill to us.

[@sindhujasankararaman]

One of the best PowerBI videos that I have ever watched!

[@wumbeiemmanuel184]

thanks Mr. chandoo, may the lord give you more time to educate us the morre.

[@aargomemnon]

Love this video. Love your calm voice.

[@AShina-zn7nx]

Thanks Chandoo, Everything about this video is 💯%. Grateful 💐

[@genshinken09]

Awesome course about Power BI. Thank you.

[@ragragrec1]

Wonderful Chandoo, you are a great teacher!

[@mayanegi8329]

Excellent way of teaching, thanks a lot.....🙏

[@discoverwithnasir]

The best video so far, with finest knowledge respect to business point of view. brief and easy to understand two thumbs up for Chandoo

[@guptavikas9681]

Your beauty of teaching is irresistible!

[@chandoo_]

Wow, thank you!

[@adsonnet]

"There is a saying to become a good in any skills or field evryone should follow the king of this field". I get this man as a king in the data analysis field 💞💯

[@sinchanacp8842]

Amazing! thank you so much for your amazing explanation 😀.

[@hudsonstokes7539]

Fantastic Video, followed along with the downloadable material. Thank you :) Much appreciated

[@neelamkushwaha1703]

Cant Thank you Enough Chandoo.. Best ever video on Power Bi on KZbin

[@A-DAY-WITH-SHANZE]

Love watching your videos. Very educational and fun to watch. God bless you, Keep up the good work.

[@axeemx]

The best explanation on PowerBI. Thank you Chandoo..

[@SeedGurukul]

Chandoo voice alongwith the bg music is soothing as well as learning.

[@Griffindor21]

Great video! In the data bars, can you specify a cell value in the min and max?

[@raghuvirrkj]

"Chandoo" Name heard Locally but what you are providing at the FOC is beyond any boundaries! Simply amazing sir, your technique of teaching is superb! I'm learning my first PBI with you! and that's the reason I developed more interest in learning it. Thank you so much for this sir!

[@chandoo_]

So nice of you

[@coolblue1524]

Chandoo, you are a magician!! Thank you for your work.💯🏆🏅

[@chandoo_]

My pleasure

[@WAIT4GOD]

I love what you do thank you for taking your time to do this!

[@kundanpachpande1264]

Thanks for the education. Greatly appreciated.

[@chandoo_]

You are welcome Kundan...

[@gospelmoto2833]

You're the man! Thanks!

[@sai_sh]

Hi Chandoo , I am addicted to your videos and implement it regulary. I have a question is there a book on the concepts of data analysis where I can learn these in a published way?

[@cradleofrelaxation6473]

Thanks for your sacrifice. We really appreciate you.

[@afsarbmahmud]

Thank you, really enjoyed this crisp course :)

[@chandoo_]

Glad you enjoyed it!

[@adwityamehra4279]

This was awesome, Chandoo! Thanks! 😊

[@chandoo_]

Glad you liked it!

[@nelpono7863]

Thank you. You are a good teacher and very generous with your knowledge.

[@satenderrandhawa2803]

Thank you Chandoo. Bless you

[@dhanrajsh7219]

I am preparing for Data analyst, learned so much of things in excel & now in power BI. If someday I got hired for any company the major credit will goes to you because your guidance fill me with a different level of confidence. Highly appreciate your work sir

[@chandoo_]

Thank you Dhanraj and all the best for you 👍👍👍

[@subarnalaha517]

Awesome learning tutorial..This is the best video for learning Power BI.Thanks a lot.

[@aarthisoundararajan1503]

Dear Chandoo, thank you so much for your Power BI tutorials.I was able to build my first ever Power BI chart and it feels amazing. Thanks again!

[@chandoo_]

So happy to hear that. More power to you ⚡

[@primeraletra]

You are awesome!!! Thank you very much for sharing this powerful knowledge

[@blinkglimpse9848]

Thankyou so much for these videos, great work!