What is Data Pipeline | How to design Data Pipeline ?

No video

What is Data Pipeline | How to design Data Pipeline ? - ETL vs Data pipeline (2024)

Рет қаралды 1,064,200

Күн бұрын

What is Data Pipeline | How to design Data Pipeline? - ETL vs Data pipeline
#datapipeline
📢📢 Subscribe to my FREE newsletter "Normal I.T. Guy" to know more about what I am thinking, learning and doing in my career & life !!
CLICK THE LINK BELOW 👇👇👇
anshultiwari.s...
**Do check out our popular playlists**
1) Latest technology tutorial (2020) -
• What is a Data Vault ?...
2) Google Cloud Platform Beginner Series (2020) -
• Google Cloud Platform ...
3) Crunching Data Series (2020) - • Learn - Data Engineeri...
Hi Friends, I am Anshul Tiwari, and welcome to our youtube channel I.T. k Funde.
More about this video -
In this video, we will understand what is a data pipeline with the help of a real-life example. Data pipelines are designed to move data from one point to another. In this video, we will cover below topics -
1 - What is a Data Pipeline?
2 - Why you need a data pipeline?
3 - Basic design of a data pipeline
4 - Types of Data Pipeline - Batch, Streaming, Lambda architecture
5 - Advanced data pipeline design
We will also learn about various products that can be used in a data pipeline - SAP BODS, Mongo DB, Apache Kafka, Big Query, MDM, Teradata, SAP Business Objects, Tableau.
Credits & Resources -
Wikipedia
www.alooma.com...
*********************FOLLOW US ON*************************
Facebook - / itkfunde
Linkedin - / ansh9685
Twitter - / ansh9685
Blog - blogs.itkfunde...
Instagram - / itkfunde
****************************************************************
*****************About This Channel************************
Friends ITkFUNDE channel wants to bring I.T related knowledge, information, career advice, and much more to every individual regardless of whether he or she belongs to I.T or not. This channel is for everyone interested in learning something new!

Пікірлер: 1 200

@sivanagarajugamidi 3 жыл бұрын

Master piece tutorial for data engineering

@ITkFunde 3 жыл бұрын

Thanks Siva

@indexima6517 3 жыл бұрын

hey! don't hesitate to follow us and to take a look at our videos which deal with the same topics :)

@vijayjayaram606 3 жыл бұрын

@@indexima6517 I guess the videos on ur channel deals with more on, what do we do after receiving the data, analytics if I understand correctly. Here, its more of pumping the data from one place to a common place, and make it available for interested people down the lane

@gautamdeusa 2 жыл бұрын

@@ITkFunde It's truly one of the finest and easiest video to follow and relate. Many thanks. Will check other videos.

@lwhieldon1 2 жыл бұрын

Thank you for breaking down concepts that are difficult to understand!

@nathancarranza9860 3 жыл бұрын

Something I’ve noticed is that Indians are good teachers and give great illustrations. Good work. Greetings from the US.

@ITkFunde 3 жыл бұрын

Thanks Nathan for making me feel even more proud of being an Indian thank you for the compliment means a lot brother 🙏😊

@fsfernandes20 3 жыл бұрын

Yes Indians like to make difficult concept easy

@nathancarranza9860 3 жыл бұрын

I don’t use my real name online, but I do give real compliments.

@AutitsicDysexlia 3 жыл бұрын

@@nathancarranza9860 Plot Twist: His real name was not Nathan. It was always Vladimir Putin.

@visionxx8656 3 жыл бұрын

Can't believe Putin is from US

@ericdasse8174 2 жыл бұрын

That was great! As a data engineer in the making, this is the first time I have understood the concept of data pipelines so clearly. Thank you very much

@lukmanaliyu7386 2 жыл бұрын

Hello Eric, I'd love to know how it's going for you at the moment with the DE track

@altamashjawad6691 2 жыл бұрын

Loved this video, probably the best explanation on advanced data pipeline out there. If in your next videos, maybe create a playlist which can show each of the section of this pipeline in detail with little examples using Python or any language etc. Just an idea, brilliant work!

