Power Bi Report
- or -
Post a project like this£250(approx. $314)
- Posted:
- Proposals: 21
- Remote
- #2656408
- OPPORTUNITY
- Expired
Azure | PowerBI | SQL | SSIS | SSAS | Tableau | Javascript | Jquery | MVC .Net Core | EF Core | .Net Core API | ASP.Net |
Ranchi
Azure Data Engineer, Power BI , SQL,ETL, SSIS and Web Site Development services
Wimbledon
software engineer|Full-Stack Software Developer| web developer| App developer | AI Engineer | WordPress
Indore
⭐ TOP RATED ⭐ Graphic Designer| WordPress / WIX |2D Animator| Video Editing |Photoshop Expert
Karachi
WordPress Expert/Woocommerce Expert/Data Scientist/Python Expert/Auto-CAD/3D/2D Animation/ White Board Animation
Rawalpindi
276731131269113522566349531234919933435906343316134271713353916330617431934113151005
Description
Experience Level: Expert
Dropped Tickets Power Bi Spec:
The company runs on a ticketing system, which is on Jira.
Tickets are scheduled to a staff member’s calendar using the jira app called Tempo.
Time that is used on a ticket is recorded on by the staff member using a Jira App called Tempo.
Project Managers need to be able to report back to clients on what status of completion work is.
To prevent a Project Manager from reaching out to a developer on every individual ticket, there needs to be an internal management system which highlights tickets which have not been updated correctly by the team member working on the task.
Tables:
All information for the reports has been integrated into tables on Azure (my SQL) and updated daily.
These tables are:
Tempo- Information on work scheduled/ planned
Work Loggs- Information on the time recorded
Allissues- Jira Ticket information
Tables and fields here
Aim
To create a report that shows tickets that have:
Been Allocated and scheduled, but have not had time recorded on them.
Been allocated and scheduled, time recorded, but no ticket status change
Been allocated and scheduled, time recorded, ticket status changed, but no comment.
Example Report here
Features
Ability to be on URL- The Report will be accessible on a Hyerlink on a website.
Scheduled date
This field is will show all records less than Now()-1 (yesterday)
With Issue_key as the linking key, Scheduled date should only show the latest date in out of all the related [issue key] records.
Work Log date
Issue_ Key is the linking key. The table may have multiple entries. This field to list the last date in related to the Issue Key.
Ability to export as CSV from Report
Ability to Sort and filter on the following fields
Assignee
Updated date
Last comment date
Last Work Log Date
The company runs on a ticketing system, which is on Jira.
Tickets are scheduled to a staff member’s calendar using the jira app called Tempo.
Time that is used on a ticket is recorded on by the staff member using a Jira App called Tempo.
Project Managers need to be able to report back to clients on what status of completion work is.
To prevent a Project Manager from reaching out to a developer on every individual ticket, there needs to be an internal management system which highlights tickets which have not been updated correctly by the team member working on the task.
Tables:
All information for the reports has been integrated into tables on Azure (my SQL) and updated daily.
These tables are:
Tempo- Information on work scheduled/ planned
Work Loggs- Information on the time recorded
Allissues- Jira Ticket information
Tables and fields here
Aim
To create a report that shows tickets that have:
Been Allocated and scheduled, but have not had time recorded on them.
Been allocated and scheduled, time recorded, but no ticket status change
Been allocated and scheduled, time recorded, ticket status changed, but no comment.
Example Report here
Features
Ability to be on URL- The Report will be accessible on a Hyerlink on a website.
Scheduled date
This field is will show all records less than Now()-1 (yesterday)
With Issue_key as the linking key, Scheduled date should only show the latest date in out of all the related [issue key] records.
Work Log date
Issue_ Key is the linking key. The table may have multiple entries. This field to list the last date in related to the Issue Key.
Ability to export as CSV from Report
Ability to Sort and filter on the following fields
Assignee
Updated date
Last comment date
Last Work Log Date
Simon L.
100% (11)Projects Completed
7
Freelancers worked with
6
Projects awarded
40%
Last project
5 Dec 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies