PointBridge Business Intelligence senior consultant Mike Burger spoke at the Chicago Business Intelligence Group on the topic of Leveraging Data Management and Data Quality within SharePoint. He presented a simple method to allow users to manage their own data using only SharePoint and SQL Server Integration Services. The presentation was an open forum discussion with attendees sharing their own experiences for debate and discourse.
There are many Master Data Management tools available in the market, however, these are often expensive or difficult to use. Allowing users to manage their data within SharePoint allows them to use an environment they are comfortable with and leverage other out of the box SharePoint functionality.
The major challenge for any BI data warehousing project is issues with data quality. Oftentimes business users expect the IT departments to just simply clean up the data without providing any other input or information. Unfortunately, IT often needs business rules in order to decide how to clean up the data. Without the proper business rules the data cleansing project can take longer to complete or even fail. A way to avoid this situation is to “empower” the business users and give them a way to manage their own data.
View the Presentation
Learn more about PointBridge's Business Intelligence Consulting practice