[go: up one dir, main page]
Scribd
Upload
3 views2 pages

Data Cleanup

The document outlines a data cleanup process that includes filtering out invalid data and transforming it for visualizations. It specifies four visualization tasks: a line chart for revenue over time, a bar chart for the top 10 countries by revenue (excluding the UK), a column chart for the top 10 customers by revenue, and a map chart for regional demand (also excluding the UK). It concludes with instructions for saving the work in Tableau and Power BI formats.

Uploaded by

maniraaz42
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views2 pages

Data Cleanup

The document outlines a data cleanup process that includes filtering out invalid data and transforming it for visualizations. It specifies four visualization tasks: a line chart for revenue over time, a bar chart for the top 10 countries by revenue (excluding the UK), a column chart for the top 10 customers by revenue, and a map chart for regional demand (also excluding the UK). It concludes with instructions for saving the work in Tableau and Power BI formats.

Uploaded by

maniraaz42
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Data Cleanup

1. Filter out invalid data:

o Apply a filter to exclude rows where Quantity < 1.

o Apply a filter to exclude rows where Unit Price < 0.

2. Data Transformation:

o Use calculated fields or transformation steps to ensure cleaned data is used in all
visualizations.

Visual Creation

Question 1: Time Series of Revenue for 2011

 Visualization Type: Line Chart

 Details:

o X-axis: Month (January to December 2011).

o Y-axis: Revenue (calculated as Quantity * Unit Price).

o Add markers for each month to show exact revenue values.

 Tab Name: Q1_Seasonal_Trends.

Question 2: Top 10 Countries by Revenue (Excluding UK)

 Visualization Type: Bar Chart

 Details:

o Exclude the United Kingdom (filter: Country != "United Kingdom").

o X-axis: Country (Top 10 by revenue).

o Y-axis: Revenue (primary) and Quantity Sold (secondary axis or label).

o Sort the countries by descending revenue.

 Tab Name: Q2_Top10_Countries.


Question 3: Top 10 Customers by Revenue

 Visualization Type: Column Chart

 Details:

o X-axis: Customer ID or Name (Top 10 by revenue, sorted in descending order).

o Y-axis: Revenue.

o Highlight the highest revenue-generating customers to emphasize priority targets.

 Tab Name: Q3_Top_Customers.

Question 4: Demand Across Regions (Excluding UK)

 Visualization Type: Map Chart

 Details:

o Exclude the United Kingdom (filter: Country != "United Kingdom").

o Show countries with demand intensity represented by color gradients or size of data
points.

o Metric: Total Quantity for each country.

 Tab Name: Q4_Regional_Demand.

Saving the Work

 Tableau Users: Save the file as .twbx (Packaged Workbook).

 Power BI Users: Save the file as .pbix.

Ensure each question has its own dedicated tab and name it appropriately.

You might also like