Sales Dashboard – Project Details

CompanyTata Consultancy Services (TCS)
RoleDashboard Developer / Data Analyst
Duration3 Weeks
Skill LevelIntermediate
Tools UsedPower BI, SQL, Excel
DeliverablesSales dashboard, SQL scripts, data-cleaning workflows
Objective

Build a dynamic and interactive sales dashboard to visualize trends across regions, product categories, and customer segments — enabling faster insights and data-driven decision-making for management at TCS. This dashboard presents real-time performance metrics such as top-selling products, profit margins, regional sales comparisons, and time-based growth trends. Key features include interactive filters by geography, date range, and product lines, as well as KPI cards tracking ROI, revenue, and conversion ratios. Designed for clarity and usability, the dashboard empowers TCS leadership to monitor key indicators and uncover strategic opportunities across business units.

Key Challenges
  • Combining multiple inconsistent data sources
  • Delivering real-time insights with clean UI
  • Creating mobile-friendly views
Features
  • Top 10 products by profit and sales
  • Dynamic filters for date and category
  • Region-level comparison
Outcome

Delivered a clean, responsive dashboard that reduced reporting time by 65% and improved strategic decision-making across departments.