The key topic areas covered in this project are:

 Data architecture  Dimensional data modeling  Data integration and ETL (extract, transform & load)  Data engineering  BI design

Project focuses on examining the traditional BI appraoch with a Data Warehouse (DW) using relational dbms and the Analytical Data Architecture (ADA) approach that leverages relational, columnar, on-line analytical processing (OLAP), Hadoop and NoSQL databases.

Talend, SSIS -- For Data Cleaning

Tableau, Power BI and Qlik --- For Data Visualization