Month: July 2022

CI/CD of Synapse Serverless – Part 1/2

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 Platform. In this blog post, we’ll specifically focus on ‘Synapse Serverless’ which virtualizes data residing in your data lake making it SQL-query-friendly for business users and data scientists. As every of […]

The Data Lakehouse

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 analytical projects, or will this just be another fuzz that will only be used in rare cases? This blog will guide you through the architecture of a Data Lakehouse, you will […]

Composite Models

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 and I would like to use and combine it with the Sales Dataset in PowerBI.” The next thing you do is analyze the request and for some reason, maybe you don’t […]

The Journey of attaining the Azure Data Engineer certificate

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 DP-200: Implementing an Azure Data Solution, and DP-201: Designing an Azure Data Solution. These previous exams DP-200 and DP-201 will retire on June 30, 2021. When passing the two old exams […]

Microsoft Ignite – The official Lytix Recap

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 going on during the past week: this 2021 edition was full of surprises and had some amazing announcements in store. Who else than Lytix to keep you up-to-date with the most […]

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

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 part? Read it here. Calculations From here on out we will continue with all the calculations that have to take place to get to the end result of the time aspect of OTIF. […]

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

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 Orders table you just made and click “Append Queries as New” Now append the newly created Orders table with the newly created Deliveries table If  you have more than 2 tables […]

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

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 of my customers lately. Us and a colleague (at the customer) figured out a way in Power BI to calculate the OTIF over multiple fact tables. For both beginner and intermediate […]

Kimball in a data lake? Come again?

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 (Extract-Transform-Load) flow. In the age of big data, an increasing number of companies are moving towards a data lake using Spark to store massive amounts of data. However, we often see […]

Process Mining, the pounding heart of the intelligent enterprise

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 IT systems. In the past this was a tedious task based upon lots of interviews and in more than 98% a misrepresentation of reality. Process Mining removes this unreliability of this tedious task […]