Group your data visually.

A dashboard that provides a dynamic slice-and-dice overview of an organization's workforce, including departments, absences, and educational credentials.

Excel assignment covering conditional formatting, formulas, PivotTables, and PivotCharts (Due: 03-06-2021)

Analytics in excel

Developed an interactive Excel dashboard to analyze global coffee shop sales across multiple regions. Leveraged Power Query for data transformation and Power Pivot for calculating key KPIs including sales, profit, and margin metrics. Designed a visually compelling dashboard with slicers, gradient formatting, and dynamic pivot charts.

Performed E-commerce Sales Analysis to identify trends, optimize sales, and improve decision-making. Analyzed customer patterns, seasonal trends, and product performance using Python, SQL, and Power BI. Delivered actionable insights to enhance revenue, streamline inventory management, and boost customer engagement.

This project utilizes Excel tool like Pivot Tables to analyze sales data and generate insights. It provides actionable recommendations for optimizing sales, customer discounts, and market expansion, helping drive informed business decisions.

Using excel to analyze crowdfunding data

Assessed historical shipping data for a shipping company selling products and shipping them to its customers' destinations to determine future shipping strategies.

This project is guided by Alex the Analyst

HR Dashboard using Excel with power-query and powerpivot

📦 Sales & Logistics Optimization: Analyzed sales, returns, and shipping costs to enhance profitability and operational efficiency. Identified trends, minimized losses, and optimized pricing strategies using Excel (Pivot Tables, Dashboards)