Data Intelligence Analyst
- or -
Post a project like this£200(approx. $251)
- Posted:
- Proposals: 8
- Remote
- #1511477
- Expired
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
MICROSOFT POWER BI REPORT.
Spice works is a Free online helpdesk ticketing system which can also be accessed through your mobile phone or laptop. It enables us to assign, accept, reply, add message content and close them out. Plus, it has the ability to add custom fields to suit the business needs. Something which we will look to develop over time.
The first stage is to be able to use Microsoft Power Bi to create the following reports ....
1) Numbers of tickets assigned to …
* Might be worth adding a date between option so that we can view different periods.
2) Number of tickets created by date
* This is flexible, you can do this by Week, by Days, by Month or ALL of these.
3) Graphical data & Counts of the total number of different categories (365 issues, one2one, hardware damage, daily dairy submission problems etc).
4) Count of the number of priorities (low, medium and high)
5) Tickets created by workbase (by work base I mean care home; Cherry Tree Lodge, Orchard House etc) I will need to show you the staff_list table in order to do this (so the list would be sent to the successful candidate.
6) Date comparison between submitted time/date and completed time/date to show how long it took ticket to be resolved. Eventually we would like to create some guidance as to how long we feel the tickets should be completed by.
7) The fun bit, can you think of anything else you feel may be beneficial? Think outside the box. It might not be a report, it might be something we an add to the spiceworks ticketing system which enables us to collect a different set of data, which can be reported on. A summary for each work base would also be impressive.
The data will be sent in Excel format originally until we can find a way to manually update and refresh this. It is worth considering how we can append the data, baring in mind the contents of the original Ticket will change (such as the status: from Open to Completed).
Spice works is a Free online helpdesk ticketing system which can also be accessed through your mobile phone or laptop. It enables us to assign, accept, reply, add message content and close them out. Plus, it has the ability to add custom fields to suit the business needs. Something which we will look to develop over time.
The first stage is to be able to use Microsoft Power Bi to create the following reports ....
1) Numbers of tickets assigned to …
* Might be worth adding a date between option so that we can view different periods.
2) Number of tickets created by date
* This is flexible, you can do this by Week, by Days, by Month or ALL of these.
3) Graphical data & Counts of the total number of different categories (365 issues, one2one, hardware damage, daily dairy submission problems etc).
4) Count of the number of priorities (low, medium and high)
5) Tickets created by workbase (by work base I mean care home; Cherry Tree Lodge, Orchard House etc) I will need to show you the staff_list table in order to do this (so the list would be sent to the successful candidate.
6) Date comparison between submitted time/date and completed time/date to show how long it took ticket to be resolved. Eventually we would like to create some guidance as to how long we feel the tickets should be completed by.
7) The fun bit, can you think of anything else you feel may be beneficial? Think outside the box. It might not be a report, it might be something we an add to the spiceworks ticketing system which enables us to collect a different set of data, which can be reported on. A summary for each work base would also be impressive.
The data will be sent in Excel format originally until we can find a way to manually update and refresh this. It is worth considering how we can append the data, baring in mind the contents of the original Ticket will change (such as the status: from Open to Completed).
MacKay M.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
12 May 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
can i know more about this project. I am expert in data analyst.
370062
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