Thanks Chandoo for this crisp and succinct video on two of the most commonly used tools. You pointed out the pros/cons perfectly to help one decide! Great! 😊👍
@chandoo_2 жыл бұрын
Thanks Vijay...
@nandkishoresoni39542 жыл бұрын
I m still using excel 2007
@nandkishoresoni39542 жыл бұрын
I started following your text blog in 2008 onwards
@christiandgreat81272 жыл бұрын
BI Engineer here. To cut to the chase. You need to learn both. I would say 20% Excel 80% PBI. Speaking through experience, you need to learn excel because when your talking projects from user they usually use excel and you need to understand what are they doing.
@yousifmohammed48412 жыл бұрын
I learnt both of them and I can't dispense any of them! Excel is great for quick analysis and data validation. On the other hand, Power Bi is much better in data visualization, slicing/dicing , connection to databases and large datasets. I can develop beautiful and interactive dashboards in Power Bi, but by the end of day I wouldn't publish them until I validate the results through Excel by the simple Excel lookups, pivoting and filtering features. In my opinion, they are integrating each other ,not competing!
@chandoo_2 жыл бұрын
Great point there Yousif.
@akin2420022 жыл бұрын
"Excel is everywhere". Facts!
@chandoo_2 жыл бұрын
💥💥💥
@itzmemk15292 жыл бұрын
You have put me in a situation that i could never skip any part of you videos. Thanks for this content.
@donaldmillwood63082 жыл бұрын
Thanks, Chandoo - Excellent pros and cons video. I have used Power BI to do financial modelling quite successfully esp with star schema data models - I found this much easier than using Excel. I can do some simulations using Power BI. Where Power BI shines for me is taking advantage of context transition and building report pages to initiate discussions with clients, colleagues, business leaders etc.
@chandoo_2 жыл бұрын
Thanks Don for sharing your perspective. I agree that the interactive nature of Power BI makes for a pleasant & collaborative experience. PS: I would love to talk and know more about the financial models you have built in Power BI. Are you open to sharing more? If so, please email me at chandoo.d@gmail.com.
@nazarkamal88318 ай бұрын
Excel is everywhere!! Excel is like a eye & BI like a cooler glass
@salehmuhammad68112 жыл бұрын
Chandoo you are one of my inspiration for power BI. Thanks for your valuable 👍 topics to be taught us.
@chandoo_2 жыл бұрын
Thank you Saleh 😀
@TheJoshtheboss10 ай бұрын
I'm just starting with Power BI, but long term Excel user. I think skills are easier transferable from Excel to BI, than the other way around. As both programs share many things, like Power Query, Data Model, DAX. Power BI looks to me like Pivot table/chart environment with Power Query. Once you know how to do those in excel, working with BI should be intuitive. However, Excel is very versatile and person coming solely from Power BI might struggle in Excel outside of pivot tables and charts, using regular ranges and tables, formulas, data validation, transforming and cleaning data without power query.
@aafifuddeen2 жыл бұрын
I love to learn Power BI, but Excel will always be my choice due to the availability
@entertainmentanalyst15592 жыл бұрын
I'll take this minute to express a heartiest thank you ... My entire 15 years of career span of data analysis and management consulting I've learned these excel stuffs from you Whenever my folks say I'm guru in excel i shout a thanks to you. Once again thanks to you for shaping my career without you even knowing it
@chandoo_2 жыл бұрын
Thanks EA :)
@dexxxxxxxx2 жыл бұрын
Sir, which languages you use as daya analyst. I'm newbie in this field I'm learning Excel. SQL and power BI is next in my list to learn. Please guide me. I'm from Gujarat.
@faisalkhizar83992 жыл бұрын
@@dexxxxxxxx "R" & python 😊
@matthewlane10402 жыл бұрын
Started learning excel from your website years ago,, just came across this channel as I’m brushing back up on PowerBI 😁 thank you for always delivering great content!!
@chandoo_2 жыл бұрын
Welcome aboard!
@mukta812 жыл бұрын
You are a very good teacher. You know how to hit the right point through the learners point of view. Thanks
@chandoo_2 жыл бұрын
Thanks Mukta... 😀
@Simon_boakye2 жыл бұрын
Indeed! He is among the best!❤️❤️💕
@pratikkushwaha2 жыл бұрын
Watching this channel for first time and I really appreciate how concise and helpful this content is. Amazing.
@chandoo_2 жыл бұрын
Welcome aboard Pratik. 😀
@salehmuhammad68112 жыл бұрын
Chandoo you are one of my inspiration for power BI. Thanks for your teaching such a valuable topics.
@chamindasilva31912 жыл бұрын
Thanks , I always appreciate your inputs and honest opinions. Your channel has become my first point of reference to learn Excel and Power BI. Thanks again and good luck with your channel.
@judyl.78112 жыл бұрын
Power BI is in demand, fancy, and quick with large dataset. Excel exists the long way. free to download.
@abigaillee9052 Жыл бұрын
Thanks Chandoo, i am inspired from your video to become a MVP in future, never stop learning even graduated from a different field!
@skumar052 жыл бұрын
Hi chandoo I want to suggest you one thing please teach power bi with database I mean to attach the file so that all viewers can practice with database
@chandoo_2 жыл бұрын
Thanks Rahul. I already have many Power BI videos, all with full sample datasets (and data models). I suggest starting with this one - kzfaq.info/get/bejne/q92Va6ZosJ7KiI0.html
@MrAloha2 жыл бұрын
How come I've never seen this video? It's exactly what I'm always teaching! 😁 Plus, I'm often asked why I teach Excel when there are so many Excel videos out there. 😂 Thanks, Chandoo!
@kazimohammadminhajulislam85502 жыл бұрын
4 days into this channel and I am sad about why not I checked Chandoo in 2010. Lets appreciate his efforts.
@chandoo_2 жыл бұрын
Welcome here Kazi. Better late than never 😀
@chrism90372 жыл бұрын
Another great video, thanks Chandoo. This is a great explanation between the two.
@chandoo_2 жыл бұрын
Thanks Chris... 😀
@abdulmalikyakubu9091 Жыл бұрын
Great video as usual, Chando. By the way, I was wondering.. do I need to master all the resources (excel, power BI, SQL and Python) before I can start to work as a data analyst? For now I'm only really savvy with excel and I'm learning power BI soon.
@nazarkamal88318 ай бұрын
Excel is best beyond all the generation!!! ❤❤❤❤🎉🎉
@behrad9712 Жыл бұрын
Oh, thanks a lot! I struggled in my mind with this question 🙏
@talksister4496 Жыл бұрын
Excellent Chandoo, thank you very much. You helped me make a clear decision.
@duurduranto2 жыл бұрын
Im loving your videos. Has the information perfectly that i am looking for to be a data analyst. Thank you very much for your help
@aparnapandravada50732 жыл бұрын
Appreciate your efforts 👌 You have given a honest review.
@chandoo_2 жыл бұрын
My pleasure 😊
@universalblak722 жыл бұрын
Great video commentary. I was at a crossroads in which of the two softwares that I want to study first. I've already started purchasing some E-Books and watching videos on Excel but as of lately I've been leaning towards Power Bi. Judging by the evidence presented Excel despite it's seniority as in terms of software takes the cake. So now moving forward my entire summer will be spent studying Excel. 😂 For I am still looking forward to learning Power Bi down the road. Subscribed and looking forward to checking out your videos and more. Thank you.
@ipsitaaparimita18732 жыл бұрын
Woww, I didn't see Excel in programming aspects. Awesome. Thanks a lot 😀
@xxczerxx Жыл бұрын
The way I see it, if you learn Python and Power BI you are pretty powerful asset as far as data analysts go. Throw some SQL in there (to minimise overusing Power Query)and you are a weapon!
@awesh19862 жыл бұрын
Awesome but I think Excel should be the starting point always. Power BI can be learnt well post EXCEL. I maybe wrong
@ArmandoReportes Жыл бұрын
I couldn't agree more with you: most college students fail to see how Excel will be useful for them. Just let them work for six months after graduation, and then they will be ready to learn Excel. I tell people to learn both Power BI and Excel, because they complement each other perfectly. When I am teaching them how to use Power BI, I often copy the queries, paste them in Excel 365's Power Query, create a Power Pivot and add some charts connected with slicers and timelines. Most people don't know Excel did it before there was a Power BI! I will explain how in 2010 Excel was given four new Powers (View, Pivot, Query and Map) which could be shared as a Web Page in Sharepoint, and then three of those four powers combined into Power BI Desktop, and Power Query was cloned: the original remained with Excel, the clone went with Power BI, and they would merge with Sharepoint to become Power BI Pro and Premium. So, even though Excel has not kept up with Power BI, it still has many great features in common with it. Learning one helps with the other.
@chandoo_ Жыл бұрын
Great points Armando.
@imtiyazali7052 жыл бұрын
ITS VERY OF KIND YOU FOR SHARING SUCH A INFORMATIVE VIDEO...I WAS LOOKING EXACTLY THIS TYPE OF VIDEO BECUASE THESE DAYS POWER BI IS IN FULL DEMAND WHEREAS I AM USING EXCEL SINCE 2010..I WAS IN A FENCE WEATHER SHOULD I GO FOR POWER BI OR NOT..
@yousifmohammed48412 жыл бұрын
Both has the same level of importance! To be a good doctor, you have to be good in diagnosis diseases by normal methods such as stethoscope as well as by advanced technologies like MRI. The same is applicable with data analysis. To be a good data analyst you have to be good in analyzing data by normal tool like Excel, as well as by advanced technologies like Power Bi or Tableau. For me ,as a patient, I can't trust doctors who know only advanced technologies because they are not authentic as they rely on machine rather than experience. On the other hand, I can't trust doctors who only know the normal tools because they are outdated. Therefore, I don't trust any data analyst who only knows Excel, or only knows visualization tools.
@daviddevita2 жыл бұрын
Hey, Chandoo! May I ask you a very silly question? There's something I simply don't understand: let's say you build a project, run the analysis and jump into an outcome. Fine. Project finished. What's next? Even if you build a dashboard, it becomes "their" problem because you aim them to self manage their decision making process. Is this right? If so, what is the daily basis activity of a data scientist? Would I be unemployed right after the project is finished? I'm kind of stuck with this doubt. Thabks for your great videos. Greetings from Argentina!
@ArmandoReportes Жыл бұрын
I work for one customer for a while, then I go to another project, and then I get a call from another one. I work with, let's say, Human Resources. They will recommend me with Finance. Finance will get me in touch with Marketing. Human Resources then will ask me to help somebody else, and I get to work with a lot of people at different departments for a while at a time, and then they call me again after I work with another company.
@lutfishaban907710 ай бұрын
Both skills should be learned for becoming data analyst
@awesh19862 жыл бұрын
I have just started with your videos you are too good with the explanation
@makarand19852 жыл бұрын
Chandoo you are a superstar (or MS Excel Super Star) !!!
@GVGV85042 жыл бұрын
Hi chandoo sir! Your videos are interesting and am having a great learning sir..I have a doubt as a human resource student, power bi or excel which one is good to learn?
@chandoo_2 жыл бұрын
I have done quite a bit of work as "HR Analyst" and I can confirm that "Excel" is the number 1 app used by HR people.
@GVGV85042 жыл бұрын
@@chandoo_ thank you sir!!
@AP-eb8hd2 жыл бұрын
Good video... When I started, it was Quattro Pro that rocked and Excel was just making its way in.. I doubt many even know about Quattro Pro anymore..
@chandoo_2 жыл бұрын
Thanks for sharing! Wow. I used a little bit of Lotus 1-2-3 back when I started learning, but my first real version has been Excel 2003.
@AP-eb8hd2 жыл бұрын
@@chandoo_ Yeap... And 2007 was a good game changer... Power Query, Power Pivot are excellent tools now. I don't even bother with VBA anymore.
@surajbhardwaj4282 жыл бұрын
Excel is the best... 👌 Thank you So much sir.👍
@salmaalaa61582 жыл бұрын
Great advice! Thanks Chandoo!!
@chandoo_2 жыл бұрын
You are welcome Salma...
@canirmalchoudhary81732 жыл бұрын
Thank you for this crystal clear analysis
@chandoo_2 жыл бұрын
You are so welcome
@TejasNaik012 жыл бұрын
Thank you Chandoo for this comparison video.
@ahmetemin17212 жыл бұрын
Great video as always, thanks man 👍
@edendavodbetossib88182 жыл бұрын
Thanks for this amazing video, it really hepled me understand what I'm supposed to do .appreciate it
@chandoo_2 жыл бұрын
Glad it helped!
@Lifewithnimi9984 ай бұрын
Thank You Chandoo!
@JoshAutomates2 жыл бұрын
Excel is the foundation and versatile as data source. How I wish they also leverage all the features from desktop similar to Excel Online. Still a few steps behind. :(
@chandoo_2 жыл бұрын
As Excel Online runs in browser, I suspect if it will ever catch up. But the compatibility is amazing so far.
@MihailAnohin2 жыл бұрын
Chandoo , thank u for this video! It was very useful for me 😊👍
@hilmansyahbo5492 Жыл бұрын
Thanks for sharing this great lesson.
@DataAnalyticsPro212 жыл бұрын
Hi Chandoo, do you think skill of PowerBI can handle the issue of unemployment at a mass level
@chandoo_2 жыл бұрын
Not sure what the correct answer is. If you are unemployed, learn whatever you need to, do whatever you can. Once you have job, more opportunities open up for you.
@Farhazh2 жыл бұрын
Hi Chandoo, thanks for the awesome video as always. I would want to have a full detailed video explaining about all dax functions and syntax with real time examples please. I am trying to learn dax but details are so widely spread over internet that its creating more of a confusion then helping. Would really appreciate please. Thanks
@chandoo_2 жыл бұрын
You are welcome Farhaz. I have a DAX getting started video here - kzfaq.info/get/bejne/m6mlg7WitrTJZo0.html I also have a DAX playlist here - kzfaq.info/get/bejne/pJ2XdK1-p8quaJ8.html I will be adding a few more soon on the channel.
@sunriseeternity3002 жыл бұрын
I like extra effort of the location changes. #chandoo #enjoylife #exceltutorial #powerbi
@shivanisorakhe45892 жыл бұрын
Very informative video. Thanks.
@mattmatt2452 жыл бұрын
Hi Chandoo. Did you do a video on how to remove duplicates when column values can be swapped like (1,2) and (2,1) would be a duplicate. Thanks
@sumbowilliams10892 жыл бұрын
Very interested in this as well
@chandoo_2 жыл бұрын
That is a good question Matt. Power Query doesn't have SET data type. We can use Lists & apply SORT on the list and then take distinct. I will make a video on this at a later time.
@mattmatt2452 жыл бұрын
@@chandoo_ If you have just numbers in both columns then it's easy to accomplish with an if statement and helper column, but if it's some combination of numbers and letters then I don't know how to count duplicates.
@chandoo_2 жыл бұрын
Good point.
@mattmatt2452 жыл бұрын
@@chandoo_ Were you able to figure out the solution ?
@kirankumar-vj8ei Жыл бұрын
Thanks for such valuable advice
@angelv13932 жыл бұрын
learning so much, thank you!!!
@thamimmo2 жыл бұрын
Which BI tool is a better option for beginners, tableau or power bi
@prathyupa2 жыл бұрын
This was useful. Thank you chandoo
@JyotiVerma-hn5by2 жыл бұрын
All three locations were cool..
@victoryudoeyo6912 жыл бұрын
This is a very detailed comparison. I believe Microsoft is fixing the different versions issue with the new 2021 (hopefully). A lot of Excel 365 features are already included in the new 2021 version. I'd personally love to see Microsoft unify the versions.
@chandoo_2 жыл бұрын
Thanks Victory. On the contrary, the news I get from MS is that while they are going to bridge some of the gaps, Excel 365 will continue to evolve where as "standalone" versions are frozen in time of the release. So 2021 will have what 365 has (probably few less features) and stay there while 365 marches on. 😨
@khaleelgaffar34362 жыл бұрын
Hello Mr Chandoo!! another amazing video!! kudos! Q - Quick question, many job listings are asking for "Alteryx", do you think it is something worth investing our time to learn? or we are better of improving on our Excel/BI skills.
@chandoo_2 жыл бұрын
Thanks Khaleel. Alteryx is a data prep & automated analysis tool. I am not familiar with it. But I suggest learning Power Query as well, as if you end up working with Microsoft platform, then PQ will be vital for data analysis.
@scottkomplin2482 Жыл бұрын
Are you available for private training on Power BI? I am a Corporate Finance Controller and want to learn how to use Power BI in my work
@riazuddin74932 жыл бұрын
Hi hope you are doing well. I have two questions. 1. Have you uploaded any video related to setting Goals & KPIs? If yes please share the link with me as I want to learn the same. 2. Regarding managing alerts on Dashboard is there any options through which I can set a general alert? For example in my Department there are various processes related to staff benefits i.e. processing of loans, reimbursements and final settlement. Each process has an agreed Turnaround Time (TAT) I want to set alert so that if any staff's request exceeds the agreed TAT then Power BI should highlight those records for me on my Dashboard alert so that I can instruct my staff or ask them the reason for delay in processing of staff request. Many thanks in advance for your usual help.
@chandoo_2 жыл бұрын
Thanks Riaz. I am doing GREAT. 1) I do not YET have a video on KPI selection. But I talk about it in other videos in my dashboard playlist. Check out them for some best practice. kzfaq.info/get/bejne/pragnrxznturaXU.html 2) I am not an expert in the Power BI online workspaces. I suggest looking at help for this. All the best.
@mrtransmogrify Жыл бұрын
Now in 2023, there are still lots of users who don't know what does a cell formatted to "General" in Excel means or implies....
@snbacademy67702 жыл бұрын
Thanks Chandoo, I am also confused between Excel and Power Bi, I am a BBA Graduate with 10 years of Account and Finance experience, Now I want to do power Bi and shift my carrier to Data analyst. It will be great help to me if you can give suggestions
@chandoo_2 жыл бұрын
Do watch the video fully. I discuss this concept. Feel free to browse the Power BI videos here - kzfaq.info/get/bejne/ebCHYLyTmbbKimw.html
@vv97302 жыл бұрын
POWER BI QUERY IMPORTING ONLY 1ST PAGE NOT ALL PAGES FROM A TABLE WHILE IMPORTING WEBDATA..HOW TO SOLVE THIS..??. AL THOUGH THE QUERY IS NOT RESTRICTING IT BY PAGE NUMBER WISE..
@satishrkulkarni114 Жыл бұрын
Mastering which skill , one can get work as freelancer
@manosdiary19962 жыл бұрын
Hai bro i am not getting map visualisation in powerbi could you pls guide for me
@poonamsutar17262 жыл бұрын
your explanation skills are awesome ... thanks
@chandoo_2 жыл бұрын
Glad you like them!
@shashankks24542 жыл бұрын
Hello sir, Can you make a video on how to land on job..and must learn functions in boath excel and power bi
@chandoo_2 жыл бұрын
I have a few videos on this theme. I suggest looking at this playlist - kzfaq.info/get/bejne/nbyibMlirLDIipc.html
@theblogger36642 жыл бұрын
Plz guide me which was Is good to Get job in anylitics Excle Power Bi Can teach Excel or Power Bi. Real time for us Can teach in telugu for Andhrapradesh students
@chandoo_2 жыл бұрын
I talked about this in the video. Please watch. I have courses on both. Excel course - chandoo.org/wp/excel-school-program/ Power BI course - chandoo.org/wp/power-bi-play-date/
@venkas1852 жыл бұрын
Hi can you help me with building some excel spreadsheet for my work?
@tariqsheikh53102 жыл бұрын
great knowledge sir
@syedmahiyan58392 жыл бұрын
If someone is starting to learn data analytics. Which will you recommend excel or power bi?
@chandoo_2 жыл бұрын
I thought that was clearly answered in the video.
@matthewlim2008 Жыл бұрын
how about Tableau
@UgoCynthia2 жыл бұрын
I'm looking to transition to data analysis, i wish you can take me on one on one coaching, thanks.
@chandoo_2 жыл бұрын
Hi Ugo.. I don't have any one-on-one programs, but please consider the Excel School program to learn from me. Visit chandoo.org/wp/excel-school-program/
@gizelledomingo99922 жыл бұрын
Thank you sir.
@Griffindor212 жыл бұрын
Great video! Whats your thought on Power BI vs SAS Viya?
@chandoo_2 жыл бұрын
Thanks Marvin... I haven't used SAS Viya. So cannot comment.
@sonalichitre22304 ай бұрын
can you. Pls guide me abt your course
@j.maginnenu62912 жыл бұрын
So what are we "modeling", etc...with power BI???.
@chandoo_2 жыл бұрын
Financial models, operational models, optimization problems, simulations, statistical models for a start.
@kurrysamir2 жыл бұрын
Have been reading on usage of PowerBI with AI, is that a good topic to add more videos on?
@chandoo_2 жыл бұрын
The AI visual space in Power BI is exciting for sure. I talk about them in my courses. I will include some demos in the KZfaq as well in upcoming months.
@ARIFSAIFIFARHAN2 жыл бұрын
Hi chandoo As I learned excel and now I am getting confused that what I should going to learn vba Or should goi for power bi
@chandoo_2 жыл бұрын
Congratulations on learning Excel. I suggest picking the next steps based on job situation. If you don't have any need to use either VBA or Power BI, wait until you have a real need. Power BI changes every month, so better to learn it closer to the time of usage. On the other hand, VBA is not being actively "improved" by Microsoft. So by the time you use it, it might be replaced by some other programming language.
@daydreamers7102 жыл бұрын
Why not learn both
@KC-tz6jo2 жыл бұрын
Thanks for your efforts 💕😎
@chandoo_2 жыл бұрын
My pleasure 😊
@proplayerpak6192 жыл бұрын
Sir can you please teach me power bi?
@dataanalyst22862 жыл бұрын
Sir how to find freelancers online jobs for XL and PBI?
@user-qi9bl9hd9l2 жыл бұрын
I purchased chandoo Gantt charts, and asked a question about video manuals to them, but no responses received.
@chandoo_2 жыл бұрын
Hi there.. Please reply back again. I may have missed your original email.
@dhirajsinghchauhan44132 жыл бұрын
Hi Chandoo , Please Help .... I have date format 02-03-2022 (want to change cell format date to text) 1. if i change manually by text to column, i get 02-03-2022 (DD-MM-YYYY) 2. If i use text to column by vba code, i get 2-3-2022 (D-M-YYYY) Please help, how to fix this.......
@chandoo_2 жыл бұрын
Hi.. I am not sure what your question is. If your output date needs to formatted, you can apply format code dd-mm-yyyy and it will show up accordingly. You can also use FORMAT function in VBA to format the converted dates to TEXT with any format string.
@mduff0012 жыл бұрын
Hi what about power pivot (best of both worlds)?
@chandoo_2 жыл бұрын
Power Pivot & Power Query are common in both worlds. So learning them makes the transition EASY.
@chiphungerford2 жыл бұрын
Great video,
@chandoo_2 жыл бұрын
Glad you enjoyed it
@eswar8832 жыл бұрын
What is education qualification.age limit to become data analyst.pliz.
@chandoo_2 жыл бұрын
There is no one answer to this question. Most DA jobs expect graduation. Not sure if they will have specific age limits.
@excellNexcel2 жыл бұрын
750 million users of Excel in the world
@srinaths95492 жыл бұрын
Chandoo Sir, thought on Thoughtspot vs BI
@chandoo_2 жыл бұрын
Sorry but I am not familiar with Thougthspot.
@ExcelWithChris2 жыл бұрын
Thanks!!!
@chandoo_2 жыл бұрын
You are welcome Chris...
@erniecortes5453 Жыл бұрын
no brainer you have to learn both
@mohseenmohammed462 жыл бұрын
excellent video
@chandoo_2 жыл бұрын
Thanks Moseen 😀😀😀
@aashishmalhotra2 жыл бұрын
If finishing studies and in mid to get job shouldn't learn Excel