Data Analysis with Power BI - from start to FINISH in 2 hours

  Рет қаралды 241,792

Chandoo

Chandoo

Күн бұрын

Join me for a live data analysis in Power BI class. We are going to understand how to load up, cleanse and analyse a bunch of financial data (budget vs. actual) with Power BI. Do bring your helmets as this one going to blow your minds 🤯🤯🤯
👉👉👉 Sample file & datasets:
==============================
Blank Data files:
URL for Actuals: chandoo.org/wp/wp-content/upl...
URL for Targets: chandoo.org/wp/wp-content/upl...
Completed workbook - files.chandoo.org/pbix/live-s...
Important Timestamps:
===================
0:00 - Introduction
26:43 unpivot other columns
29:19 date format in target
39:00 right click query targets → reference (to duplicate queries, remove other columns, remove duplicates)
40:35 date format
55:43 measures
59:35 customize current theme
1:07:25 measure total target
1:12:46 be careful when selecting the salesperson to choose the one from table targets, otherwise you get in total tagets the sum of all targets and is just a big mess. Chandoo mentioned this as well
1:13:38 right click variance % data bars
1:16:22 click the three dots and sort
Additional videos you should watch on POWER BI:
========================================
Power Query INTRO - • Power Query Tutorial -...
Power BI Sales Dashboard in one hour - • How to Make a Sales Da...
Power BI Beginner to PRO Data analysis - • Beginner to PRO Data A...
How to write DAX - • Learn Power Pivot & DA...
10 Power BI Tips for better visuals - • 10 Power BI tips to ma...
💥 Want more? TRY my Power BI Course - chandoo.org/wp/power-bi-course
~~~
Have a beautiful day 😃
#POWERBI #DATAANALYTICS

