In this project, I performed end-to-end sales data analysis using Python, MySQL, Pandas, Matplotlib, and Power BI to extract business insights and support data-driven decision making.
Key tasks included:
• Extracting sales data from MySQL databases using SQL queries.
• Cleaning and transforming data using Pandas.
• Calculating KPIs such as Total Revenue and Total Quantity Sold.
• Identifying top customers and best-selling products.
• Creating visualizations using Matplotlib.
• Building an interactive Power BI dashboard for sales performance analysis and reporting.
Tools Used:
Python, MySQL, SQL, Pandas, NumPy, Matplotlib, Power BI
Results:
Generated actionable insights, identified sales trends, and developed an interactive dashboard to support business decisions.