SQL Server And the Snow Flake Schema

$10-30 USD

종료됨

게시됨

거의 4년 전

$10-30 USD

제출할때 지불됩니다

Let us consider a data cube of a bookstore with three dimensions: Book, Time, Location and one measure sum_sales. The dimension Book contains information about title, category and authors. The hierarchy of the dimension Location contains city and country. However, the dimension Time records data about day, week, month quarter and year. 1. Give a full snowflake schema for the bookstore cube (ER diagram under PowerDesigner or other software). 2. Give query samples for the OLAP operations: drill-down, roll-up, slice. a. In SQL format. b. Under SQL Server Analysis Manager. 3. Under Analysis Manager of SQL Server, give a table that allows you to display information of amount sales of books by considering all levels of dimension hierarchies. 4. Give an example of OLAP operations (drill-down, roll-up, slice) by using MDX query language. • Provide report • SQL Server files

SQL

Database Administration

Oracle

Microsoft SQL Server

프로젝트 ID: 26313772

프로젝트 정보

8 제안서

원격근무 프로젝트

활동 중 4년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

8 이 프로젝트에 프리랜서들의 평균 입찰은 $32 USD입니다.

@tutulsoft

-- 20 years Database expert --- i can complete your requirement by designing database with Snow flake schema ---------

$80 USD 2일에

5.0

(20 건의 리뷰)

5.2

@ZishanChuhan

Hi, I am expert in DB Modeling, ER Diagram, Star schema, snowflake schema, DWH concepts. I can do this task perfectly with complete accuracy as per your requirements.

$30 USD 2일에

4.6

(9 건의 리뷰)

3.4

@KnackITSolutions

Hello, I am expert in MYSQL with good years experience. I can make your server in low budget. Please contact me for further details.

$15 USD 2일에

0.0

(0 건의 리뷰)

0.0

@guruanbu533

OOooooo

$25 USD 1일에

0.0

(0 건의 리뷰)

0.0

@jdebeer62

I have more than 30 years’ experience in the IT industry within Government Departments, Science and Research, Mining, Manufacturing industries, Health care as well as Financial sector. My aim is excelling at everything I am doing and by principle strive to be the best in my professional career, as well as in the company I am employed. The knowledge and experience I have gained throughout my employment at both private and public enterprises have added to my extensive IT skills base. I am proud of my achievements in many of the information technology products and solutions and was 4 times the top performer/team in the last 6 years. As an ICT Specialist, I always strive to be on top of the fast technology changes by investigating and researching new technologies and solutions across a variety of systems, networks and infrastructures.

$20 USD 7일에

0.0

(0 건의 리뷰)

0.0

@sunilmudunuri

I'm an experienced freelancer database and .net design, development and optimization with 10 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design. I am currently in Texas, US Here is few technologies I have mastered since last 10 years and can deliver the best solutions if you get me hired. 1) Sql Server 2005/2008/2012 2) C#, Asp.net, Angular 2) MYSQL, MS Access 3) Oracle (PL/SQL) 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS

$25 USD 1일에