Tableau assingment

Overview:

A national company has been receiving customer complaints across a wide variety of products and services. To improve customer satisfaction and operational efficiency, the company needs an in-depth analysis of these complaints to identify patterns and actionable insights. Your task is to assist the company by creating an interactive Tableau dashboard and providing strategic recommendations based on your findings. Demonstrate original critical thinking and synthesis of ideas; reliance on AI-generated analyses is inappropriate and does not fulfill the requirements for graduate-level scholarship.

Background:

The company has provided a dataset containing information about customer complaints. This dataset includes various details such as the products involved, the nature of the complaints, how complaints were submitted, and the resolution provided. Your analysis will focus on uncovering trends, understanding customer priorities, and evaluating the companys responsiveness.

Dataset Description:

The dataset includes the following columns:

Customer ID: A unique identifier for each customer.
Product: The specific product associated with the complaint.
Product Category: The broader category of the product.
Issue: Description of the issue reported by the customer.
Consumer Disputed?: Indicates if the consumer disputed the resolution (Yes, No, or Pending).
Date Received: The date the complaint was received.
Date Submitted: The date the complaint was submitted by the consumer.
Submitted via: The channel through which the complaint was submitted (e.g., Website, Email, Phone).
Tags: Priority level or special conditions (e.g., High Priority, Escalated).
Timely Response?: Whether the company provided a timely response (Yes or No).
ZIP Code: Customers ZIP code.
Number of Complaints: Count of complaints submitted by the customer.
State: The state where the customer resides.
Company Response to Consumer: Outcome or resolution provided by the company.

Objectives:

Your goal is to analyze the dataset and provide actionable insights through an interactive Tableau dashboard. The final deliverable should help the company achieve the following:

Identify trends and patterns in customer complaints.
Understand which products and categories receive the most complaints.
Evaluate the effectiveness of the company’s responsiveness and resolutions.
Propose recommendations to enhance customer satisfaction.

Task:

Data Cleaning and Preparation:

Ensure data consistency and accuracy.
Handle missing values and correct any data inconsistencies.
Derive additional columns if needed.

Dashboard Design:

Design a dashboard that is clear, visually appealing, and easy to interpret, modeled after the example dashboard shown in the provided video.
Use appropriate chart types, colors, and labels to enhance readability.

Analysis and Insights:

Analyze the data and provide insights based on the visualizations.
Identify trends, patterns, and any notable observations from the data.

Presentation:

Prepare a brief report or presentation summarizing the findings.
Include a 20 – 25 minute presentation video where you walk through the workings of the dashboard and a brief summary of the analysis. The presentation should cover:
Overview of the Dashboard: Demonstrate the dashboard’s interactive features, functionality, and key insights.
Data Sources and Preparation: Explain the data cleaning and preparation steps and highlight key aspects of your analysis.
Detailed Walkthrough: Go through each visualization, explaining what it shows and why it is important.
Key Insights and Observations: Summarize the main findings and insights from the data.
Technical Aspects: Briefly discuss any technical challenges or interesting techniques used in creating the dashboard.

Supporting files: * Tableau dashboard file* Brief, 1-2 page executive report summarizing the findings

Submission: (submit all THREE items)

1. Tableau dashboard file

2. Prepare a brief executive report (1-2 pages) summarizing the findings.

3. Submit a video file demonstrating the dashboard’s interactive features, functionality, and key insights.

Any dashboard generated using AI will be marked zero.

Evaluation Criteria:

Accuracy of data cleaning and preparation.
Completeness and clarity of visualizations.
Creativity and effectiveness of the dashboard design.
Depth of analysis and quality of insights.
Overall presentation and communication, including the effectiveness of the recorded presentation video.

Requirements: as per question

WRITE MY PAPER

Comments

Leave a Reply Cancel reply