SQL Server Analysis Service SSAS package BIM Simple Task

I need a person who can work in SQL Server Data Tools 5 Question need to answered using [SSAS package solution (BIM and EXCEL files)] OLAP data file will be provided Q1: How many vendors have low quantity on hand (<10), medium quantity on hand (<50), and high quantity on hand (>50)? Q2: In DimDate, create ‘Fiscal’ hierarchy that include Day Number of Month, Day Number of Week, and Year. Show gross profit dollar amount by fiscal year Q3: Create role for Washington Sales Analyst to see only vendor and customer who live in Washington state. Which vendor has the highest sale revenue? Q4: Create KPI ‘Product Inventory Availability.’ The KPI is defined as quantity ordered divide by quantity on hand. Show vendors has low KPI (<0.1), medium KPI (<0.5), and high KPI (>0.5)Q5: Write your own question, and solve it