Regression analysis is a statistical method used to model and understand the relationship between an independent variable and one or more dependent variables. It’s commonly used for predicting or understanding the impact of changes in the independent variable on the dependent one.
In simpler terms, regression analysis helps us analyze and quantify relationships between variables, making it an invaluable tool in fields like economics, finance, and beyond.
Today, we’ll explore creating a dashboard to analyze the relationship between Profit and Sales using Tableau’s Sample Superstore dataset.
This step-by-step SkillPill will help you visualize and understand the data, allowing for more informed and strategic decision-making.
→ In Tableau Desktop connect to Sample – Superstore data provided by Tableau.
→ Create a worksheet named Profit and Sales Trendline
→ Add Sales on Columns
→ Add Profit on Rows
→ Add Customer Name on Details
→ Go to Analytics and add the trendline line by linear
Explanation of Profit=0.15*Sales+ (-627.97) -> when the sales are raising with one unit the Profit = 0.15*1+(-627.97)
→ Create a worksheet named Profit Distance based on the model
→ Create a calculated field named Slope which will calculate the variance by the formula:
WINDOW_COVAR(SUM([Sales]), SUM([Profit]))/WINDOW_VAR(SUM([Sales])).
→ Create a calculated field named Intercept which will calculate the variance by the formula:
WINDOW_AVG(SUM([Profit]))-WINDOW_AVG(SUM([Sales]))*[Slope].
→ Create a calculated field named Calculated Profit where we’ll replicate the Regression formula:
SUM([Sales])*[Slope] + [Intercept]
→ Also, we will calculate the Profit distance % by the formula:
(SUM([Profit])-[Calculated Profit])/[Calculated Profit]
→ Add Sales on Columns
→ Add Profit on Rows
→ Add Customer Name on Details
→ Add Calculated Profit on Rows
→ Go to Analytics and add the trendline line by linear
→ Make the Profit and Calculated Profit dual axis and synchronize then the axis
→ Right-click on Calculated Profit and add Table Calculation by Customer Name
→ Go to Marks and Make Calculated Profit as Line
→ Go to Marks and add Profit Distance % on Text
→ Go to Marks and add Profit Distance % on Detail
→ Go to Marks and add Profit Distance % on Color
→ Go to Color – Advanced and add Start -1 and End 1
→ Hide the Calculated Profit Axis by right-clicking and unchecking the show header option
→ Go on Marks and make a Sum(Profit) circle
Here is the dashboard in Tableau Public:
Watch the video tutorial here:
About btProvider:
We hold all possible technical and sales certifications for all products:
Tableau Desktop, Tableau Public, Tableau Server, Tableau Prep, and Tableau Data Management.
With Tableau Software – the best data visualization platform – you can always understand your business or your job better. Using Tableau, you will make intelligent and strategic decisions and quickly understand the data flow, numbers, and the results it produces. See other #skillpill video tutorials here:
How to display multiple insights on a dashboard in #Tableau
How to create Stacked Bars on Grand Totals in Tableau
How to create a Buffer Zoom in a Tableau Map
Are you interested in learning more about Tableau Software – one of the best analytics tools and implementing the solution in the entire company?
See how Tableau works, by downloading a free trial here:
In this Skillpill, you will learn how to use tSendMail in Talend. tSendMail is a component used to send emails directly from a Talend job. It supports various email protocols, such as SMTP, and allows the configuration of the sender, […]
🚀 Enhance Your Tableau Dashboards: How to Swap a Different View Parameter! 📊✨ Tableau is one of the most powerful tools for data visualization and business intelligence. Its user-friendly interface and rich set of features allow you to create interactive […]
In this Skillpill, you will learn how to create a Parliament Chart in Tableau. A Parliament Chart, or semicircular chart, represents the distribution of parliamentary seats. It is not a standard chart type in Tableau but can be manually created […]