edSlash - Let's Build a Better Future, Together
edSlash / Assignments TABLEAU PRACTICE PROJECT
Guided analytics project

Mobile Sales
Analytics

Transform raw mobile sales transactions into meaningful business insights. Analyse revenue, customer demographics, regional performance and purchasing patterns using Tableau.

Intermediate 60–90 Minutes Tableau 100 Points
Explore Challenges → ↓ Download Dataset
Project overview

Your analytics challenge

1,000Transactions
11Data fields
11Core tasks
3Bonus tasks
01 / Assignment landing page

Business Scenario

Understand the business problem before beginning your analysis.

Your Role

You are a Data Analyst working for a mobile phone retail business. Management wants to understand overall sales performance, identify high-performing locations, analyse customer purchasing patterns and evaluate payment preferences.

Your responsibility is to analyse the supplied dataset and build an interactive Tableau dashboard that communicates meaningful business insights.

Learning Objectives

  • Build KPI calculations.
  • Aggregate business measures.
  • Compare categorical dimensions.
  • Analyse time-based trends.
  • Create calculated fields.
  • Design interactive dashboards.

Software Required

Tableau Desktop or Tableau Public.

Estimated Duration

60–90 minutes for core tasks.

Difficulty Level

Intermediate · Basic Tableau knowledge recommended.

02 / Dataset explorer

Explore the Dataset

Understand the available fields and inspect sample records before connecting the CSV to Tableau.

Mobile Sales Dataset

CSV · 1,000 Rows · 11 Columns
↓ Download CSV
1,000Records
11Columns
2024Dataset year
0Missing values

Data Dictionary

TransactionIDUnique transaction identifier
DateTransaction date
MobileModelMobile product model
BrandMobile brand
PriceProduct price
UnitsSoldQuantity sold
TotalRevenueRecorded transaction revenue
CustomerAgeCustomer age
CustomerGenderCustomer gender
LocationTransaction location
PaymentMethodPayment method

Sample Records

Transaction IDDateMobile Model BrandPriceUnits RevenueAgeGenderLocationPayment
79397f68...2024-01-06directionGreen Inc1196.958528002.8032FemalePort ErikOnline
4f87d114...2024-04-05rightThomas-Thompson1010.34642378.8255FemaleEast LindaCredit Card
6750b7d6...2024-02-13summerSanchez-Williams400.809531322.5657MaleEast AngelicastadOnline
7da7de95...2024-04-17keepGreer and Sons338.607931159.7546MaleEast KevinCash
469044af...2024-06-02optionBrown and Sons839.794111523.3638MaleNew LindaboroughOnline
Showing 5 sample records. Download the CSV for the complete dataset.
Data Quality Note: Brand and Location have very high cardinality (980 unique brands and 963 unique locations). Use Top 10 filters for readable comparisons. Also, TotalRevenue does not equal Price × UnitsSold in the supplied records. Use the recorded TotalRevenue field for the required revenue analysis.
03 / Guided challenges

Complete the Analysis

Expand each task to view its requirements. Use the hints when necessary and track your progress as you work.

Part A — KPI Development

0 / 6
1. Total Revenue GeneratedCalculate overall sales revenue.
5 Points⌄

Calculate the sum of TotalRevenue to measure the overall sales performance.

  • Create a KPI card.
  • Format the value as currency.
  • Use SUM(TotalRevenue).
Drag TotalRevenue into the view, confirm aggregation is SUM, and display it using a Text mark.
2. Total Units SoldMeasure total quantity sold.
5 Points⌄

Calculate the sum of UnitsSold across all transactions.

  • Display total units as a KPI.
  • Use a whole-number format.
Drag UnitsSold into the view and set the aggregation to SUM.
3. Average Price of MobilesEvaluate the average recorded price.
5 Points⌄

Calculate the average of Price to understand the typical product price point.

  • Display average price as a KPI.
  • Format to two decimal places.
Drag Price into the view and change its aggregation to AVG.
4. Total Revenue by BrandCompare brand-level performance.
5 Points⌄

Aggregate TotalRevenue by Brand.

  • Sort brands by revenue descending.
  • Display the Top 10 brands.
  • Include labels or informative tooltips.
Place Brand on Rows and SUM(TotalRevenue) on Columns. Sort descending and apply a Top 10 filter using SUM(TotalRevenue).
5. Average Customer AgeUnderstand customer demographics.
5 Points⌄

Calculate the mean of CustomerAge.

  • Display average customer age.
  • Use an appropriate number format.
Drag CustomerAge into the view and change its aggregation to AVG.
6. Sales by GenderCompare revenue and units by gender.
5 Points⌄

Group sales by CustomerGender and compare total revenue and/or units sold.

  • Include Female, Male and Other.
  • Clearly identify the measure being compared.
Place CustomerGender on Rows and SUM(TotalRevenue) or SUM(UnitsSold) on Columns.

Part B — Visualization Challenges

