To develop datamart based on a provided MS SQL database. For details please see attached files.
- The project must be developed using Microsoft SQL Server Analysis Services 2008.
- Include rights definitions to access data on cube and dimension by role, define permissions to process database, define role to access (drill through) or not the data.
- Be able to display the reports tags in different languages (multi-language).
- Support automatic email of the Sales Report, this report is defined in the worksheet 20121219 BI Reports - EN.pdf Mail Report page. This report can be developed in Microsoft Reporting Service 2008 and integrated to Share Point 2010Documentation.
- The reports must be integrated with Microsoft SharePoint 2010, and the end user must have the capability to build his own reports and dashboard.
To be provided by us:
- Database with all facts and dimensions tables with data, this is a SQL Server 2008 R2 database.
- Changing on table structure must be approved by us, but you can create any Store procedure, view, index, etc. that you need for development.
Deliverables by the selected vendor:
- Documented source code of all projects.
- Technical Training including debugging and deployment.
Skills: analysis, training, debugging, ssrs, microsoft-sharepoint