extract transformation load etl operations

ExtractionĮxtraction is the process of receiving data from single or multiple sources.

Let’s dive into the three steps of ETL to elaborate on the process. In our case, we’ll receive data from an Oracle database (most kiosks), from Salesforce (stores), and from spreadsheets (newer kiosks), extract the data, transform when necessary, and load into a single data warehouse database to be accessed by reporting tools and used to generate dashboards and scorecards. ETL is a group of processes designed to turn this complex store of data into an organized, reliable, and replicable process to help your company generate more sales with the data you already have. How will you collate all the data from different locations, formats, and structures into a unique database ready to be accessed for dashboard generation? ETL FundamentalsĮTL stands for Extract, Transform, and Load. The newest kiosks that started operations during the system transition have shared spreadsheets used to compute sales.

Bigger stores are using a new Salesforce system. Some of the retail kiosks are still using a proprietary system in an Oracle database. You already know that it is almost impossible to consolidate the information due to different formats and structures. One of the directors asks you to generate a dashboard with sales information from all the points of sale to present in the next board meeting. Your board of directors is struggling to make decisions based on sales because the information is available but it is in different locations and formats. Imagine this scenario-you are the IT manager of a cell phone case company with retail locations all over the United States. One of the most critical mistakes that prevent companies from providing vital decision-making information to business users is the absence of reliable data from one or more data sources, gathered in a single location, organized and prepared to be used.

Extract transformation load etl operations