How itstheprashant/sales-customer-dashboard works
Project type and high-level purpose
• This is a Business Intelligence/data-visualization project built in Tableau Desktop, published to Tableau Public.
• Purpose: ingest static CSV datasets, build interactive dashboards (Sales & Customer), and deliver them to business users for KPI tracking and customer insights.
File structure
• Datasets/ : Four CSV files (Orders, Customers, Products, Location).
• Requirements for Dashboard.pdf : Functional/visual requirements.
• README.md : Documentation & links.
Extract architectural insights from README
• Data source relationships (Orders↔Customers↔Products↔Location).
• Two dashboards (Sales, Customer) sharing the same data model.
• Interactive filters (Year, Category/Sub-category, Region/State/City).
• Deployment: published to Tableau Public.
Main components & interactions
a. Data Layer
b. Tableau Data Model
• Shows joins/relationships between the four tables.
c. Dashboard Layer
• Two dashboard modules:
• Sales Dashboard
• Customer Dashboard
d. Interactivity Layer
• Filters & parameters (Year selector, Category/sub-category, Region/state/city).
e. Presentation/Consumer Layer
• Tableau Public (hosted web UI)
• End users (Executives, Sales Managers, Marketing team)
f. External Services
• Tableau Public server (for hosting).
• Web browser (user interface).
Architectural patterns & design principles
• Star schema–style data model within Tableau.
• Layered architecture: Data → Data Model → Visualization components → Presentation to end users.
• Re-use of data source for both dashboards to ensure consistency.
• Parametrization & filtering for dynamic slicing of the same data.
Relevant technologies/frameworks
• Tableau Desktop (& Tableau Public)
• CSV (flat-file data stores)
• Calculated fields, parameters, filters (Tableau features)
• Possibly an external data-prep tool (if used) or manual CSV maintenance.
1. Layout the Data Layer on the left.
2. Center the Tableau Data Source block showing table joins.
5. To the far right, illustrate Tableau Public and connect dashboards → Tableau Public.