While the User Interface(UI) upgrade alone is superior enough compared to Salesforce Classic reporting, Lightning gives users access to Einstein (Wave) Analytics reporting.
The platform has its own database pulled from Salesforce and is automatically updated every hour.