Skip to content

Analyze product pricing trends across categories and brands using SQL and Python. Explore pricing distributions, top products, and market insights with visualizations in Jupyter Notebook.

Notifications You must be signed in to change notification settings

Ankityadav3m/MarketMetricsProject

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

7 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“Š MarketMetricsProject

MarketMetrics is a data-driven project designed to analyze product pricing trends across various categories and brands. The project combines SQL analytics with Python-based visualizations to uncover insights into product performance, brand competitiveness, and pricing distribution.

πŸ” Features

  • SQL queries for:

    1. Calculating average sale prices by category and brand
    2. Ranking top-priced products within each category
    3. Computing running averages for dynamic price tracking
  • Jupyter Notebook analysis with:

    1. Cleaned and structured data exploration
    2. Graphical representations using Seaborn and Matplotlib
    3. Business insights derived from pricing and category-level trends

πŸ›  Technologies Used

  • MySQL
  • Python (Pandas, Seaborn, Matplotlib)
  • Jupyter Notebook

πŸ“ Files Included

  • MarketMetrics.sql β€” SQL scripts for analytical queries
  • MarketMetrics_Project.ipynb β€” Python notebook with data visualizations and insights

About

Analyze product pricing trends across categories and brands using SQL and Python. Explore pricing distributions, top products, and market insights with visualizations in Jupyter Notebook.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published