Closed

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

Skills: .NET, Database Administration, Microsoft SQL Server, Oracle, SQL

See more: ssas tabular change workspace database, cannot deploy model to the deployment database server, analysis services deployment wizard step by step, tabular model designer an error occurred while connecting to the server, ssas tabular model deployment, ssas tabular deployment wizard, cannot deploy metadata. reason: an error occurred while connecting to the server., deploy tabular model to another server, programmatore sql server analysis service roma richieste, sql server analysis services, sql server 2008 ssrs ssas ssis, sql server 2008 service broker stored procedure parameters, iphone sql server web service, demand cloud sql server reporting service, dashboard sql server reporting service, backup sql server automatic service, access sql server web service iphone, sql server reporting service batch report, data transfer sql server local service provider, sql server integrtion service reporting service

About the Employer:
( 11 reviews ) SAHIWAL, Pakistan

Project ID: #15627711

10 freelancers are bidding on average $23 for this job

khannanav

We have 10 years of experience working on Oracle and have delivered projects to telecom, farming, state government to name a few. We have expertise working on MySQL, SQL, .NET. Relevant Skills and Experience JAVA, Ora More

$25 USD in 1 day
(8 Reviews)
3.8
IslamMinhajul

Hi I am working on SQL server for 15 years. I worked some sql server on freelancer listed in feedback. Thanks

$25 USD in 1 day
(5 Reviews)
3.6
LeeSwagger08

Hi I am a certified web application developer and passionate Sql and msbi [login to view URL] will be more than happy to work with me

$10 USD in 1 day
(1 Review)
1.4
bnrajumnc

Build OLAP Cube for 5 tasks. Relevant Skills and Experience SSAS, SQL SERVER. Proposed Milestones $35 USD - design of OLAP cube and 5 measures.

$35 USD in 7 days
(2 Reviews)
1.5
Sherlynmae13

I bid for $10. Relevant Skills and Experience I'm good in Microsoft.

$15 USD in 10 days
(0 Reviews)
0.0
dario575

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
AARUSAMY

A proposal has not yet been provided

$20 USD in 1 day
(0 Reviews)
0.0
KarnamKarthik

A proposal has not yet been provided

$25 USD in 7 days
(0 Reviews)
0.0