@MrBignate12345 4 жыл бұрын

Please continue to create videos like these! So easy to understand. Love your visual teaching style and the examples you give.

@ITkFunde 4 жыл бұрын

Thank you MrBignate...The aim is to simplify these techie jargons for everyone to correlate and enjoy learning.

@prabur4027 2 жыл бұрын

This would be the Best start for the Data Engineers.. A clear precise and short pictorial representation of Data Pipeline (Basics). Best video so far I had seen.. 😊 Thanks.. Much Appreciated.. 👍

@ITkFunde 2 жыл бұрын

Thanks Prabu 👍☺️🙏

@vivekjoshi3769 2 жыл бұрын

Do data analysts also use data pipeline creation in their jobs ? Or are they expected to know it ? Asking as some companies write knowledge of ETL in JDs.

@prabur4027 2 жыл бұрын

@@vivekjoshi3769 knowing any of the ETL tools would help in constructing the pipelines and they can visualize data flow from source to target.. Yes mostly it is used..

@sy-vf4js 3 жыл бұрын

And again, another easy-to-digest video. Thumbs up!

@ITkFunde 3 жыл бұрын

Thank you 🙏🙏☺️

@squarehead6c1 3 жыл бұрын

Great intro, just what I needed. I learned the distinction between ETL and general pipe lines, and Kafka's place in the architecture.

@ITkFunde 3 жыл бұрын

Thanks Ronnie☺️

@bigglesharrumpher4139 Жыл бұрын

Great video - it seems while technology has advanced, the concepts of batch loads and real-time data is actually decades old. Back in early 2000's we controlled all ETL and real-time loads with Unix or DOS or SQL scripts that provided return codes for success/failure which triggered alert emails, and we had KPI's for Data quality, backing-out jobs for failed loads, and many other control systems. It just seems there are more 'out-of-the-box' software to handle these now as opposed to custom-built solutions. Great presentation!

@Thekingslayer-ig5se Жыл бұрын

Nice

@alexanderulloaopazo6275 3 жыл бұрын

Thank you! I had read a lot of papers about Data Pipeline, but I couldn't get the main idea. However, your video was so easy to understand!! Now I have a better picture of the complete process. Thanks again.

@ITkFunde 3 жыл бұрын

Thank you Alexander !!!

@MrBignate12345 4 жыл бұрын

Would love to learn more about how to choose the right frameworks/technologies for data pipelines and data warehouses/lakes for differing requirements. It would be nice to see a playlist of you designing or comparing solutions for an analytic stack.

@ITkFunde 4 жыл бұрын

Thanks MrBignate I have created various playlists one of which is " Crunching Data Series "...I will surely make more videos on similar topic. It is because of encouragement from audience like you which helps me move forward so thanks and really grateful for your positive feedback.

@lcsxwtian 3 жыл бұрын

Simply one of the best videos on data pipeline on KZfaq. Deserves so much more attention.

@mardiidking4030 Жыл бұрын

This topic is so complex as a beginner, but I understand this explanation so well. I didn't even have to go back in the video or rewatch it to understand. This is beautiful.

@ITkFunde Жыл бұрын

Thank you so much for your kind words and support 🙏🙏♥♥

@ramakrishnachimmani7273 3 жыл бұрын

Thank you. The best way of explanation. I was looking for this kind of video for long time. As a traditional ETL developer, I questioned my self, why people are using a term called 'Data pipeline' though we have ETL process and what is the exact difference between them. Thanks again.

@ITkFunde 3 жыл бұрын

Thanks Rama for your positive feedback !!

@juliansihite1289 Жыл бұрын

This guy really explain everything clearly and simple! Good job brother, keep sharing and contributing! You're a great teacher :)

@ITkFunde Жыл бұрын

Thanks Julian 😊❤️🙏

@kenford3738 3 жыл бұрын

Great job explaining the difference between Data Pipelines and ETL.

@ITkFunde 3 жыл бұрын

