Blogs

Note: This blog was written when Fabric was still in Public Preview. Some features may have changed at the moment of reading. Features are...

Starting on May 23, 2023, a new kid on the block emerged in the Microsoft stack called Fabric. Is this simply a rebranding of...

From its launch in 2019 until today, Azure Synapse emerged as a powerful analytics service, accelerating time to insight tremendously across data warehouses and...

The goal of this exercise is to upload some data we read from csv files, structure them as Json and upload the data to...

Welcome to the Intellus support blog! We offer expert support beyond analytical projects, helping customers with day-to-day tasks, ad-hoc requests, technical questions and small...

Data is abundant, but making it understandable and conveying its significance to stakeholders can be challenging. That's where storytelling comes in. In this post,...

Do you know that feeling when you finally have your data warehouse up and running using dozens of stored procedures written in SQL? You...

Power BI is a powerful data visualization and business intelligence tool that allows users to easily create interactive dashboards and reports. Whether you are...

Power BI is a powerful tool for data visualization and analysis, and its adoption is on the rise in businesses of all sizes. In...

Are you feeling out of the loop when it comes to analytics developments and important updates? Our newsletter is here to help. By subscribing,...

Synapse or Databricks, which one to choose? This question is asked a lot when implementing a future-proof data platform. Both platforms are cloud-based, future-proof...

Did you ever watch the Netflix series The Queen’s Gambit, in which the story follows the life of Beth Harmon, a fictional chess prodigy...

During your ETL, large amounts of data are loaded from a source into a target storage. As this is something that is often done...

Sometimes getting the right insights in your data is more complex than any already existing Power BI visual can offer. Maybe you want to...

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...

Introduction As there are huge amounts of data available within companies, data is also moved in increasing quantities from one data storage to another...

A lot of companies struggle with the same issue: departments are operating in siloes. These siloes have all their own terms, concepts, definitions and...

When you have Power BI integrated into your company, it is very important that the tenant of the Power BI service is managed well....

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...

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...

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...

Introduction Hi and welcome to this blog on process mining Process mining is a set of techniques used in the field of process management...

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...

Introduction As can be noticed in several other blogposts, Azure Synapse provides a wide variety of functionalities to support organizations in creating a Data...

Introduction Every year, a new buzzword emerges in Data and Analytics; get to know the ‘Data Lakehouse’. Will this be the future of all...

Imagine having your Data Model ready and everyone loves it.Then you get this question all of a sudden. “I have made this excel file...

Introduction On February 23, 2021, Microsoft released a new beta certification exam, Exam DP-203: Data Engineering on Microsoft Azure. It is replacing the exams...

Microsoft Ignite, the most prominent technology innovation event of the year, hosted by Microsoft, is just around the corner. There has been a lot...

In this final blog, we discuss the measures that have to be made. Note: this is the third part of the blog. Missed the second...

Bringing everything together in one table Note: this is the second part of the blog. Missed the first part? Read it here. Step 1 Select the new...

It’s always fun to make your customers happy and learn new stuff by simply just doing your job. That’s what we did at one...

Introduction Most companies are already familiar with data modelling (be it Kimball or any other modelling technique) and data warehousing with a classical ETL...

Process Mining provides you with an objective and quick diagnosis on the actual execution of your business processes by extracting the necessary information from your...

One of the most valuable, yet less used functionalities of Power BI is ‘Paginated Reports’. This article will explain what they are, when you...

Transfer learning in Spark demystified in less than 3 minutes reading Introduction Businesses that want to classify a huge set of images in batch...

Just last week, the Power BI CAT team extended their current licensing model with the release of Premium Per User (PPU) under public preview....

Have you wondered what a data lake is? What are typical use cases for this lake? How can you benefit from a data lake...

Organizations understand the value of data more than ever. A Data Warehouse as a single source of truth, a data lake to store data...

Data Warehouses have served the purpose of providing a source of value-added information for quite some decades. In supporting business users in their day-to-day...

If you landed on this page to learn more about animals, I have to disappoint you. Pandas, Koalas and PySpark are all packages that...

As a Business Intelligence Consultant working with Power BI, I often get the following question: “Could you give me a top X of our...

Application Lifecycle Management (ALM) refers to a (software) development process which has been setup in a governed and easy-to-manage way. ALM provides added value...

Data isn’t life. They say music is. Well, is it? Wouldn’t it be awesome to simply combine both worlds? Let’s find out if this...

This day in age, apps are all around us. From our phones to our laptops, even in stores and restaurants, we can sometimes find...

‘Cloud’ or ‘Clowned’? With the high adoption of cloud computing in all processes, ‘Analytics’ is the one that can benefit from it the most....

Arriving at work and the first thing you do is opening your Power BI report and going for a coffee while waiting for the...

Best wishes and many Data Insights.  Oleon, my client, is at the forefront of the growing market of natural Chemistry. As lead of the...

The title accompanying this blog post is quite the mouth full. This blog post will explain why you should be using Spark. If a...

You’ll often hear a Lytix consultant say that he/she is proud of our XTL Framework. What is it exactly? And how can it improve...

There’s no denial that Power BI has been maintaining a steep growth since its release in 2015 in terms of capabilities. Consequently, the same...

With the on-premises gateway, you can directly connect to your SAP BW system. This allows you to refresh the reports that are in the...

While self-service is an easy way of creating and changing existing reports, organizations may struggle with version control of the reports that are published...

Wow, you may recall our previous post ‘5 tips for Excel users when connecting to Power BI’, its popularity needed us to upgrade our...

Excel is not dead! We often notice organizations starting their self-service / Enterprise Data Warehouse (EDW) project by stating the goal ‘getting rid of...

Governed Self-Service: a Power BI Rollout Power BI has gained a lot of op popularity in the past years. Due to the large portfolio...

Companies are creating more and more data, on which they want to gain insights. One valuable source of data is data from within the...

As there are huge amounts of data available within companies, data is also moved in increasing quantities from one data storage to another for...

Everyone who has already come in touch with data science, has already heard of features used in such models. One aspect that can become...

Most companies are already familiar with data modelling (be it Kimball or any other modelling technique) and data warehousing with a classical ETL (Extract-Transform-Load)...

If you landed on this page to learn more about animals, I have to disappoint you. Pandas, Koalas and PySpark are all packages that...

Transfer learning in Spark demystified in less than 3 minutes reading Businesses that want to classify a huge set of images in batch per...

Application Lifecycle Management (ALM) refers to a (software) development process which has been setup in a governed and easy-to-manage way. ALM provides added value...

On February 23, 2021, Microsoft released a new beta certification exam, Exam DP-203: Data Engineering on Microsoft Azure. It is replacing the exams DP-200:...

Have you wondered what a data lake is? What are typical use cases for this lake? How can you benefit from a data lake...

The title accompanying this blog post is quite the mouth full. This blog post will explain why you should be using Spark. If a...

Hi and welcome to this blog on process mining Process mining is a set of techniques used in the field of process management and...

Every year, a new buzzword emerges in Data and Analytics; get to know the ‘Data Lakehouse’. Will this be the future of all analytical...

Data Warehouses have served the purpose of providing a source of value-added information for quite some decades. In supporting business users in their day-to-day...

We want you to attend! Hello analytics enthusiasts! Lytix organizes four (4!) free meetups that demonstrate to you the 360 degree process of using...

Introduction Microsoft’s DA-100 certificate proves a vast knowledge of Power BI. In this article, I will give you some tips and tricks on how...