Its been amazed the way you use and to explain the data and how it work in professional way. It is so useful to me to clear my interview for the Data Analytics and BI. I hope to will make it further videos on that topic. I will consider it if you make a complete role model for the Data Engineer for further to accelerate it. Thanking You.
This was very well explained and very helpful.I use Excel a lot and tried to pull data in from a lot of different places and this was very insightful. Thank you!
Very helpful video, this is a great way to see how ETL works in a familiar environment. But I noticed the order date is not really used for anything (we don't really need the order table, order details table has everything we need), you did mention it was just to show the functionality.
Thanks for the great video. I learn those things in microsoft power BI and wondering now how powerful the excel is. Keep sharing more videos like this.
@@ITkFunde Arrey sir - I think we can collab at somepoint in future. Please share your LinkedIn .. so that I can reach you .. Or post it in the video.. That will be very helpful.
One small question here - if data stored in the csv files are updated on daily basis then will this ETL will update the product category wise sales numbers ? if not what are the ways to trigger this model live? overall an awesome way of explaining the concepts
Yes. As long as the file name stays the same, e.g. products.csv. There is a tool to select Refresh All when in the Data toolbar. I'm sure there are several options but that is likely the easiest. Perhaps only refresh clselect csv's when setting up initial import dialog box.
Nice video. Very clear presentation. What is the advantage of building the merged tables over linking them in the diagram view and adding a measure for the total? When is that method preferable?
Thanks James for your feedback and a good question ! Loading and joining tables into data model allows us to use this data model in Power Pivot which is a diff functionality but to explain, once you have created a data model you have the flexibilities to run diff slice and dice queries and run various adhoc queries in power pivot. Hope this make sense.
Hey Buddy, thank for sharing and teaching us. Really appreciate. Just wanted to ask.or beginners like me, who don't have background of data query, how to learn it? I mean, I know basics of excel but never used power query and data mixing. Please do reply. Thanks
I had test on Excel where I had many tables in excel one is price table which had the details of price of the product and several columns were there and I had a different table where number of units (quantity) was there but these two tables were not directly connected price table had product id and orders table have product id which is connected to products table ...I wasn't able to connect these two tables because it was many to many relationship ....so if I go with your method like merging tables work for this condition?
thanks for the video, was quite helpful. a small suggestion though, overlaying the video with like and sub notification so many times makes the watching experience extremely irritating. your content is good enough to sell on its own.
Hi Sir, Above video is Excellent, it use full, but can you please provide your worked sheet with the process document, send all documents related above video, its use full all for practice, and my excel sheet does not show power query option, I am using microsoft 365 excel, please guide me, Thank you so much sir
Its been amazed the way you use and to explain the data and how it work in professional way. It is so useful to me to clear my interview for the Data Analytics and BI. I hope to will make it further videos on that topic. I will consider it if you make a complete role model for the Data Engineer for further to accelerate it. Thanking You.
Thanks Ali for your feedback !!!
Ali I am looking job in the same domain... can you help me with this?
I am new to data engineering and your tutorials are very clear and easy to understand for beginners. Thank you so much. Keep up the good work !
Thanks🙏
This is one of the most amazing video on youtube I have seen in the recent past. More power to you bro, keep making such simple yet amazing videos.
As a beginner into data modelling It's a great video 🎉❤... Please create more complex project series like this ... and also with more industrial tools
thanks for suggestion 🙏
Bro this video has taken you to next level .....wonderful videos keep going we keep watching
Thanks Nikhil
This was very well explained and very helpful.I use Excel a lot and tried to pull data in from a lot of different places and this was very insightful. Thank you!
Hi Sara thank you for this valuable feedback. Please checkout other tutorials in data series. ~ Anshul
Very helpful video, this is a great way to see how ETL works in a familiar environment. But I noticed the order date is not really used for anything (we don't really need the order table, order details table has everything we need), you did mention it was just to show the functionality.
One of the finest contents on youtube... Keep it up Brother.
God bless you..
Thanks Rahul bhai for your kind blessings
Pretty much useful video..u made think look so easy..Now am clear with ETL concept..please keep on posting such valuable videos..Kudos.
Thank you! Your tutorial was so clear and easy to follow. I'm definitely passing it a long to my data analyst colleagues.
Thanks Angela in future i will start a series on data Analytics hope you it will help you and your colleages
Thanks for the great video. I learn those things in microsoft power BI and wondering now how powerful the excel is. Keep sharing more videos like this.
Great explain to show the pwoer query....its solve my problem too...thank you very much for your efforts.
You are most welcome
Extraordinary Tutorial.. Well Explained. Great Job. Keep it up. You serve for students and God will bless you to become successful person.
Thanks Ashutosh🙏☺️
Thanks for making this video. It was enlightening to see a practical example of how to go from raw CSV data to insights on Excel.
Bahut sahi bhai !! You are doing a great job. This is a hidden gem for sure.
Thanks Raj🙏☺️
@@ITkFunde Arrey sir - I think we can collab at somepoint in future. Please share your LinkedIn .. so that I can reach you .. Or post it in the video.. That will be very helpful.
Very useful.
Thank you!
Thanks, that helpful.
Glad it was helpful!
Hi Anshul, your videos are very informative and the way you explain it's awesome..
Thank you Satish :)
This was a great tutorial. Thank you so much for making it
Thanks Anirban 🙏☺️
Great Video, Thank you for creating such content. It is easily understandable.
One small question here - if data stored in the csv files are updated on daily basis then will this ETL will update the product category wise sales numbers ? if not what are the ways to trigger this model live?
overall an awesome way of explaining the concepts
good question
Yes. As long as the file name stays the same, e.g. products.csv.
There is a tool to select Refresh All when in the Data toolbar. I'm sure there are several options but that is likely the easiest.
Perhaps only refresh clselect csv's when setting up initial import dialog box.
Nice video. Very clear presentation. What is the advantage of building the merged tables over linking them in the diagram view and adding a measure for the total? When is that method preferable?
Thanks James for your feedback and a good question ! Loading and joining tables into data model allows us to use this data model in Power Pivot which is a diff functionality but to explain, once you have created a data model you have the flexibilities to run diff slice and dice queries and run various adhoc queries in power pivot. Hope this make sense.
Interesting. Thanks for sharing Anshul
Thanks Shirish for your support !!
Great explain keep it up
Excellent way of explaining keep it up
Your lectures are excellent please make videos on data engineering cloud based
Hey Buddy, thank for sharing and teaching us. Really appreciate. Just wanted to ask.or beginners like me, who don't have background of data query, how to learn it? I mean, I know basics of excel but never used power query and data mixing. Please do reply. Thanks
beautifully explained...
Thanks Praveena
Thank you very much Sir ...
Thanks bhai
Very much thank you, Sir!
Thanks Hadi
Very Well explained
Excellent. Thanks
Yes sir a session vedio on SQL joins and subquery will be helpful.
Sure Binoy I will plan something around this. THANKS FOR YOUR FEEDBACK.
Thank you brother..
Very well explained, have some queries, how do i reach out to you to understand better
Thanks Giresh you may send me a mail
I had test on Excel where I had many tables in excel one is price table which had the details of price of the product and several columns were there and I had a different table where number of units (quantity) was there but these two tables were not directly connected price table had product id and orders table have product id which is connected to products table ...I wasn't able to connect these two tables because it was many to many relationship ....so if I go with your method like merging tables work for this condition?
Gr8 video..👌
Thanks Vijeta :)
well explained.....
thanks for the video, was quite helpful. a small suggestion though, overlaying the video with like and sub notification so many times makes the watching experience extremely irritating. your content is good enough to sell on its own.
Can you please prepare a video on market engineering for. Market research people
Excel can do all this? WOW!
Yes indeed ☺️
Hi Anshul sir.. is there any step by step Playlist for ETL .?
Hi Rahul i will work on it
Please provide the roadmap for data-warehousing and data-mining for a data engineer
How to calculate overall percentage revenue for beverage category over all other sales ?
Sir thank you for the great video. Would you be able to make a tutorial on how to create an interactive pivot chart in excel?
super thanks sir
Do you have any premium course for data analytics?? Except this?
Not yet
Hi Sir, Above video is Excellent, it use full, but can you please provide your worked sheet with the process document, send all documents related above video, its use full all for practice, and my excel sheet does not show power query option, I am using microsoft 365 excel, please guide me, Thank you so much sir
Hello bro, excel or google sheets; which one is better.
Can you send/ provide me csv files for practice. Or how to create csv files.
How do I get the files
How to edit if something goes wrong?
i cannot find the dataset can you please share it again
Please share Csv Files.
Hi Nidhi I will check its been a while since I made it
This could have been done much easier using power pivot
I got a better idea of the data pipeline
Annoying music in background