Hi Nali,
You could use Report Center site template as the BI front on SharePoint 2007.
Here is a short description for the site template:
Select this site template when you want to create a site for the creation, management, and delivery of Web pages, dashboards, and key performance indicators (KPIs) that communicate metrics, goals, and business intelligence information. The Report Center site provides a central location for business-intelligence-related information. This template includes special document libraries for storing reports, lists, and connections to external data sources. It also provides access to page templates and Web Parts to help you create pages and lists that contain business information. Within the Report Center, users can search for items by using categories, view a calendar of upcoming reports, and subscribe to reports that are relevant.
Example use A Report Center can help you create a live, interactive business intelligence (BI) portal that assembles and displays business information from disparate sources, using integrated BI capabilities such as dashboards, Web Parts, KPIs, and business data connectivity technologies. This site provides users with a single place to find the latest reports, spreadsheets, or KPIs.
See Default site templates (http://office.microsoft.com/en-us/sharepointserver/HA101744911033.aspx) for more information.
Here are some article help you to manage the site for your reference:
· Working with a Report Center site (http://office.microsoft.com/en-us/sharepointserver/HA102437521033.aspx)
· Roadmap to business intelligence features of SharePoint Server 2007 (http://office.microsoft.com/en-us/sharepointserver/HA102472901033.aspx)
· PerformancePoint Server 2007 TechCenter (http://technet.microsoft.com/en-us/office/performancepoint/default.aspx)
Hope the information can be helpful.
Lambert Qin
TechNet Subscriber Support in forum
If you have any feedback on our support, please contact mtngfb@microsoft.com
Sincerely,
Lambert Qin
Posting is provided "AS IS" with no warranties, and confers no rights.