Blogs
Read below our blogs and updates on the latest technologies for data engineering, advanced analytics and data science.
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 moreKickstart 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 moreA 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 moreSubscribe 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 moreSynapse 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 moreOnce 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 moreStrategies 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 moreCharticulator 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 moreVirtualizing 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 moreLoading 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 moreStandardize 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 moreMonitoring 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 moreSynapse 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 morePower 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 morePower 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 moreProcess 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 moreCI/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 moreCI/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 moreThe 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 moreComposite 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 moreThe 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 moreMicrosoft 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 moreLesson 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 moreLesson 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 moreLesson 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 moreKimball 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 moreProcess 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 morePower 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 moreTransfer 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 morePremium 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 moreThings 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 moreAzure 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 moreThe 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 morePandas, 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 moreDAX 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 moreHow 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 morePower 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 morePower 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 moreSnowflake, 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 more10 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 moreGoverned 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 moreManaged 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 moreLytix’ 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 morePower 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 moreHaving 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 moreKeep 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 more5 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 more5 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 moreGoverned 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 moreConnecting 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 moreLoading 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 moreFeature 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 moreKimball 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 morePandas, 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 moreTransfer 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 moreHow 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 moreThe 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 moreThings 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 moreManaged 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 moreProcess 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 moreThe 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 moreThe 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 moreLytix’ 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 moreThe 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