Project Details

In this endeavor, I crafted a sales analysis utilizing Excel pivot tables, aimed at empowering businesses to discern effective customer discounts, streamline negotiations with consumers, and pinpoint potential business expansion prospects in promising regions. The generated reports will furnish actionable insights and recommendations, enabling businesses to refine their sales strategies, amplify customer satisfaction, and optimize revenue streams.

Throughout this venture, I acquired proficiency in the following areas:

1. Pivot table manipulation
2. Utilization of Power Query
3. Basic understanding of DAX
4. Application of Conditional Formatting
5. Enhancing report aesthetics
6. Familiarization with sales domain metrics

Project Details

In this endeavor, the objective is to craft a comprehensive report tailored for stakeholders spanning sales, marketing, finance, and the executive team. Emphasis is placed on the following key aspects:

1. Robust Data Modeling
2. User-Centric Report Design
3. Drillable Insights

Throughout this project, I acquired proficiency in the following areas:

1. Power Query, encompassing both basic and advanced operations
2. Mastery of both fundamental and intricate DAX formulas
3. Data modeling involving amalgamation of 10+ tables
4. Selection of appropriate visuals and formatting techniques
5. Adherence to dashboard design principles
6. Utilization of bookmarks for enhanced navigation
7. Deployment on the Power BI service platform
8. Implementation of stakeholder feedback for refinement
9. Integration of sales, marketing, finance, and supply chain metrics.

Live Interactive Dashboard

Project Details

Analyzed a rich dataset to uncover insightful trends that could reshape our understanding of HR analytics. With carefully constructed measures such as average salary, month names, and year, the data now tells a compelling story about workforce dynamics.

Key findings include:
1. **Recruitment Channels:** Indeed emerges as the top platform for recruiters in selecting job applications, followed closely by LinkedIn and Google search.

2. **Salary Insights:** The Executive Office boasts the highest average salary, highlighting its critical role within organizational hierarchies.

3. **Departmental Analysis:** The Production department not only has the largest number of employees but also the most managers, indicating significant operational scale.

Live Interactive Dashboard

Project Details

- Developed multiple multifunctional dashboards to visualize survey data for CodeX, an imaginary food and beverage company specializing in soft drinks.
- Aimed to provide management with actionable insights for product improvement.
- Each dashboard delivers critical analytics in marketing, consumer behavior, and preferences etc.
- Designed a homepage with functional buttons and icons for easy navigation to other sections.

Live Interactive Dashboard

Project Details

The sales performance analysis reveals that a total of 2823 orders resulted in ₹10 million in sales, with Classic Cars leading the product categories, accounting for 56% of sales, followed by Vintage Cars at 27%. Sales are heavily concentrated in North America and Europe, with the USA being the top contributor, making up 51% of total sales, followed by Australia at 17%. The Euro Shopping Channel stands out as the top customer, contributing ₹912K, and the top 20 customers collectively account for ₹4.376M in sales. Shipped orders dominate, contributing ₹9.292M, but a significant portion of orders are still "In Process," "Cancelled," or "Disputed," highlighting areas for improvement. The dependency on a few key customers, like the Euro Shopping Channel, which alone accounts for 9% of total sales, suggests the need for customer base diversification. Recommendations include expanding market reach to underrepresented regions, reducing customer dependency, and optimizing order management.

Live Interactive Dashboard