The Microsoft Fabric Offering
Introduction Microsoft Fabric, the unified environment launched in 2023 is now central to Microsoft’s data strategy. What is the Microsoft Fabric Offering? What is Microsoft’s competition to this software? What other unified environments are available. This blog aims to demystify some of these areas. What is the Microsoft Fabric Offering? Microsoft Fabric brings together multiple […]
Top Power BI Tips for 2023
Here are our top Power BI tips for 2023 Highlighting our top 5 Power BI tips for 2023 based on popularity Our most popular Power BI tip this year Show values in Rows in Power BI How to show values in rows in the matrix visual in Power BI. a step-by-step guide to change […]
Calculated Columns and Measures in Power BI
Introduction to Calculated Columns and Measures in Power BI A guide to understanding the differences between calculated columns and measures in DAX for Power BI What is a calculated column? A calculated column is a static value added to a table, calculated row by row when you load the data. What is a measure? A […]
Joblogic Integrations with Power BI
Introduction This post outlines our recent approach to Joblogic integrations with Power BI for a client. Our client offers engineering maintenance services across the UK. They utilize Joblogic field service management software, an all-encompassing field service management software, for activity monitoring. Field Management Software Field service management software improves efficiency, productivity, and customer satisfaction of […]
Unlock the Power of Geo Data
Geo data, or geospatial data, is data that describes the location and attributes of objects or phenomena on Earth. This data can be used to create maps, analyse spatial patterns and trends, and model the real world. Geo data dashboards can also help organisations gain deeper insights into their customers, markets, operations, and performance. In […]
When to transform data for Power BI
As a general principle we should always look to transform data close to its source to gain efficiencies and minimise potential for discrepancies Over the last few weeks we have shown how data can be combined from multiple sources in three different ways UNION in SQL APPEND data in Power Query UNION in DAX A […]
Steamlining Success with Payroll Automation
Are you looking for a payroll automation solution? Are you tired of your business spending hours manually calculating your payroll? Do errors occur every month as you process your overtime? Do you wish there was a better way to streamline your payroll process? Many businesses face challenges of managing complex payroll processes in a fast […]
Power BI KPIs
Power BI KPIs – an overview Power BI KPIs can be a very powerful way to draw attention to specific key performance indicators What is a KPI? a KPI (Key Performance Indicator) is a way to measure performance against a target. These targets can be financial, strategic, operational or simply functional. The important point is […]
Direction of travel on a map in Power BI
Can we show the Direction of travel on a map in Power BI? A global commodity trading client of ours had a requirement to create a dashboard that presented the latest locations and headings for a range of container ships This was part of a migration away from using Tableau, to using Power BI The […]
BambooHR integration 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 some of the steps and experience. These methods will no […]
