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