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!
Table of Contents | ||||
---|---|---|---|---|
|
How to Use
Power BI Templates?SAP Analytics Cloud Dashboard Templates
Go to the Templates tab.
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 Dashboard Templates Description
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.
Select Create data source in front of the desired dashboard template.
In the Name* field, enter the data source name.
[Optional] In the Description field, enter the data source description.
[Optional] Apply filter by Projects.
Select Next.
Copy the generated URL, and then select Next.
Info |
---|
After selecting Next, the selected dashboard template as a .package file will be downloaded to your computer. |
Open your SAP Analytics Cloud, and then navigate to Transport.
Select Export, and then select My Content.
Select (1) Upload, and then select (2) Select Package.
Upload the .package file you've downloaded before, and then select OK.
Info |
---|
It takes SAP Analytics about a minute to upload the package. Select Refresh to see the uploaded resource. |
Return to Transport, then Import, and then select Content Network Storage.
Select the dashboard template file you’ve just uploaded.
Info |
---|
In our case, it’s Jira Sprint Dashboard. |
Select the import option that suits your needs, and then select Import.
Info |
---|
It’s recommended to review the impacted content, analyze and decide what’s better - overwriting the objects & data or not. In our case, we selected to overwrite objects and data. |
Info |
---|
The import process will be shown in the notification bar. Once the import is done, a pop-up notification will appear. |
Select the notification, and then select the connection.
In the *Connection Name field, enter the name for this connection.
In the *Data Service URL field, enter the copied URL in step 7.
In the *Authentication Type field, select Basic Authentication.
In the *User Name field, enter the username associated with your Jira cloud account.
In the *Password field, enter your token created here.
Select OK.
Navigate to Modeler, find the model you need, and then open it.
Info |
---|
In our case, it's Sprint Dashboard. The model might be in Recent files or try using Search. |
In the Workspace section, select Data Management.
Under Import Jobs, select the corresponding job, and then select Refresh.
Data can’t be refreshed if there are any empty tables. You’ll see the following message in this case: The data query returns an empty result set.
Open the dashboard, go to Stories, and then select Recent Files.
Find your dashboard.
Tip |
---|
Congratulations! Now you can view your dashboard. |
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.