DAta warehouse modelling
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.
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:
Sales Person Firstname
Sales Person Lastname
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:
Sales Person FirstName
Sales Person LastName
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.
ID Proiect: #31242642
Detalii despre proiect
♦ 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
3 freelanceri licitează în medie 1200₹ pentru acest 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
Hi, I have worked on similar projects at Pangaeax.com. 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