Sometimes getting the right insights in your data is more complex than any already existing Power BI visual can offer. Maybe you want to display your own branding inside visuals? Or you just like to play around to create the most beautiful and unique visuals. Here, Charticulator enters the field. This open-source project by Microsoft […]
Month: July 2022
Virtualizing your Azure Data Lake with SAP HANA
Organizations are looking for best-of-breed solutions to tackle data challenges. While lots of organizations are using SAP HANA for reporting and analyzing SAP ECC or SAP S/4HANA data, ‘data lakes’ are often used in parallel for other use cases. Data Lakes are ideal for storing large volumes of information in a cost-effective way. In an […]
Loading Mechanisms Part 1
Introduction As there are huge amounts of data available within companies, data is also moved in increasing quantities from one data storage to another for multiple reasons. As copying data can come with a longer load time and higher costs, you want to make this process as efficient as possible. Luckily, there are multiple loading […]
Standardize your data models with Azure Synapse Lake Database Templates
A lot of companies struggle with the same issue: departments are operating in siloes. These siloes have all their own terms, concepts, definitions and data. When management wants to get a clear overview of all the available data and introduce company-wide reporting, they hit a roadblock. The data is not easily combined into a data […]
Monitoring Power BI usage metrics using Azure Data Factory
When you have Power BI integrated into your company, it is very important that the tenant of the Power BI service is managed well. But how do you do this? How do you measure which reports are consumed the most, which datasets are used the most, which employees are the most active on Power BI? […]
Synapse Dedicated SQL Pool vs. Serverless SQL Pool
Microsoft’s Synapse Analytics Suite aims to provide solutions for various data usage, consumption, and exploratory situations while also ensuring that clients can control costs in a straightforward and predictable manner. To address these distinct circumstances, Microsoft has built two separate techniques to controlling and allocating computation. In this blog we will go through both techniques. […]
Power BI Aggregations
Have you ever worked with a large Power BI report that’s just very slow to load? You’ve tried tweaking the model to improve the performance but without any luck. Then maybe aggregations is something to look into. Using aggregations, you can store the values of a (large) table aggregated by, for example, a date, a […]
Power BI Deployment Options [Part 1]
Ever wondered how software engineers are able to work in massive teams on the same project/code and get changes pushed to the end users at frightening speed and consistency? Wonder no more! In this series, I will explain all there is to know about Application Lifecycle Management when using Power BI. At the end of […]
Process Mining: Understanding Simple Process Discovery Techniques using Python
Introduction Hi and welcome to this blog on process mining Process mining is a set of techniques used in the field of process management and improvement which supports the analysis of processes based on event logs. Process Mining is able to fire different algorithms on a certain event log to identify patterns and trends in […]
CI/CD of Synapse Serverless Part 2/2
Introduction In the first part we’ve explored the reasons why using CI/CD is important in projects. Additionally, we’ve defined three core concepts that need to be implemented as best-practices in Synapse Serverless databases. In this part, we’ll explore how we can continue using our beloved technical tooling ‘Visual Studio’ together with Git and Python in […]