Consultant BI

Project Description

The service is requested as part of the project Sales BI. The project has the purpose to provide reporting on daily sales information based upon SAP COPA and manual flat file data for the business units A / B / L worldwide.

Concretely, detailed task description without personal reference, which reveals the independency of the service provision

The scope of services includes the following tasks, which are independently performed by the external contractor:

The contractor will work on the subcomponent “Future Sales” which will serve the purpose to extract and transform data from SAP SD Module and load it to reporting in tabular models.

-  Functional and technical consulting of business analysis and facilitate documentation of business requirements

-  Independently implement the needed business functions in the application’s business core layer including the related deployment activities.

-  Implement the required functionality in Sales BI tabular model

-  Establish and align data quality KPIs

-  Perform functional unit testing

-  Conduct guiding of user testing (business acceptance testing)

-  Functional consulting of documentation of business logics and procedures

-  Handover of implementation to internal and external maintenance organizations

Used tool stack: Azure Cloud services, team foundation server (Azure Dev Ops), Microsoft Azure DWH

Microsoft Azure Analysis services tabular model