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 […]
As the name suggests, timeline chart in Tableau represents when the notable events are going to occur in the month, year, or even day. Also, the timeline can be used as a calendar showing upcoming dates of interest. Learn Tableau for Data Science In this article, I am going to mention the steps that required […]
Summary: In this article “Alteryx for Beginners”, we are going to learn how to use Alteryx and some of the key data skills (like blend, filter, analyze etc.) Following are the topics that, I am going to mention in this article you can also try out the Alteryx A to Z BootCamp Course with Real […]
Objective: Our objective is to build a progress chart for different KPIs. In this example, we will be using: “Marketing Cost vs Budget”, “Operational Cost vs Budget” and “Headcount Cost vs Budget”. The Progress Chart will look like this: Pre-requisites: To create this type of chart, we need to have data in the specific […]
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 […]
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 […]
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, […]
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 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 […]
Other Visualizations Have you ever wondered where you should live in order to have an edge on where to find a partner? Well you can increase your chances by living in an environment where there is a higher ratio of men to women or vice versa. Also to pair that variable with the per […]