Thanks Ken 🙏☺️

@K0n5tant 3 жыл бұрын

Your way of explaining these concepts is excellent, thank you!

@ITkFunde 3 жыл бұрын

Thanks a lot

@dhritimanbnrj 3 жыл бұрын

best productive 10 minutes of my life.

@ITkFunde 3 жыл бұрын

Thanks Dhritiman for this super comment you made my day 🙏☺️

@mitchelleleeuw2266 Жыл бұрын

☺️I’m new in Data Engineering and man you created a clear picture of what I’ve been learning and trying to understand 🙂love this… definitely subscribing 🤩

@othmanbelmouzouna3893 3 жыл бұрын

Very good tutorial with valuable explanations. Thanks.

@ITkFunde 3 жыл бұрын

Thanks Othman

@brentcos9370 3 жыл бұрын

Very informative, especially for a non-computer science guy like myself. Thanks!

@ITkFunde 3 жыл бұрын

Thanks Brent that is the essence of this channel - Making I.T. interesting for everyone.

@KolawoleAdekoya Жыл бұрын

Simplified and clear explanation of the concepts. Great diction and presentation. Well done!

@ITkFunde Жыл бұрын

thanks Kolawale

@arunachalampalani4321 Жыл бұрын

Couldn't have asked for more. Very well explained, Thank you mate.

@rohidaskumbharkar7277 2 жыл бұрын

This was extremely helpful for understanding to Real and batch data streaming and also lambda architecture.

@ITkFunde 2 жыл бұрын

Thanks Rohidas

@aitemiryeskenov355 3 жыл бұрын

Wonderful explanation. Can't tell you how much I appreciate brilliant tutorials like this one.

@Gridblue 2 жыл бұрын

Thank you for the video, I learnt what data lake hydration projects are, my previous company had no proper KT, I struggled to grasp what I was doing. This was very nicely explained and cleared the doubts that I had.

@ITkFunde 2 жыл бұрын

Thanks♥️

@hasmilaomar5562 2 жыл бұрын

It is good that u explain the concept of data pipeline by referring to water pipeline. So much easier to understand and remember. Thank you for your video!!

@damiiete 2 жыл бұрын

Great explanation for introduction to data pipelines. Thanks for clarifying the distinction between ETL and data Pipelines.

@kalyanchakri5258 4 жыл бұрын

Love your way of teaching in a simple understandable concepts. Im mad of you..!

@ITkFunde 4 жыл бұрын

Thanks Kalyan for your feeback it helps a lot..

@Manoj419419 3 жыл бұрын

Great explanation and examples used. Thanks a ton !!

@ITkFunde 3 жыл бұрын

Thanks Manny

@sabysreya 3 жыл бұрын

Simple and super easy to understand 👌👍👏👏

@ITkFunde 3 жыл бұрын

Thanks again

@ramakambhampati5094 Жыл бұрын

You are a real "Data Pipeline Spiderman".... fantastic instructor..please share more videos....thanks

@ITkFunde Жыл бұрын

Thanks Rama ☺️☺️

@vox-populi-vox-dei- 2 жыл бұрын

I think, you'ver covered it all as part of Enterprise Data Architecture. This is from the technology view and bit of functional view as well. Good job!

@ITkFunde 2 жыл бұрын

Thanks

@chocochipbananasplit 3 жыл бұрын

I got more out of your video than reading 5 articles on the matter! Your content is great!

@NathJones11 Жыл бұрын

A very clear explanation of the differences between the two methods. Often I see everything limped under an ETL umbrella, when it may not accurate.

@ITkFunde Жыл бұрын

Thanks 🙏

@meemanikandan 3 жыл бұрын

Good one to understand Data Pipeline. Thanks!

@ITkFunde 3 жыл бұрын

Thanks🙏

@hussamcheema 3 жыл бұрын

Excellent Explanation. Keep making more videos regarding Data Engineering, AI, and Data Science.

@ITkFunde 3 жыл бұрын

