Content Comparison

SAP Analytics Cloud dashboard templates supported with pre-configured data sources are now available in this latest version.  We are happy to offer you the new and exciting

SAC Jira reporting experience!

Build your first

SAC dashboard in a day with Jira

SAP Analytics Cloud dashboard templates in

SAP Analytics Cloud for Jira from Alpha Serve!

How to Use

SAP Analytics Cloud Dashboard Templates

1. Go to the Templates tab.

Image Removed

Jira ITSM Issues Created Report

Issues Created Report is one of the most widely used reports in Jira. It shows the full issues overview per certain project and period of time, the share of issues per type and/or priority. It is used by support teams to monitor workload as well as development quality based on users' requests.

2. Select the template you would like to use and click either on its name or the Create Data Source button.

3. Set up the auto-generated data source. You can edit the data source name, add a description and apply a project filter. Click Next.

4. Copy the generated data source link and click the Next button to download the .pbit file.

5. Open Power BI Desktop. Go to File > Import > Power BI template and select the .pbit file you’ve downloaded in the previous step.

6. Insert a copied data source URL into the corresponding field.

7. Select Basic Authentication and input your credentials. This step is described in more detail in our User Guide: https://aserve.atlassian.net/wiki/spaces/PBCFJC/pages/1088454657/User+Guide#Export-data-into-Microsoft-Power-BI-Desktop.

Jira Project Dashboard

Jira Project Dashboard is a project overview report that allows one to get an instant overview of all or certain projects in the Jira instance. It shows the main KPIs for the selected projects. 

This dashboard will be useful for project managers and team leaders. It allows users to monitor the issues based on their type or priority, track the project progress and control the work resources allocation.

Jira Project Dashboard template can also be used to build Jira dashboard for multiple projects that is challenging in the default Jira reporting. With Power BI Connector for Jira it is possible to build any multiple projects dashboard that you need in Power BI.

Jira Service Management Dashboard

Jira Service Management Dashboard shows the major service level indicators for the definite Jira ITSM projects. It will be useful as a daily monitoring tool for team leaders of the support or customer accounting teams, as it visualizes the total number of open and closed tickets, their share division, and their division by types or priority. 

The SLA indicators are also included in this dashboard, such as Average Time to Resolution (Estimated and Actual), including by Assignee, or types of issues created by type.

Jira Sprint Dashboard

Jira Sprint Dashboard shows the main metrics used to monitor the sprint progress (for the current sprint) or sprint results (for the completed sprints). 

It is useful for team leads and project managers to monitor sprint progress or analyze the finished sprint in retrospective.

Jira Sprint Time Report

Jira Sprint Time Report is actually time tracking report Jira sprint. It shows timing progress on the sprint and the comparison of the original estimates and actual performance in a certain sprint. It allows users to see the time efforts on each issue and the time load per assignee. 

Jira Work Log Report / Jira Time Work Report

Jira Time Work Report shows timing and workload per a particular assignee. It is a Jira work log report that can be applied to a certain project and/or the selected period of time. It is flexible in selecting the weekend days, as they differ in some countries. This may be used as a configurable alternative for timesheets in Power BI.

Jira Cumulative Flow Diagram

The Cumulative flow diagram shows the various statuses of Jira project's issues over time. It's a visual indication of how many issues are passing through each status, thus, through the column of your project board. This helps users see which columns accumulate more issues than others, and identify bottlenecks in your team's workflow - and take actions accordingly and on time.

Project Helicopter View / Jira Project Overview Report

Project Helicopter View is a big-picture view report on a certain project. It is built based on Jira + Projectrak app data. It allows users to see the overall projects that are currently open in the company, which types they are and how many projects and managed by one team lead.

1. Select Create data source in front of the desired dashboard template.

3. In the Name* field, enter the data source name.

4. [Optional] In the Description field, enter the data source description.

5. [Optional] Apply filter by Projects.

6. Select Next.

Image Added

7. Copy the generated URL, and then select Next.

Image Added

8. Open your SAP Analytics Cloud, and then navigate to Transport.

9. Select Export, and then select My Content.

Image Added

10. Select (1) Upload, and then select (2) Select Package.

11. Upload the .package file you've downloaded before, and then select OK.

Image Added

12. Return to Transport, then Import, and then select Content Network Storage.

13. Select the dashboard template file you’ve just uploaded.

14. Select the import option that suits your needs, and then select Import.

15. Select the notification, and then select the connection.

16. In the *Connection Name field, enter the name for this connection.

17. In the *Data Service URL field, enter the copied URL in step 7.

18. In the *Authentication Type field, select Basic Authentication.

19. In the *User Name field, enter the username associated with your Jira cloud account.

20. In the *Password field, enter your token created here.

21. Select OK.

22. Navigate to Modeler, find the model you need, and then open it.

Image Added

23. In the Workspace section, select Data Management.

Image Added

24. Under Import Jobs, select the corresponding job, and then select Refresh.

25. Open the dashboard, go to Stories, and then select Recent Files.

26. Find your dashboard.

Image Added

SAP Analytics Cloud Templates Overview

Jira Timework Report

The Jira Timework Report Dashboard Template provides a succinct snapshot of workloads according to users and selected Jira projects. It presents a detailed view of time spent on each project day by day, enhancing project management capabilities. A significant aspect of this template is its ability to clearly communicate complex data through intuitive and visually engaging SAP Analytics Cloud charts and graphs. It brings clarity to tracking, revealing both high-level overviews and granular details of time utilization across Jira projects.

Jira Sprint Dashboard

The Jira Sprint Dashboard Template for SAP Analytics Cloud offers a comprehensive overview of sprint activities. It allows the selection of sprints for focused analysis and provides a mechanism to filter sprints based on their start and end dates. One of its key features is a detailed tracking tool that exhibits the number of tasks completed alongside original and remaining estimates. This information can be viewed at task and user levels, facilitating workload management and productivity monitoring. Furthermore, the dashboard classifies and enumerates the issues encountered during the sprint, offering insights into recurring problems and their impact on the project timeline. Time spent on each issue is broken down, providing a window into the team's problem-solving efficiency and helping managers make choices based on reliable data, leading to improved workflow management.