Business intelligence (BI) is a technology-driven process for analyzing data and presenting actionable information which helps executives, managers and other corporate end users make informed business decisions.

Data Warehouse (DW), also known as an enterprise data warehouse, is a system used for reporting and data analysis, and is considered a core component of business intelligence. Data Warehouses are central repositories of integrated data from one or more disparate sources.

The below list holds true for RDBMS Systems.

Here are a few materials:

• Database Language : SQL and PL/SQL. HackerRank is often a good place to start practicing.

• Scripting language : Unix

• The Data Warehouse Toolkit, 3rd Edition by Ralph Kimball & Margy Ross

• ETL Tools : ETL Stands for Extract Transform Load and are used for Data Integration. They are used to extract data from disparate source systems and integrate them in a Data Warehouse, which will in-turn be used by Decision Makers for bringing out Analytical reports. Informatica PowerCenter is one of the common ETL Tools. Others include Talend Open Studio which is an open-source ETL tool developed by Talend.

• Tableau is a Data Visualization tool, which is often used for creating compelling visualizations. An Open source version called Tableau Public is available to get Hands on experience on the tool.