This video demonstrates an ecommerce sales dashboard built in Tableau, using an Excel data source with 20 fields and 1200 rows. It explains four key parts: KPI line graphs (sales, profit, order quantity), a market share pie chart, a category sales bar graph, and a customer acquisition line graph. The dashboard helps analyze trends, market share, and customer acquisition to derive business insights.
A short editorial from the VEONIB team on why this content matters.
This video offers a practical walkthrough of building an ecommerce sales dashboard in Tableau, focusing on KPI trends, market share, and customer acquisition. It's a clear, project-based approach for analysts seeking to visualize sales performance.
What stands out is the use of interactive elements like market share filters, which enhance data exploration. SEONIB adds value by emphasizing how such dashboards can be optimized for search and AI-driven insights, turning visual data into actionable business intelligence.
Data analysts and BI professionals should watch this to learn Tableau dashboard design, then apply these techniques to their own sales data for deeper insights.
A visual dashboard that tracks ecommerce sales metrics like revenue, profit, and orders.
Year-to-date analysis of sales performance, comparing current year to previous year.
A data visualization tool used to create interactive dashboards and reports.
Key Performance Indicator trends shown over time to measure business performance.
Percentage of total sales in a market attributed to a specific segment or region.
The process of gaining new customers, often tracked monthly or by market.
What data source is used in the Tableau ecommerce sales dashboard?
The dashboard uses a pre-cleaned Excel file containing 20 fields and 1200 rows with customer order information, including categories, geography, profit, and margin.
What are the main KPIs displayed in the dashboard?
The main KPIs are sales, profit, and order quantity, each visualized as a line graph to show trends over time.
How does the dashboard compare current year sales to previous year?
It shows current year sales of 14.11 million with a growth of 5.04% compared to the previous year.
What does the pie chart represent in the dashboard?
The pie chart represents market share based on sales, highlighting that Europe and Latam dominate the sales share.
Can the market share segments be used as filters?
Yes, the market share segments in the pie chart can be used as interactive filters to analyze other parts of the dashboard.
What trends are shown in the category bar graph?
The bar graph shows sales trends by category, with camping & hiking and water sports growing, while fishing dropped significantly by 25%.
What does the customer acquisition line graph display?
It displays customer acquisition per month by market, allowing analysis of market-wise trends over time.
How can this dashboard help a business?
It provides insights into customer acquisition, order quantities, market shares, and sales trends, which can guide strategic decisions.