Project Details

Used Microsoft Excel, Pivot Tables, Power Query, Power Pivot, and Conditional Formatting.

📈𝐅𝐢𝐧𝐚𝐧𝐜𝐢𝐚𝐥 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬:
Profit and Loss (P&L) Report:
- Monthly and quarterly breakdowns.
- Key indicators: Net Sales, COGS, Gross Margin, GM %
- Year-over-Year Comparison to identify trends, variations and areas for improvement.

🔍 𝐒𝐚𝐥𝐞𝐬 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬:
- Customer, Market and Target Performance:
- Segmentation for Customer metrics, Market penetration, and Target achievement.
- Insights for strategic decision-making and resource allocation.

📊𝐓𝐨𝐩 𝟏𝟎 𝐏𝐫𝐨𝐝𝐮𝐜𝐭𝐬:
-Identify and analyze top-performing products.
-Assess sales volume, revenue, and profit margins.

📅𝐍𝐞𝐰 𝐏𝐫𝐨𝐝𝐮𝐜𝐭𝐬:
- Evaluate the impact of new products.
- Comparative analysis of sales, market reception, and profitability.

📊𝐓𝐨𝐩 𝐚𝐧𝐝 𝐁𝐨𝐭𝐭𝐨𝐦 𝟓 𝐏𝐫𝐨𝐝𝐮𝐜𝐭𝐬:
-Identify strategic insights for product focus and marketing efforts.

Project Details

𝐂𝐥𝐢𝐞𝐧𝐭: Atliq Hardware, a leading computer hardware producer in India with a global presence.
𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞: Lack of sufficient insights for quick and informed decision-making at the top level of management.
𝐒𝐨𝐥𝐮𝐭𝐢𝐨𝐧:Conducted data analysis on nearly 2 million records in the consumer goods domain.
𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐂𝐨𝐦𝐩𝐚𝐫𝐢𝐬𝐨𝐧:Evaluated company performance against competitors.
𝐏𝐫𝐨𝐝𝐮𝐜𝐭 𝐒𝐞𝐠𝐦𝐞𝐧𝐭𝐬:Analyzed different product segments.
𝐒𝐚𝐥𝐞𝐬 𝐂𝐨𝐦𝐩𝐚𝐫𝐢𝐬𝐨𝐧 (𝟐𝟎𝟐𝟎 𝐯𝐬. 𝟐𝟎𝟐𝟏):Identified trends and changes in sales.
𝐂𝐨𝐬𝐭 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬:Identified highest and lowest cost products.
𝐏𝐫𝐞𝐬𝐞𝐧𝐭𝐚𝐭𝐢𝐨𝐧:Created a presentation to effectively communicate analysis and insights to top-level management.
Provided actionable insights for data-informed decision-making.Empowered management with a deeper understanding of the company's performance and market positioning.
𝐓𝐨𝐨𝐥𝐬 𝐔𝐬𝐞𝐝:
-SQL for data querying and analysis

Project Details

In this project, the primary objective was to create a unified report for stakeholders in sales, marketing, finance, and the executive team. Key areas of focus included:

1. Building a Robust Data Model
2. Designing User-Centric Reports
3. Providing Drillable Insights

During this project, I acquired the following skills and knowledge:

1. Proficiency in Power Query, covering both basic and advanced operations.
2. Mastery of basic and complex DAX formulas.
3. Expertise in data modeling with over 10 interconnected tables.
4. Selection of appropriate visuals and formatting techniques.
5. Skill in using bookmarks for enhanced user experience.
6. Deployment on the Power BI service platform.
7. Actively incorporating stakeholder feedback.
8. Analysis and reporting of metrics across sales, marketing, finance, and supply chain domains.

Live Interactive Dashboard

Project Details

Working with AtliQ Grands, a renowned luxury hotel chain, we implemented "Business and Data Intelligence" strategies to revitalize their market share and revenue. Our primary task was to create a dynamic Power BI dashboard to glean insights from their historical data.

➡️Key areas of focus included:
1. Developing an interactive Power BI dashboard for real-time data analysis.
2. Implementing crucial hospitality domain metrics like RevPAR, ADR, DBRN, DSRN, and DURN.
3. Analyzing historical data to uncover revenue-enhancing opportunities.
4. Providing actionable insights to guide pricing and occupancy decisions.

➡️During this project, I acquired the following skills and knowledge:
1. Proficiency in Power BI for data visualization and analysis.
2. Deep understanding of key hospitality metrics and KPIs.
3. Data-driven decision-making for pricing and occupancy optimization.
4. Effective data presentation to aid in strategic decision-making.

Live Interactive Dashboard

Project Details

In the Telangana Growth Insights project, our primary goal was to provide comprehensive reports to government stakeholders for informed decision-making in three critical departments: Registration & Stamps, Transport, and Ts-Ipass. Key focuses included:

1. Building a Robust Data Analysis Framework
2. Crafting User-Centric Visualizations
3. Delivering Actionable Data Insights

Throughout this project, I honed the following skills and expertise:

1. Proficiency in data analysis with Power BI, encompassing diverse data sources.
2. Mastery of data modeling, connecting and optimizing multiple datasets.
3. Selection of impactful visualizations for data representation.
4. Skill in interactive dashboards and drill-down functionalities.
5. Successful deployment on the Power BI service platform.
6. Iterative improvement based on stakeholder input.
7. Comprehensive metrics analysis spanning various sectors for government decision-makers.

Live Interactive Dashboard

Project Details

In the Mitron Bank Credit Card Expansion, our aim was to diversify offerings and boost market presence.

Key findings:
1. Spending trends: Bills, Groceries, Electronics dominate, with Mumbai leading.
2. Income impact: Salaried IT, Business Owners, Other Salaried are top spenders.
3. Age preferences: 25-34, 21-24 focus on Entertainment, Apparel, Travel.
4. City dynamics: Mumbai leads, diverse patterns in Delhi NCR, Bengaluru, Chennai.
5. Gender & marital impact: Males, married individuals prominent card users.

Learnings:
1. Crafted targeted offers for demographics.
2. Introduced category-specific features.
3. Prioritized customer engagement.
4. Holistic approach - age, location, profession.
5. Anticipated positive business impact - higher card usage, increased spending, enhanced brand image for Mitron Bank. This project signifies the synergy between data analytics and business strategy, poised to elevate Mitron Bank's standing in the financial market.

Live Interactive Dashboard