As a Data Analyst, I analyze and visualize data in order to answer business questions and to enable data-driven decision making.
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 Power BI is one of the most widely used BI tools. But using Power BI on the Mac can be a challenge. This is because Microsoft does not offer a version of Power BI Desktop for the Mac. Nevertheless, there are workarounds for using Power BI on the Mac....
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 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...
Introduction In this tutorial, we want to create a Stripplot. In order to do this, we use the stripplot() function of Seaborn. Import Libraries First, we import the following python modules: import seaborn as sns import matplotlib.pyplot as plt Load Data We would like to use a seaborn sample...
Introduction In this tutorial, we we want to draw several Plots in one figure. We can achieve this by using Subplots. In order to create a Subplot, we use the subplot() function of Matplotlib. Import Libraries First, we import the Pyplot submodule. The Pyplot submodule contains a collection of important...