The Difference Between Conceptual, Logical, and Physical Data Models

The three models are the conceptual model is used to establish their entities, their attributes, and the relationships. The logical data model defines a structure of the data elements. And it's more detailed than your conceptual model, but is also technology, agnostic, and business oriented. Finally here, you have the physical data model, which is that describes the database specific implementation of the data model. That is, build it in Power BI, building it in SQL server, whatever that physical object looks like. It made it 100%. These could be tables in your gold layer, in your medallion architecture, in your lake house. They're designed, ready to be consumed by any tool, whatever you