Project Details

Within this initiative, I curated a comprehensive sales report utilizing Excel pivot tables. This tool serves as a cornerstone for businesses, facilitating the assessment of customer discounts, fostering effective negotiations, and pinpointing avenues for expansion in promising markets. The generated reports furnish actionable insights and strategic recommendations, equipping businesses to refine their sales strategies, elevate customer satisfaction levels, and maximize revenue streams.

Key Learning Points:

Mastery of Pivot Table functionality
Proficiency in Power Query for data manipulation
Introduction to DAX for analytical purposes
Implementing Conditional Formatting for data visualization
Enhancing report aesthetics for improved readability
Acquiring proficiency in Sales Domain Metrics analysis
This initiative endeavors to arm businesses with the essential analytical tools and insights necessary to monitor, evaluate, and optimize sales operations effectively.

Project video

Project Details

The project's core aim is to develop a comprehensive report catering to diverse stakeholders. It prioritizes:

1. Robust Data Model: Constructing a sturdy model to integrate and analyze varied datasets seamlessly.
2. User-Centric Design: Crafting an intuitive interface aligning with end-users' needs.
3. Drillable Insights: Enabling stakeholders to explore granular data through interactive functionalities.

Proficiencies gained include:

- Power Query for data preparation.
- DAX Formulas for insightful calculations.
- Complex Data Modeling for coherence and accuracy.
- Visual Selection and Formatting for enhanced comprehension.
- Dashboard Design Principles for actionable presentation.
- Bookmark Usage for intuitive navigation.
- Power BI Service Deployment for widespread accessibility.
- Stakeholder Feedback Incorporation for iterative enhancements.
- Metrics Mastery across sales, marketing, finance, and supply chain domains.

Project video

Project Details

Project Overview: Impact of 5G Launch

This Wavecon project analyzes the impact of the 5G rollout on our telecom client's performance metrics through a comprehensive dashboard. Key findings include:

1. **Revenue Boost**: 5G launch has significantly increased revenue, driven by customer acquisition and plan upgrades.
2. **ARPU Concern**: **Average Revenue Per User (ARPU)** is below target, needing strategic improvement.
3. **Top Plans**: Premium and unlimited 5G plans are highly successful, reflecting strong customer interest.
4. **Mid-Tier Plans**: Some mid-tier plans underperform, requiring reassessment and possible revision.
5. **5G Starter Plan**: Underperformance suggests potential discontinuation to optimize the portfolio.
6. **4G Plan Discontinued**: The **4G Basic Plan** has been discontinued due to the shift towards 5G.

This analysis highlights necessary strategic adjustments to enhance performance and optimize plan offerings.
Power BI
SQL
Excel
DAX Studio

Project video

Project Details

Utilized Power BI for a detailed analysis of Shield Insurance, examining revenue, customer behavior, city trends, sales modes, and age group dynamics. Produced a comprehensive report that informed strategic decisions and actionable recommendations. This work contributed to projecting an 8-10% revenue growth and enhancing market presence through data-driven insights.

Project video

Project Details

In the "Consumer Goods Domain" project, I analyzed the database of Atliq Hardwares to tackle their challenge of making data-informed decisions. I addressed ten ad-hoc requests to extract actionable insights.

My findings revealed a substantial increase in unique products, a dominant 'Notebook' segment, and a thriving 'Accessories' category. I also uncovered sales seasonality and highlighted the crucial role of the 'Retailer' channel.

Key takeaways included recognizing the transformative potential of data analytics for informed decision-making, understanding the dynamic nature of the consumer goods market, valuing product diversity, being aware of seasonality trends, and appreciating the importance of distribution channels in influencing sales.

This project significantly enhanced my skills in data analysis, problem-solving, and communication, contributing to my development as a data analyst.

Project video

Project Details

In this project, I conducted several operations to gain insights:

1. **Data Cleaning:** Handled missing values and outliers.
2. **Data Transformation:** Added occupancy percentage columns.
3. **Insights Generation:** Answered key questions such as:
- Calculated average occupancy rate by room type and city.
- Identified occupancy rates on weekdays vs. weekends.
- Analyzed revenue generated per city.
- Examined monthly revenue trends.
- Assessed revenue by booking platforms.

Project video