This has been the best explanation on ETL ever. Super digestible and straightforward, the real world example makes everything more understandable. Thank you!
I'm a beginner to data analysis and was hearing about ETL for the first time in one of my SQL projects. This video has explained ETL very clearly to me. Thanks Chandoo!
Sir: I always get bore studying ETL concept but your superb explanations provides me energy to study again. You are great in practical explanation within short talk. Muhammad Khan, North America.
This is the video I have been searching for! I was so confused about how ETL could be defined... if ETL only happened using ETL tools, or if you could build your own ETL pipeline without the common tools! Thank you!
Thank you for this video! This helps me a lot, even though I already have experience with ETL. :) I like using Python to do this and actually is how I got started because I was learning on my own and went down the wrong path. :P
Hi Chandoo, Happy new Year 2024. I have experience in Oracle PLSQL and MSSQL database's and i wish to switch my career to datawarehouse projects. Kindly guide me the path to proceed like what course should i start..
For ETL include as if we have one shared drive for the company and we take couple of data and combine and clean the data to get the data you need to create a report? Or I should have other sources like sql, azure or scrap the data?
@@chandoo_ my question is, can i say I do etl if I combine multiple excels using a primary’s keys? Or it something advance like scrape a data then joining data using sql?
Just cleaning data and combining tables is not ETL. You will need to be actually doing the "L" to a database / warehouse system. Don't be fast and loose with the terminology (especially in interviews).
Sir , i wanted to ask you that if i wanted to be a Business Analyst and Data analyst should i pursue MBA after having the skill set of Data analyst. And if i pursue MBA , should i do specialisation in Business Analyst or Normal MBA would do? Thank you ❤️
MBA is not requirement to be either Business or Data Analyst. If you have a strong background in the industry, you can get in to these positions. MBA often helps in speeding up the process (for example it might take 4-5 years of experience to get the role, but with MBA you might get the same in 1-2 years).
Hi Chandoo, can you help me in one issue I'm facing like. I have one Item number xyx00001 but for that 3departments are working but when I have created a Measure formula of variance e.g. (calculate Sum(total hour) - Sum(actual hours))in measure result I'm getting 3 different value instead on same on in each row any logic can you provide. and yes there is no relationship issue for that can you help
Chandoo, i have a problem. I need ur help. I have a excel files in share point . Which has query connection with other excel files. I need to refresh all in a excel file. Without opening the file manually. Because that file is connected to power bi
forget it! you need to delete the main file and run a progress report. the report will delete the setup and then you insert the fileload which will allow for a refresh on demand.
Hello Sir, Could you please help me know what skills are required to become a data analyst? I've watched tons of videos including yours on this topic and got confused. To give a brief idea, I have an intermediate level of knowledge of Excel, SQL, Python (Including Numpy, Pandas, Matplotlib, and Seaborn), Power BI ( PQ, Data Modeling, DAX, Dashboarding), and Statistics. When I go to any job portals, it says you need to know machine learning, and deep learning too. 🥲 Can I get a job with these skills?
Sir, this is a Superb Explanation.
Glad you liked it
I liked the clever pun "Enjoyed? Then Like" (ETL) 😁
This has been the best explanation on ETL ever. Super digestible and straightforward, the real world example makes everything more understandable. Thank you!
What an eloquent manner to describe these concepts. I greatly appreciate it. 🙏🏽
I'm a beginner to data analysis and was hearing about ETL for the first time in one of my SQL projects. This video has explained ETL very clearly to me. Thanks Chandoo!
Neither Ramarao nor RamCharan, you are my Superhero!! God bless you with long life Anna. Thank you so much for the great content
Wow respect man… most people pay obeisances to actors from who we get entertained and not educated
Wonder to see actor comparison in comments for ETL !
That is so sweet. Thanks Raghu 😍
Sir: I always get bore studying ETL concept but your superb explanations provides me energy to study again. You are great in practical explanation within short talk. Muhammad Khan, North America.
I’m looking into pivoting my career into data engineering and this video really was informative. Thank you
This is the video I have been searching for! I was so confused about how ETL could be defined... if ETL only happened using ETL tools, or if you could build your own ETL pipeline without the common tools! Thank you!
I like how you show us the real-world example. Make the learning more understandable!
Bro you are dam good at explanation, I love learning from the ETL course
Thank you for a great explanation, we need more of you in this world😄
Along with the explanation, your presentation and delivery style is beautiful
Your videos and teachings are top notch!!! Simply good at what you do
Glad you like them!
I watched in 13 minutes. But the pain behind to shoot this video with all those props. Amazing efforts chandoo sir😮😊
Thanks Arjun :) It was a fun video to make.
What a great mentor.
Came here thinking I know nothing about this but turns out it's my daily job lol
Thank you so much for this. It helped clarify a lot about ETL and its tools
Man, this clarifies everything, thank you so much!
Glad it was helpful!
I like how you explain topics, they never get anymore complicated
Thanks Joshua...
Thanks Chandoo. I always enjoy learning from you.
Good morning, and thats the nice to explain with a small data set
Thank you for explain it very clear ❤
thank you man, very clear and helpful
Thank You So Much. You put a lot of effort into this vid!
You are doing such good work. Keep it up.😊
You are welcome Andrew. 😀
Amazing explanation!!
Thanks for that 🎉
It's Wow! The way you explain...….
great explanation, thanks a lot
Am always happy seeing you solving problems...kudos my mentor
thank you! this was super helpful
Clever explanation
Awesome Video Chandoo Annaya 💌👏
Really enjoyed it. Thanks bro
Just Awesome Brother. Could you do more videos on ETL and it's famous tools in industry for Data Analytics.
The whole video was very helpful! I did chuckle at the ETL/like the video joke 🤭
Glad it helped!
last ETL concept was great ...
Thank you for this video! This helps me a lot, even though I already have experience with ETL. :) I like using Python to do this and actually is how I got started because I was learning on my own and went down the wrong path. :P
Awesome explanation brother... keep it up :)
always helpful sir
You won a subscriber 👍
Super cool explanations - I like the paper concept
Glad you liked it!
Great job. Thanks a ton
I enojyed that. Countless examples without actual specific examples like this.
Many thanks Chandoo.You are awesome.
Thanks a ton . Invaluable
ASMR, amazing explanation!
Thank you very much ❤
Thanks 🙏 SIR, God Bless You
Most welcome
Nice work Chandoo, thank you!
Am learning the ETL
Very good explanation power
wow this is so amazing .
👏🏻awesome
Awesome, very useful
Nicely explained sir😊...!!! Please make a complete video of Microsoft 365.
Great video!!
Thank you so much!
Thank you ❤
Hi Chandoo, Happy new Year 2024. I have experience in Oracle PLSQL and MSSQL database's and i wish to switch my career to datawarehouse projects. Kindly guide me the path to proceed like what course should i start..
Fantastic!!
Thanks.
thank you!
Great
Any ETL tool recommendation to start with?
For ETL include as if we have one shared drive for the company and we take couple of data and combine and clean the data to get the data you need to create a report? Or I should have other sources like sql, azure or scrap the data?
Not sure I understand your question. Try again please?
@@chandoo_ my question is, can i say I do etl if I combine multiple excels using a primary’s keys? Or it something advance like scrape a data then joining data using sql?
Just cleaning data and combining tables is not ETL. You will need to be actually doing the "L" to a database / warehouse system. Don't be fast and loose with the terminology (especially in interviews).
@@chandoo_ please can further explain how to do the “L” to the database?
L = Load. This is where the transformed data is loaded to target system using either SQL or some other ingestion methods.
Pls make a video on how to upload a dashoboard on linkedin
Sir , i wanted to ask you that if i wanted to be a Business Analyst and Data analyst should i pursue MBA after having the skill set of Data analyst.
And if i pursue MBA , should i do specialisation in Business Analyst or Normal MBA would do?
Thank you ❤️
MBA is not requirement to be either Business or Data Analyst. If you have a strong background in the industry, you can get in to these positions. MBA often helps in speeding up the process (for example it might take 4-5 years of experience to get the role, but with MBA you might get the same in 1-2 years).
Thank you, first comment
Hello sir , please make a full course in SQL ...please sir
I have a detailed SQL video here - ruclips.net/video/l8DCPaHc5TQ/видео.html
Which tool you used? Please reply
Sir do we need sqlserves ,ssis,azure, To learn powerbi and to get job on it.
bring end to end ETL project Sir
Hi Chandoo, can you help me in one issue I'm facing like. I have one Item number xyx00001 but for that 3departments are working but when I have created a Measure formula of variance e.g. (calculate Sum(total hour) - Sum(actual hours))in measure result I'm getting 3 different value instead on same on in each row any logic can you provide. and yes there is no relationship issue for that can you help
This is awesome: loved the jokes
sir can you share data so that we can practice the same query
You can use the dataset and SQL shared in this video - ruclips.net/video/l8DCPaHc5TQ/видео.html
SHouldnt it be if(sum(s.amount)>1000,1,0)
I liked just for the dad joke at the end
Is ETL dev job will replace by AI.? How can freshers tackle this ? 😢
Chandoo, i have a problem. I need ur help. I have a excel files in share point . Which has query connection with other excel files. I need to refresh all in a excel file. Without opening the file manually. Because that file is connected to power bi
forget it!
you need to delete the main file and run a progress report. the report will delete the setup and then you insert the fileload which will allow for a refresh on demand.
Where the stages explenation
😃
ETL is just data entry then? WTF😂
First
Mai first
Hello Sir,
Could you please help me know what skills are required to become a data analyst?
I've watched tons of videos including yours on this topic and got confused.
To give a brief idea,
I have an intermediate level of knowledge of Excel, SQL, Python (Including Numpy, Pandas, Matplotlib, and Seaborn), Power BI ( PQ, Data Modeling, DAX, Dashboarding), and Statistics.
When I go to any job portals, it says you need to know machine learning, and deep learning too. 🥲
Can I get a job with these skills?
Did you got the job? I am in ur stage now and looking for a job