Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
stylesquare
typelist
printablefalse

...

About Net2

Net2 is a company specializing in cloud-based solutions designed for Startups and Small and Medium Enterprises (SMEs). They leverage their expertise in Microsoft .NET technologies and Azure Cloud to develop custom-made, cutting-edge solutions. Their team of passionate individuals prioritizes delivering impactful features that make a real difference for their clients. This "People First" approach, coupled with their focus on making advanced technology accessible, positions them as a strong partner for startups and SMEs looking to bridge the gap with powerful digital solutions.

...

Overview

Luc Debliquis, Founder and CEO of Net2, also serving as a "CTO on Demand," employs the Data Processor for Jira to streamline and enhance the efficiency of time management and client reporting within his company. This case study explores how the app facilitates the analysis and consolidation of team timesheets, thereby supporting better resource allocation and client service delivery.

Background

Luc's company specializes in providing development services, where team members log their work hours directly into clients' Jira instances. Given the diverse projects ranging from internal development to training, Luc sought a solution to effectively manage and analyze time spent across various activities.

Status
colourYellow
titlechalenge

The primary challenge was aggregating time logs from multiple sources to generate comprehensive time reports. This was crucial for internal analysis to improve productivity and for creating detailed reports for clients, demonstrating the value and distribution of work done by Luc's team.
Luc was particularly surprised by the lack of a native OData integration between Atlassian Jira and Microsoft Power BI. He expressed initial thoughts of developing a custom solution using Jira's REST API if a suitable solution wasn't readily available. Fortunately, his search on the marketplace led him to discover the Data Processor for Jira (smile)

Status
colourGreen
titlesolution

By leveraging the Data Processor for Jira Free version, Luc was able to:

  1. Download Team Timesheets

    Easily extract timesheet data from Jira to review and analyze how the team allocates time across different projects, including internal projects and training sessions.

    image-20240306-094608.png
  2. Consolidate Worklogs

    Connect to clients' Jira instances to aggregate all worklogs into a single Power BI report. This enabled Luc to create a unified view of each team member's time allocation, enhancing the accuracy and coherence of internal and client-facing reports.

    2_worklogs_conslidated.jpg

  3. Generate Comprehensive Reports

    Utilize the consolidated data in Power BI to produce detailed time reports for each individual, as well as for client billing and performance analysis.

    Monthly user breakdown.png

Status
colourPurple
titlebenefits

  • Improved Visibility
    Net2 gained valuable insights into team time allocation, enabling better project management and resource optimization.

  • Streamlined Reporting
    The Data Processor for Jira plugin simplified data consolidation and reporting processes, saving Net2 valuable time and resources.

  • Enhanced Client Satisfaction
    Net2 can now deliver accurate and comprehensive client reports, fostering trust and stronger client relationships.

  • Cost-Effective Solution
    Net2 discovered a free and user-friendly solution that addressed their needs, eliminating the need for custom development using the Jira REST API.

Outcome

Net2 was impressed with the capabilities and user-friendliness of the Data Processor for Jira plugin. It addressed their time management challenges and eliminated the need for custom development, saving them valuable time and resources. This case study demonstrates how the Data Processor for Jira plugin helps companies like Net2 gain valuable insights into team time allocation and streamline their reporting processes.

...