Project Details

This project tackles AtliQ Technologies’ data analysis challenges after facing a significant financial loss in Latin America, due to inefficiencies in Excel-based reporting. The goal was to implement Power BI for enhanced decision-making across key departments: Finance, Sales, Marketing, Supply Chain, and Executive teams. Using an extensive dataset (1.8M+ records), I created interactive Power BI reports to track KPIs such as Profit & Loss, Net Sales trends, Customer and Product performance, Forecast Accuracy, and more. I employed a snowflake schema for efficient data modeling, and tools like SQL, DAX Studio, and ChatGPT for analysis and troubleshooting. The project enables AtliQ to make data-driven decisions, optimize operations, and improve financial performance. Special thanks to Dhaval Patel and Hemanand Vadivel for their mentorship throughout the journey.

Live Interactive Dashboard

Project Details

In this project, I analyzed HR data to identify trends and areas for improvement in gender diversity, specifically at the executive management level. Using Power BI, I designed and developed interactive dashboards to visualize key performance indicators (KPIs) related to gender balance, enabling clear insights into the organization's diversity landscape. These visualizations were tailored for senior leadership, providing them with a comprehensive view of gender-related metrics across different departments and roles. I communicated key findings and actionable insights via concise email reports, helping leadership make informed decisions to refine diversity strategies. The project emphasized a data-driven approach to support efforts aimed at achieving gender parity in leadership positions, demonstrating proficiency in both analytical and communication skills. The initiative contributed to advancing diversity and inclusion efforts by equipping senior leadership with the tools needed to im

Live Interactive Dashboard

Project Details

In this project, I conducted an in-depth analysis of Swiggy Instamart's sales, customer satisfaction, and inventory distribution using Power BI. The goal was to uncover key insights to drive optimization across various business areas. I focused on key performance indicators (KPIs) such as total sales, average sales, number of items sold, and customer ratings.

I created dynamic dashboards and visualizations to evaluate how factors like fat content, item type, outlet size, and location impact sales. Key charts included donut charts for fat content, bar charts for item performance, and funnel maps for regional sales distribution. Additionally, I analyzed sales trends across different outlet types and sizes to help Swiggy Instamart make informed decisions regarding inventory management, outlet expansion, and targeted marketing efforts.

This project provided actionable insights for enhancing operational efficiency, customer satisfaction, and overall business performance.

Live Interactive Dashboard

Project Details

AtliQ Hardware faced challenges in gaining sufficient insights for data-informed decision-making. To address this, I leveraged SQL for extensive data analysis, working with approximately 1.43 million records across multiple tables. By utilizing advanced SQL techniques such as joins, user-defined functions, and window functions, I was able to efficiently extract valuable insights from the data.

Project Details

AtliQ Hardware faced challenges in gaining sufficient insights for data-informed decision-making. To address this, I leveraged SQL for extensive data analysis, working with approximately 1.43 million records across multiple tables. By utilizing advanced SQL techniques such as joins, user-defined functions, and window functions, I was able to efficiently extract valuable insights from the data.