ACP-620 Day 5: Reporting Lab

Owned by Frank Lapa
Last updated: Nov 07, 2023
3 min read

 

Lab Exercise 1: Automated Daily Stand-Up Reminder
(Beginner Level - 6 months of experience)

Objective: Develop JQL queries to filter issues based on specific criteria for reporting purposes.

Steps:

  1. Learn Basic JQL Syntax:

    • Navigate to “Issues” and open the “Advanced search” for issue filtering using JQL.

  2. Create a JQL Query:

    • Construct a JQL query to filter all “Bug” issues created in the last 7 days: issuetype = Bug AND created >= -7d.

  3. Save and Share the Query:

    • Save the JQL search as a filter and share it with your team for quick access.

  4. Verify the Query Results:

    • Confirm that the query results match the criteria specified.

  5. Deliverable: A screenshot of the JQL query and the list of issues it returns.

 

Lab Exercise 2: Sprint Retrospective Automation
(Intermediate Level - 9 months of experience)

Objective: Set up a Jira dashboard to help a Scrum team track their sprint progress.

Steps:

  1. Create a New Dashboard:

    • Go to “Dashboards” and click “Create a new dashboard”.

  2. Add Gadgets for Scrum Reporting:

    • Configure gadgets such as the “Sprint Health Gadget”, “Burndown Chart”, and “Velocity Chart” to the dashboard.

  3. Customize Gadget Filters:

    • Use JQL to configure the gadgets to display data for the current sprint only.

  4. Share the Dashboard:

    • Share the dashboard with the Scrum team and stakeholders.

  5. Deliverable: A screenshot of the dashboard and a brief explanation of how each gadget aids the team.

 

Lab Exercise 3: Issue Assignment Balancer
(Advanced Intermediate Level - 1 year of experience)

Objective: Generate a report to analyze issue types and their statuses for the last quarter.

Steps:

  1. Define the Report Criteria:

    • Use JQL to create a filter for issues created or resolved in the last quarter.

  2. Select the Report Type:

    • Navigate to the “Reports” section and select “Issue Analysis”.

  3. Configure the Report Parameters:

    • Use the previously created filter as the source for the report.

  4. Interpret the Data:

    • Analyze the report data to identify patterns in issue types and statuses.

  5. Deliverable: A screenshot of the report and a summary of your findings

 

Lab Exercise 4: Version Release Notes Compilation
(Experienced Level - 1.5 years of experience)

Business Requirement: As a client overseeing multiple Scrum teams, I require a dashboard that provides an overview of all active sprints, indicating their health, progress, and any potential blockers to ensure timely delivery.

Steps:

  1. Plan the Dashboard Structure:

    • Determine which gadgets will represent the necessary data points to meet the client's requirements.

  2. Implement Multi-Project Gadgets:

    • Add and configure gadgets like “Sprint Health Gadget” and “Version Report” with JQL queries that target active sprints from multiple teams.

  3. Ensure Real-Time Data:

    • Configure the gadgets to update dynamically, providing real-time insight into sprint progress.

  4. Review and Optimize:

    • Consult with the client to ensure the dashboard meets the intended purpose and make adjustments as needed.

  5. Deliverable: Screenshots of the dashboard and explanations of how each gadget and JQL query provides the required overview for the client.

 

Lab Exercise 5: Implementing SAFe (Scaled Agile Framework) with JIRA
(Advanced Level - 2+ years of experience)

Context: SAFe (Scaled Agile Framework) is an agile software development framework designed to provide a structured approach for large enterprise organizations that need to scale agile beyond single teams. It facilitates team alignment, collaboration, and delivery across multiple agile teams.

Business Requirements:

  1. Set Up Scrum Projects:

    • Create 3 Jira Scrum projects to represent individual teams within the Agile Release Train (ART). These should be named to reflect the squads within them. For instance, “Alpha Squad - Project A”, “Beta Squad - Project B”, and “Gamma Squad - Project C”.

  2. Organize a PMO Planning Project:

    • Establish a separate Jira project named “ART Planning - PMO” to manage Program Increment (PI) planning and track progress at the PMO (Project Management Office) level.

  3. Develop SAFe Dashboards:

    • Construct dashboards that give a visual representation of key SAFe metrics such as PI Objectives, feature progress, and sprint burn-downs.

  4. Create a Cross-Epic Kanban Board/Roadmap:

    • For PI planning across squads, configure a Kanban board or a Roadmap in Jira to visualize Epics and their status across the different Scrum teams.

Steps:

  1. Create and Name Scrum Projects:

    • In Jira, create three new Scrum projects. Ensure the naming convention is clear and reflects the teams’ identities within the ART.

  2. Set Up a PMO Planning Project:

    • Create a Jira project dedicated to the ART's PI planning activities. This project will be pivotal for the PMO level to oversee the train planning and coordination.

  3. Configure SAFe Dashboards:

    • Use Jira’s dashboard functionality to create and configure dashboards. These should include gadgets such as “Sprint Health”, “Burndown Chart”, “Epic Report” where we can see all data coming from all Scrum Projects

  4. Implement a Cross-Epic Kanban Board/Roadmap:

    • Configure a Kanban board that aggregates Epics from all three Scrum projects. This board will be essential for visualizing work items during PI planning sessions and tracking them throughout the PI.

  5. Deliverable: Screenshots of the Scrum projects setup, the PMO project, the SAFe dashboards, and the Kanban board/Roadmap. Additionally, provide a brief explanation of how each component contributes to implementing SAFe in Jira, ensuring alignment with the business requirements.