Pull sales data from SQL server data base using pyodbc python library and analyse it using pandas and matplotlib libraries.
Data is ProductAnalysisMatplotlib-Example.ipynb file is a mock-up sales data of imaginary store for women fashion and beauty products.
Visualisation including:
- sales by category,
- returns by category,
- top selling products by category,
- top selling products overall in store (color legend by category)