Territorial Sales Dashboard

Atliq Technologies - Sales from 2017 to 2020.

Thanks to CodeBasics for making this data public for educational purposes.

🎯 Objectives

1) EDA to be carried out using SQL on the sales data from Atliq Technologies for the period of 2017 to 2020.

2) An interactive BI dashboard to be developed to draw insights from aforementioned data using Power BI.

💾 Files Description

This project repo includes 2 files:

• Territorial Sales Overview_Atliq.sql - Includes all the SQL queries that were executed in MYSQL to conduct Exploratory Data Analysis(EDA) on the sales data.
• Territorial Sales Overview_Atliq.pbix - The interactive BI dashboard file developed using Power BI Desktop.

⚙️ Pre-requisites

• MySql
• Power BI
• Sales Data - from CodeBasics

📋 Methodologies

1) EDA using SQL queries

The queries in Territorial Sales Overview_Atliq.sql is run one after the other in MySql to get a sense of the distribution of data. It is noted that a number of transactions are recorded in USD as currency.

2) Visualisation using Power BI Dashboard

Formula to create normalised revenue (norm_amount) column, assuming a constant conversion rate of $ 1 = ₹ 75:

= Table.AddColumn(#"Filtered Rows", "norm_amount", each if [currency] = "USD" or [currency] ="USD#(cr)" then [sales_amount]*75 else [sales_amount], type any)

💡 Insights

1) Delhi NCR and Mumbai markets have performed consistently over the years as the top markets in revenue and profits generated. Ahmedabad is also notable for its high profit margins as compared to its share of revenue.

2) The overall generated revenue has taken a hit in 2020 which could be because of the COVID pandemic.

3) From the pie chart for 'Top 5 Products', it is seen that 84.48% of sales transactions have no record of 'Product ID'. This gap needs to be addressed by the Data team.

📚 References

• Dhaval Patel @Youtube.com, 'Sales Insights Data Analysis Project In Power BI'.

• 365 Careers @Udemy.com, 'SQL - MySQL for Data Analytics and Business Intelligence'.

• Skillsoft Academy, 'Channel - Power BI'.

📜 Credits

K X Vinay Jose