Пікірлер: 145
@cztop54
@cztop54 Жыл бұрын
Thank you so much for this Chandoo! I've worked with Power BI, on an off, for several years but had to keep switching to other projects. So, each time I started over again as a beginner since I did not know where else to start; time had past and I'd forgotten lots of what I'd learned prior and I had no idea what I didn't know. It was very disappointing and wasteful; I couldn't seem to move forward. I found this video today and, right off the bat, you answered about six questions I'd had that I'd never been able to find quick or understandable answers to -- highly valuable and helpful and time really well spent! You're also a really excellent teacher! You've made my day -- I can move forward now with Power BI and data analysis!
@chandoo_
@chandoo_ Жыл бұрын
So good to hear that Cindy. More power to you ⚡
@namy1557
@namy1557 Жыл бұрын
Great Work Chandoo, really appreciate that you took time for the youtube family and teach them about various skills 👍👏
@punknart
@punknart Жыл бұрын
Just found out your channel. Ive been learning Power Bi from the last months and this video definitely cleared me up a bunch of questions I had. Despite I understand the basic concepts, at the moment of applying all the knowledge Ive been learning to my own datasets, I struggle a lot because every dataset is unique and there are obviously no tutorials with the exact information. I appreciate you make this kind of videos, I will keep watching more of your videos. Thanks a lot!!
@kfersha1407
@kfersha1407 Жыл бұрын
Great job Chandoo, I really appreciate that you took time for such VALUABLE post to teach us.
@adriansoto8911
@adriansoto8911 Жыл бұрын
Thank you. I am new to Power BI and you showed me a great deal.
@srinivaskadari929
@srinivaskadari929 Жыл бұрын
Its nice that i found your channel.
@lecturesfromleeds614
@lecturesfromleeds614 17 күн бұрын
Wow! This channel is amazing! You put a lot of work into it and it shows! Subscribed...
@tinausr
@tinausr Жыл бұрын
26:43 unpivot other columns 29:19 date format in target 39:00 right click query targets ->reference (to duplicate queries, remove other columns, remove duplicates) 40:35 date format 55:43 measures 59:35 customize current theme 1:07:25 measure total target 1:12:46 be careful when selecting the sales person to choose the one from table targets, otherwise you get in total tagets the sum of all targets and is just a big mess. Chandoo mentioned this as well 1:13:38 right click variance % data bars 1:16:22 click the three dots and sort
@abualese8776
@abualese8776 Жыл бұрын
Hi Thank you for this great work pls when i click actual as heading to change to whole no i got error all the way down the column pls what do i need to do?
@user-td8qr1ym6y
@user-td8qr1ym6y 3 ай бұрын
Thank you so much, I was stuck in the problem that you mentioned (Total target mess). Can you explain why is it so?
@hamidrezaakbari7611
@hamidrezaakbari7611 25 күн бұрын
Thank you very much Chandoo, the educational series was useful and practical 🙏👌
@vijayav-qz4ld
@vijayav-qz4ld Жыл бұрын
Thank you so much Chandoo. I really appreciate your time for this tutorial. I have learned a lot following your channel.
@zkiyyeller3525
@zkiyyeller3525 Жыл бұрын
Sorry I missed the live stream! Thank you Soooo much Chandoo for all that you do. A long-time fan man!
@samphoenix1623
@samphoenix1623 Жыл бұрын
Your videos are crispy and to the point and very professional thank you 🙏 @chandoo garu
@abdullahiadamumaina2708
@abdullahiadamumaina2708 8 ай бұрын
thank you for your assistant Sir, really appreciate to you
@sunnyonyemeziem3433
@sunnyonyemeziem3433 Жыл бұрын
Great Work Chandoo, I really appreciate your time for this tutorial. I have learned a lot following your channel👍.
@lakshmananm6085
@lakshmananm6085 Жыл бұрын
Chandoo i am watching almost your videos, it's really helpful for my work, am working as a data analytic in 🇮🇳😊
@madrasapattinam
@madrasapattinam Жыл бұрын
Thanks Chandoo Sir! Hope you feel better soon. Very informative video on many useful elements on PBI like Forecast, Reference tables and Add column with Date thingy.. super fun to explore along with you. You have a wonderful pace and calming voice. God Bless!
@chandoo_
@chandoo_ Жыл бұрын
Thanks Madrasapattinam for the lovely message and super. It was just seasonal allergies and I already feel so much better.
@AliAli-xt6ow
@AliAli-xt6ow Жыл бұрын
Hi Chandoo, am your new subscriber (Dec 2022). I am hopefully transitioning to Data analytics this year. Looking forward to your videos. Many thanks.
@mohamedkader9746
@mohamedkader9746 Жыл бұрын
Hi Chandoo 👋 You really have a great knack for educating ppl on Excel applications. I have learnt alot from your online videos and tutorials and it pushed me into learning PQ and now I'm building PQ templates for my work for routine tasks and stuff! Every single time I get notifications from KZbin I'm learning something, maybe it's something I already knew but you would be covering it from another angle that most would not have thought or ignored. So thanks again for generously sharing your knowledge and making an impact always 😌
@idwtv534
@idwtv534 Жыл бұрын
What is PQ?
@chandoo_
@chandoo_ Жыл бұрын
PQ is Power Query. See this video to get a taste of what it can do - kzbin.info/www/bejne/iXjdlpqjlp6Vmrs or read this article - chandoo.org/wp/power-query-tutorial/
@mariarocha355
@mariarocha355 Жыл бұрын
@@chandoo_ hi just wanted to know can we change a blob field to text from the database...as it shows in binary form, and we use the change to text option it still shows no proper results
@nasimulhaque309
@nasimulhaque309 Жыл бұрын
Assalamualaikum, Chandoo Sir, I found your Videos simply simple and highly informative with proper presentation, voice and guideline. Alhamdulillah. Plz make some videos about freelancing and job carrier with Power BI and SQL. Plz go on. We are with you.
@ismailnarikodan7157
@ismailnarikodan7157 11 ай бұрын
Really inspiring way of presentation... You're become part of our career / life.. Thanks for this awesome platform 🙏❤
@mohantr8343
@mohantr8343 Жыл бұрын
చందూ గారు చాలా సంతోషం🙏🏻
@wazzannadeem
@wazzannadeem Жыл бұрын
This is exactly what I wanted. Thank you soo much Chandoo Sir
@olumidepeter3456
@olumidepeter3456 Жыл бұрын
This is exactly what I needed. Thanks for a great Job
@chandoo_
@chandoo_ Жыл бұрын
Glad it helped!
@sowjanyakake5720
@sowjanyakake5720 8 ай бұрын
At 1:18:04, we can arrange the months in the chronological order: Click on Month from fields and select Column tools tab from the header. Select Sort by column>month_number. And then we can use sort axis option of the viz by Month
@ssaaurabh456
@ssaaurabh456 Жыл бұрын
SQL itself a dimension you may learn some basic to in 2 hours but not all Chandoo sir is right / but SQL itself is is easy rather than other programming languages and believe me if you learn any single programming language well and deeply you may automatically learn many other languages 50%-70% for me this is my observation in my case . i learn SAS in my initial days after that i learn SQL ,R and python i found concept is same for all language at least upto 50%.
@Sabiransari20540
@Sabiransari20540 Жыл бұрын
Big Congratulations Chandoo, Great Teacher..
@Vinodbhalekar02
@Vinodbhalekar02 10 ай бұрын
You are simply Great Chandu.....
@ironpurush0978
@ironpurush0978 Жыл бұрын
I want to request to put timestamps on your videos please and please can you make a video on how to curate a perfect data analyst resume. It will be very helpful for begineers or freshers trying to get into data analysis career path.
@chandoo_
@chandoo_ Жыл бұрын
Hi... I have timestamps on regular videos. Adding them to livestream is a bit tricky. If you have watched the replay, please comment with your preferred timestamps. I will include them in the video description so others can benefit.
@QuantuMatrix
@QuantuMatrix Жыл бұрын
Hi, nice presentation and impressive knowledge delivered. Thanks for such tutorials
@awanishanurag1763
@awanishanurag1763 Жыл бұрын
Please bring some content on Advanced Data Cleaning using formulas like how to extract text and numbers from mixed data set! How to perform such advanced manipulations on text functions!
@chrism9037
@chrism9037 Жыл бұрын
Epic video Chandoo, thank you!!
@poongak
@poongak Жыл бұрын
Deeply appreciate it.
@raveendranaiduenaganti7460
@raveendranaiduenaganti7460 3 ай бұрын
Hello Chandoo garu, good morning from India
@aparnapandravada5073
@aparnapandravada5073 Жыл бұрын
Awesome Chandoo. Very useful 👌
@parusharamudugunaganti2658
@parusharamudugunaganti2658 Жыл бұрын
Hello from Hyderabad...Very informative Chandoo...Take a bow
@sankyppp
@sankyppp Жыл бұрын
Congrats on hitting a milestone with the subs
@allahbakshukhan6565
@allahbakshukhan6565 Жыл бұрын
Hi sir I’m big fan of you god bless you sir your ultimate talented I’m learning from you sir little bit
@adilumr6359
@adilumr6359 Жыл бұрын
Completed the video. Thanks
@syedsyed777
@syedsyed777 Жыл бұрын
Hi chandoo sir, Thank you so much for this video ... love ❤️ from Oman 🇴🇲 Can you please video on customer retention using cohort analysis Where customer joined in year 2015 still buying awesome chocolates in 2022. Need to find retenation of customers no. Of years using cohort. 2. Please make one video on data preparing and cleaning.(using excel n sql) Thank you in advance
@vishweshmahajan6720
@vishweshmahajan6720 Жыл бұрын
Congrats for 300 thousand subscription
@Pixceljunkee
@Pixceljunkee Жыл бұрын
Gratulation to 300.000+ fowlower
@aldobogaralvarezmedrano4788
@aldobogaralvarezmedrano4788 Жыл бұрын
Master Chandoo 👏
@aaliyarahman5526
@aaliyarahman5526 Жыл бұрын
Thank you Chandooo :)
@chodavarapuudaykumar9204
@chodavarapuudaykumar9204 Жыл бұрын
Hello chandoo, I enjoyed your video greatly. I have a small request for you when I tried to build visual the total sales measure doesn't work it. It says can't load the visual will you explain it what is problem for it. Thank you
@gopinathperiyasamy9896
@gopinathperiyasamy9896 Жыл бұрын
Hi Chandoo this video helped me how to start work on power bi it is useful, I have one request can you make videos for the default chart, custom chart, and for maps chart can you help on this to understand better I want learn more, I am new to this field
@TriggerJigar
@TriggerJigar Жыл бұрын
Thank you so much sir a lot love ❤️❤️❤️
@the_engineer17
@the_engineer17 Жыл бұрын
shift + click..... to sort multiple columns
@infinitejourney...
@infinitejourney... Жыл бұрын
Thank you sir 🙏
@aryanmalhotra9143
@aryanmalhotra9143 9 ай бұрын
thank you!
@paulakujuobi1932
@paulakujuobi1932 11 ай бұрын
Thank you
@naveedrandhawa7776
@naveedrandhawa7776 Жыл бұрын
now finish the session. thanks chandoo
@aadharsanabharathi506
@aadharsanabharathi506 Жыл бұрын
U r. Great bro
@myguytv1144
@myguytv1144 Жыл бұрын
hi please, I am having some issues with my power BI software, it says "cant display visuals" when I input a bar chart or a pie chart the data set that I used is the one for this tutorial above. please what should I do?
@rachelatuah7928
@rachelatuah7928 Жыл бұрын
hi Chandoo I'm a new subscriber and also on a new career path to being a data analyst...after downloading the dataset, i noticed i couldn't change the data type for the edited target column cus it has a $ sign in front of the data and i don't know to remove it so I'm stuck...
@karenholden5740
@karenholden5740 Жыл бұрын
Sir, i work in a hospital, is there a possibility that u cud make a video where u can show us how to calculate readmisdion rates within a full year and flag (pts admitted
@abhinav10x
@abhinav10x 8 ай бұрын
Thank you for this session....।।
@durgaprasad5488
@durgaprasad5488 Жыл бұрын
Anna telugu vocha meku super nenu English vallu anukunna 🙏🙏
@gospelmoto2833
@gospelmoto2833 Жыл бұрын
I like your humor man...
@ssaaurabh456
@ssaaurabh456 Жыл бұрын
SQL comes into play when we working with databases or big data which is not handled by spreadsheets. if our spreadsheets is capable of handle the data then we doesn't need SQL. Most of the time Excel does all the work. Google sheets is also a good platform, but for big data we defiantly need SQL (structured query language) if we want a good data analyst we have to work R/python , SQL, spreadsheets, visualization, and also the story telling for continuous and stable growth throughout the journey.
@jaitiwari241
@jaitiwari241 Жыл бұрын
But, if I want to enter this field ..is power bi, excel, and basic SQL is enough? plz reply
@ssaaurabh456
@ssaaurabh456 Жыл бұрын
@@jaitiwari241 yes its enough but be sure go through each and every concept of all three
@taizoondean689
@taizoondean689 Жыл бұрын
Chandoo Sir, I need all movies rating details from IMDB. Can you help using web Scraping using power BI
@prakashg7024
@prakashg7024 Жыл бұрын
thank you sir
@RiaMarliana
@RiaMarliana Жыл бұрын
Thanks and thanks again n again Mr Chandoo. Thanks for your time and effort.
@fog2640
@fog2640 8 ай бұрын
finished watching
@taizoondean689
@taizoondean689 Жыл бұрын
Thank you for posting such helpful videos. It's great and you made my day when you replied on my comment during the session 😊🙏👍
@sim9955
@sim9955 Жыл бұрын
this is a great video Chandoo, too bad i was able to attend the live stream!! wondering if you can give us tutorials on SQL projects that we can do to add to our skill set portfolio?
@chandoo_
@chandoo_ Жыл бұрын
You are welcome Solo. I do have SQL videos here - kzbin.info/www/bejne/r5e6lI1smtSnask
@karimallahwala7022
@karimallahwala7022 Жыл бұрын
Thank you so much for that great Knowledge your are sharing
@nasirubello3546
@nasirubello3546 6 ай бұрын
Thanks sir
@ssaaurabh456
@ssaaurabh456 Жыл бұрын
snowflake is a schema type of data modeling in databases for big data mostly used and practiced by data engineers. star schema and snow flake schema is the most common.
@turkeyjobsprovider
@turkeyjobsprovider Жыл бұрын
Sir plz could u explain deference beetwen business analyst n business analysis?
@adnanabbasi9482
@adnanabbasi9482 Жыл бұрын
Hi Chandoo, I've two questions. My first question (maybe you think personal) but want to understand the day-to-day job of a data analyst. What exactly do you do in your current organization (I mean - work only on Power BI) or along with it you also do some more and different things (this is just to understand the working)? Secondly, need your advice to get a data analyst job what are the core expertise one must have?
@auwalbala86
@auwalbala86 6 ай бұрын
HELLO FROM NIGERIA
@Liftlikekong
@Liftlikekong 11 ай бұрын
how to export the filtered visual and data in power bi
@sureshkota8051
@sureshkota8051 Жыл бұрын
Hi Chandoo garu Where can I download an Excel file which you are using
@janardhanreddy9836
@janardhanreddy9836 Жыл бұрын
Hi chandu sir can you pls do it YTD and MTD video by using SQL query
@CaribouDataScience
@CaribouDataScience Жыл бұрын
Very nice introduction. One question is what do the two date fields represent?
@robertalavezzari6970
@robertalavezzari6970 Жыл бұрын
I do not have the forecast option, how come, is there a way for me to make it appear?
@israrhisbani9290
@israrhisbani9290 Жыл бұрын
Sir can u gives us beginning completed course data analyst without programming video please
@krishnakishore993
@krishnakishore993 Жыл бұрын
Hi Sir, Your Video Content Was excellent sir, Is there any group to get updates of Your live sessions or any updates, if avaiable pls share link sir.
@myguytv1144
@myguytv1144 Жыл бұрын
it says on my power bi home screen cant load data for visuals errror. Calculation error in measurement what do i do?
@sidharthabajpai6652
@sidharthabajpai6652 Жыл бұрын
Good
@championofchrist7051
@championofchrist7051 Жыл бұрын
Very audible
@tinausr
@tinausr Жыл бұрын
Guyz be wary when you try that SAles table 1:12:56 with the variance - the only correct variance that I got was when I put dSalesPerson in rows not using any other Sales person from the other two tables nor actuals not targets. This got my brain boiling. I still donot get it why it is that way? Great video though. I feel that I am learning so much from the basics. Really well made!
@statesman6379
@statesman6379 Жыл бұрын
I was getting the same error. I just figured it out. We are supposed to use the dSalesPerson because that is the Dimensions table that we created. We created that so that we would not have duplicate SalesPerson in our query. The error occurred because it was calculating duplicate sales persons from the other tables.
@YehLoh
@YehLoh Жыл бұрын
can power bi analyse live fed data instantly....?
@ismahanduale5086
@ismahanduale5086 Жыл бұрын
Hi love to lern from you but i never get the data to use to leaen
@vijayaprasathk5391
@vijayaprasathk5391 Жыл бұрын
hi in video timed 1:34:46 Table has Grand total values i could not understand profit per box summation is $10.9. can u help with
@hayatibrahim4615
@hayatibrahim4615 Жыл бұрын
How to make power bi ID to publush report?
@gorretnalwoga8356
@gorretnalwoga8356 10 ай бұрын
How do i download that tool ( Power BI)on my computer?
@monuthakur7649
@monuthakur7649 Жыл бұрын
How to connect two workbooks in excel?
@sumitwadhwani3835
@sumitwadhwani3835 Жыл бұрын
Hello sir, Your videos are of great help . There is a problem I'm having with the varience part when i am adding total target to y axis it says calculation error in measure 'targets'[Total Target]: the function SUM cannot work with values of type string. Dont know where it went wrong.. Plz help n point where it went wrong.
@rajishn
@rajishn 9 ай бұрын
After creating the measure - showing error - "" actuals Don't have a support for visit of 'Model' type! "" and the graph not showing error too "cant display the visual" pls guide
@manishrochwani1023
@manishrochwani1023 10 ай бұрын
Hello sir, Thank you so much for this hardwork you are putting for people. Can u make a video on DAX calculation in power bi. From basic to scratch with references to business case studies from different domains.
@chandoo_
@chandoo_ 10 ай бұрын
Hi Manish.. I do have a DAX video to help you get started - kzbin.info/www/bejne/hoKYnXSCmat7ebc For more on DAX, I suggest enrolling in my course - chandoo.org/wp/power-bi-course/
@manishrochwani1023
@manishrochwani1023 10 ай бұрын
@@chandoo_ thanku sir. I found u late. I had enrolled for power bi course from some other person. Paid the amount. Now no option.
@chandoo_
@chandoo_ 10 ай бұрын
That is ok Manish. Happy learning :)
@CaribouDataScience
@CaribouDataScience Жыл бұрын
In the variance chart ho can I make the negative variances a different color than the positive?
@chandoo_
@chandoo_ Жыл бұрын
Yes, you can. You can use conditional formatting feature of Power BI to change colors. See this video - kzbin.info/www/bejne/opnJY6eAms6qj9k
@allauddinmomin8814
@allauddinmomin8814 Жыл бұрын
All currency is not showing as a number , So what i do? plz anyone can help me😶
@anjalisaroj1768
@anjalisaroj1768 7 ай бұрын
Hi sir, I already did full course but not I don't know how to apply job in companies to get a job ... Can you please help me out this
@ronifirmanda2923
@ronifirmanda2923 Жыл бұрын
why I have 17 rows on unique months?
@sayanmondal1303
@sayanmondal1303 Жыл бұрын
In my case, all the currencies are not shown as numbers.. e.g. it's showing like "$47368" instead of ""47368" .. I'm not able to change it. So when I want to add the Total sales in Y axis, it's showing error.. can anyone help ?
@civilstudent595
@civilstudent595 Жыл бұрын
Same problem
@bariadipen6607
@bariadipen6607 Жыл бұрын
I'm getting error as "DataFormat.Error: We couldn't convert to Number." when transforming target table
@talkwithjyoti1883
@talkwithjyoti1883 Жыл бұрын
can any one help me please sales are text type I am not able to convert it into numeric
@kpp4958
@kpp4958 8 ай бұрын
In actual data set there is no column of measures .....I have downloaded data but missing measures column
@TamilSelvan-lf3fy
@TamilSelvan-lf3fy Жыл бұрын
Power BI or tableau for data analyst ?
MILLION JAMOASI 10 YILLIK YUBILEY 2023
3:00:06
Million Jamoasi ™
Рет қаралды 20 МЛН
DIY Magic🤩: Rainbow Candies As Makeup!🌈💄 #funnycat #catmemes #trending
00:20
Is That Lipstick On His Neck??
00:13
Polar
Рет қаралды 6 МЛН
Learn Power Query & Automate Boring Data Tasks in 15 Minutes!
18:45
Project Management   CPM in Excel
7:17
Andrew Tiger
Рет қаралды 15 М.
This ~NEW~ Excel Function is Shockingly Powerful!
9:37
Chandoo
Рет қаралды 128 М.
Power BI DAX Tutorial - Beginner to Advanced [Full Course]
1:26:33
Pivotalstats
Рет қаралды 27 М.
MILLION JAMOASI 10 YILLIK YUBILEY 2023
3:00:06
Million Jamoasi ™
Рет қаралды 20 МЛН