Financial Dashboard  – Finance Domain

I crafted a dynamic finance dashboard in Power BI for enhanced data visualization, highlighting key financial metrics such as an income of Rs 3M, expenses of Rs 1M, savings of Rs 2M, a monthly expense rate of 2%, and a savings rate of 64%.

Cars Supply Chain Management

I executed a car supply chain analytics project using Python for data extraction and cleaning, performed data analysis with Pandas, and created impactful Power BI visualizations of sales by shipping modes and customer insights.  

Income Statement – Finance Domain

Developed a Power BI dashboard to effectively present income statements, including revenue, expenses, and net income. Implemented % Change and Gross Profit metrics, showcasing strong financial analysis skills. Used graphs to highlight trends, enhancing decision-making with key insights over time.  

HR Analytics – HR Domain

Created an HR Analytics Dashboard to monitor vital metrics like employee attrition, average tenure, and job satisfaction. Employed advanced data visualization to provide insights into attrition trends by age group, tenure, and educational background, supporting strategic HR planning.

Sales Insights  

I enhanced data quality and insights through advanced SQL data analysis and developed a Power BI sales dashboard to facilitate data-driven decision-making. The dashboard featured dynamic visualizations illustrating sales trends and top business categories.

SQL Sales Analysis

The project delved into targeted sales analysis, spotlighting transaction patterns and specific criteria, quantifying January 2024 sales for individual performance evaluation through MySQL queries, and pinpointing the top-selling product to unveil market trends and product popularity insights.