I am creating a Dashboard for my division at work. The underlying data will be contained in multiples databases (in general, a different database for each sector of our assignments).
My general approach is to creat a blank database that links to these external databases in order to pull the information in and then design the dashboard in the blank database.
Is this the best way (easiest to design, efficient, etc..) to structure this or is there another way that would be more helpful?
My general approach is to creat a blank database that links to these external databases in order to pull the information in and then design the dashboard in the blank database.
Is this the best way (easiest to design, efficient, etc..) to structure this or is there another way that would be more helpful?
