1) Interactive Microsoft Excel Dashboard
- Successfully developed a visually appealing and dynamic Excel dashboard, comprising structured layouts, insightful pivot tables, diverse charts including KPIs, combo chart, and dynamic pivot table slicers, resulting in a 25% improvement in data accessibility and decision-making efficiency for stakeholders.
- The dashboard facilitated real-time monitoring of key performance metrics, enabling swift and informed decision-making processes.
2) Data Visualization in Tableau
- Leveraged Tableau to create an insightful data visualization project exploring global happiness metrics.
- By analyzing and visualizing complex datasets, the project offered comprehensive insights into factors influencing societal well-being worldwide.
3) Dataset Cleaning Using Microsoft Excel
- Conducted comprehensive data cleaning on a diverse movie's dataset, employing Excel to ensure data integrity. Activities included column fitting, standardizing missing values, space removal, duplicate removal, and consistent formatting.
- The meticulous data cleaning process laid a solid foundation for reliable analysis and decision-making, enhancing the overall quality and reliability of insights derived from the dataset.