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? […]
Integrating Joblogic with Power BI
Introduction Our client provides nationwide engineering maintenance services. They use Joblogic, a comprehensive field service management software, to track activity. In this blog we talk about Integrating Joblogic with Power BI. Field Management Software Field service management software improves efficiency, productivity, and customer satisfaction of businesses. It helps them plan, schedule, invoice. Field service businesses, […]
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
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 […]
Improve Payroll Efficiency
Are you tired of your business spending hours on manually calculating overtime for your employees due to complex contracts? Do you wish there was a better way to automate and streamline your payroll process? If you answered yes, you are not alone. Many businesses face challenges of managing complex payroll processes in a fast pace […]
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
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 internal BI team had been using a dashboard in Tableau which catered […]
Connect BambooHR to Power BI: Streamlining HR Analytics
Connect BambooHR 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 blog seeks to share some of the steps and experience. Getting Real Time Analytics Whilst the business was utilising BambooHR, a popular HR software […]
UNION in DAX
Using UNION in DAX is a third option to combine data for analysis in Power BI We recently showed how to do this in SQL UNION in SQL and how to do similar in Power Query APPEND in Power Query It isn’t always possible to do this in SQL such as if the datasets […]
APPEND data in Power Query
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 SQL, particularly […]
