• Stars
    star
    1
  • Language PLpgSQL
  • Created over 5 years ago
  • Updated over 5 years ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

The idea was to manage the inventory efficiently based on the sales history by identifying the products that were in surplus amounts because of poor sales and targeting on their sales; A star schema approach was devised to build the data warehouse using SQL Server Management Studio to create dimension tables and fact table; Tableau and Power BI were used to visualize the data; The Northwind model was implemented in Neo4j, a graph database to compare how it fares against the traditional ER modelling techniques. Further graph information retrieval and analysis were demonstrated using cypher query language for Neo4j.