Project Details

In this project, I created a sales report using Excel pivot tables to help firms discover effective consumer discounts, streamline negotiations, and identify prospective expansion opportunities in promising countries. The report provides actionable insights and strategic recommendations, allowing firms to enhance sales methods, improve customer satisfaction, and increase revenue.

Skills acquired:
1. Pivot Table 
2. Power Query
3. Basic DAX.
4. Conditional formatting.
5. Report beautification
6. Sales Domain Metrics

This project serves as a toolkit, providing firms with the resources and information they need to monitor, evaluate, and improve their sales efforts. Businesses may discover new opportunities, create growth, and maintain competitiveness in today's dynamic market landscape by analyzing sales data.

Project Details

The objective of this project is to create a single report that the executive team, sales, marketing, and finance departments can all use. The following is highlighted:

Steady Data Modeling
2. Human-centered report design
3. Signable Knowledge

The following are the things this project taught me.

1. Basic and Advanced Operations for Power Query
2. Data Cleaning and Analysis
3. Simple and intricate DAX formulas
4. Data modeling with more than ten tables
5. Selecting appropriate images and layout
6. Design principles for dashboards
7. Making use of bookmarks
8. Setting up the Power BI service
9. Implementing Stakeholder Feedback
10. Metrics related to sales, marketing, finance, and supply chain.

Live Interactive Dashboard

Project Details

1. As a data analyst, I have been tasked with completing the following task using sample data and a mock-up dashboard.

• Create the metrics according to the metrics list.
• Create a dashboard according to the mock-up provided by stakeholders.
• Create relevant insights that are not provided in the metric list/mock-up dashboard.

2. Key Learning: -

• Making decisions based on data is essential for increasing revenue and reclaiming market share.
• Third-party knowledge offers new viewpoints and ideas to promote company expansion.
• Decision-making is simplified by the real-time visibility provided by effective dashboards and visualization.
• Revenue optimization and ongoing improvement are made possible by metrics and performance monitoring.
• Data insights have a favorable effect on both visitor satisfaction and revenue growth.
• Adaptation and ongoing development are necessary to maintain competitiveness.

Live Interactive Dashboard

Project Details

I managed ad hoc requests for consumer goods data for AtliQ Hardware, a leading Indian computer hardware manufacturer with a global presence. The objective was to utilize Power BI for creating visualizations and SQL for addressing business queries.

Project Outcomes:

- Identified key markets in the APAC region.
- Revealed a 36.33% increase in unique products.
- Provided detailed segment-wise product counts.
- Offered insights into manufacturing costs.
- Generated comprehensive reports on sales and seasonal patterns.

Technical Skills:

Power BI expertise in creating interactive visualizations and reports.
Advanced data modeling and analysis.
Proficiency in SQL querying and data manipulation.

Soft Skills:

Analytical thinking and problem-solving.
Attention to detail.
Effective communication of data insights.
Critical thinking.