Do you know how to create Dynamic Categories and Legends in Tableau? Follow along to the video or check out the steps below. Dynamically selecting the measures values and legends. If you want to compare different categories values in a chart and want to select them dynamically, this is a simple and efficient way of […]
Continue reading
Do you know how to compare selected and previous months in Tableau? Follow along to the video or check out the steps below. Let’s compare the selected month with the previous month. Create a calculated field named “Order Month” with the following formula: DATE(DATETRUNC(‘month’, [Order Date])) Create a parameter named “Date” with: Data type: Date […]
Continue reading
Do you know how to dynamically delete multiple header rows in Power BI? Follow along to the video or check out the steps below. Have you ever been in a situation that you have an excel file with nested column headers, and you want them to be correctly ingested in your dashboarding tool? And to […]
Continue reading
Implementing data analytics or business intelligence solutions is one of the most common goals for organisations. Every business appreciates there is value in data and that it is important to leverage it to create an edge on their competitors. The benefits of business intelligence solutions have been well understood for many years. Why then, have […]
Continue reading
In 2018 we started building a SaaS application for our client DC20, who wanted to leverage the power of really big data in PropTech. DC2O was founded by Peter McCarthy and Paul Clarke. They believe that understanding the whole-of-life cost, including operational costs, is the key to asset management. Their aim is to automate WoL […]
Continue reading
They say Power BI is easy to use and you can create effective, powerful dashboards in a few hours. But is Power BI really working for you? Is it really that easy? If that was the case, why do so many companies give up on their Business Dashboard strategies? If you are not 100% sure […]
Continue reading
They say Tableau is easy to use and you can create effective, powerful dashboards in a few hours but is Tableau really working for you? If they only truly take a few hours to build, why do so many companies give up on their Business Dashboard strategies? The answer is simple. They either hit a […]
Continue reading
In our How To Guides for Power BI beginners we show you how to tackle some of the more tricky tasks. Getting started in Power BI is very easy and it doesn’t take long to create a reasonably good looking dashboard. It also doesn’t take very long to realise you have only just scratched the […]
Continue reading
Since the pandemic, there has been a meteoric rise in the adoption of business dashboards. It makes sense. Businesses want to understand more about their businesses and be able to ask a whole new range of questions about their corporate data. When building business intelligence solutions, these are the most common technical errors in Business […]
Continue reading
What’s the easiest way to create new value for your clients? You deliver great value for your clients but you are always looking for more. You have been working with your clients, producing high value products of services and you are very good at what you do. But it’s a very competitive landscape. Finding a […]
Continue reading