One dashboard for two companies: what changes
Many owners run more than one company: a design-build firm and a specialty business, or two brands in different markets. They want one view of both.
I built that for a group with two operating companies. Four things had to be done differently from a single-company build.
Put the company on every row
Every record in the database carries the company it belongs to, from the first load. Adding it later means rebuilding the tables. With it in place, any dashboard can show one company, the other, or both.
Translate cost codes by company
Two companies rarely use the same cost codes. Sometimes they use the same code for different things. So the translation to a shared set of categories is keyed on the company and the code together, never on the code alone.
Expect different systems
The two companies may not use the same tools, and one may have a data feed the other lacks. Decide early which measures apply to both and which exist for one company only, and say so on the dashboard.
Each company also has its own Buildertrend account, so each has its own exports. Put the company first in every file name and load them separately.
Do not blend what should not be blended
A combined total is useful for things like signed work and open jobs. It can mislead for rates and durations when the two businesses work differently. Show those side by side.
If you would rather have this built for you, I do it for building and remodeling firms. It starts with a small fixed-price review.