If you plan to use Excel to analyze information from existing data servers, create and upload data connection (ODC) files ...

If you plan to use Excel to analyze information from existing data servers, create and upload data connection (ODC) files to the Data Connection Library. If you want users to create new KPI Lists then add them to the "Owners" group. Users in the "Members" group can edit pages but can not create KPI Lists.