In this project, I used an SQL Dump found on GitHub, which contains data about an India-based company’s customers, markets, products, and transactions. This project’s objective was to create a dashboard that would allow managers in the company to gain insights into sales performance and make decisions based on that, where the end goal is increasing sales.
Before beginning, defining the metrics and KPIs is crucial to getting the most out of the data in hand, so the questions we need to answer are:

1. What’s the company’s revenue growth over time?
2. What’s the revenue from each specific client?
3. How many sales were made in each year/month?
4. How many sales were made by a specific client?
5. Who are the top customers?
6. Which products are bestsellers?
7. What markets bring in the most revenue?
8. What markets have the biggest sales quantity?
9. What percentage of sales were made online?

The dashboard will help answer the questions above, shedding light on areas of improvement to increase sales.

1. Show all customer records

   SELECT * FROM customers;

2. Show total number of customers

   SELECT count(*) FROM customers;

3. Show transactions for Chennai market (market code for chennai is Mark001

   SELECT * FROM transactions where market_code='Mark001';

4. Show distrinct product codes that were sold in chennai

   SELECT distinct product_code FROM transactions where market_code='Mark001';

5. Show transactions where currency is US dollars

   SELECT * from transactions where currency="USD"

6. Show transactions in 2020 join by date table

   SELECT transactions.*, date.* FROM transactions INNER JOIN date ON transactions.order_date=date.date where date.year=2020;

7. Show total revenue in year 2020 in Chennai

   SELECT SUM(transactions.sales_amount) FROM transactions INNER JOIN date ON transactions.order_date=date.date where date.year=2020 and transactions.market_code="Mark001";