****************************************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-X1GEN2
Path     : C:\Users\kgnazdowsky\Documents\Find IT EZ Docs\Test Cases\PowerBI\Revenue Opportunities.pbix
****************************************************************************************************

-------------------------------------------------- "Opportunity Overview" Visualization "0fa4715079a4d5b14dc6" Datasource Filter --------------------------------------------------

SELECT
	"Total Revenue"
FROM
	"f"."Sales"


-------------------------------------------------- "Opportunity Overview" Visualization "2a48b7b9c411369725ca" "Categorical" Filter --------------------------------------------------

	"Sales Stage" not in ("'Finalize'")


-------------------------------------------------- "Opportunity Overview" Visualization "2a48b7b9c411369725ca" Datasource Filter --------------------------------------------------

SELECT
	"Total Opportunity Count"
FROM
	"f"."Sales"
	,"s"."SalesStages"
WHERE
	"Sales Stage" not in ("'Finalize'")


-------------------------------------------------- "Opportunity Overview" Visualization "77960fe4d6dd7e864e6c" Datasource Filter --------------------------------------------------

SELECT
	"Product Code"
FROM
	"p"."Products"


-------------------------------------------------- "Opportunity Overview" Visualization "eaf58d9fd08140688010" Datasource Filter --------------------------------------------------

SELECT
	"Region"
	,"Total Opportunity Count"
	,"State"
FROM
	"a"."Accounts"
	,"f"."Sales"
ORDER BY
	"Total Opportunity Count" DESC


-------------------------------------------------- "Opportunity Overview" Visualization "91b894da4c7a504a0d7c" Datasource Filter --------------------------------------------------

SELECT
	"State"
	,"Total Revenue"
FROM
	"a"."Accounts"
	,"f"."Sales"


-------------------------------------------------- "Opportunity Overview" Visualization "efc42a2f1a28997b4092" Datasource Filter --------------------------------------------------

SELECT
	"Total Revenue"
	,"Total Opportunity Count"
	,"Month"
FROM
	"f"."Sales"
	,"d"."Dates"
ORDER BY
	"Month" ASC


-------------------------------------------------- "Opportunity Overview" Visualization "772b1906500006b78011" Datasource Filter --------------------------------------------------

SELECT
	"Sales Stage"
	,"Total Opportunity Count"
FROM
	"s"."SalesStages"
	,"f"."Sales"
ORDER BY
	"Total Opportunity Count" DESC


-------------------------------------------------- "Opportunity Overview" Visualization "8a2c970418c8c8b490ba" Datasource Filter --------------------------------------------------

SELECT
	"Region"
	,"Total Revenue"
	,"State"
FROM
	"f"."Sales"
	,"a"."Accounts"
ORDER BY
	"Total Revenue" DESC


-------------------------------------------------- "Detail" Visualization "df4f5199190e7a2291de" Datasource Filter --------------------------------------------------

SELECT
	"Opportunity Size"
	,"Region"
	,"Partner"
	,"Total Opportunity Count"
	,"Total Revenue"
	,"Average Revenue"
	,"Average Opportunity Days"
FROM
	"o"."Opportunities"
	,"a"."Accounts"
	,"p"."Partners"
	,"f"."Sales"
ORDER BY
	"Total Revenue" DESC