Project Details

In this project, I crafted a comprehensive sales report using Excel pivot tables. This tool helps businesses determine optimal customer discounts, support negotiations with clients, and identify potential growth areas in promising countries. The resulting reports provide actionable insights and recommendations to refine sales strategies, improve customer satisfaction, and boost revenue.

Throughout this project, I mastered the following skills:

1. Pivot tables
2. Power Query
3. Basic DAX
4. Conditional Formatting
5. Report Styling
6. Sales Metrics Analysis

The main goal of this project is to give businesses the necessary tools and insights to track, analyze, and enhance their sales operations. By leveraging sales data, businesses can discover new opportunities, foster growth, and remain competitive in a fast-paced market.

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Project Details

Conducted a detailed SQL-based analysis on AtliQ company's hardware products .
The analysis included insights on:

Product Performance:
Evaluated fiscal year-wise performance for each product.
Compared performance across different regions.

Market Share Analysis:
Identified the company’s market share in various regions.
Assessed product-wise contributions (mouse, keyboard, SSD, monitor) to overall market share.
Tracked region-wise market share contributions to understand regional strengths.
Analyzed customer-wise contributions, identifying key customers driving significant market share.

Top Products and Customers:
Highlighted the top-performing products.
Identified top customers contributing to sales growth.

Regional Insights:
Assessed product demand and performance across different geographical markets.

Market Share Contribution:
Tracked product, region, and customer contributions to market share over different fiscal years, identifying trends

Project Details

This project involved a thorough analysis of insurance data. After cleaning and preparing the data, I developed key metrics to track daily growth in revenue and customer numbers. I performed a detailed city-wise analysis to find where the most policyholders are located and which age groups buy the most policies. I created two dashboards: one that shows sales performance by different modes and another that compares policyholders and revenue across age groups. These dashboards provide clear insights into the company’s growth, customer trends, and regional performance.

Live Interactive Dashboard

Project Details

This project uses SQL to analyze consumer behavior and marketing effectiveness in the energy drinks sector. It identifies key demographics, including gender and age groups, and evaluates the effectiveness of various marketing channels, particularly for youth (ages 15-30). The analysis delves into consumer preferences for ingredients and packaging, pinpointing what drives brand loyalty and market leadership. It also examines purchase behaviors, preferred locations, and typical consumption scenarios. Geographic insights are provided through city and tier-based analyses to highlight regions with high consumer counts. By processing survey data and demographic information, the project offers comprehensive insights into market trends and consumer preferences, enabling more effective marketing strategies and improved brand positioning in a competitive market.

Project Details

For Mitron Bank, I developed an advanced dashboard aimed at promoting and launching new credit cards. The dashboard provides a detailed analysis through various views, including spending patterns, utilization rates, customer demographics, and credit card expenditure. By integrating these insights, the dashboard helps understand current financial behaviors and identify potential opportunities. The recommendations offered are designed to guide the bank in pinpointing the most effective locations and strategies for introducing their new credit cards. This tool empowers Mitron Bank to make data-driven decisions, optimize its marketing efforts, and enhance the success of its new credit card initiatives.

Live Interactive Dashboard