Skip to content
View amanat-mahmud's full-sized avatar
๐ŸŽฏ
Focusing
๐ŸŽฏ
Focusing

Block or report amanat-mahmud

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this userโ€™s behavior. Learn more about reporting abuse.

Report abuse
amanat-mahmud/README.md

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


Popular repositories Loading

  1. doctor_bhai doctor_bhai Public

    JavaScript 1

  2. supply_chain_analysis supply_chain_analysis Public

    Data-driven analysis of inventory management and supply chain efficiency (2015-2018). Identifies key trends in product classes, sales performance, and shipping. Provides actionable insights to optiโ€ฆ

    1

  3. portfolio portfolio Public

    A simple portfolio website using html + CSS.

    HTML

  4. Smile-Foundation Smile-Foundation Public

    HTML

  5. Eat-Fresh-Practice- Eat-Fresh-Practice- Public

    HTML

  6. Munchies Munchies Public

    HTML