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'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!
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..
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).
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).
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?