Home Assignment 2 Total Points 100 Due Date By 11:30 Pm On M
Home Assignment 2 Total Points 100due Date By 1130 Pm On March 8
Based on the data provided in D2L (USA.xlsx), provide executive team with visualized data to help them with decision-making. [Please submit the link of your tableau dashboard not the complete tableau file. Please review the lecture video on how to create this link.]
Executive Overview
1. Identify key measures and provide aggregate values for each of them.
2. Create and calculate profitability KPI; show the contribution of each product line for the generated profit.
3. Identify the profitability of the company across different states; determine if they are above or below the benchmark.
4. Analyze the performance of each product line in terms of sales.
5. Find the most profitable products sold by the organization.
6. Identify products that are high in sales quantity and profitable to the company.
7. Compare all products based on profitability KPI and the number of quantities sold.
8. Find the product that provides high profit amount irrespective of profit ratio.
Target Market/Customers
Using data on the most profitable products, identify target customer profiles/market based on attributes such as marital status, gender, age group/generation, and commute distance.
Grading Criteria
Your grade will be based on:
- Visualization answers to at least 7 out of 11 questions (45 points)
- Interactive dashboards including actions and filters (50 points)
- Explanation of each visualization (5 points)
Problem Description
The current infotainment systems are often third-party products that lack optimal design and user experience. First-party infotainment systems, which are integrated into expensive vehicles, typically offer better design. The goal of this project is to develop a third-party infotainment system that emphasizes user experience for drivers.
User Requirements
The system targets car drivers, adopting best practices and standards derived from existing systems and course learnings. The interface must be accessible, simple, and safe for use while driving. Considerations include large icons and text, minimal input requirements, adaptive brightness, and safe auditory cues. The system should also include a virtual assistant for hands-free operation and should offer optimized interaction based on whether the vehicle is moving or parked.
UI Environment and Task Analysis
The UI is designed for inside the vehicle, primarily used when driving or parked. The environment is quiet and clean, with the driver expected to be well-maintained for optimal interaction. The system must adapt to day/night cycles, ensuring visibility and safety. Key tasks include making phone calls, playing music, using map navigation, and viewing vehicle information like date and time. Task flows are streamlined for minimal distraction, employing visual and voice inputs to enhance safety and usability.
Paper Prototype
A paper prototype has been created to visualize the system navigation flow, starting from loading screens, with options for navigation, calls, music, settings, and information. This helps refine the design prior to development, ensuring alignment with target user needs and safety considerations.
Paper For Above instruction
In this project, the focus is on developing a comprehensive data visualization dashboard to support strategic decision-making for a company's executive team. The provided dataset in "USA.xlsx" contains sales, product, customer, and geographical information that can be leveraged to generate insights. Effective visualization is critical for enabling quick understanding of key business metrics and identifying areas for improvement.
Firstly, key measures such as total sales, total profit, total number of units sold, and average product price are central to evaluating business performance. Aggregating these measures across relevant dimensions like product categories and regions allows stakeholders to understand overall trends. For instance, total sales and profit margins can be visualized via bar charts or KPI cards on a dashboard.
Next, profitability KPIs at the product line level reveal contribution margins and help determine which segments are most lucrative. Calculating contribution margins involves subtracting costs from revenues for each product line, then visualizing this data using waterfall charts or grouped bar charts. These visualizations highlight profit drivers and areas requiring cost adjustments.
Furthermore, analyzing profitability across states informs regional performance, helping identify underperforming regions or markets that surpass benchmarks. A choropleth map can display profit margins by state, with color gradients representing profitability levels relative to a defined benchmark. Such geographic analysis enables targeted regional strategies.
Assessing product line performance involves comparing sales volumes and profit contributions. A scatter plot or bubble chart illustrating sales quantity versus profit contribution allows identification of high-volume, high-profit products. This visual aids in prioritizing inventory, marketing, or expansion efforts.
Identifying the most profitable products provides insight into product portfolio optimization. Boxplots or Pareto charts can emphasize top performers by profit amount, helping prioritize features or identify potential candidates for discontinuation of less profitable items.
Combining sales volume and profitability reveals products that are both high in volume and profit, guiding cross-selling and promotion strategies. A joint visualization, such as a matrix or dual-axis chart, supports this analysis.
Calculating products’ profitability KPIs relative to sales volume facilitates comprehensive product evaluations. A comparative bar chart displaying profit per unit versus sales volume enables quick assessment of efficiency and profitability balance.
Finally, identifying products generating the highest absolute profit—regardless of profit ratio—pinpoints the most financially beneficial offerings. A simple ranking table or ordered list helps focus on high-value products.
Beyond product analysis, customer profiling based on demographic attributes enables targeted marketing. Using data from the most profitable products, customer segments are characterized by marital status, gender, age group, and commute distance. Visualizations like pie charts, histograms, and heat maps illustrate these profiles, supporting marketing strategies aimed at high-value customer segments.
For example, a demographic breakdown could reveal that most profitable customers tend to be middle-aged males living within a certain commute distance, informing tailored advertising campaigns or product features. Such insights contribute to a data-driven approach to market segmentation and outreach.
The implementation of an interactive Tableau dashboard enhances decision-making by allowing stakeholders to filter, drill down, and explore data dynamically. Incorporating actions such as hover-over details, clickable filters, and cross-highlighting ensures usability and depth of insights. These interactive features aid in rapid scenario analysis, hypothesis testing, and strategic planning.
In conclusion, the proposed visualization dashboard consolidates critical sales and customer data into an accessible, interactive platform. It addresses key questions related to product profitability, regional performance, and customer demographics, providing the executive team with actionable insights. By leveraging visual analytics, the organization can optimize product offerings, improve regional strategies, and target high-value customer segments effectively, ultimately driving growth and profitability.