1. Display query that calculates and imports into Power BI the average salesAmountQuota per YEAR for each...
Question:
1. Display query that calculates and imports into Power BI the average salesAmountQuota per YEAR for each year since the year 2000 (or earliest valid year), using data in the factSalesQuota table. Display only the calendar year and the average salesAmountQuota
2. Use the HAVING clause to display query that calculates and imports into Power BI the average salesAmountQuota per employee using data in the factSalesQuota table for calenda years 2000 to date BUT displays results only for the averages that fall below a certain threshold (you are free to establish the threshold). Display only the calendar year and the average salesAmountQuota.
3. Display query that uses an INNER JOIN to source for records from the product dimension table and the internet sales fact table. Display only the product's name, its color, its status, its order number, its total product cost and its total sales amount. Also generate a column that calculates it net margin (profit).
4. Display query that imports into Power BI the gross total sales by country