Thanks a lot mate for your feedback and suggestion!!

@maelherbert321 3 жыл бұрын

Really content. Bravo from France 👏👏👏

@ITkFunde 3 жыл бұрын

Merci Mael 😊

@rajguru1998 3 жыл бұрын

Finally understood the pipeline in 10 mints... thank u

@asthagoel3000 Жыл бұрын

Big concepts explained very quickly in an easy to understand manner. Thanks!

@jamesmcmurtry5351 3 жыл бұрын

Great visual layout. Would love to see this applied to an ELT model with Snowflake and it's advantages/disadvantages. Possibly a suggestion on ML complementary tools like Looker and Kraken.

@ravinduabeygunasekara833 2 жыл бұрын

This is superb!. I am very strange to Data Engineering, and this video gave me a super insight! Keep up the good work

@ITkFunde 2 жыл бұрын

Thanks Ravindu ☺️

@anilpetwal 2 жыл бұрын

What a brillient explaination

@alagurajastp Жыл бұрын

Thanks for giving Basic understanding

@JibrilLamai 3 жыл бұрын

This is a very good explanation and the best I have seen so far in my quest to understand this concept. Thank you very much. Now I can confidently visualize and explain the same concept with ease and a great understanding of it.

@ITkFunde 3 жыл бұрын

Thanks Jibril glad it helped 🙏☺️

@sid1r 3 жыл бұрын

Thank you so much for a great and easy to understand data pipeline introduction. I love how you focus on the concepts and not jargons, as it allows for people to understand the essence of data pipeline.

@Aditya-zv5et Ай бұрын

really a great video for someone who is trying to understand data pipeline

@deviprasad7847 3 жыл бұрын

Data Pipeline made easy in a short video with lot of information

@ITkFunde 3 жыл бұрын

Thanks Devi

@knorth2386 3 жыл бұрын

Hi Anshul, your video was helpful. I have experience with ETL but didn't know that it was a specific type of data pipeline. Thanks for showing the different type of systems and technologies used for the concept visual that you explained with.

@ITkFunde 3 жыл бұрын

Thank you Kyle coming from an experienced guy means a lot. Hoping for continued support !!

@FIRE_EVERYTHING Жыл бұрын

Excellent high level overview Anshul, I appreciate that you differentiated between batch data and real time data with the Lambda Architecture as it seems most applicable to modern organizations. Your explanation of dashboards as consumers was also very realistic. Your video helped me better understand the general steps in the process. +1 Subscriber.

@ITkFunde Жыл бұрын

Thanks Matthew for supporting ❤️

@SunnyUtkarsh81 Жыл бұрын

that's very simple and best way to explain about data pipeline

@edsonsabino 2 жыл бұрын

Great! The part that I liked the most was the one in wich he explained the difference between ETL and data pipeline

@mikebrooks4182 3 жыл бұрын

Thanks for a great overview of how the Lambda architecture can expedite the delivery of data to data consumers. For future videos, it would be helpful to map this to the roles, responsibilities, and skill requirements needed to manage this environment.

@ITkFunde 3 жыл бұрын

Thanks Mike for suggestion will try to add this

@sourabhsuri8812 3 жыл бұрын

Thank you so much brother, for clarifying some of the concepts.. Truly appreciate it. Can you suggest - Which way is the Tech Heading now - Data Warehouse Vs. Data Lake? Are DWH a thing of past?

@ITkFunde 3 жыл бұрын

Thanks Sourabh, DWH is here to stay its not going anywhere. Today data world has become enormously huge and there is space for DWH and DL to co exist also Datalake can not solve all business problem. There is a hybrid approach coming up wherein you have your DWH on top of your Datalake

@vivek1joshi 2 жыл бұрын

Data Mesh

@GonzaloArangoF Жыл бұрын

It is a clear presentation for common people. Tanks!!

@empressbelless3232 3 жыл бұрын

This is meant to be a compliment. I appreciate how articulate your English is with each word you speak! Easy to listen to!

@nikolaysokolov9027 2 жыл бұрын