0 / 5
7. Revenue by LocationIdentify high-performing areas.
8 Points⌄

Create a bar chart or map showing SUM(TotalRevenue) grouped by Location.

  • Rank locations by revenue.
  • Display the Top 10 locations.
  • Verify geographic roles if using a map.
Place Location on Rows and SUM(TotalRevenue) on Columns. Sort descending and apply a Top 10 filter.
8. Top 10 Highest Revenue TransactionsIdentify the largest transactions.
8 Points⌄

Sort transactions by TotalRevenue descending and display the 10 highest-revenue transactions.

  • Use TransactionID as identifier.
  • Show revenue values clearly.
  • Use a horizontal bar chart.
Place TransactionID on Rows and SUM(TotalRevenue) on Columns. Apply a Top 10 filter using revenue.
9. Sales Trend Over TimeObserve revenue patterns.
8 Points⌄

Build a line chart plotting SUM(TotalRevenue) over Date.

  • Choose an appropriate date granularity.
  • Use a chronological date axis.
  • Add informative tooltips.
Place Date on Columns and SUM(TotalRevenue) on Rows. Change Marks to Line and select Month or another suitable date level.
10. Revenue by Payment MethodAnalyse payment preferences.
8 Points⌄

Create a pie or donut chart showing each PaymentMethod's contribution to total revenue.

  • Use SUM(TotalRevenue).
  • Show percentage of total.
  • Include readable category labels.
Place PaymentMethod on Colour and SUM(TotalRevenue) on Angle. Use Quick Table Calculation → Percent of Total for revenue share.
11. Revenue by Gender and Age GroupCompare demographic segments.
8 Points⌄

Create age groups and display revenue by gender within each group using a stacked bar chart.

  • Below 30: CustomerAge < 30
  • 30–50: CustomerAge between 30 and 50, inclusive
  • Above 50: CustomerAge > 50
  • Use SUM(TotalRevenue) and CustomerGender as Colour.
Create a calculated field called Age Group using IF / ELSEIF conditions. Place Age Group on Columns, SUM(TotalRevenue) on Rows and CustomerGender on Colour.
0 / 11 Tasks Completed
Progress is saved in this browser.
04 / Advanced challenges

Go Beyond the Basics

Optional challenges for learners who want to investigate the dataset more deeply.

BONUS 01 · DATA QUALITY

Investigate Revenue Consistency

Compare TotalRevenue against Price × UnitsSold. Quantify the differences and explain the implications.

BONUS 02 · DEEPER ANALYSIS

Brand and Model Drill-down

Create a Brand-to-MobileModel hierarchy. Add a Top N parameter for dynamic rankings.

BONUS 03 · INTERACTIVITY

Dynamic KPI Selector

Build a parameter-driven selector to switch between Revenue, Units Sold and Average Price.

05 / Final project requirements

Build Your Final Dashboard

Combine your analysis into a polished, interactive dashboard for business stakeholders.

Expected Dashboard Layout

Use this layout as inspiration. You may create your own design.

Mobile Sales Performance Dashboard

Sales Overview · Customer Insights · 2024
Total RevenueSUM(TotalRevenue)
Units SoldSUM(UnitsSold)
Average PriceAVG(Price)
Average AgeAVG(CustomerAge)
Sales Trend Over Time
Revenue by Payment Method
Revenue by Location · Top 10
Revenue by Gender & Age Group

Dashboard Requirements

01. KPI SummaryDisplay key business metrics prominently at the top.
02. Consistent DesignUse readable labels and consistent colours.
03. Interactive FiltersInclude Date, Brand, Gender, Location and Payment Method.
04. Useful TooltipsShow meaningful values and additional context.
05. Dashboard ActionsEnable chart selections to filter related views where appropriate.
06. Professional PresentationUse a clear title and logical layout.
Submission Requirements:
1. Tableau workbook (.twb or .twbx).
2. Dashboard screenshot or PDF export.
3. Three to five business insights supported by your analysis.

Evaluation Rubric

CriteriaAssessmentPoints
KPI and Business AnalysisCorrect calculations and comparisons30
Visualization AccuracyChart selection, sorting and labels40
Dashboard DesignLayout and readability15
Business InsightsEvidence-based observations15
Total100
edSlash · Learn by building. Tableau Practice Assignment · Mobile Sales Analytics

Post your screenshot on LinkedIn with the #TableauwithedSlash and tag @edslash and @tableau.

Talk to our Industry Experts for Career Counselling

Company

About
Gallery
Careers
Contact
Hire from edSlash

Platform

Take Quiz
CV/Resume Review
Intern with Us
Leetcode Challenge
Verify Certificate

Resources

Learn Python
Python Projects
EDA Projects
Courses
#LearnwithAnalogies

Get in touch

+91-9354328855

info@edslash.com
Privacy Policy
Cookie Policy
Terms of Service
Refund Policy

© 2021 edSlash. All Rights Reserved.