MATRIX42
  • Products

    Products

    List Caret Icon
    Service Management

    Streamline IT and Enterprise Services with AI-powered Service Management.

    List Caret Icon
    Intelligence

    Secure, intuitive, and helpful AI for a happier, more productive and strategic Service Desk.

    List Caret Icon
    Software Asset Management

    Gather full visibility of all your software and licenses – maximizing value and reducing unnecessary costs.

    List Caret Icon
    IT Asset Management

    Track and manage all your IT assets in one place – saving you time and money.

    List Caret Icon
    Unified Endpoint Management

    Manage all your PCs, servers, OS deployments, distribution, patching and inventory.

    List Caret Icon
    Identity Governance and Administration

    Govern, automate, and protect identities and access rights with an intuitive European IAM solution.

    List Caret Icon
    Remote Assistance

    Experience the breakthrough in remote maintenance with Matrix42 FastViewer.

    List Caret Icon
    Endpoint Data Protection

    Secure your endpoints at every possible point and stop valuable data from leaving your company.

    Why Matrix42?

    List Caret Icon
    AI Your Way

    Bring AI to every role in your organization - on your terms.

    List Caret Icon
    Cloud Your Way

    All the benefits of cloud, with the flexibility, control and data sovereignty you need.

    List Caret Icon
    The European Choice

    Software that is built, hosted and supported in Europe.

    Marketplace

    Marketplace-section-image

    With Matrix42 FastViewer, you open the door to a world where remote support is faster, more secure and more intuitive than ever before.

    Buy Now
  • Solutions

    Solutions

    List Caret Icon
    Cost and Compliance

    Get full visibility of all your software and licenses – maximizing their value and reducing unnecessary costs.

    List Caret Icon
    Process efficiency

    Manage all your PCs, servers, OS deployments, software distribution packages, patching and inventory.

    List Caret Icon
    Operational agility

    Track and manage all your IT assets in one place – saving you time and money.

    List Caret Icon
    End User experience

    Secure your endpoints at every possible point and stop valuable data from leaving your company.

    List Caret Icon
    Intelligent automation

    Experience the breakthrough in remote maintenance with Matrix42 FastViewer!

    Industries

    List Caret Icon
    Industries

    From the public sector to construction, see how our solutions have helped companies in your industry.

    Services

    List Caret Icon
    M42 academy

    Enablement and training to maximize the use, configuration and customization of our products.

    List Caret Icon
    Professional services organization

    Consulting and Delivery Services to support you from initial implementation to ongoing development.

    Get a Free Consultation

    Take the first step toward smarter decisions with our free consultation service.

  • Partners

    Partners program

    Find a partner

    Our partners are industry experts. They have successfully completed the Matrix42 certification program and are dedicated to ensuring the success of your project.

    Become a partner

    Learn more about the benefits of becoming a Matrix42 partner.

  • Resources

    User resources

    List Caret Icon
    Webinars & events

    Find upcoming events and webinars here and visit us in person or online.

    List Caret Icon
    Video

    Explore our library of Matrix42 product videos & best practices.

    List Caret Icon
    Webinar recordings

    Watch our past webinars and gain valuable insights from our experts.

    List Caret Icon
    Downloads

    White papers, e-books, guides and market studies to download.

    Learn more

    List Caret Icon
    Success stories

    How we’ve helped transform businesses around the world.

    List Caret Icon
    Blog

    Stay up to date with the Matrix42 blog and articles.

    List Caret Icon
    Press room

    Press releases, news and media information.

    List Caret Icon
    Product news

    Latest releases and product-related news.

    Digitalize and automate 2025

    Resources Megamenu Section Image

    The #1 event for European Service
    Wednesday, October 1st, 2025 — Live-streamed from Frankfurt, Germany

    Sign Up Now
  • Company

    M42 careers

    Open positions

    Become one of our talents and share our vision. Join the digital transformation.

    Working at Matrix42

    Our DNA consists of technology, global teams and digitalization.

    About Matrix42

    The European Choice

    Learn what makes Matrix42 the European Choice in service management and why software made in Europe matters.

    Management team

    Get to know the Matrix42 Executive Committee & Advisory Board.

    About us

    Find out more about Matrix42 and our story.

    Contact

    Contact Megamenu Image

    We are happy to answer your questions.

    Get in Touch
