01 jul 2021 Import text by example in Power BI reports

Weirdly formatted files, we’ve all had to import them into our reports at some point. Luckily, Power BI has new option that might make our lives easier: import text/CSV by example. We’ll show you how to use it in this blog.

15 jun 2021 The Databricks lifecycle and how it impacts your maintenance

There's plenty of updates to Databricks. And that sometimes leaves users frazzled. his begs the questions, why are there updates so often? And what is the impact on maintenance of your dearest Databricks-projects?

05 mei 2021 Avoid headaches when working with separate PBIX files in Power BI

Splitting datasets and reports into separate PBIX files is a very common way of managing Power BI reports. But dividing sets and reports can result in a headache or two. Let our blog be your Power BI painkiller.

25 feb 2021 Niets beter dan Power BI: de Coca-Cola van de BI volgens Gartner

Al zolang Kohera bestaat, staat Microsoft als leider in de rechterbovenhoek van Gartner’s Magic Quadrant voor Analytics en BI Platformen. Net daarom hebben we bij Kohera een bewuste keuze gemaakt voor Microsoft Power BI. Het is zowaar de cola van de BI-tools.

15 feb 2021 De Tijdloze 2020: follow-up

Op 31 december zaten we met enkele Koherianen opnieuw gekluisterd aan onze radio. Zouden we erin geslaagd zijn het voorspellingsmodel zodanig aan te passen dat we De Tijdloze Top 100 van Studio Brussel juist hadden?

08 feb 2021 Defining your Azure infrastructure as code with Bicep

Azure Resource Manager templates are great. Managing the resulting JSON files not so much. So Microsoft launched Azure Bicep. Read how it will help with maintaining your infrastructure as code.

13 jan 2021 Small Multiples: a new smart feature in Power BI

Recently, a long-awaited feature was added to Power BI: Small Multiples. Time to explore our new options of visualizing data!

27 dec 2020 De Tijdloze van StuBru: Kohera’s voorspelling voor 2020

Deze eindejaarsperiode is er een waarbij heel wat tradities gesneuveld zijn. Gezellig samenzijn met de hele familie of lekker gaan eten op restaurant zitten er niet in dit jaar. Gelukkig zijn er ook nog zekerheden, zoals De Tijdloze van StuBru, die ook dit jaar voor muzikaal vertier zorgt in de laatste dagen van het jaar. En daarbij hoort natuurlijk ook onze voorspelling.

14 dec 2020 Running Python scripts on Azure with Azure Container Instances

Always wanted to run Python on Azure? We'll show you how with Azure Container Instances.

23 nov 2020 We’ve taken Azure Synapse for a spin

Microsoft has recently taken us on a word lingo with the launch of Azure Synapse Analytics. At Kohera, we've experienced some confusion in the market between Azure Synapse as a standalone product and Azure Synapse Analytics as a SaaS platform. We guess it's time to set things straight once and for all, or at least for a while.

10 aug 2020 How to send emails with an SMTP server in Azure Databricks

A client asked if we could provide a simple form of monitoring on a part of a provided solution. For this particular source, our client asked us to send a simple email with record counts to a mailing list. No problem! Let's get to work

03 aug 2020 Caching in Databricks?
Yes, you can!

Sometimes, Databricks can be a bit sluggish. Caching with, for instance, the Delta Cache Accelerated Worker can help you speed it up. We'll explain how it does that.

24 apr 2020 Een inleiding tot Partitioning, deel 1

Naar aanleiding van een migratieproject bij een van onze klanten, kreeg ik inspiratie om enkele zaken rond Partitioning uit te klaren. Partitioning is geen performance feature, maar is voornamelijk een methode om het management van grote tabellen te vergemakkelijken.

08 apr 2020 Budget allocation: combining different levels of granularity in Power BI

Allocating budgets on a different level is not easy to manage in DAX. It was (and still is) a DAX struggle for me. This blog post will guide you through the different steps I took to easily manage the different granularities (and write easy DAX afterwards) by allocating budget on day level using Power Query.

17 mrt 2020 Kohera’s Modern Data Platform: Choosing the model – Pt.1

Kohera’s Modern Data platform does not come with a canned data model by default. This makes the framework extremely flexible to adapt to a variety of project workflows, but it also means during the Analysis phase we will need to think about how to structure the data before continuing. A blogpost.

19 feb 2020 The hidden gems of the function Web.Contents()

Some of our customers want us to import their data from a standard on-premises or cloud-based (Azure) SQL-database, others want us to import their data from a REST API. If ever, you’ll have to import data from a REST API, you’ll surely encounter some obstacles.

30 jan 2020 Should I use serverless for all my Azure SQL Databases?

Azure SQL Database serverless is a new compute tier made for single databases. This new model automatically scales the compute based on the actual workload per second. This means that you only have to pay for the compute resources (memory & vCores) you use. But there's more...

15 jan 2020 How to create a Time Table in Power BI in a few simple steps

In a previous blogpost, we already explained how to make a date table in Power BI with DAX. Besides the dates you can add extra properties for each date: year, month-names, weekday-names,... But what about hours and minutes? In this blog and video, we'll show you how to create time tables in Power BI.