It's excellent explanation. Thanks!

@haydarissa9371 2 жыл бұрын

Very elegant way to explain data pipelining and ETL approach. I appreciate the examples given especially the master data management. Well done.

@sunderdase3511 Жыл бұрын

A simple and superb explanation about Data pipeline structure. Thanks a lot. Really appreciate!

@obiradaniel 2 жыл бұрын

Thank you very much, very elaborate and concise, this import for everyone in the technical data cycle, data engineer, analyst, administrator and data scientist.

@alessandroceccarelli6889 Жыл бұрын

Thank you for your high-quality videos! In our use case, we ingest daily a .zip file containing 3 .csv’s related to sales, inventory and orders from different shops (20-30) and CRMs (4-5 ; each one with its own naming convention, dtypes, …). How would you improve the following pipeline? - Raw zip files are uploaded to a GCP bucket - The upload triggers a Python GCP Cloud function that transforms the data to create single naming/dtypes conventions and brief new columns (e.g. timestamp by merging date + time) - Transformed data is uploaded to MongoDB - 3 separate collection for sales, inventory and orders - and raw .csv’s to a separate GCP bucket as parquet files (1 folder for each CRM and PoS as subfolder) - A PubSub message posted by the function triggers a GCP Function that loads processed data from MongoDB, applies ML models and stores results in separate collections (1 for each analysis type; e.g. forecast, anomaly detection, …) - A Python web app directly reads ML output data from MongoDB Thank you so much and love your videos; 🤗

@redshift3639 2 жыл бұрын

Very useful video. Thank you

@ssbsathish 2 жыл бұрын

Awesome thanks for sharing your interest

@ITkFunde 2 жыл бұрын

Thanks Sathish

@sulaimankhan8033 2 жыл бұрын

Watched it again & again for clarity - Good !!

@ITkFunde 2 жыл бұрын

Thanks ♥️♥️

@joshuaabok3329 2 жыл бұрын

Amazing analogy. Amazing explanation of data pipeline. This is just awesome.

@delivcemwangi7396 2 жыл бұрын

Thanks so much this is the most simplified and easy to learn video on Data Pipelining

@ITkFunde 2 жыл бұрын

thanks

@burimcakolli3400 10 күн бұрын

Great Teacher! Used your Video for my teaching in switzerland

@ITkFunde 10 күн бұрын

Thanks Mate, so happy to see it's helping 😊😊

@davydwes 3 жыл бұрын

quickly and good explanation. Tks

@ITkFunde 3 жыл бұрын

Thanks Davyd ☺️

@darinacherepanova6930 2 жыл бұрын

It’s eyes opening and matching pieces in my head into logic, really thankful !

@amitparmar8076 Жыл бұрын

What a superb explanation with simplistic examples and scenario.

@muthuk72 Жыл бұрын

Excellent glimpse !!! thanks lot

@ITkFunde Жыл бұрын

Thanks Muthu 😊

@bhuvaneshkumar9763 Жыл бұрын

Precise explanation of Data pipe line...👏👏👏

@ITkFunde Жыл бұрын

Thanks Bhuvanesh

@abhinavshankar92 3 жыл бұрын

Simple and Clear

@ITkFunde 3 жыл бұрын

Thanks Abhinav 🙏☺️

@erengulbayram 3 жыл бұрын

Great explanation! Thank you

@ITkFunde 3 жыл бұрын

😊 thxxxx

@emailamit08 2 жыл бұрын

Awesome teaching method crystal clear understanding for a beginner like me. 10/10

@diemuino 7 ай бұрын

Excellent explanation and examples, Anshul. Thank you for the video!

@ITkFunde 7 ай бұрын

Thanks Dear

@coolfreaks68 3 жыл бұрын

*3 natures of data pipeline :* *1. Real Time Integration : User Event triggered process.* ( Example : API Led Connectivity, Mulesoft API ) ( data incoming rate : small ) *2. Near Real Time Integration : Message Queue triggered process.* ( Example : Websphere Message Broker, Kafka ) ( data incoming rate : medium ) *3. Batch Integration : Scheduled process.* ( Example : Informatica Powercenter workflow ) ( data incoming rate : large )

