Unlock the full potential of Data Analytics with our in-depth tutorials! We provide comprehensive guides to create powerful dashboards and data visualizations. From mastering analytics fundamentals to advanced reporting techniques, our tutorials cover it all.
Introduction Power BI offers with the Power Query Editor a powerful tool for cleaning and transforming data. One important part of data preparation is filtering your data. Filtering enables you to sort out irrelevant data and to reduce the amount of data. One important type of filtering is custom filtering....
Introduction Power BI comes with the powerful formula language Data Analysis Expression (DAX) which allows the implementation of custom calculations. There are numerous operators and functions available in DAX. One essential DAX function is the SWITCH function. The SWITCH function provides an elegant way to handle multiple conditions and is...
Introduction Power BI offers with the Power Query Editor a powerful tool for cleaning and transforming data. One important part of data preparation is filtering your data. Filtering enables you to sort out irrelevant data and to reduce the amount of data. One important type of filtering is conditional filtering....
Introduction Power BI comes with the powerful formula language Data Analysis Expression (DAX) which allows the implementation of custom calculations. There are numerous operators and functions available in DAX. One essential DAX function is the IF function which is used for conditional calculations. In this tutorial, we will explore the...
Introduction Power BI offers with the Power Query Editor a powerful tool for cleaning and transforming data. One important part of data preparation is filtering your data. Filtering enables you to sort out irrelevant data and to reduce your amount of data. In this tutorial, we show you how to...
Introduction In this tutorial, we want to create a Histogram. In order to do this, we use the hist() function of Matplotlib. Import Libraries First, we import the Pyplot submodule. The Pyplot submodule contains a collection of important functions such as the plot() function or the hist() function. In addition,...
Introduction In this tutorial, we want to create a Barplot. In order to do this, we use the barplot() function of Seaborn. Import Libraries First, we import the following python modules: import seaborn as sns import matplotlib.pyplot as plt import numpy as np Load Data We would like to...
Introduction In this tutorial, we want to explain the characteristics of a Data Lakehouse. In order to do this, we will take a closer look at the key features of Data Lakes and Data Warehouses and how a Data Lakehouse combines the best of both worlds. Definition At its core,...
Introduction In this tutorial, we want to create a Pie Chart. In order to do this, we use the pie() function of Matplotlib. Import Libraries First, we import the Pyplot submodule. The Pyplot submodule contains a collection of important functions such as the plot() function or the pie() function. import...