So here we are for another instalment of the Enterprise DNA challenge.
It’s been an awesome few weeks and we’ve have had some amazing submissions across the board. We are covering some serious ground in terms of scenarios and industries not to mention the sharing of ideas, tips, tricks and approaches.
So here it is all the 8th instalment of the EDNA challenge.
Remember its open to everyone so don’t be afraid to get stuck in.
Click here to learn more about the challenge and how it works.
If you’re not sure of anything just reach out to me.
Remember: The weekly winner will receive a complimentary membership to the platform that they can share with anyone and the opportunity for your work to be showcased across our channels. There is also a newcomer category with some great prizes on offer so be sure to get involved.
THE BRIEF
So this week’s challenge is around a system that I’m sure many of us use and have heard of, Jira.
Jira is a major player and a core tool used by many organisations whether it’s to support agile development or manage service desk tickets.
This challenge is covering of two major components that you are likely to need in your armoury as an all-round analyst;
It’s a common ask to design and implement a report that can help manage tickets being received, managing workloads and planning interventions.
Data has been extracted into a flat file and is ready for you to build out in Power BI.
The ask is to produce a report that gives us the below insight into our business.
Patterns related to; ticket status, ticket composition, ticket technician
Types of issues
Timings around different issues (time to resolve etc)
Identify areas/issues we could further train users
Identify patterns for reoccurring issues so we can identify areas which may need management intervention
After some great data profiling from our contestants a few questions were posed to the business to help us produce a report that is beneficial.
1)How to handle records where the create date is after the due date?
The business were surprised at this, and the only business reason behind this is staff creating tickets after the event (Wink, wink, nudge, nudge this is great information. There are likely issues with the business process or data capture. We should highlight these records to the business in the report.)
It could also highlight implementation issues so present these records as such.
2)How to handle records without due date?
In general there should be no tickets without due dates and any that are should be marked as incomplete as there should be no tickets without a time frame.
I hope these questions help you structure your thought process and also in terms of handling the data.
SUBMISSION DUE DATE – Sunday, 25th October 2020 (PST)
Please can you all submit your PBIX files to powerbichallenge@enterprisedna.co
The data set can be downloaded here.
Best of luck!
Any issues or questions please reach out.
Haroon
Enterprise DNA
“I truly appreciate your efforts in helping the ones who needed to get more professional help in using Power BI. Your videos are A+ and really helpful+inspiring for me. I wish you the best from Turkey.”
“I have taken couple of courses from Sam from Enterprise DNA. I really liked the course. Its well explained, organized and importantly all the datas and formulas & even dashboards are available for everyone.”
“Enterprise DNA has greatly increase my ability to report within our company forever. I went from knowing nothing about Power BI to using it on a daily basis in 30 days simply by watching Sam’s videos & executing his technique.”
“Sam has a very hands-on approach to his training, and is always willing to help! Been apart of several different DAX classes, & Sam’s training is by far the best I have come across.”
“I am really thankful to Sam for helping me through the Power BI. I was a newbie and his hands-on approach and business-oriented approach is all we need. Great work Sam. Keep going!”
“Thanks to Enterprise DNA training! I have improved my Power BI tool skills and have a deeper understanding of data analytics. Sam does an excellent job teaching and problem-solving.”