Security
The biggest benefit you’ll get from having a business intelligence tool’s data library is the ability to set permissions. This is the magic behind self-service BI. By giving everyone in your organization access to the data they should be able to see (and nothing more), you’ll free your employees to help themselves. When they browse the data library to answer questions and discover trends, they’ll only be able to see the data sets that they’ve been given permission to view.
For large organizations with the right BI software, security can be a decentralized process. Sure, you’ll need IT staff to do the heavy lifting when it’s time to connect to the main company data sources, but a surprising amount of permissions work can be offloaded to departments, teams, and individual users. All spreadsheets and API connections that a user sets up will only be seen in their library until they decide to share them. Similarly, a regional sales office may have several data sets that are completely managed locally.