Week 4 Task 10

1. The SQL below and public link to the query show the number of sales, total sales, average sales, and total profit per year by region. This would be useful when determining which region generates the most revenue and are the most profitable and which regions are falling short.
SELECT year("Date") 'Year', "Region", count("Sales") 'No. Sales per Region per Year' , sum("Sales") 'Total Sales per Region per Year', avg("Sales") 'Average Sales per Region per Year', sum("Profit") 'Total Profit' from "Sales" group by year("Date"), "Region"
https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=315226000000007542&STANDALONE=true&privatelink=06cebc3d1ea9d175474274599be74a68&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true
2. The SQL below and public link to the query shows the number of sales, total sales, and average sales per customer. This would be useful when deciding who your most valuable customers are and which customers you should try to generate more sales from.
SELECT "Customer Name", count("Sales") 'Number of Sales per Customer', sum("Sales") 'Total Sales per Customer', avg("Sales") 'Average Sales per Customer' from "Sales" group by "Customer Name"
https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=315226000000007411&STANDALONE=true&privatelink=402a98aa06d17822eb7f0a23b2662d4f&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true
3. The SQL below and public link to the query shows the Sales and Profit for 2009 by Region and Product Category. This would be useful to determine in a particular year which region and product category generated the most revenue and profit for the company.
SELECT year("date") 'Year', "Region", "Product Category", sum("sales") 'Sales per Region by Product Category', sum("Profit") 'Profit per Region by Product Category' from "sales" where year("date") = 2009 group by "Region", "product category"
https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=315226000000007150&STANDALONE=true&privatelink=942b32284e6000ad27ea7c7770d78066&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true
4. The public link below is to a Sales & Profit Dashboard that I created.
https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=315226000000007653&STANDALONE=true&privatelink=b483e4fe7575638d6ac01a941f3720eb&ZDB_THEME_NAME=blue