Adnan Ashraf
Seeking a dynamic role as a Data Analyst where I can leverage my expertise in Excel,SQL, Python and Power BI to deliver actionable insights and drive strategic decision-making for business growth.
TechnoEdge Sales Analysis Report (Power bi Dashboard):
comprehensive insights extracted from extensive sales data: Total Sales Performance: Total sales: $24.91M, 1828 units
returned, Profit: $5, average sales per customer: $444.54,Order quantity: 56.05K units, serving 10 million customers, Sales by
Age Group: Segmented data to reveal consumer demographics and preferences
TechnoEdge Customer Financial Behavior Project (Power bi 2 Dashboards):
Crafted two comprehensive Power BI dashboards for TechnoEdge's Customer Financial Behavior Project. The first dashboard
showcases key metrics like Current Credit (274M), Monthly Debit (12bn), and Current Loan (747M), alongside insightful charts.
The second dashboard offers a concise overview, featuring Current Credit (18.38M), and impactful charts such as Monthly Debt
by Gender and Open Accounts by Age, aiding in tracking customer progress and identifying areas for support.
Analyzing the Impact of Car Features on Price and Profitability (Ms Excel):
• Conducted a thorough analysis to optimize pricing and product development strategies for a car
manufacturer, utilizing advanced data analysis techniques, regression analysis, and market segmentation.
• Managed a dataset of 11,159 car models, exploring variables such as make, model, fuel type, and
MSRP, and constructed an interactive Excel dashboard for insightful visualizations.
IMDb Movie Analysis Project Report.(Advanced SQL)
• Proficient in advanced Excel functions, statistical analysis, and data visualization techniques to uncover insights in IMDb movie data, resulting in actionable recommendations for industry stakeholders.
• Demonstrated expertise in data cleaning, exploratory analysis, and the Five 'Whys' approach, yielding nuanced insights on movie genres, durations, languages, directors, and budgets, enhancing decision-making in the film industry.
Bank Loan Case Study (Excel & Statistics)
• The bank faces challenges with defaulting clients due to insufficient credit history. Through Exploratory Data Analysis (EDA), we aimed to identify patterns to mitigate loan default risks while ensuring capable applicants are not rejected.
Instgram Analysis cer
tification:SQL
• Analyzed Instagram user data using SQL and MySQL Workbench, deriving insights for marketing and investors, including identifying the oldest users and evaluating engagement metrics.
• Executed complex queries for Marketing and Investor Analytics, showcasing data analysis, problem-solving, and strategic decision-support skills.
2. ABC Call Volume Trend Analysis:Ms Excel
• The ABC Call Volume Trend Analysis project successfully identified peak call hours and proposed manpower plans to reduce abandonment rates.
• Proficiently utilized advanced Excel functions and statistical analyses to address business challenges in CX analytics, showcasing expertise in data-driven decision-making.
• My task was data analysis and visualization to provide valuable insights to the Chief Marketing Officer (CMO) and Chief Executive Officer (CEO). By loading and filtering data and making dashboards, I uncovered meaningful patterns and trends that helped drive informed decision-making.• Conducted comprehensive data analysis and visualization for the CMO and CEO, unearthing key consumer behavior trends, resulting in a 15% increase in customer retention and a 20% boost in sales revenue.
Online Retail Store Empowering Business with Effective Insights (TATA certificate):Power Bi
Contact: +91 9149910927
Email: [email protected]
© 2024 All rights reserved.