Project Details

In this project, I crafted a sales report using Excel pivot tables, equipping businesses with the means to assess customer discounts, streamline negotiations, and pinpoint expansion prospects in promising markets. The resulting reports offer actionable insights and recommendations to refine sales strategies, elevate customer satisfaction, and optimize revenue generation.

Throughout this project, I acquired proficiency in the following key areas:

Pivot Tables
Power Query
Introduction to DAX
Conditional Formatting
Report Enhancement
Sales Domain Metrics
In essence, this project serves as a tool for businesses to take charge of their sales operations. With data-driven analysis, they can seize untapped opportunities, foster growth, and thrive in today's competitive market landscape.

Project video

Project Details

Derived from Codebasics and Atliq Technologies' Resume Project Challenge 4 in the consumer goods domain, AdHoc_Analysis focuses on Atliq Hardware, a prominent computer hardware manufacturer facing data-driven decision challenges.

Problem
Atliq Hardware struggles with timely and informed decision-making based on data. To address this, the management aims to augment the data analytics team, a SQL challenge is employed to identify junior analysts with both technical and soft skills.

Tools & Approach
Utilizing MySQL, PowerBI, Excel. The project applies MySQL concepts such as Joins, CTEs, Subqueries, and various functions. PowerBI employs Dax and various visualizations.
Findings & Solutions
The project uncovers critical metrics, including Gross Profit, Contribution %, Order by Overall Amount Sold, Average Gross Sales, and Average Manufacturing Cost.

Project video

Project Details

Conducted an extensive analysis of Shield Insurance's performance using Power BI. Unveiled insights by examining revenue & customer behavior trends, city-specific variations, sales modes, and age group dynamics.
Created a comprehensive report detailing key findings, contributing to strategic decisions and actionable recommendations. Enhanced projected revenue growth by 8-10% and market presence through data-driven insights.

Project video

Project Details

Mitron Bank is a legacy financial institution headquartered in Hyderabad. They want to introduce a new line of credit cards, aiming to broaden its product offerings and reach in the financial market.

Objective:
- Diversify Mitron Banks product Portfolio
- Spotlight High-value segments
- Decipher Customer Behavior's
- Strategically facilitate Credit Card Expansion
- Analyze trends and patterns within each Category

Resources Provided:
📍 Customers Demographics
📍 Spend Pattern across different factors
📍 Metadata
📍 Blueprint for Insights from Tony

Tools Used:
⭐ Power Query: ETL
⭐ PowerBI: Dashboard
⭐ Canva: Graphics
⭐ ClipChamp: Video Editing

Project video

Project Details

Key highlights:

Leveraged XLOOKUP and INDEX MATCH for seamless data association across multiple tables.
Implemented robust data cleaning techniques, including duplicate detection and removal.
Transformed raw data into structured tables for enhanced analysis.
Utilized IFS conditions for accurate sales calculations.
Applied meticulous formatting for improved data visualization and currency representation.
Generated insightful pivot tables to uncover trends and patterns.
Designed dynamic pivot charts, including a sales line chart and pie chart showcasing country contributions and top customer spending.
Enhanced user interactivity by syncing visuals with slicers and a timeline.
Crafted a cohesive dashboard experience, bringing all elements together seamlessly.
Fine-tuned the dashboard's aesthetics with a carefully curated color palette, removing gridlines and optimizing sizing for optimal user experienc

Project video