The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Currently building an employee salary dashboard
Right now I’m deep into the data preparation stage—cleaning and merging multiple tables using Power Query.
The biggest challenge so far has been structuring the data correctly so it actually supports meaningful analysis (not just visuals).
So far I’ve:
• Cleaned and transformed raw data
• Started merging tables & building relationships
• Begun shaping the data model
Next step: turning this into a dashboard that clearly shows salary trends and employee insights.
Sharing the process as I build—final version coming soon. 👀
Open to feedback or suggestions.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
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.
Impressive. Is possible to do something so advanced on Excel only, or there is some code for the dashboard, behind it?
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.
The dark theme with orange and teal contrast makes the KPIs pop instantly — Total Sales, Profit and Margin visible at a glance without any scrolling. Interactive filtering by month, city and category together is what separates a real decision tool from a static report. Did you build the interactivity using slicers or VBA?
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.
Trending
aivideo
AI video tools are moving at warp speed. Which ones are you experimenting with?
illustration
Handcrafted illustration is bubbling up across the web. What are you drawing lately?
aidesignflow
AI tools are redefining design work. What's your current workflow?
returntonature
Spring is a reset for creativity. What’s inspiring you outside the screen right now?
freelancerlife
Freelancer life is wins, pivots, and everything in between. What’s yours right now?