Systems and methods of automating the generation of a logical model defining one or more tables of a data source are provided. The logical model definitions of the tables can be exposed to a platform that can access and obtain data from multiple heterogeneous data sources based on a unified and normalized format. Tables of a data source can be analyzed to determine key characteristics, and based on the key characteristics, converted into dimension and fact table representations, objects, and operations that comport with the unified and normalized format. Default rules for generating the dimension and fact table representations, objects, and operations can be followed, or user-defined customizations can be implemented.