We need to create a Centralised application for an organization with multiple calculations for different metrics spread across various domains\functions across a combination of hierarchies (Customer, Product, Brand\Market , time\period etc) and at the levels selected . Also there are number of other usecases like Causal analysis etc where we attempt to relate the results of different metrics at different levels and derieve insights Is Neo4J or in general Graph DB a good tool for such usecases. Could someone share any example or usecase where Neo4 J is used for such scenarios
You might need a combination of databases? Your requirement is a bit high-level to determine if a GraphDB alone will sufice ?
For example "time/period" could have a requirement for a timeseries database ...
Or if need "causal analysis" with "temporal consistency" - you might need a causal database ...
That said, you could create a solution with multiple databases, with Neo4J as the "semantic heart" (that is what i am doing).
Thanks Josh. To further deep dive in the requirement, We have stand alone metrics semantic tables with elements required for calculation of metrics and flat hierarchies required for that particular KPI catered by that table. Each KPI has its own semantic table. The common element is the hierarchies aligned to each of the KPI. By time period I mean different KPIs will have different time granularity- For eg some may have weekly calculations , some monthly and some yearly. Some KPIs may also have near real time frequrency. Comparisions will be between KPIs at the same level of granularity