Gaelim Holland
Author Archives: Gaelim Holland

How to Calculate Percent using excel Formulas

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

How to PIVOT in SQL

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

How to Create Venn Diagrams in Python

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

Parallel Coordinate Plots

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

How to Reverse a String in Python

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

3 Ways to Add Leading Zeros in Excel

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

Avoid Python Errors in Power BI

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

How to Use and Tune XGBOOST

Why XGBoost is Awesome? One of the most implemented and widely used classifiers is XGBoost, and there are reasons for it XGBoost has an ability to implement both Classification and Regression models using the same core algorithm. It is one of the most used algorithms in Kaggle and daily use case applications. First of all, […]

How to Create a Function in Python

A function is a reusable block of code that performs a certain functionality. Functions are fundamental building blocks of a programming language as they introduce modularity and reusability in the code.  In this article, we will learn how to create and call a function in python. We will also go through the important concepts like […]

SQL MUST Interview Questions & Answers (Level 1 MYSQL)

These questions cover what data analysts would face at an entry-level to the intermediate range for SQL. Depending on the organization and role, the requirement for SQL knowledge may increase. However, these will cover the main concepts from joins, subqueries, grouping, alias, and filtering. You can practice all these SQL queries on our free platform: […]

1 2 3 10