Skip to content

amanat-mahmud/amanat-mahmud

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 
Β 
Β 

Repository files navigation

Typing SVG

πŸ“Š Data Analyst | Business Intelligence Developer

Excel Power BI Tableau SQL Python

  • πŸ’Ό Transforming raw data into actionable insights and compelling stories
  • πŸ› οΈ Skilled in ETL processes, database management, and dashboard creation
  • πŸ”­ Currently working on:
  • 🌱 Expanding skills in: Tableau and Plotly Dash for interactive data storytelling
  • πŸ“‚ Explore my Data Analysis Portfolio
  • πŸ“« Let's Connect: LinkedIn
  • πŸ“„ View my Resume
  • 🀝 Open to collaboration on data-driven projects and analytics challenges

Data Analysis Projects

Excel Projects

  1. Telecom Churn Analysis: Analysis of customer churn in telecommunications (2015-2018). Identifies key factors influencing customer retention, provides insights on demographic and behavioral patterns, and offers strategies to reduce churn and increase customer lifetime value.
  2. Supply Chain Analysis: Analysis of inventory management and supply chain efficiency (2015-2018). Identifies key trends in product classes, sales performance, and shipping. Provides actionable insights to optimize inventory levels, reduce costs, and improve customer satisfaction in a complex supply chain environment.
  3. Sales Analysis: Analysis of sales performance metrics from 2014-2017, identifying key trends in product sales, regional performance, and profitability. Provides actionable insights to optimize inventory, improve profit margins, and enhance customer satisfaction in a competitive market.
  4. Customer Complaint Analysis: Analysis of consumer complaints in the financial services sector, leveraging data from 2013-2016. This project examines customer satisfaction, resolution times, and dispute rates across various companies and products. It provides actionable insights and recommendations to improve complaint handling processes, enhance customer satisfaction.

Power BI Projects

  1. CRM and Sales Analysis: Analysis of Customer relationship management and sales management(2024). Identifies optimizing sales performance,top sales agent,conversion rate, win rate and revenue forecasting. THis was done for Fp20 challenge.
  2. Insurance Analysis: Interactive Power BI dashboard analyzing customer demographics, sales channels, and policy trends. Provides actionable insights on revenue generation, customer growth, and age-group impacts to drive data-informed business decisions.
  3. E-commerce Sales Analysis: E-commerce sales and promotions analysis(2019). Examines user behavior, product performance, and promotional impact across brands, categories, and states to optimize sales strategies and profitability.
  4. Hotel Management Analysis: Analyzing customer retention, revenue trends, and market diversity to optimize pricing strategies and enhance customer experience in the hospitality industry.
  5. Adhoc Sales Analysis: E-commerce sales analysis project using Power BI. Insights on revenue, product categories, regional performance, and order statuses to optimize sales and improve customer satisfaction.

SQL Projects

  1. Social Media Analysis: Wrote complex queries, merged and analyzed data from multiple databases to optimize content strategy and user engagement through hashtag analysis, user influence metrics, and regional content preferences.
  2. Sales Analysis: Wrote queries to analyze sales performance metrics from 2014-2017, focusing identifying key trends in product sales, regional performance, and profitability through comprehensive data-driven insights and recommendations.
  3. Call Center Analysis: Developed SQL queries to analyze customer service metrics, sentiment, and regional trends to optimize call center operations and improve customer satisfaction.

Tableau Projects

  1. Beverage Analysis: Data-driven market research and strategy development for Codex, an emerging Indian energy drink brand. Includes consumer preference analysis, product optimization, competitor assessment, and targeted marketing recommendations to increase market share and brand awareness.
  2. Hotel Management Analysis: Analyzing customer retention, revenue trends, and market diversity to optimize pricing strategies and enhance customer experience in the hospitality industry.

Python Projects

  1. Food delivery Analysis: Analyze 5 months of Khao's food delivery data to boost sales and profitability. Identify key factors affecting performance, analyze trends, and provide actionable recommendations for resource allocation and strategy improvement.

Skills

Data Analysis

excel power-bi-2021 tableau plotly

Programming Languages

Web Development (MERN Stack)

mongoose

Tools & Technologies

Connect with me


About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published