Get Started

Products

  • Service Management
  • Intelligence
  • Software Asset Management
  • IT Asset Management
  • Unified Endpoint Management
  • Identity Governance and Administration
  • Remote Assistance
  • Endpoint Data Protection

Why Matrix42?

  • AI Your Way
  • Cloud Your Way
  • The European Choice

Marketplace

Marketplace-section-image

With Matrix42 FastViewer, you open the door to a world where remote support is faster, more secure and more intuitive than ever before.

Buy Now

Solutions

  • Cost and Compliance
  • Process efficiency
  • Operational agility
  • End User experience
  • Intelligent automation

Industries

  • Industries

Services

  • M42 academy
  • Professional services organization
Get a Free Consultation Take the first step toward smarter decisions with our free consultation service.

Partners program

  • Find a partner
  • Become a partner

User resources

  • Webinars & events
  • Video
  • Webinar recordings
  • Downloads

Learn more

  • Success stories
  • Blog
  • Press room
  • Product news

Digitalize and automate 2025

Resources Megamenu Section Image

The #1 event for European Service
Wednesday, October 1st, 2025 — Live-streamed from Frankfurt, Germany

Sign Up Now

M42 careers

  • Open positions
  • Working at Matrix42

About Matrix42

  • The European Choice
  • Management team
  • About us

Contact

Contact Megamenu Image

We are happy to answer your questions.

Get in Touch
  • Français
  • Suomi
  • English
  • There are no suggestions because the search field is empty.
Blog
Topic Products Matrix42 News

How to generate service desk analytics in minutes, not days

Picture of Matrix42 Matrix42 January 9, 2024 3 minutes
facebook twitter Share on LinkedIn Share via Email


This post is the first of five on accelerating business insight generation with Matrix42 Service Management and Microsoft Power BI. Your benefit: greater business agility that opens up new opportunities to improve service levels, save costs, and generate new revenues.

Today, Acme Trading Co. has a service management infrastructure that is second to none. Every process required for smooth business operations is fast, automated, and transparent to everyone, from the CEO to the receptionists. As a result, Acme is running more efficiently and effectively than ever before. And employees are registering record satisfaction levels in staff surveys. But it wasn’t always like this. Rewind to summer 2015, and the picture was nowhere near this pretty….

The bad old days of service desk analytics

Tuesday, 9.30am:

The morning after the meeting the night before. CIO Stefan Simpson has had another grilling from the COO about service desk performance – or lack of it. Slow service, unanswered emails, unhappy users. The usual story. And now he needs to produce a report that clarifies the situation. He sends an email to Service Desk Manager Tim Tober. The task: generate a complete report on incident resolution over the last six months. The deadline: end of the day on Friday – at the latest.

Tuesday, 9.45am:

Tim Tober opens the email from his boss and groans. As if he didn’t have enough to do already. “This is going to take hours,” he says to himself. And the problem is, he’s right. Sure, he can pull together the information from his creaking service desk software – between dealing with tickets, emails and calls. But it will take hours – and that’s just the start. Then he needs to check the data is complete, and manually build charts so that Stephan understand the data. Then he needs to get all this into a presentable format. Even if he works late, it will be tough to get this done by the end of the week. Then again, he doesn’t really have a choice.

Wednesday, 8pm:

Tim has finally managed to get what he thinks is a complete set of data into a spreadsheet. Now all he needs to do is use it to create attractive charts that management can interpret quickly. Not exactly one of his greatest strengths. Now, where’s the folder from that PowerPoint training he did last year?

Friday, 5pm:

Tim’s desk is littered with chocolate bars, empty energy drink cans and dirty coffee mugs. He looks exhausted – because he is. He prints off the final page of his report, puts everything in a binder and walks over to Stephan’s office. Finding it empty, he places the report on Stephan’s desk. Then he trudges back to his PC to go through the emails he wasn’t able to answer during the day. But he’s in no hurry. He knows he’ll be spending most of the weekend in the office anyway…

