Category: Training

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 […]

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

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 Power BI within an organization. After completing the four hands-on session, you’ll be granted the ‘Lytix 360° Power BI’ certification.  Are you ready to become a Power BI expert? Then make […]

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

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 to succeed.  The DA-100 exam is a new power BI certification exam, out of the beta phase since July. It is a replacement for the older 70-778 “Analyzing and Visualizing Data […]