Data Modelling and OLAP Techniques for Data Analytics

  • By Daniel
  • 12 Jan, 2021
  • 1 min read

Technologies: MS SQL Server Express, SQL, transactional / relational and multidimensional database techniques, MS SQL Server Management Studio, Draw.io, Astah, Excel

Description: This project aims to demonstrate how to build a Data Warehouse of data from an inventory sector of a company that is the most critical at the time of requesting the project. Where the objective is to improve the analysis, management, competition reports and agility in the response for both customers and the company.
Creation of a Data Warehouse using the star scheme for the best performance in the reports. ETL technique for extracting, transforming, and loading data from flat files.