Here’s how it works: Import data tables into the Power Pivot data model from Excel or external sources. Establish relationships between tables using ... tool for large-scale business analysis.