A Guide to Extracting Data from Joblogic
Following on from the blog last week,Joblogic Integrations with Power BI – Select Distinct Limited I thought I’d write a similar guide to extracting data from Joblogic. Joblogic is a popular Field Service Management (FSM) software that helps facility management companies run their operations. FSM software is particularly useful for companies that provide services at […]
Choosing the Right Paginated Reporting Tool
Pixel-Perfect Precision: In the data realm, the importance of robust reporting tools cannot be overstated. Businesses rely on accurate, timely, and insightful reports to drive strategic decisions, identify trends, and measure performance. In the modern landscape there is lots of focus on interactive visualisation software. However what are the options the distribution and delivering of […]
How and Why to Modernise Your Data Reporting
This blog aims to discuss the how to modernise your data reporting from legacy reports. By legacy reporting we are referring businesses functioning with multiple disparate Excel reports. What are the benefits of moving? How do you go about moving? Why move from Legacy Reports? 1. Improved Efficiency: Over our years of experience, we have seen many […]
Navigating Power BI Data Alerts
Introduction Whilst reporting is a key component of any business, how do you respond to key changes. How do you ensure actions are generated when the data changes beyond the limits you set. As part of our Business Support Expert Services this can be a really efficient way to set up reports to monitor values […]
BambooHR integration to Power BI
How to integrate your Bamboo HR system to Power BI BambooHR integration to Power BI to get real time visibility of your HR data On a recent project a client had a requirement to connect BambooHR to Power BI. This focussed on BambooHR UK but the system is used worldwide. This blog seeks to share […]
How to Append Data in Power Query: A Step-by-Step Guide
Last week we looked at how to combine datasets in SQL using UNION UNION in SQL – Select Distinct This week, we are looking at using the same source data, but doing the combining in Power Query, via the transform options in Power BI It is not always possible to combine the data in SQL, […]
