uberdrive.com

Category: custom

  • How to Connect FleetCheck to Power BI: A Complete Step-By-Step Guide

    What is Power BI & Why Connect it to FleetCheck?

    In the world of fleet management, data is power…

    FleetCheck already delivers robust and reliable reporting capabilities as standard. However, for larger or more complex operations looking to take their data even further, integrating Power BI can add significant value. Power BI works alongside FleetCheck – creating interactive dashboards, merging data from various sources, and enabling deeper, customised analytics that complement your fleet management workflow.

    What you’ll gain:

    • Automated reporting
    • Custom dashboards
    • Real-time insights
    • Professional visualisations

    Think of this integration as building a bridge between your fleet management system and your business intelligence. No complex coding needed.

    What You’ll Need Before Starting

    • Active FleetCheck account with admin access
    • Power BI desktop (free download from Microsoft)
    • About 15 minutes of your time

    Step 1: Generate Your FleetCheck API Key

    • Log into FleetCheck and navigate to Settings
    • Click API from the menu
    • Press the green “Create API Key” button
    • Name your API key (something memorable like “PowerBI-Integration”)
    • Copy the generated API key and save it somewhere secure
    • Add your IP address if you have a fixed IP (click the green “Add IP address” button)
    • Press save to finalise your API key

    PRO TIP: Keep your API key confidential. Treat it like a password and never share it publicly.

     

    Understanding the API Documentation

    After creating your key, click “View the API information” to access the Swagger documentation – a roadmap of all available data endpoints, showing you exactly what data you can pull from FleetCheck and how to format your requestions.

     

    [siteorigin_widget class=”SiteOrigin_Widget_Image_Widget”][/siteorigin_widget]

    Step 2: Connect Power BI to FleetCheck

    • Open Power BI desktop
    • Click “Get data”

    • Select “Web” from the data source options

    • Choose “Advanced” for more connection options
    • In the URL field, enter your FleetCheck API endpoint (found in the Swagger documentation)
    • Under HTTP request header parameters, type “APIKey” and paste your API key from Step 1 into the box on the right
    • Click OK to establish the connection

    Step 3: Transform and Optimise Your Data

    You can use Power Query Editor to filter, transform, and clean your data to fit your reporting needs.

    Essential Transformations to Consider:

    • Filter data to focus on specific dates, vehicle types, or departments
    • Clean up formatting to ensure dates, numbers, and text display correctly
    • Rename or remove unnecessary columns to improve performance and clarity
    • Set up automatic updates so your dashboards always show current information

    What Happens Next?

    And that’s it! You’ve successfully set up Power BI and are ready to take your fleet data to the next level.

    Your next steps:

    • Explore your data to understand what information is available
    • Create your first dashboard
    • Share insights with your team to driver better decision making

    Need Help?

    If you encounter any issues during setup, feel free to get in touch with our client support team at support@fleetcheck.co.uk or call 01666 577928.

  • Single sign-on emerging as key trend in fleet software, says FleetCheck

    Single sign-on (SSO) capabilities – allowing users to access all their systems with one login – are emerging as a significant trend within the fleet software sector, reports FleetCheck.

    Increasingly, users want the ability to switch easily from one platform to another on their screen through a series of advanced integrations, explained CEO Peter Golding.

    “We’re being asked more and more often to look at ways fleets can move between applications – such as our fleet management software and tachograph analysis.

    “The best way to do this is through Single Sign-On (SSO). Users log in once and can access all their systems without needing multiple usernames and passwords. Data can be automatically integrated, and transitioning between different applications is just a click away.”

    FleetCheck’s first major project in this area is a single sign-on with tachograph provider VDO. This is believed to be an industry first for fleets in the UK, with one fully joined-up system to manage every aspect of fleet compliance without the need to have separate systems open. Some fleet managers have referred to it as a “day-to-day fleet operational bible.”

    Peter said: “This is more than a simple data import – using SSO, users can access all compliance information in one location, integrating data collected from VDO tachographs and FleetCheck’s software, including walkaround checks and maintenance records.

    “It delivers a unified method for Driver Hours compliance, reduces administrative workload, and enhances management of fleet operations, as well as streamlining the process for meeting Earned Recognition requirements.”

    The response from customers had been positive and FleetCheck was keen to create more relationships of this kind, he added. “This area offers significant potential for fleet software and we look forward to collaborating with other suppliers on further SSO integrations.”