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? Can it be done with the standard Power BI mapping visuals? 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 […]
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 […]
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 are […]
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, […]
Connect Power BI to Google Big Query
A Quick Guide to Connecting Power BI to BigQuery Power BI is a leading business intelligence platform, with powerful features for self service analysis BigQuery is a fully managed cloud based data warehouse platform for you to manage your data The great thing about both of these platforms is that they both have a really […]
Advanced Top N Filter Power BI
The basic Top N filter in Power BI can be very useful. But if you need to show the values of the whole you will need to use an advanced Top N Filter Measure This guide shows you how you can set it up If you use the standard top N filter you would see […]
How to use Custom Formats in Power BI
Custom Formats in Power BI allow you to create your own specific formats so that you are not limited to the pre-defined options that come as defaults Some organisations have specific standards for things such as date formats, these can be catered for using custom formats For example if you want your date formats to […]
