I liked the clever pun "Enjoyed? Then Like" (ETL) 😁
@ArenitaHernandez8 ай бұрын
What an eloquent manner to describe these concepts. I greatly appreciate it. 🙏🏽
@hazmannaim7055 ай бұрын
I like how you show us the real-world example. Make the learning more understandable!
@AllisonSadin-cq2wt4 ай бұрын
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!
@raghukoduri2018 Жыл бұрын
Neither Ramarao nor RamCharan, you are my Superhero!! God bless you with long life Anna. Thank you so much for the great content
@carcrazynishant Жыл бұрын
Wow respect man… most people pay obeisances to actors from who we get entertained and not educated
@chaitanyakumar3023 Жыл бұрын
Wonder to see actor comparison in comments for ETL !
@chandoo_ Жыл бұрын
That is so sweet. Thanks Raghu 😍
@suck-myballs11528 ай бұрын
This was a GREAT video! Simple, informative, and with a real-world example!
@AdalgrimTook4 ай бұрын
Came here thinking I know nothing about this but turns out it's my daily job lol
@yqhanliving10 ай бұрын
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!
@FawazPashaShroff17 күн бұрын
Bro you are dam good at explanation, I love learning from the ETL course
@juliamavis28305 ай бұрын
I’m looking into pivoting my career into data engineering and this video really was informative. Thank you
@aryanpatil49Ай бұрын
Along with the explanation, your presentation and delivery style is beautiful
@djenobthemixbane11465 ай бұрын
Thank you so much for this. It helped clarify a lot about ETL and its tools
@chijiokeijezie969 Жыл бұрын
Your videos and teachings are top notch!!! Simply good at what you do
@chandoo_ Жыл бұрын
Glad you like them!
@NaisDeis Жыл бұрын
Man, this clarifies everything, thank you so much!
@chandoo_ Жыл бұрын
Glad it was helpful!
@arjundev4908 Жыл бұрын
I watched in 13 minutes. But the pain behind to shoot this video with all those props. Amazing efforts chandoo sir😮😊
@chandoo_ Жыл бұрын
Thanks Arjun :) It was a fun video to make.
@joshuabretana Жыл бұрын
I like how you explain topics, they never get anymore complicated
@chandoo_ Жыл бұрын
Thanks Joshua...
@tamirbahalker168 ай бұрын
Thank you for a great explanation, we need more of you in this world😄
@nukestrom57195 ай бұрын
What a great mentor.
@stevenvanveldhoven43683 ай бұрын
Thanks Chandoo. I always enjoy learning from you.
@thenorthremembers5978Ай бұрын
thank you! this was super helpful
@omgitsbees15 күн бұрын
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
@kehindefayomi7417 Жыл бұрын
Am always happy seeing you solving problems...kudos my mentor
@andrewjason3756 Жыл бұрын
You are doing such good work. Keep it up.😊
@chandoo_ Жыл бұрын
You are welcome Andrew. 😀
@ihemanthsagar8 күн бұрын
You won a subscriber 👍
@pillslifestylereviews67146 ай бұрын
Thank You So Much. You put a lot of effort into this vid!
@tariqhussain14977 ай бұрын
Good morning, and thats the nice to explain with a small data set
@surajmane54814 ай бұрын
It's Wow! The way you explain...….
@pcandy4683 ай бұрын
The whole video was very helpful! I did chuckle at the ETL/like the video joke 🤭
@chandoo_3 ай бұрын
Glad it helped!
@chicaocasanova3 ай бұрын
Thank you very much ❤
@kirandeepmarala5541 Жыл бұрын
Awesome Video Chandoo Annaya 💌👏
@victorbegnini57548 ай бұрын
Amazing explanation!! Thanks for that 🎉
@markpatterson76611 ай бұрын
I enojyed that. Countless examples without actual specific examples like this.
@learn_ai_with_us Жыл бұрын
last ETL concept was great ...
@VivekKBangaru7 ай бұрын
Really enjoyed it. Thanks bro
@aiasaiascon3894 Жыл бұрын
Super cool explanations - I like the paper concept
@chandoo_ Жыл бұрын
Glad you liked it!
@talesoftravelsbysj2 ай бұрын
Clever explanation
@shivaratribikshapathilinus59853 ай бұрын
Am learning the ETL
@Sandeepindiamyself Жыл бұрын
Nicely explained sir😊...!!! Please make a complete video of Microsoft 365.
@edwindsouza71577 ай бұрын
Very good explanation power
@balutaalex6694 Жыл бұрын
ASMR, amazing explanation!
@alfredtomiamubiaya3330 Жыл бұрын
Many thanks Chandoo.You are awesome.
@chrism9037 Жыл бұрын
Nice work Chandoo, thank you!
@loybiz7 ай бұрын
Great job. Thanks a ton
@PavanMS87 Жыл бұрын
Thanks a ton . Invaluable
@jagatkrishna1543 Жыл бұрын
Thanks 🙏 SIR, God Bless You
@chandoo_ Жыл бұрын
Most welcome
@idreeskhan5129 Жыл бұрын
wow this is so amazing .
@nviknesh81129 ай бұрын
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..
@easterntoronto4 ай бұрын
Great
@hukkuhukku62088 ай бұрын
👏🏻awesome
@Prabhakaran-hp1to Жыл бұрын
Thank you so much!
@aparnapandravada5073 Жыл бұрын
Awesome, very useful
@NavneetKaur-kd6bd Жыл бұрын
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 ❤️
@chandoo_ Жыл бұрын
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).
@Nash03039 ай бұрын
Fantastic!!
@CaribouDataScience Жыл бұрын
Thanks.
@KiranYadavOG Жыл бұрын
thank you!
@ajayyaleti6197 Жыл бұрын
Thank you ❤
@skrejaulhaque Жыл бұрын
Thank you, first comment
@nikki_siddi Жыл бұрын
Great video!!
@Sardar_Uk2 ай бұрын
Which tool you used? Please reply
@janauppara10 ай бұрын
Any ETL tool recommendation to start with?
@nandiniagarwal9201 Жыл бұрын
Pls make a video on how to upload a dashoboard on linkedin
@ppy0019 Жыл бұрын
Hello sir , please make a full course in SQL ...please sir
@chandoo_ Жыл бұрын
I have a detailed SQL video here - kzbin.info/www/bejne/ommndIOXfchoirM
@rajatthakur6444 Жыл бұрын
bring end to end ETL project Sir
@trueman5948 Жыл бұрын
Sir do we need sqlserves ,ssis,azure, To learn powerbi and to get job on it.
@talebbagazi1435Ай бұрын
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_Ай бұрын
Not sure I understand your question. Try again please?
@talebbagazi1435Ай бұрын
@@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?
@chandoo_Ай бұрын
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).
@talebbagazi1435Ай бұрын
@@chandoo_ please can further explain how to do the “L” to the database?
@chandoo_Ай бұрын
L = Load. This is where the transformed data is loaded to target system using either SQL or some other ingestion methods.
@JagdishDive123 Жыл бұрын
Is ETL dev job will replace by AI.? How can freshers tackle this ? 😢
@rockky-zz8ii Жыл бұрын
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
@BhuvaaneshRavi4 ай бұрын
SHouldnt it be if(sum(s.amount)>1000,1,0)
@daminitripathi913 Жыл бұрын
sir can you share data so that we can practice the same query
@chandoo_ Жыл бұрын
You can use the dataset and SQL shared in this video - kzbin.info/www/bejne/ommndIOXfchoirM
@mukeshvarma8662 Жыл бұрын
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
@mikatu Жыл бұрын
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.
@transworld8005 Жыл бұрын
😃
@whothefcares26873 ай бұрын
ETL is just data entry then? WTF😂
@prrrrince Жыл бұрын
First
@skrejaulhaque Жыл бұрын
Mai first
@akashgautam1909 Жыл бұрын
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?
@bharaths59063 ай бұрын
Did you got the job? I am in ur stage now and looking for a job