Blogs

Read below our blogs and updates on the latest technologies for data engineering, advanced analytics and data science.

Let’s turn your data into value. Book your call right here.

Knowledge sharing

Performance tuning using indexes

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

Read more

Kickstart your Power BI Knowledge

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

Read more

A hitchhikers guide to adopting Power BI

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

Read more

Subscribe to our Lytix newsletter!

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

Read more

Synapse vs Databricks: Which one to choose from?

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

Read more

Once a pawn a time Power BI meets chess…

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

Read more

Strategies for Loading Your Data Incrementally

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

Read more

Charticulator in Power BI

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

CI/CD of Synapse Serverless – Part 1/2

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

Read more

The Data Lakehouse

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

Read more

Composite Models

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

Read more

The Journey of attaining the Azure Data Engineer certificate

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

Read more

Microsoft Ignite – The official Lytix Recap

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

Read more

Lesson learned at the customer: Merging two tables to calculate On Time In Full (OTIF) [Part III]

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

Read more

Lesson learned at the customer: Merging two tables to calculate On Time In Full (OTIF) [Part II]

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

Read more

Lesson learned at the customer: Merging two tables to calculate On Time In Full (OTIF)

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

Read more

Kimball in a data lake? Come again?

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

Read more

Process Mining, the pounding heart of the intelligent enterprise

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

Read more

Power BI: Paginated Reports

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

Read more

Transfer learning in Spark for image recognition

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

Read more

Premium Per User (PPU) explained

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

Read more

Things to consider when creating a Data Lake

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

Read more

Azure Synapse Analytics

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

Read more

The Data Vault Methodology

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

Read more

Pandas, Koalas and PySpark in Python

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

Read more

DAX Pattern: Top X and Others

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

Read more

How ALM streamlines BI projects: Azure DevOps

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

Read more

Power BI and Spotify – A match made in heaven?

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

Read more

Power Apps

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

Read more

Snowflake, a DWH as a Service

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

Read more

10 performance tips to speed up your Power BI reports

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

Read more

Governed Corporate Power

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

Read more

Managed Big Data: DataBricks, Spark as a Service

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

Read more

Lytix’ XTL Framework

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

Read more

Power BI Governator

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

Read more

Having Power BI on SAP BW using a gateway?

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

Read more

Keep those Power BI reports in (source) control!

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

Read more

5 Tips for Power BI/Analysis Services to improve the use of Excel

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

Read more

5 tips for Excel users when connecting to Power BI

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

Read more

Governed Self-Service: a Power BI Rollout

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

Read more

Connecting and Using MS Graph in Azure Data Factory

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

Read more

Loading mechanisms – Part I

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

Read more

Feature Store

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

Read more

Kimball in a data lake? Come again?

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

Read more

Pandas, Koalas and PySpark in Python

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

Read more

Transfer learning in Spark for image recognition

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

Read more

How ALM streamlines BI projects: Azure DevOps

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

Read more

The Journey of attaining the Azure Data Engineer certificate

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

Read more

Things to consider when creating a Data Lake

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

Read more

Managed Big Data: DataBricks, Spark as a Service

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

Read more

Process Mining: Understanding Simple Process Discovery Techniques using Python

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

Read more

The Data Lakehouse

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

Read more

The Data Vault Methodology

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

Read more

Lytix’ Power BI 360° Certified: Uplift your Power BI game

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

Read more

The Journey of attaining ‘DA-100: Analyzing data with Power BI’

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

Read more