These are a set of functions which help in applying aggregation/ranking functions over a subset of records from the entire records of a table. Pease note, this function only creates an additional column in the “select” result set. The original data in the table remains intact. Elements of a Window Function When preforming Widows functions, […]
If you are like me, you have never heard of a ridge plot. However, I find that it’s one of the more interesting plots used to describe numerical data. It allows you display the distribution of data across a dimension. In other words, you will be able to see the distribution of temperatures across a […]
In this tutorial, we will discuss how to calculate The first basic formula for calculating the percentage of anything in Excel is Percent Total Formula Part/Total = Percentage. Excel automatically converts the answer to percentage. Before starting out, you must understand the two ways that percent input and result works in Excel. Step 1: Type […]
Pivot – This keyword in MS SQL Server is used to convert the rows to columns for a table and perform aggregations on a specific column. Please note, this keyword will not be able to remove/impact records from the table. It only interchanges the rows to columns in the output result set only. The original […]
It’s simple to identify the similarities and contrasts between two or more groups when using a Venn diagram to represent their relationships. In this post, we’ll demonstrate how to make Venn diagrams in Python and how to edit them as needed. There is no out-of-the-box matplotlib or seaborn function that produces a Venn diagram out […]
Multivariate numerical data can be visualized using a parallel coordinates plot. This visual compare samples or observations across several numerical variables. The X- axis is used to represent each feature or variable. All of the axes are parallel to one another and equally spaced apart. A distinct scale and unit of measurement can be used […]
If you are wondering how to reverse a string in Python, this can easily be done with slice notation. However, I will show you a few quick ways to reverse Python strings. I will list these in order difficulty. Two Main Points Reverse Python Strings with Slice Notation When slicing a string, you should think […]
Adding leading zeros in Excel is of the basic steps in data preparation. Often people try to manually achieve this task. However, there are 3 quick and easy ways in which you add leading zeros to balance out the length of your values. For example, if you want to ensure that your values have seven […]
Finding outliers in your data is easier than you think. You can use statistics concepts to identify the threshold where outliers may fall. One of the most accurate ways is to use the Z-Score. This score is composed of the mean, standard deviation, and current value. You see from the image below how this is […]
When integrating Python into Power Bi, you will often be faced with integration issues. However, luckily, there is a very easy way to avoid these problems. In this post, we are going to evaluate how to sidestep some of the major errors with Python in Power BI. Missing Dependencies The most common error is that […]