The three main types of data warehouses are Enterprise Data Warehouse (EDW), Operational Data Store (ODS), and Data Mart. Each serves specific purposes in organizing and managing data for analytical insights.