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