Skip to main content

Create a Live KPI Dashboard Using IBM Maximo + Excel or Power BI


📊 How to Create a Live KPI Dashboard Using IBM Maximo + Excel or Power BI

If you manage facilities or assets using IBM Maximo, you already know it holds a goldmine of data—work orders, asset histories, maintenance trends, inventory levels, and more.

But here’s the challenge: Maximo’s built-in reporting can be complex or limited. What if you could create a real-time, visual dashboard showing:

  • Open vs. completed work orders

  • PM compliance rates

  • Response times

  • Asset failure trends

  • Inventory levels

In this post, I’ll walk you through how to create a live KPI dashboard using IBM Maximo and Microsoft Excel or Power BI.

🎯 Why Build a KPI Dashboard?

Because data means nothing without insight.

A KPI dashboard helps your team:

  • Make fast, data-driven decisions

  • Identify performance gaps

  • Justify budgets and staffing

  • Improve SLA compliance

And best of all, it’s not that hard to build!

🛠️ Option 1: Maximo + Excel Dashboard

✅ What You Need:

  • IBM Maximo (with access to the database or REST API)

  • Microsoft Excel

  • MxLoader or Power Query

🔄 Steps:

  1. Extract Data from Maximo

    • Use MxLoader to export key tables like WORKORDER, ASSET, LOCATION, or ITEM.

    • Or use Excel's Power Query to connect directly to Maximo REST APIs (if allowed).

  2. Clean and Organize the Data

    • Create tables for:

      • Open vs. completed WOs

      • Work orders by site or location

      • Scheduled vs. actual completion dates

  3. Build Pivot Tables or Charts

    • Use Excel to create visual charts for:

      • PM completion rate by month

      • Average response time

      • Top 10 failing assets

  4. Automate Refresh

    • If using Power Query/API, set it to auto-refresh every hour or day.

    • Share the file via OneDrive or SharePoint for easy access.

🎁 Bonus: You can embed this Excel dashboard into a PowerPoint report or a shared link for management.

🚀 Option 2: Maximo + Power BI (Live Dashboard)

✅ What You Need:

  • Maximo with REST API access (or database connection)

  • Power BI Desktop (Free)

  • Power BI Pro (for sharing dashboards online)

🧭 Steps:

1. Connect Power BI to Maximo

  • Use Web Connector to connect to Maximo REST API (e.g., /maxrest/rest/oslc/os/WORKORDER)

  • Or connect to your Maximo database via SQL Server/ODBC if permitted

2. Load Key Tables

Focus on:

  • WORKORDER (for task metrics)

  • ASSET (for performance)

  • LOCATIONS (for site-level breakdowns)

  • KPI Table (optional, custom KPIs in Maximo)

3. Transform the Data

In Power BI, use Power Query Editor to:

  • Filter active WOs

  • Calculate averages (e.g., time to close)

  • Merge tables (e.g., asset ↔ work order)

4. Create Visuals

Build charts like:

  • Gauge: PM Compliance (%)

  • Bar chart: WOs by status

  • Line chart: Response time trends

  • Table: Top asset failures with downtime

5. Schedule Auto Refresh

Publish the dashboard to Power BI Service and set it to refresh:

  • Daily (recommended)

  • Hourly (if using direct REST connection)

📍Tip: Embed your Power BI report in an internal portal or export to PDF for execs.

📷 Example KPIs You Can Show

KPI Description
PM Compliance % of preventive maintenance completed on time
Work Order Backlog Total open WOs vs. completed
Mean Time to Repair (MTTR) Avg. time to close a work order
Asset Downtime Total downtime logged for top 10 assets
Inventory Stockouts Count of stock items below minimum level

🔐 Security Tip

Always make sure your data connection respects security protocols:

  • Use API keys or tokens

  • Avoid exposing sensitive data

  • Work with IT to set up secure access to Maximo’s backend

🧠 Final Thoughts

IBM Maximo gives you the data. Power BI or Excel gives you the insight.

Whether you want a quick Excel-based dashboard for your FM team or a full enterprise-level Power BI dashboard, this approach gives you clarity, accountability, and visibility.


Labels:

Comments

Post a Comment

Popular posts from this blog

CAFM in Facility Management

🏢 What Is CAFM and Why IBM Maximo Is a Game Changer for Facilities Management In today’s fast-moving world, managing a building—or an entire organization’s facilities—is no small job. Whether it’s an office tower, hospital, museum, or metro station, there’s a constant need to keep things running smoothly: lights on, air conditioning working, equipment maintained, and assets accounted for. That’s where CAFM comes in. 💡 So, What Exactly Is CAFM? CAFM stands for Computer-Aided Facilities Management . It’s a category of software tools designed to help facility managers plan, manage, and optimize everything that happens within the four walls of a building—and often far beyond. Think of it as your digital command center. With a good CAFM system, you can: Schedule preventive maintenance Track work orders Monitor asset lifecycles Manage space and room usage Control inventory and spare parts Generate reports and insights Basically, it replaces paper checklists,...
Post a Comment
Read more

Top 10 Maximo Features for Facility Teams

Top 10 IBM Maximo Features Every Facilities Team Should Be Using Managing buildings, equipment, and maintenance requests is no easy job—especially if you're still using spreadsheets or outdated tools. That’s why more and more facilities teams are turning to IBM Maximo , one of the most powerful CAFM and EAM platforms available today. But Maximo can be overwhelming at first. It has dozens of features—some well-known, some hidden gems. Here are the Top 10 Maximo features every facilities team should be using to save time, reduce costs, and stay on top of asset and maintenance management. 1. Work Order Management This is the core of Maximo. Easily create, assign, and track work orders for maintenance tasks. You can: Prioritize urgent issues Attach photos or checklists Track progress in real-time No more paper forms or guessing who’s doing what. 2. Preventive Maintenance (PM) Maximo allows you to schedule preventive maintenance based on time, usage, or condition...
Post a Comment
Read more