Gaelim Holland
Gaelim Holland
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. You can also Learn Python Data Insights on YouTube import pandas as pd import numpy as np import seaborn […]
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 […]
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 spreadsheet style pivot table, you will need two dependencies with is Numpy and Pandas. However, in newer iterations, you don’t need Numpy. Let’s […]
How to Use CALCULATE in Power BI
Great Uses of 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 filter a column in a table. CALCULATE […]
How to Fix VLOOKUP Errors
How to Fix VLOOKUP Errors Summary: VLOOKUP function in Excel is the most widely used function and it comes in very handy while looking up the value from different data sources. However, VLOOKUP also has a lot of limitations and specificities, which leads to various problems and errors. In this article, we are going to […]
Google Career Listings Visualization
The data was sourced from Kaggle where a user scraped the Google’s careers. Natural Language Toolkit was used in Python. NLTK and BeautifulSoup were used to clean the dataset and split the twelve hundred plus job listings. The job listings were tokenized into nearly seventy-five thousands words. The stop words were removed from the list […]
Tableau Directional Vector Map
Directional Vector Map in Tableau Directional maps help to show the trade routes, shipping and a whole host of directional data represented. The best way to represent this is by using the map in Tableau. Your boss may ask you to visually represent the amount of items shipped to different locations around the globe. We are […]
Excel Pivot Table Tips & Tricks
Pivot Tables: Pivot tables in Excel are considered as the most important tool. A pivot table allows the users to organize and summarize the selected columns of data to develop a required analysis report. Using pivot table user can do quick data analysis and it is quite easy to use as well. In this article, […]
Create a Funnel Chart in Tableau
Funnel Chart in Tableau Funnel Chart is used to represent different levels of a process in the form of funnels representing top-down approach. The size of funnels can be shown through any measures like Sales, Profit or Costs etc. Funnel chart is very useful in identifying the problem areas in a process or identifying the […]
NRA Political Donations from 1990 to 2018
NRA Donations by Party and Politician Where does the NRA concentrate their donations? You can view the data according to the New York Times, OpenSecrets.org and Fortune Magazine. The top politicians that receive money from the NRA are overwhelmingly Republican with Donald Trump who is the the top politician of the Republican party with over […]