Bike Sales Dashboard - EXCEL DATA ANALYSIS
Tools Used: Microsoft Excel (Data Validation, Remove Duplicates, Pivot Tables, Pivot Charts, Slicers) Project Description: This project involved an end-to-end analysis of a bike sales dataset using Excel. I cleaned and prepared the raw data by removing duplicates and applying data validation, then built an interactive dashboard to visualize key customer demographics and purchasing trends. The dashboard enables dynamic filtering by marital status, education, and region to uncover actionable insights into bike-buying behavior.
Key Steps & Skills Demonstrated:
Data Cleaning: Used the Data Tools menu to remove duplicates and ensure data integrity
Data Quality: Applied Data Validation to maintain consistent data entry standards
Data Analysis: Created Pivot Tables to analyze customer income, age brackets, and commute distance
Data Visualization: Built interactive charts and implemented slicers for dynamic filtering
Dashboard Creation: Designed a user-friendly interface to present key business insights
==========================================================================================================================================
Personal Budget Tracker – Google Sheets
Tools Used: Google Sheets (Data Validation, Custom Formulas, Conditional Formatting, Charts, Pivot Tables)
Project Description: I developed a fully functional Personal Budget Tracker in Google Sheets to monitor income, expenses, and cash flow. The project features a transaction ledger with automated balance calculations and an interactive dashboard that visualizes spending patterns and financial health.
Key Features & Skills Demonstrated:
Data Integrity: Used Data Validation and Dropdown Lists for accurate, consistent data entry
Automation: Applied Custom Formulas for real-time calculations and balance tracking
Data Visualization: Created Charts and used Conditional Formatting to highlight key metrics
User-Friendly Design: Built an intuitive dashboard with filtered views and spending summaries
This project demonstrates practical skills in spreadsheet management, from basic data organization to advanced analysis and visualization.
==========================================================================================================================================
Data Professional Survey Breakdown (Power BI Project)
- Conducted an end-to-end analysis of a Data Professional Survey using Power BI, uncovering insights on salaries, job titles, and industry trends.
- Transformed raw data using Power Query, established table relationships, and created DAX measures for dynamic calculations.
- Designed interactive dashboards with conditional formatting, drill-downs, and visualizations (e.g., bar charts, slicers) to highlight: - Salary distribution by job title and country. - Programming language preferences and career difficulty perceptions. - Work-life balance and salary satisfaction metrics.
- Tools: Power BI, DAX, Power Query.
==========================================================================================================================================
Academic Stress Level Data Survey
