DAta warehouse modelling

Finalizat Postat la acum 2 ani S-au achitat serviciile după ce au fost prestate
Finalizat S-au achitat serviciile după ce au fost prestate

MegaOmniCorp sells flipwidgets to Canadian consumers. It has a number of salespeople who manage sales territories. Each salesperson has their own Quota which may vary over time depending on market conditions. MegaOmniCorp uses a machine learning algorithm to set the sales quota for each sales person and territory based on a number of inputs including sales data over time. Additionaly, management will leverage sales data to set compensation levels for their sales people. The machine learning algorithm requires a data feed that provides the number of products sold per product per salesorder per sales person per territory. Management requires a report that provides the total amount sold YTD per salesperson per territory.

The Task:

Part 1. Design a star schema that meets the needs of both requirements based on the ERD embedded.

Using PowerPoint, Word or NotePad, provide the design of the star schema and return it with the code written below.

Part 2. Write a MS SQL-server stored procedures that produces a data set based on the star schema you have designed.

Part 2 a: Write the stored procedure to extract data from your star schema for the machine learning algorithm. You should include the columns:


Order Quantity


Sales Person Firstname

Sales Person Lastname

Order Date


Part 2b: Write the stored procedure to extract data from your star schema for the Management Report. The procedure should accept the following parameters: Territory and a group of sales people (one or more). You should include the following columns:


Job Title

Sales Person FirstName

Sales Person LastName

Sales YTD

Impressive Bonus:

Provide the employee percent of total annual sales as column PercentOfTotal.

Also provide the Employee rank by sales while avoiding the use of cursors.


Create and return a zip file containing your report sql file and a star schema diagram.

Stocare date Informatică Exploatarea Datelor MySQL

ID Proiect: #31242642

Detalii despre proiect

3 propuneri Proiect la distanță Activ acum 2 ani

Acordat lui:


♦ PL/SQL Expert ♦ Immediate Start ♦ I’m a software Engineer with 8+ years experience in DB development. I’m expertise in multiple databases , MYSQL, Oracle and PostgreSQL. I would be right person for this project becau Mai multe

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% INR în 1 zi
(0 Recenzii)

3 freelanceri plasează o ofertă medie de 1200₹ pentru proiect


I’m data warehousing expert with around 12years of experience into data and it’s life cycle. Have worked on extensive data modeling and warehousing for numerous clients. Thanks, Vijeth Kumar

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 7 zile
(0 recenzii)

Hi, I have worked on similar projects at I have a good profile there. It is the only platform for data analytics or data related needs for freelancers and clients. Rates are reasonable as well. Let me kn Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 7 zile
(0 recenzii)