Mr. Ryan, the Head of HR, wanted a comprehensive and interactive dashboard to analyze the company’s employees. The goal was to answer key HR questions about: ✅ Employee demographics (race, education, age, gender) ✅ Workforce size, attrition rate, and hiring trends ✅ Performance review timelines and satisfaction ratings ✅ Groups most affected by attrition and potential retention strategies
This dashboard allows executives to filter by department, gender, age group, year, and attrition status, providing both a high-level overview and the ability to drill down into detailed insights for better decision-making.
🔗 [View the Full Interactive Report]
✅ Total Employees: 1,470
✅ Attrition Rate: 16.12% (highest in Sales – 20.63%)
✅ Majority of employees are 20–29 years old, with most resignations in this group.
✅ Employees without stock options are more likely to leave.
✅ White employees have the highest average salary ($115k), while "Other" group has the lowest ($101k).
📌 Introduce stock options or bonuses – Higher attrition among employees with no stock options.
📌 Enhance career growth for younger employees – Mentorship and training programs.
📌 Focus on Sales & HR departments – These teams have the highest attrition rates.
📌 Monitor job satisfaction closely – Self-rating and job satisfaction show downward trends.
The CEO of the Contoso e-commerce business needs a single interactive dashboard to understand the company’s sales performance and customer service efficiency. This dashboard helps them track revenue trends, see which products and campaigns bring in the most sales, and check if KPIs are being met. It also shows how well the customer service team is performing, who the top revenue clients are, and which open cases need attention so the company can improve client retention and satisfaction.
They want to:
See overall sales performance – how many opportunities are open, won, or lost, and whether revenue targets are being achieved.
Identify which products, campaigns, and regions bring the most revenue so resources can be focused effectively.
Understand deal win/loss factors – which discounts, campaigns, or sales reps lead to higher success rates.
Know who the top revenue-generating clients are so they can reward loyal customers and strengthen relationships.
Monitor customer service KPIs like satisfaction, escalation rate, SLA compliance, and resolution time.
Get visibility on open and high-priority cases to make sure issues are resolved quickly to keep customers happy.
This dashboard lets executives filter by sales owner, manager, region, or product category and get both a high-level overview and detailed insights to make better business decisions.
The dashboard answers key business questions for the CEO:
✅ How are sales performing over time?
✅ Which products and campaigns generate the most revenue?
✅ Are revenue KPIs being met by region, sales owner, and category?
✅ Which companies bring the most revenue (for client appreciation initiatives)?
✅ How is the customer service team performing in handling cases and inquiries?
Before you click on the link to my dashboard, I want to clarify this to you:
There are 2 charts in this report that cannot be published on the web version of Power BI, so I replaced them with static screenshots on the published link.
📥 For the best experience, I highly recommend downloading the .pbix file to explore the dashboard fully and interact with all visuals. ContosoDashboardFinal Thank you so much for checking out my work! :3
🔗 View the Interactive Dashboard
✅ Close % Rate: 64.5% with 12,346 total opportunities
✅ Revenue Trend: Highest revenue months were July 2020 ($1.6M) and Jan 2021 ($1.6M)
✅ Top Revenue Products: Design App ($6.1M), Stand-up Desk ($4.5M), and Tablets ($4.1M)
✅ Top Campaign Type: Email campaigns generated the greatest potential sales value ($3.3M)
✅ Top Clients: Abbott Inc. and Abercathy & Sons – high revenue contributors worth retention focus
✅ Customer Service KPIs: Avg customer satisfaction = 4.27, Escalation Rate = 16%, SLA Compliance = 76%
📌 Focus on High-Revenue Products: Design App, Stand-up Desk, and Tablets have the highest returns.
📌 Expand Email Marketing Campaigns: Email generates the highest potential sales value.
📌 Reward Top Clients: Provide loyalty rewards to high-value customers (Abbott Inc., Abercathy & Sons).
📌 Improve Customer Service Efficiency: Reduce resolution times (currently avg 76 mins) and escalation rates.
📌 Track Open Cases: Prioritize open and high-severity cases to improve client retention.
- Power BI Desktop & Power Query – Data cleaning and transformation
- DAX Measures – KPIs for revenue, close rate, and customer satisfaction
- Data Modeling (Star Schema) – Optimized for sales and customer service reporting
- Interactive Visuals – Drilldowns, filters, and key influencer analysis
📄 HR Attrition".pbix – HR Attrition Power BI dashboard file
📄 ContosoDashboardFinal".pbix – Contoso Sales Power BI dashboard file
📄 README.md – Project documentation
👤 Nathan Vu
🔗 LinkedIn Profile | Portfolio Website