Tableau is a powerful data visualization and business intelligence tool.
It helps transform raw data into interactive dashboards and reports.
Tableau can connect to multiple data sources like Excel, SQL, and cloud databases.
It supports both structured and unstructured data.
Tableau Desktop is used for creating visualizations and dashboards.
Tableau Server allows sharing dashboards across an organization.
Tableau Online is a cloud-based version of Tableau Server.
Tableau Public is a free version for public data sharing.
Tableau Prep helps clean and prepare data before analysis.
It uses a drag-and-drop interface to simplify visualization creation.
Users can create charts like bar, line, pie, scatter, and area charts.
Tableau can perform trend analysis using time-series data.
It allows real-time data monitoring and updates.
Dashboards combine multiple visualizations for holistic insights.
Tableau supports filtering, grouping, and drilling down into data.
Parameters let users make dynamic changes to visualizations.
Calculated fields enable custom metrics and KPIs.
Tableau can blend data from multiple sources.
Maps in Tableau allow geospatial analysis.
Tableau supports storytelling features to present insights sequentially.
It is widely used in finance, marketing, healthcare, and retail.
Tableau has a strong community and extensive online resources.
Users can publish dashboards to Tableau Server or Tableau Online.
Data extracts improve performance for large datasets.
Tableau automatically recognizes data types and suggests visualizations.
It allows interactive filtering using dashboards and sheets.
Tableau integrates with R and Python for advanced analytics.
AI-powered features provide automated insights and recommendations.
Tableau can schedule data refreshes to keep reports updated.
Users can export dashboards as PDF, images, or PowerPoint.
Tableau ensures secure data access and role-based permissions.
It encourages self-service analytics for business users.
Tableau helps organizations make data-driven decisions efficiently.
Press Ctrl + D to duplicate a worksheet.
Use Ctrl + M to create a new dashboard.
Show Me panel suggests the best chart for selected data.
Use Filters to refine displayed data interactively.
Drag dimensions to Rows and measures to Columns to build charts.
Right-click a field to create a Calculated Field.
Use CTRL + Shift + D to duplicate a dashboard.
Apply Context Filters for complex filter scenarios.
Use Highlight Actions to emphasize specific data points.
Tooltips can be customized with rich formatting.
Use Aliases to rename field values in visualizations.
Groups help categorize similar dimension members.
Sets let you create dynamic subsets of data.
Use Data Blending to combine multiple sources.
LOD Expressions allow advanced level-of-detail calculations.
Quick Table Calculations simplify ranking, percent change, and totals.
Dual-Axis Charts overlay two different measures on one chart.
Calculated Fields can include IF, CASE, and logical statements.
Use Bins to categorize continuous data.
Dashboard Actions can filter, highlight, or navigate between sheets.
Story Points help build narrative visualizations.
Show Filter lets users interact with dashboards.
Swap Rows and Columns quickly changes chart orientation.
Format Pane customizes fonts, colors, and borders.
Snap-to-Grid ensures aligned dashboard objects.
Custom Shapes can replace standard marks.
Parameter Controls allow dynamic user input.
Automatic Refresh keeps dashboards up-to-date.
Data Interpreter cleans messy Excel files on import.
Extract Filters reduce dataset size for performance.
Performance Recorder identifies slow dashboards.
Keyboard Navigation helps move through dashboards without a mouse.
Annotations provide additional insights or explanations on charts.
SUM([Sales]) – Calculates total sales.
AVG([Profit]) – Calculates average profit.
COUNT([Customer ID]) – Counts number of customers.
COUNTD([Order ID]) – Counts distinct orders.
[Sales] - [Cost] – Profit calculation.
IF [Profit] > 0 THEN "Good" ELSE "Loss" END – Conditional logic.
CASE [Region] WHEN "East" THEN 1 WHEN "West" THEN 2 END – Case statements.
DATEDIFF('day', [Order Date], [Ship Date]) – Days between dates.
DATEPART('month', [Order Date]) – Extracts month from a date.
YEAR([Order Date]) – Extracts year.
RANK_UNIQUE(SUM([Sales])) – Ranks sales values uniquely.
ZN([Profit]) – Converts nulls to zero.
[Sales] / TOTAL([Sales]) – Percent of total.
LOOKUP(SUM([Sales]), -1) – Previous row value.
WINDOW_SUM([Profit]) – Sum over a table window.
IFNULL([Discount], 0) – Replace null discount with 0.
MEDIAN([Sales]) – Calculates median sales.
INDEX() – Returns row index in the partition.
FIRST() – Returns the first row in partition.
LAST() – Returns the last row.
ATTR([Category]) – Returns a single value if consistent, else *.
STR([Order ID]) – Converts number to string.
INT([Profit]) – Converts float to integer.
ROUND([Sales], 2) – Rounds sales to 2 decimals.
[Profit] / [Sales] – Profit ratio.
IF [Sales] > 1000 THEN "High" ELSE "Low" END – Categorization.
WINDOW_AVG([Profit]) – Moving average.
PREVIOUS_VALUE(0) – Cumulative calculation.
[Sales] - LOOKUP([Sales], -1) – Difference from previous row.
RANK_PERCENTILE(SUM([Sales])) – Percentile ranking.
TOTAL(SUM([Profit])) / SUM([Sales]) – Overall profit ratio.
[Region] + " - " + [Category] – Concatenate strings.
IF DATEPART('year', [Order Date]) = 2025 THEN [Sales] END – Filter for 2025 sales.