Where to Find Data?

It’s often a struggle to find the good data that you really need to help enhance your data projects. However, Let’s continue to build a comprehensive list of sources that hopefully provide you with a wealth of datasets to work with. Check out the list of Datasets below. Feel free to help build out this […]

Get Google Trends Data into Power BI with Python

As of the time of writing this post, there is no native connector in Power BI for Google Trends API to pull data directly a report. However, we can easily do this with just a few lines of Python code. This will allow you to bring in multiple keywords to compare trends over time. We […]

Fill Blank Cell with Previous Cell

Excel has a lot of great functions and shortcuts that will make data cleaning and manipulation easier. Not knowing these techniques will add frustration and a lot of time to your current workload and analysis. You can follow the instructions below to figure out how to fill blank cells with previous cell values. Check out […]

Best Power BI Courses

​Power BI’s user-base is growing daily. In just a few years, the adoption of Power BI into data productivity suites has exponentially grown. The team at Microsoft provides monthly updates that increase Power BI’s functionality and customization. ​If you are familiar with the field of data visualization, you would have heard of Power BI as […]

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

How to Find Outliers in SQL

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

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

1 2 3 12