Project Details

In this project, I developed a sales report using Excel pivot tables to help businesses determine effective customer discounts, facilitate consumer negotiations, and identify potential expansion opportunities in promising countries. The generated reports will offer actionable insights and recommendations, allowing businesses to optimize their sales strategies, improve customer satisfaction, and maximize revenue.

During this project, I learned:

1. Pivot Tables
2. Power Query
3. Basic DAX
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

This project aims to equip businesses with essential tools and insights to monitor, evaluate, and enhance their sales activities. By analyzing sales data, businesses can uncover new opportunities, drive growth, and remain competitive in a dynamic market environment.

Project Details

The project aims to create a single comprehensive report for stakeholders across sales, marketing, finance, and the executive team. The primary focus areas include:

1. Robust data modeling
2. User-friendly report design
3. Drillable insights

Throughout this project, I gained experience in:

1. Power Query (basic and advanced operations)
2. Basic and complex DAX formulas
3. Data modeling with over 10 tables
4. Selecting appropriate visuals and formatting
5. Dashboard design principles
6. Using bookmarks
7. Deploying reports in Power BI service
8. Implementing stakeholder feedback
9. Metrics for sales, marketing, finance, and supply chain

Live Interactive Dashboard

Project Details

**Hotel Data Analytics Project Using Python**

AltiQ Grand Hotel has a chain of hotels in Delhi, Mumbai, Bangalore, and Hyderabad, with various types of hotels and room segments. Bookings are made via AtliQ's website or third-party sites.

**Problem Statement**

AltiQ Grand is struggling against competitors, losing market share and revenue. Management seeks to adopt data-driven decision-making to boost revenue. To avoid interfering with the Booking database (OLTP), we will use ETL to create a Data Warehouse (OLAP) for analysis.

**Analytics Approach**

The project steps include understanding the business problem, data collection and understanding, data cleaning and exploration, and data transformation.

**Project Insights**

The project will provide insights into metrics such as occupancy percentage, profit per city, loss-making segments, month-wise variations, and revenue per booking platform.

Project Details

Atliq Hardware, a tech company, is transitioning from Excel to MySQL to deal with increased amount of data and to enhance efficiency

Atliq's business model involves selling hardware to customers like Croma,BestBuy who in turn sell to the end consumer

The project involves Finance analytics, Market analytics & Supply chain analytics to derive decision making insights

Project Details

Overview: This project identifies an optimal export destination and product for HS code 57, specifically woven carpets (HS 570232), using various trade metrics.

Approach:
1. **Product Selection**: HS 570232 was chosen using SHI, RHI, EPI, RCA, and PHI.
2. **Export Destination Selection**: Switzerland was selected based on import growth values, BOT, and RHI.

Trade Metrics Used:
- SHI: Measures export diversification.
- RHI: Indicates export destination concentration.
- EPI: Evaluates export potential.
- RCA: Identifies significant export potential.
- PHI: Assesses market structure and competition.

Insights: HS 570232 was selected due to its high RCA value and positive trend. Switzerland was chosen for its favorable trade metrics and high import penetration.

Detailed Calculations: Comprehensive calculations for RCA trends, PHI values, import growth, BOT analysis, RHI values, and TII calculations are included.

Project Details

Overview: This project explores the export feasibility of five agro commodities (Rice, Maize, Jute, Spices, Onion) targeting Middle Eastern markets. It includes analyses of product-market fit, pricing, potential buyers, trade documentation, and competitor analysis for rice exporting countries.

Objectives:

- Feasibility Study: Analyze the viability of exporting the five commodities using trade indicators.
- Market Identification and Strategy: Identify new markets, develop competitive pricing strategies, compile potential buyers, and detail trade documentation and
customs procedures.
- Competitor Analysis: Conduct detailed competitor analysis for rice exporting countries.

Key Insights:

- Feasibility study using trade indicators for product-market fit.
- Identification of new markets and competitive pricing strategies.
- Comprehensive list of potential buyers.
- Detailed trade documentation, necessary certifications, and customs clearance.