ETL ( Extract, Transform, Load )
What Is ETL? Simple Way Extract, Transform, Load. But, It Is Technical Term. How Non Technical Person Understand. For that Post Created.
ETL Used For Data Warehousing Purpose. Now What Is Data Warehousing. Again Technical. Before going that Let We go for Example.
Small Business Owner wondering on my business not growing how to expand for that what to do. Normally Indian go for astrology, prediction etc. instead of actual root cause finding.
By Mistake, you approach me instead of asking your horoscope details I asked where are you doing business on which did you maintain any data like invoice bill created, receipt given, national way doing or international way how data maintaining through physical or soft like pdf, any database using etc. Further details like which product or service giving and where etc.
In that case, I can’t view each thing and understand As Need result or reason quickly. From whatever format data present I have to extract from that like name, location, bill amount, date, many more whichever way present image, pdf, text, physical, database. But, I extracted now what you do with that.
After Extracted but data should be on sync format like date format different on each bill or abbreviation used many more. Have to have same format plus have same meaning. For that data clean or transform require.
Once that done, we can load data into any database or file Excel if no bulk data present and build small or large data warehouse which stored each transaction detail on history way with good format and analysis generate report to you which have meaningful information to grow further way your business before using any strategy.
Other Examples, If anyone doing share market or SIP thing, Now days on your investment like share mutual fund etc. NSDL sending report to you in your mail id in detail way which share or mf did you buy with when plus redemption details etc. That thing important to view for which share giving high profit or less profit many more. Based on that you plan for investment.
This happened due to build Data Warehouse using ETL. Similar can use in your business or any subject to grow or plan.
