Have you ever been asked what percentage of something accounts for something else? For example, is it true that 80% of our sales come from 20% of customers (or 80/20 rule or Pareto principle)?
This step-by-step tutorial will walk you through how to do this in Tableau Desktop. Whether you're aiming to analyze 8% or 80% of your sales data, this tutorial caters to all levels, offering step-by-step instructions and explaining potential pitfalls.
This technique will work with any data set, so you don't have to be using sales data. You could be looking at number of complaints, number of patients, fundraising dollars, etc.
Additional topics and concepts covered:
- parameters
- row-level calculations
- aggregate calculations
- LOD expression
- table calculations (ATTR, INDEX, Running Total, WINDOW_COUNT)
- secondary table calculations
- and more ...
This tutorial not only teaches you the technical steps but also helps clarify the logic behind each step, ensuring a deeper understanding of data analysis in Tableau.
Superstore Data Set (Excel):
data.world/sqlbelle/sample-su...
Starter Workbook:
public.tableau.com/app/profil...
00:00 Introduction
02:02 Steps
02:32 Step 1 - Setup (Parameters, FIXED LODs)
07:23 Step 2 - Focus on Sales calculations
14:27 Step 3 - Focus on Determining number of customers
21:29 Step 4 - Polish / Cleanup
Additional Tutorials
Parameters
• Tableau Tutorial - Par...
LOD
• Tableau LOD (Level of ...
Basic Calculations
• Learn Tableau Basic Ca...
Table Calculations
• Tableau Table Calculat...
Order of Operations
• Master Tableau's Order...
12 Common Tableau Errors
• 12 Common Tableau Erro...
#tableau #TableauTips #TableauTutorial #TableauForBeginners #calculations #datafam #visualanalytics #dataanalysis #parameters #dataanalyst
2 июл 2024