Data warehouse and implementation bus matrix

The Power BI model should preferably align with a corporate data architecture framework of standard facts and dimensions that can be shared across models. Though consumed into Power BI Desktop, existing data definitions and governance should be observed. Any new facts, dimensions, and measures developed with Power BI should supplement this architecture.

1. Create a data warehouse bus matrix:
   
   • A matrix of business processes (facts) and standard dimensions is a primary tool for designing and managing data models and communicating the overall BI architecture.

• In this example, the business processes selected for the model are Internet Sales, Reseller Sales, and General Ledger.

1. Create an implementation bus matrix:
   • An outcome of the model design process should include a more detailed implementation bus matrix.

• Clarity and approval of the grain of the fact tables, the definitions of the primary measures, and all dimensions gives confidence when entering the development phase.