Overview
Background
This project will oversee the adoption of the centrally supported Power BI Gateway demonstrated through CAHSS data sources and dashboards. In particular, it will establish links and data feeds to provide an interface to the dashboards;
- School and Programme Quality System (SPQS)
- Inventory System
The current test Power BI Gateway service is running on a tactical server which is inappropriate for wider Power BI services.
The Power BI Gateway is required to securely handle data connectivity and data transfer between on-premise data and cloud services. The gateway is an integral component of Power BI services that supports;
- Scheduled data refresh for on-premis datasets imported to the Power BI Service
- Use of DirectQuery to query data from the Power BI Service
- Use of Analysis Services, Live Connections, to query data from the Power BI Service
When implemented, the gateway will be fully supported in the production environment.
A description of Power BI Gateway
Scope
The scope of the project includes; the build of development and production servers together with the implementation and configuration of Power BI Gateway Services. The scope also includes the creation of production services which will be covered under formal SLA and OLA. It does not include the installation of Power BI licenses.
Power BI licences were purchased under see PICCL**
Objectives & Deliverables
|
Number |
Description |
Priority (MoSCoW) |
|
O1 |
To create compute environments to support Power BI Gateway service. |
|
|
D1.1 |
Build the compute environment necessary for the implementation and support of the Power BI Gateway Service. |
M |
|
O2 |
To install Power BI gateway across compute environments |
|
|
D2.1 |
Install Power BI gateway on the newly commissioned servers residing on the corporate network. |
M |
|
O3 |
To configure Power BI Gateway Services supporting CAHSS dashboards ; SPQS and Inventory System. |
|
|
D3.1 |
Configure Power BI Service data sources for the gateway and dashboards for;
|
M |
|
O4 |
To configure data sources and refresh cycles for CAHSS dashboards in O3 |
|
|
D4.1 |
Set-up dataset to utilise data refresh schedules. |
M |
|
O5 |
Implement required access controls |
|
|
D5.1 |
Implement Identities, credentials and permissions to be used by the data gateway. Individual users to be identified as part of the project. |
M |
|
O6 |
Provide Power BI gateway as a fully supported production service measured by SLA. |
|
|
D6.1 |
Create SLA and OLA for the production service. |
M |
Benefits
The benefits of the approach are to provide a Power BI production service that will be owned by IS and will have the appropriate service and operating level agreements (SLA and OLA) in place implemented in production strength environment.
Creates the basis for a service usable across the University.
Success Criteria
SPQS and Inventory databases are connected to the Power BI service via the Power BI Gateway and are available for the College BI team to create Power BI dashboards for end-users.
SPQS and Inventory dashboards are connected via the Power BI Gateway.
Gateway services are enhanced with formal support in place.
Service issues are resolved by IS as measured against SLA and OLA.
The gateway service is re-usable among other BAPI applications across the university.
Project Milestones
Target Date |
Previous Date | Title | Stage | Complete |
|---|---|---|---|---|
| 19-Sep-2017 | No date available | Project Initation | Initiate | Yes |
| 06-Oct-2017 | No date available | Planning Complete | Plan | Yes |
| 01-Dec-2017 | No date available | Business Analysis Complete | Analyse | Yes |
| 08-Dec-2017 | No date available | System Analysis Design | Design | Yes |
| 15-Dec-2017 | No date available | Build Complete | Build | Yes |
| 11-Jan-2018 | No date available | Integration Testing Complete | Integrate | Yes |
| 22-Jan-2018 | No date available | Acceptance Complete | Accept | Yes |
| 29-Jan-2018 | No date available | Deploy To Live | Deliver | Yes |
| 06-Apr-2018 | No date available | Data Source Configuration | Execute | No |
| 20-Apr-2018 | 13-Feb-2018 | Project Closure | Close | No |