ETL is an abbreviation for Extraction Transformation Loading. Purpose of ETL is to get data out of the source systems and load it into the data warehouse. Simply a process of copying data from one place to other. Typically, data is extracted from an OLTP database, transformed to match the data warehouse schema and loaded into the data warehouse database.
A simple answer to the question in the title is "Business analytics is a buzzword". So much so that, many find it fashionable to use it as per their convinience. After all, every one has some opinion about the meaning of a buzzword. But for all the techies, let us explore the meaning of business analytic in a true sense.
Lets explore the definition of business intelligence(BI). It is an umbrella term that combines architectures, applications, and databases. It enables the real-time, interactive access, analysis, and manipulation of information, which provides the business community with easy access to business data. By analyzing the past and present business situations and performances, BI provides valuable insight to any organization.
Data mart is often interchangingly used to mean a data warehouse. If you are not proficient, you may be one of those who said data mart while it is supposed to be a data warehouse. This article will explain the concept of data mart and how it is different from a data warehouse.
Business intelligence and data warehousing technologies are heavy on jargons. There are specific terms to define specific method and processes. For a beginner, it may be confusing to go through a technical paper to grasp clear understanding.