As I said, not a pretty picture. Fortunately, one year on, and things have improved radically for Stefan and Tim. Why? Because they implemented Matrix42 Service Management, a fully integrated solution recognized by ITAM Review as best-in class. They use it together with Microsoft Power BI, which Acme gets for free through its use of the Microsoft stack. So, let’s see how the same scenario plays out today using this combination of state-of-the-art technologies.

Service desk analytics with Matrix42 Service Management and Microsoft Power BI

Tuesday, 9.30am:

With a fresh mug of coffee in front of him, Stefan sends an email to Tim. It’s a request for a service desk analytics on incident resolution since the deployment of Matrix42 Service Management and Microsoft Power BI. Deadline: Lunchtime, at the latest.

Tuesday 9.45am:

After a weekend at the beach, Tim is refreshed and raring to go, when he sees Stephan’s email come in. He smiles as he remembers how he used to dread moments like this. He reads the request, and knows immediately what he has to do. His integrated, centralized Matrix42 Service Management system contains all the incident resolution information he needs. With a few clicks, he exports it into a format that can be easily imported into Microsoft Power BI. Once in the system, Power BI’s dashboard engine automatically creates charts that present all the key figures in a clear, easy to interpret format. Open incidents, closed incidents, time to resolution… it’s all there, and it’s all understandable at a glance. Plus, Tim knows its easy for Stephan to access more detail within the dashboard. All he has to do is select an item or hover over a visualization to drill down into the underlying metrics. Plus, he can access a clear report page on every incident KPI by clicking once on the relevant tile. And the best thing is, this is only scratching the surface. It would be just as quick and easy for Tim to import comprehensive data on, for example, application usage. This would enable Stefan to make direct comparisons between incident analytics and application usage patterns. But first things first. It’s time to send Stefan the link to his report.

Tuesday, 10.30am:

Stefan receives an email from Tim containing a link. It takes him straight to the report he needs within the Microsoft Power BI interface. “Last year that would have taken 4 or 5 days, not 45 minutes,” he says to himself. He compares incident resolution rates for the first half of 2016, to those from the second half of 2015. And then he smiles. A BIG improvement. Time for the COO to find out how things have changed….

Look out for the next post in the series, where we find out how Service Manager Barbara Brown solves a CRM access crisis. Matrix42 Service Management and Microsoft Power BI can transform your service management environment too. With awesome service desk analytics!

Sign up to get tips & articles sent directly to your inbox
Latest News
list-item-img Digital Employee Experience (DEX): Transforming HR in the Digital Age
list-item-img Speaker Spotlight: Charles Betz on Reclaiming ITSM in the Age of AI – Digitalize and Automate 2025
list-item-img Meet the Matrix42 Visionaries of Digitalize and Automate 2025 – Keynote Insights you can’t miss!
list-item-img Digitalize and Automate 2025: Spotlight on our Guest Speaker Prof. Dr. Holger Schmidt – and what to expect from the Matrix42 event
See More
Most read
list-item-img Matrix42 Recognized as a Strong Performer in the 2025 Gartner® "Voice of the Customer” for IT Service Management Platforms published in July 2025.
list-item-img Achieving DORA compliance with integrated ITAM, ITSM and SAM
list-item-img Matrix42 Kickoff 2025: Shaping the European Choice in service management
list-item-img ITSM – The Path to Choosing the Optimal IT Service Management Tool
Read more
Matrix 42
Digitalize & Automate
  • Our Products
    • Service Management Overview
    • Enterprise Service Management
    • IT Service Management
    • IT Asset Management (CMDB)
    • Software Asset Management
    • Unified Endpoint Management
    • Endpoint Data Protection
    • Identity Governance and Administration
    • FastViewer
    • Intelligence
  • Our Solutions
    • End User Experience
    • Process Efficiency
    • Cost and Compliance
    • Operational Agility
    • Intelligent Automation
  • Company
    • Why Matrix42
    • Management Team
    • Success Stories
    • How to buy
    • Industries
    • Events and Webinars
    • Marketplace
    • Support
    • Careers
    • Supplier Code of Conduct
    • Matrix42 Academy
    • Contact
  • Partner
    • Find a Partner
    • Become a Partner
    • Partner Portal
  • Terms and Conditions
  • Imprint
  • Data Privacy Policy
  • Accessibility
Font Loading Test