Tag: Microsoft

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

Power BI: Paginated Reports

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 need to use them and how they can benefit your organisation. At the end, some samples can be downloaded that demo the functionality.  Starting-Off with an Example As you can see […]

Transfer learning in Spark for image recognition

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 per day can do this by leveraging the parallel processing power of PySpark and the accuracy of models trained on a huge set of images using transfer learning. Let’s first explain […]

Premium Per User (PPU) explained

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. On what ground exactly do current licensing models differ from this new release? We’re reaching our next destination: Premium Per User! What Power BI licensing offerings Microsoft already had in store? First […]

Pandas, Koalas and PySpark in Python

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 serve a similar purpose in the programming language Python.  Python has increasingly gained traction over the past years, as illustrated in the Stack Overflow trends. Originally designed as a general purpose […]

Power Apps

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 apps. An app supports business processes in consulting balances, inputting records, grouping products, activity planning and making prognoses. However, to make those apps, someone with the right expertise needs to spend […]