Back to datasets
Dataset assetOpen Source CommunityData VisualizationSales Analysis

Orders.xlsx

This Excel file contains a sales order dataset used for generating all visualisation charts. The data includes order date, ship date, customer, sales amount, profit and other fields. A Tableau workbook connects to this dataset to create visual insights into sales performance.

Source
github
Created
Sep 24, 2024
Updated
Sep 24, 2024
Signals
332 views
Availability
Linked source ready
Overview

Dataset description and usage context

Tableau Visualization Project Dataset Overview

Project Purpose

The project aims to demonstrate Tableau's core functionalities by creating a variety of tables and charts, providing hands‑on practice with real data manipulation and visualisation techniques.

File Structure

The repository contains the following files:

  • A1_Harshaanth_ThiyagarajaKumar.twbx: Tableau packaged workbook with multiple visualisations.
  • Orders.xlsx: Dataset used by the workbook, containing sales order records.
  • Assignment_1_Instructions.pdf: Detailed project instructions and visualisation requirements.

File Overview

  1. Tableau Workbook (A1_Harshaanth_ThiyagarajaKumar.twbx): The workbook includes 5 basic tables and 17 charts, organised into three main sections:

    • Section 1: Basic Tables

      1. Simple Table
      2. Highlight Table
      3. Cross Tab
      4. Multi‑Measure Table
      5. Single‑Measure Multi‑Function Table
    • Section 2: Basic Chart Types

      1. Vertical Bar Chart
      2. Horizontal Bar Chart
      3. Heat Map
      4. Pie Chart
      5. Tree Map
      6. Stacked Bar Chart
      7. Side‑by‑Side Bar Chart
      8. Side‑by‑Side Pie Chart
      9. Map
      10. Box Plot
      11. Scatter Plot
      12. Histogram
    • Section 3: Date‑Based Charts

      1. Continuous Line Chart
      2. Discrete Year‑over‑Year Line Chart
      3. Area Chart
      4. Dual Line Chart (Separated)
      5. Dual Axis Synchronized Line Chart

    Each worksheet follows the specifications in the PDF and satisfies the required visualisation deliverables.

  2. Excel Dataset (Orders.xlsx): Contains sales order records used to generate all visualisations. Fields include order date, ship date, customer, sales amount, profit and other relevant attributes. The Tableau workbook connects to this file to produce visual insights into sales performance.

  3. Project Instructions (Assignment_1_Instructions.pdf): Provides detailed guidelines for the assignment, listing the required tables and charts. The project is divided into three parts:

    • Part 1: Basic Tables
    • Part 2: Basic Chart Types
    • Part 3: Date‑Based Chart Types

    Each part contains multiple tasks designed to help users become familiar with Tableau's various visualisation capabilities.

Need downstream help?

Pair the dataset with AI analysis and content workflows.

Once the source passes your review, move straight into summarization, transformation, report drafting, or presentation generation with the JuheAI toolchain.

Explore AI studio