Data isn’t just numbers — it’s stories waiting to be told 📊✨.
I’ve spent months exploring real-world datasets and building impactful dashboards using Power BI, Excel, and SQL to turn raw information into meaningful insights.
Here are my top 4 portfolio projects that truly reflect my journey as a Data Analyst — from HR insights to restaurant analytics, pandemic visualization, and mobile sales trends.
By Nivesh Bansal: Portfolio | Linkedin | GitHub
💼 1. IBM HR Dashboard — Employee Insights at a Glance
GitHub: View Project on GitHub →
Description:
A complete HR analytics dashboard that helps companies track key employee metrics like department-wise headcount, attrition rate, gender ratio, performance, and salary distribution.
🧰 Tech Stack:
Power BI, Excel, DAX, Data Modeling
📂 Data Source:
HR Analytics dataset (Kaggle / simulated employee records)
💡 Highlights:
- Gender & department-wise employee distribution
- Attrition & satisfaction analysis
- KPI cards for HR decisions
- Trend insights for hiring and retention
🍽️ 2. Zomato Dashboard — Restaurant Business Analytics
GitHub: View Project on GitHub →
Description:
This Power BI dashboard visualizes restaurant data from Zomato, analyzing key factors like cuisine trends, restaurant ratings, price levels, and city-wise performance.
🧰 Tech Stack:
Power BI, Excel, Power Query, DAX
📂 Data Source:
Public Zomato dataset from Kaggle
💡 Highlights:
- City-wise restaurant distribution
- Top cuisines & rating trends
- Cost vs. rating correlation
- Insights for restaurant business strategy
🦠 3. COVID-19 Analytics Dashboard — Tracking the Global Pandemic
GitHub: View Project on GitHub →
Description:
A data-driven visualization of the global COVID-19 situation — showing total cases, recoveries, deaths, and vaccination progress across countries.
🧰 Tech Stack:
Power BI, Excel, Power Query, API data import
📂 Data Source:
COVID-19 World Data (Johns Hopkins, WHO, or Kaggle)
💡 Highlights:
- Country & continent-wise comparison
- Real-time refresh from API
- Trend lines for daily new cases
- Dynamic slicers for analysis by region
📱 4. Mobile Sales Dashboard — Business Performance Tracking
GitHub: View Project on GitHub →
Description:
A sales performance dashboard analyzing smartphone sales trends, top brands, revenue, and customer ratings.
🧰 Tech Stack:
Power BI, Excel, SQL, DAX
📂 Data Source:
Mobile Sales dataset from Kaggle / Google Sheets
💡 Highlights:
- Region & brand-wise sales
- Revenue and profit margin analysis
- Year-over-year comparison charts
- KPI indicators for business growth
🌟 Final Thoughts
Each of these projects helped me explore different aspects of business intelligence — from people analytics to real-time data visualization.
If you’re a data enthusiast, feel free to explore the GitHub repositories, try the dashboards, and maybe even fork them to learn from the logic and visual design.
Top comments (0)