•Developed dynamic Power BI dashboards to address challenges faced by Employees due to Indian managers, enhancing data-driven decision-making.•Created comprehensive Excel dashboards to analyze and visualize company sales trends, contributing to strategic planning initiatives.•Successfully tackled real-world business problems through well-structured assignments, overcoming challenges posed by team dynamics and managerial feedback.•Gained hands-on experience in formulating solutions for complex business scenarios, leading to a deeper understanding of problem-solving methodologies.•Navigated through interview preparation by mastering a range of frequently asked questions, expanding my knowledge and boosting my self-assurance