UNIT-5
UNIT-V
Generating New Data with Forecasts:
Generating data with forecasts in Tableau involves using its built-in forecasting tools to predict future trends based on historical data. Forecasting in Tableau uses historical data to predict future values using time series analysis. Tableau primarily uses Exponential Smoothing Models for forecasting.
Requirements:
§ At least one date field (e.g., daily, monthly) to define the time dimension.
§ At least one measure (e.g., sales, profit) for forecasting.
§ Ensure data is clean, with no missing values in the date or measure fields for accurate forecasts.
§ Aggregate data if needed (e.g., sum sales by month).
Steps to generate Forecasts in Tableau:
Step-1: Connect to data source (Excel, SQL, cloud databases, etc.) (Retail Sales)
Ensure that historical data points (e.g., 12+ months for monthly data) for reliable forecasts.
Step-2: Drag and drop the date field to Columns (Ship date)) and the measure (Sales/Profits) to Rows. And use continuous rather than discrete for smoother forecasting.
Step-3: Apply filters to focus on relevant data (e.g., specific regions or products). Use parameters for dynamic control (e.g., adjust forecast periods).
Step-4: Right click on the visualization / go to analytics Pane / go to Analysis and select Forecast Options.
Forecast Length: Set how far into the future to predict (e.g., 6 months).
Source Data: Choose whether to include all data or a specific range.
Model Type:
Automatic: Tableau selects the best model (usually exponential smoothing).
Custom: Adjust seasonality (e.g., yearly, quarterly) or model specifics.
Confidence Intervals: Default is 95%; adjust for wider/narrower uncertainty bands.
Step-5: Forecasted values appear as a continuation of the historical line, often in a different shade. Confidence intervals show the range of uncertainty (shaded bands).
# If you need to add trend line (linear, polynomial, power or exponential etc.,) from Analytica pane to visualize the overall direction
# If you need quality metrics (RMSE, MASE) by selecting describe forecast by right click and select.
Parameters
Parameters are dynamic values that can replace constant values in calculations, filters, reference lines, and more. They allow users to interact with the visualization by inputting or selecting values.
Important Features
Single value at a time
Unlike filters, parameters can only hold one value at a time.
Static list
Parameter values are not automatically updated based on data source; they need to be manually updated if data changes.
User Interaction
Users can choose values via dropdowns, sliders, type-ins, etc.
Works across multiple sheets
One parameter can be used in multiple worksheets/dashboards.
Creating of Parameter:
Step-1: Connect the data file to Tableau (Retail Sales)
Step-2: Right-click in the Data pane → Select Create Parameter…
Give the parameter a name (Analysis By (Dimension Swap) → Set data type (Integer, Float, Date, String, etc.) (String) → Set current value (default value) (1) → Set allowable values (All, List, Range) (List).
Step-3: After choosing the List, choose one by one from the data pane what ever you need. (Here we consider string so take Customer Name)
Value: Customer Name Display As: Customer Name
Value: Customer Segment Display As: Customer Segment
Step-4: After Creating Parameter, right click and select show parameter. You see RHS Pane i.e., created parameter.
Step-5: After that go to Analyze → Create Calculated Field → Give the name as Analysis By in the pop-up box and type the syntax as follows:
CASE [Analysis By (Dimension Swap)]
WHEN 'Customer Name' THEN [Customer Name]
WHEN 'Customer Segment' THEN [Customer Segment]
END
Providing Self-Evidence Adhoc Analysis with Parameters
Self-evident ad hoc analysis in Tableau using parameters empowers users to interactively explore data without needing predefined dashboards or complex setups. Parameters enable dynamic, user-driven analysis by allowing inputs to adjust calculations, filters, or visualizations on the fly.
It explores the analysis where users can independently explore data, adjust variables, and derive insights through intuitive, interactive controls without requiring deep technical knowledge. Parameters act as user-controlled inputs (e.g., sliders, dropdowns) to modify metrics, filters, or views dynamically, making analysis self-evident and accessible.
Suppose user wants to explore (e.g., sales performance, customer segmentation, forecasting) follow the steps.
Creating of Parameter:
Step-1: Connect the data file to Tableau (Retail Sales)
Step-2: Right-click in the Data pane → Select Create Parameter…
Give the parameter a name (Analysis By (Dimension Swap) → Set data type (Integer, Float, Date, String, etc.) (String) → Set current value (default value) (1) → Set allowable values (All, List, Range) (List).
Step-3: After choosing the List, choose one by one from the data pane whatever you need. (Here we consider string so take Customer Name)
Value: Customer Name Display As: Customer Name
Value: Customer Segment Display As: Customer Segment
Value: Product Category Display As: Product Category
Value: Product Sub-category Display As: Product Category
Value: Product Container Display As: Product Container
Value: Product Name Display As: Product Name
Value: Region Display As: Region
Value: Ship mode Display As: Ship mode
Step-4: After Creating Parameter, right click and select show parameter. You see RHS Pane i.e., created parameter.
Step-5: Integrate Parameters into Calculations, Create calculated fields to use parameter values dynamically.
Go to Analyze → Create Calculated Field → Give the name as Analysis By in the pop-up box and type the syntax as follows:
CASE [Analysis By (Dimension Swap)]
WHEN 'Customer Name' THEN [Customer Name]
WHEN 'Customer Segment' THEN [Customer Segment]
END
Step-6: Build Interactive Visualizations – Use calculated fields in charts, tables or maps and add the parameters to the dashboard for user interaction.
Editing views in Tableau Server:
Editing views on Tableau Server (now part of Tableau Cloud or Tableau Server for on-premises deployments) allows authorized users to modify published workbooks, views, or dashboards directly in the web interface without needing Tableau Desktop.
The Purpose of Web editing is it enables users to tweak visualizations, create new views, or adjust dashboards interactively in a browser. It accesses Tableau Server/Tableau Cloud via the Web Edit feature. The scope is Users can modify calculations, filters, parameters, layouts, and formatting, depending on permissions.
Requirements:
1. Permissions:
- Users need Editor or Explorer (can publish) site roles to edit workbooks.
- Specific permissions: Web Edit capability for the project/workbook and Write/Save to save changes.
- Admins control permissions at the project, workbook, or view level.
2. License:
- Requires a Creator or Explorer license (Explorer with editing permissions enabled).
3. Browser Support:
- Works in modern browsers (Chrome, Firefox, Safari, Edge).
4. Published Workbook:
- The workbook must be published to Tableau Server/Cloud with web editing enabled.
How to Edit Views on Tableau Server
- Accessing Web Edit:
- Navigate to the workbook or view on Tableau Server.
- Click the Edit button (pencil icon) on a view or dashboard (visible if permissions allow).
- Alternatively, select Edit Workbook from the workbook’s menu.
- Editing Interface:
- Opens a browser-based version of Tableau’s authoring environment, similar to Tableau Desktop.
- Components available:
- Data Pane: Shows data sources and fields.
- Shelves: Rows, Columns, Filters, Marks, etc.
- Toolbar: Undo, Redo, Save, Add New Worksheet/Dashboard.
- Analytics Pane: Reference lines, trend lines, etc.
- Common Editing Tasks:
- Modify Visualizations:
- Drag fields to shelves to change chart types (e.g., bar to line).
- Adjust marks (color, size, label).
- Filters:
- Add, edit, or remove filters.
- Create quick filters for interactivity.
- Calculations:
- Create or edit calculated fields (e.g., SUM([Sales]) / [Select Metric Parameter]).
- Parameters:
- Edit existing parameters or create new ones to drive dynamic analysis.
- Formatting:
- Adjust titles, fonts, colors, or tooltips.
- Modify dashboard layouts (e.g., rearrange tiles, add text objects).
- Add Sheets/Dashboards:
- Create new worksheets or dashboards within the workbook.
- Saving Changes:
- Click Save to overwrite the original workbook (if permitted).
- Use Save As to create a copy (requires Publish permissions).
- Note: Saving may overwrite shared content—communicate with team members.
Using Parameters in Web Editing
1. Editing Parameters:
- Access parameters in the Data pane.
- Modify allowable values, range, or current value.
- Update parameter-driven calculations or filters.
- Dynamic Analysis:
- Combine parameters with web-edited calculations for ad hoc analysis (e.g., adjust a threshold to filter data).
- Example: Edit a parameter “Select Year” to update a view dynamically.
- Adding Parameters:
- Create new parameters directly in the web interface to enhance interactivity.
- Example: Add a “Top N” parameter to control the number of items displayed.
Limitations of Web Editing
1. Data Source Restrictions:
- Cannot modify the underlying data source structure (e.g., add new connections, edit joins).
- Limited to published data sources or extracts.
- Advanced Features:
- Some Desktop features are unavailable (e.g., custom SQL, complex data blending).
- No access to certain extensions or advanced scripting (e.g., Python/R integration).
- Performance:
- Large datasets may slow down web editing.
- Extracts refresh schedules cannot be modified in web edit mode.
- Version Control:
- No built-in version history for web edits (use Save As for backups).
- Parameter Limitations:
- Cannot dynamically update parameter lists based on data changes (manual updates required).
- Single-value selection only (no multi-select).



















Excellent explanation! Clear, concise, and incredibly beginner-friendly. 🚀
ReplyDeleteIf you're eager to explore more exciting Tableau-tutorials and deepen your understanding, don't miss this detailed guide:
👉 Tableau-tutorials – Explore What's New
Keep learning, keep coding, and keep growing! 💻✨