The BI site in SharePoint 2010 provides you reports, monitor key performance indicators and allows you to create dashboards that provide a consolidated view of business data.
The business problem that my client requests me is to allow the end-user to provide feedback to the SQL database. There are about 50 fields that are updated from an external source, but around 20 has to be entered manually by the user.
We have found that with the Business Connectivity Services: External Lists – Enables accessing data (read/write) from external systems in the same way that SharePoint list data is accessed.
We have prepared a little demo with a dummy database of 5 fields and it works very well. We can configure the items available for editing and the non-editable.
It’s challenging to learn a tool, find detailed solutions and keep the project on track , but is funny.