AbsentData - Looking for outsights

0 Seaborn Histogram

You can easily create and style a histogram in Seaborn with just a few steps. Let’s get started. You will need a few dependencies to ensure that the plot is shown. The dependencies that you essentially need to load are Matplotlib and Seaborn. However, let’s load the standards such as Pandas and Numpy also in case […]

0 Waffle Chart in Tableau

Definition: Waffle chart is a 10 X 10 cell grid in which each cell represents 1 percentage point summing up to total 100%. Waffle charts can be represented with conditional formatting where cells are highlighted with different colors based on the percentage value of that KPI. There are following used cases of Waffles chart: To […]

0 Create a Python Heatmap with Seaborn

You can easily create a heatmap using the Seaborn library in Python. For this tutorial, I’m going to create this using Jupyter Notebooks. The first step is to load the dependencies which are the essential library. import pandas as pd import numpy as np import seaborn as sns import matplotlib.pyplot as plt %matplotlib inline Now […]

0 Google Store Most Installed Apps

The Google Apps store has a plethora of different apps ranging across a ton of different categories. Here is a visualization created in Tableau that give you an idea of what are the most popular apps on the platform. The dataset was sourced a Kaggle.com in the form a CSV. I did some light […]

0 Create Pivot Tables with Pandas

One of the key actions for any data analyst is to be able to pivot data tables. Luckily Pandas has an excellent function that will allow you to pivot. To create this spread shit style pivot table, you will need two dependencies with is Numpy and Pandas. However, in newer iterations, you don’t need Numpy. […]

0 Pareto Chart in Tableau

Pareto chart is basically based on the theory of “80-20” phenomena, where it means that 80% of the output is being generated by the 20% of the input. In terms of retail data, we can also say like this that 80% of revenue is from 20% of customers. Pareto chart is a combination of both […]

0 EXCLUDE – LOD Deep Dive in Tableau

EXCLUDE: “EXCLUDE” level of detail expression is used to omit specified dimensions from the aggregations. Using “EXCLUDE”, a user can omit the lower level granularity dimension which is present in the view and can directly calculate the value at higher granularity level. “EXCLUDE” level of detail expression is majorly used to calculate ‘difference from overall […]

0 INCLUDE – LOD Deep Dive in Tableau

INCLUDE: As the name suggests, “INCLUDE” level of detail expression compute aggregations considering dimensions which are specified in the calculation and also take into consideration those dimensions which are present in the view. “INCLUDE” level of detail expression is useful when the user wants to calculate values at the lower level of granularity and then […]

0 FIXED LOD Calculation – Deep Dive in Tableau

FIXED: “FIXED” level of detail expression aggregates the value only at the dimensions which are specified by the user in the calculation. “FIXED” expression does not take into consideration those dimensions in the view. The difference between FIXED and INCLUDE/EXCLUDE is unlike INCLUDE/EXCLUDE, FIXED calculations are not relative to the dimensions in view. Example: Requirement: […]

0 How to Use CALCULATE in Power BI

Great Uses for CALCULATE in Power BI Calculate is one of the most versatile functions in Power BI. When you begin using anything from simple filters, time intelligence functions or even advanced formulas, often the CALCULATE formulas are leveraged to produce the desired outcome. Let ’s use CALCULATE to filer a column in a table. CALCULATE […]

1 2 3 … 5 Next »