Powerpivot within Excel and Power BI itself allows one to use SQL to pull data from an ERP or from a data warehouse, allows one to build a model with relationships between tables (instead of vlookup or index/match) and allows you to work with much larger tables than native Excel.