@pedrotaraujo2 3 жыл бұрын

Nice Video! thank you for sharing!

@ITkFunde 3 жыл бұрын

Thanks Pedro

@dhansraj7345 2 жыл бұрын

Very nice architecture in a simple hand drawn picture and presentation also. Awesome job

@ravirty8962 3 жыл бұрын

Simply superb tutorial with good example.

@ITkFunde 3 жыл бұрын

Thanks Ravi☺️

@shivesh2813 2 жыл бұрын

really insightful and helpful channel for learning IT fundamentals

@guillermocarlosmancocuzcan5251 2 жыл бұрын

Thanks for share your knowledge in a simple way.

@ITkFunde 2 жыл бұрын

Thanks a lot for supporting

@francis191 2 жыл бұрын

Clear simple and easy to understand - great presentation

@ajeet23790 6 ай бұрын

Your teaching technique is amazing. Thank you for sharing the knowledge on data pipeline. My all doubts related to data pipeline is clear now.

@essboogy 2 жыл бұрын

This is excellent. Really interesting and easy to follow. I am just starting training with IBM to be a Data Engineer. Leaving healthcare for good!

@ITkFunde 2 жыл бұрын

Thanks a lot ☺️☺️🙏

@zahirsiddique747 Жыл бұрын

Nice and simple explanation of Data pipeline.

@fredericklester9372 2 жыл бұрын

Excellent technical tutelage on data pipelines!

@udaythakur1405 3 жыл бұрын

Easy & Crisp To Understand. Really appreciate.

@ifeakintayo6871 3 жыл бұрын

wonderful. God bless you. Very detailed high level explanation . Boss!!!!!

@ITkFunde 3 жыл бұрын

Thanks Ife for your support and wishes 🙏🙏☺️

@akankshagupta5067 3 жыл бұрын

awesome tutorial. Thank You.. :)

@ITkFunde 3 жыл бұрын

Thanks Akanksha

@robertvandersluis7412 Жыл бұрын

Thank you - this was so helpful. Very clear and concise.

@ITkFunde Жыл бұрын

♥️♥️♥️

@sripathysrinivas4579 Жыл бұрын

Fantastic!!! Thanks for your time and explaining the basics!!!

@ITkFunde Жыл бұрын

My pleasure!

@smitadash8113 2 жыл бұрын

Very crisp and clear explanation of data pipeline. Thank you very much for explaining in detail. Much helpful.

@ITkFunde 2 жыл бұрын

Thanks Smita

@ashishshukla004 3 жыл бұрын

Hats off Anshul Sir ji... thank you for sharing all the knowledge in so simple way.

@ITkFunde 3 жыл бұрын

Thanks Ashish hope you are doing well

@jasper5016 2 жыл бұрын

Thanks a lot. This tutorial taught so many things within 10 mins.

@eldrigeampong8573 2 жыл бұрын

Excellent explanation. Keep it up

@vansf3433 Жыл бұрын

The benefit of pipelining is the ability to put all 5 stages, 1. Fetch, 2. Decode, 3. Execute, 4 Read memory, 5. Write memory , to work, simultaneously operating on independent commands. The max-benefit come when the pipeline is full You can measure the pipeline performance by calculating the cycles per instruction CPI

@arunkumarr2302 Жыл бұрын

Data ware house is a storage which contains 4 stages namely collect,store, analyse,consume with help of etl . Uses of data warehouse is integrity,time based sir .Etl-> extract transform and load. Data pipeline is a transformation of data from one place to another like as water from ground to people through pipe . Data pipeline is classified with 3 types namely 1)Real time data pipeline 2) Batch data pipeline (for example particular data is required . I need sales history of a store per day )(etl bods is used for batch data pipeline) 3) Log data pipeline (combination of 1+2) sir . Thank you so much 👏 for this session 🤗