i have one application which contain all data of company and shows everything at aggregate level to executive, this contain 100 kpis from different modules and functions, for that i append transaction tables in single table to create a single fact table. but now this single fact table contain 1 crore records, what should i do? should i create different dashboard as per module at link them to a single landing page?
