SALES_INSIGHTS

In this project we do EDA on sales data using SQL queries. We use tableau to create visualizations

DATA

• You can find the dataset used for this project as an csv file here.

OBJECTIVES

• To find category wise sales.
• To find sub_category wise sales for each category.
• To find region wise, state wise, city wise sales.
• To find month wise sales.
• To find year wise sales.
• To find top 10 customers by sales.
• To find top 10 sales agents by sales.
• To find common shipping mode.

SAMPLE VISUALIZATION

OUTLINE FOR DATA ANALYSIS

• Under the file Data analysis you can the Data analysis part of this project.
• Under the qureries folder you can find the qureries written to retrive the data and the retrived data can be found as csv files under result csv files.

OUTLINE FOR DATA VISUALIZATION

• Under the Data visualization there will be two files. Under screenshots you will find the visualizations and sales insights.twb file is workbook i used to make visualizations in tableau.