Pareto chart is basically based on the theory of “80-20” phenomena, where it means that 80% of the output is being generated by the 20% of the input. In terms of retail data, we can also say like this that 80% of revenue is from 20% of customers. Pareto chart is a combination of both […]
EXCLUDE: “EXCLUDE” level of detail expression is used to omit specified dimensions from the aggregations. Using “EXCLUDE”, a user can omit the lower level granularity dimension which is present in the view and can directly calculate the value at a higher granularity level. Tableau Training and Certification at Edureka “EXCLUDE” level of detail expression is […]
INCLUDE: As the name suggests, “INCLUDE” level of detail expression compute aggregations considering dimensions which are specified in the calculation and also take into consideration those dimensions which are present in the view. “INCLUDE” level of detail expression is useful when the user wants to calculate values at the lower level of granularity and then […]
FIXED: “FIXED” level of detail expression aggregates the value only at the dimensions which are specified by the user in the calculation. “FIXED” expression does not take into consideration those dimensions in the view. The difference between FIXED and INCLUDE/EXCLUDE is unlike INCLUDE/EXCLUDE, FIXED calculations are not relative to the dimensions in view. Example: Requirement: […]
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 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 […]