Datamart development - business intelligence

Datamart development - business intelligence


Job Description

To develop datamart based on a provided MS SQL database. For details please see attached files.

Additional Requirements:
- 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.
- Documentation.
- Technical Training including debugging and deployment.

Skills: analysis, training, debugging, ssrs, microsoft-sharepoint

Open Attachment