Analysis of two separate OLTP databases into a data warehouse

A business analytics and information management case study (2018) that suggests the transformation of a company utilising two separate OLTP databases (sales and marketing) into a data warehouse. Outlining the Dimensional Model implementation, ETL process, and predictive model, the case study generates business insights that suggests the company implements as a response to its current problem areas affecting its performance.

Business Intelligence using Qlik Sense

A Business Intelligence investigation project using Qlik Sense in order to answer management questions regarding customers, suppliers, and products. The project includes:

• Performance Dashboard,
  • Data Preparation
  • Creation of the Dashboard
• Details Sheet,
• Time Aware Chart, and
• Pivot Table.