Voucher Report

I need a SQL VIEW to be created with detailed explnation for my voucher report generated using SQL SERVER MANAGEMENT STUDIO. The purpose of the report is to track the usage of vouchers which will be built as a power BI report. I have a specific format or template in mind for the voucher report, which needs to be followed. The desired output of the view should be done in SSMS by joining several tables which then can be pulled into power BI to create a bar report. Initially though it is a five bar chart, I need only two bars as of now for Number of vouchers and Number of redeemed vouchers (so two views in SSMS and those views will be pulled into Power BI for creating Bars). Sample report of how it looks is attached