Data Hub to Spoke Model Performance Question
We are building a budgeting and reporting model based on transactions incorporating our chart of accounts. We have built a Data Hub to house the lowest level transactions. Currently we budget using 6 categories with several layers of hierarchy totaling a count of 6,475 items. Summarizing monthly transactions we are looking at loading approximately 374,619 rows of data lines from csv files into the Data Hub annually and accumulating three years. We then will pull that into our spoke model to report on and allow for budgeting and forecasting. We are concerned that our cell count is too high and are struggling with how to lower it. Do you have recommendations to lower this in our spoke model? We have tried to keep our formulas simple and follow best practices. Is it reasonable to have the quantity of categories, hierarchies and data lines in our spoke model in order to complete our budgeting at the lowest level hierarchy?
We’ve included a screenshot of our spoke model including the module showing 398,697,600 cell count.
Thank your assistance with this.