UNIT-1

 UNIT-1

What is Tableau Desktop?

Tableau Desktop is a powerful data visualization and business intelligence (BI) tool that allows users to connect, analyze, and visualize data interactively. It helps businesses and individuals create interactive dashboards, reports, and charts to derive insights from data quickly and efficiently.

Important Features of Tableau Desktop

  1. Data Connectivity – Connects to various data sources, including Excel, SQL databases, cloud services (Google Sheets, AWS, etc.), and big data platforms.
  2. Drag-and-Drop Interface – Users can build visualizations easily without coding.
  3. Data Blending and Integration – Combines data from multiple sources to create a unified view.
  4. Interactive Dashboards – Allows filtering, highlighting, and drilling down into data for deeper insights.
  5. Real-Time Data Analysis – Supports live and extract data connections for real-time or offline analysis.
  6. Advanced Analytics – Offers statistical functions, trend analysis, and predictive modeling.
  7. Mapping and Geographic Analysis – Supports geospatial data visualization with maps.
  8. Collaboration and Sharing – Dashboards can be shared via Tableau Server, Tableau Online, or exported in various formats (PDF, PNG, etc.).

 Uses of Tableau Desktop

  • Business Intelligence (BI) Reporting – Used in finance, sales, marketing, healthcare, and other industries to analyze performance.
  • Data-Driven Decision Making – Helps organizations make informed decisions based on visual insights.
  • Market Analysis – Analyzes trends, customer behavior, and competitive positioning.
  • Academic and Research Analysis – Used by researchers and students for data exploration and presentation.

Tableau Desktop Editions

  1. Tableau Desktop Personal – Limited to private use with file-based data sources.
  2. Tableau Desktop Professional – Connects to all data sources and supports collaboration with Tableau Server and Online.
  3. Tableau Public – A free version with limited features, mainly for sharing visualizations publicly.

How to Connect to our Data in Tableau Desktop

Tableau Desktop allows you to connect to various data sources, including files, databases, and cloud-based services. Here's a step-by-step guide to connecting your data in Tableau Desktop.

Step 1: Open Tableau Desktop

  • Launch Tableau Desktop on computer.
  • The Start Page appears with options to connect to different data sources.

Step 2: Choose a Data Source

A. Connect to Files

  • Click on "Microsoft Excel" to connect to an Excel file.
  • Click on "Text File" to connect to CSV or TXT files.
  • Click on "JSON," "PDF," or other supported file formats as needed.

B. Connect to Databases and Servers

  • Click on "Microsoft SQL Server", "MySQL", "PostgreSQL", etc., to connect to relational databases.
  • Provide server credentials (host, username, password) if required.
  • Select the database and tables you want to use.

C. Connect to Cloud Services

  • Click on "Google Sheets", "AWS Redshift", "Snowflake", etc., to connect to cloud-based data.
  • Authenticate with your Google, AWS, or other cloud credentials.

Step 3: Load and Preview Your Data

  • After selecting the data source, Tableau displays a preview of your data.
  • You can:
    • Rename columns
    • Change data types (e.g., string to date)
    • Filter or clean data before visualization

Step 4: Drag Tables into the Data Pane

  • If working with multiple tables, drag and drop them into the Data Pane.
  • Use Joins or Relationships to combine tables if needed.

Step 5: Start Visualizing Data

·     Click "Sheet 1" at the bottom to move to the Worksheet.

·  Drag fields from the Data Pane to the Rows and Columns to create visualizations.

 

Generated Values in Tableau

Generated values in Tableau refer to automatically created fields that Tableau provides for every data source. These values are not directly present in the dataset but are created by Tableau for enhanced functionality and analysis.

Types of Generated Values in Tableau

1. Measure Names & Measure Values

  • Measure Names: A system-generated field that contains the names of all numeric measures in the dataset.
  • Measure Values: A system-generated field that contains the actual values of all measures.

Note: Used when multiple measures need to be displayed in a single visualization (e.g., a combined chart for sales and profit).

2. Number of Records (Deprecated in newer versions)

  • Represents the count of rows in a dataset.
  • Can be used to calculate aggregations such as COUNT, SUM, or AVERAGE.

3. Latitude (Generated) & Longitude (Generated)

  • Automatically generated when Tableau detects a geographic field like country, state, or city.
  • Used in map visualizations to place data points on a geographical map.
  • Tableau assigns approximate latitude and longitude coordinates based on known geographic locations.

4. Table Calculation Fields

  • Generated dynamically when users apply quick table calculations (e.g., Running Total, Moving Average, Percent Difference).
  • These calculations exist temporarily and are not stored in the dataset.

Importance of Generated Values

  • Simplifies data visualization by reducing the need for manual calculations.
  • Supports dynamic filtering and analysis (e.g., using Measure Names & Measure Values in dashboards).
  • Enhances geographic mapping with Latitude & Longitude (Generated).

When to Use a Direct Connection in Tableau

A direct connection means Tableau pulls data directly from the source without storing it locally.

When to Use a Direct Connection

  • Real-Time Data Analysis – When you need live, up-to-date data (e.g., stock market, sales dashboards).
  • Large Datasets – If the data is too large to extract efficiently.
  • Frequent Data Changes – If the data updates regularly and must reflect the latest values.
  • Server-Based Data Sources – When connecting to databases like SQL Server, MySQL, Snowflake, etc.

Note: Example: Analyzing live sales data from a company’s ERP system without exporting it to an Excel file.


Joining Tables in Tableau

A join combines data from multiple tables within the same data source (e.g., SQL database, Excel file).

Types of Joins in Tableau

🔹 Inner Join – Returns only matching records from both tables.
🔹 Left Join – Returns all records from the left table and matching records from the right.
🔹 Right Join – Returns all records from the right table and matching records from the left.
🔹 Full Outer Join – Returns all records from both tables, filling gaps with NULLs where no match exists.

When to Use Joins

  • When working with related tables in the same database (e.g., Orders and Customers tables).
  • When tables share a common key (e.g., Customer ID, Product Code).
  • When performing relational database queries inside Tableau.

Note: Example: Joining "Sales" and "Product Details" tables using "Product ID" to analyze total sales by category.

Blending Different Data Sources in a Single Worksheet

Data Blending combines data from multiple, independent sources (e.g., MySQL + Excel). Unlike joins, blending happens at the visualization level and keeps data sources separate.

When to Use Data Blending

  • When data is stored in different databases or formats (e.g., SQL + Google Sheets).
  • When direct joins aren’t possible due to different data structures.
  • When analyzing separate but related data sources (e.g., sales data from Excel + website traffic from Google Analytics).
  • When performance is an issue with large datasets (Blending processes only required data).

Note: Example: Blending "Sales Data" from MySQL and "Customer Feedback" from an Excel file to analyze sales performance and customer satisfaction together.

Comments

Popular posts from this blog

Tableau An Over View

Tableau Syllabus (APSCHE) and Model Paper

UNIT-5