Nikhil Mishra
Data analyst building Excel and Power BI dashboards
New to Contra
Nikhil is building their profile!
Sales Analytics Dashboard (Power BI)
Interactive sales analytics dashboard built in Microsoft Power BI to monitor revenue performance, profitability, and product trends.
Key insights included:
• Total revenue, profit, cost, and margin KPI tracking
• Monthly sales performance and trend analysis
• Best-selling products and most profitable categories
• Sales performance by city
• Interactive filtering by product, category, and location
This dashboard enables businesses to quickly identify top products, evaluate profitability, and monitor sales trends across regions.
Tools used: Microsoft Power BI, data modeling, and data visualization.
3
32
Sales Performance Dashboard (Excel)
Interactive Excel dashboard built to analyze sales performance, product profitability, and regional trends.
Key features:
• Total sales, total profit, and margin KPI tracking
• Monthly sales and profit trend analysis
• Sales performance by product category
• City-level sales comparison
• Top performing products analysis
• Interactive filtering by month, city, and category
This dashboard helps businesses quickly understand revenue performance, identify profitable products, and monitor sales trends.
Tools used: Microsoft Excel, pivot tables, and data visualization.
3
45
Service Performance & Cost Optimization Dashboard (Power BI)
Built an interactive dashboard in Microsoft Power BI to analyze service operations, costs, and performance trends.
Key insights included:
• Work order tracking and completion performance
• Total cost, net loss, and cost per work order analysis
• Monthly revenue vs cost trends
• Technician workload distribution
• Geographic performance visualization across districts
This dashboard helps businesses quickly identify operational inefficiencies, cost drivers, and performance patterns to support better decision-making.
Tools used: Microsoft Power BI, data modeling, and data visualization techniques.
4
51
Service Performance & Cost Optimization Dashboard
This dashboard analyzes service performance, operational costs, and revenue trends to help businesses understand profitability and efficiency.
Key features:
• KPI overview including total cost, net loss, and work orders
• Monthly revenue and cost trend analysis
• Service efficiency and order performance metrics
• Geographic insights through a US performance map
• Technician workload and top performer tracking
Tools used:
Excel for data processing and dashboard design.
Purpose:
This dashboard helps businesses quickly identify cost drivers, performance trends, and operational inefficiencies.
2
51