I want hire some one do my Assignment.

Job Description:

Part 1 - SQL


Use the Adventure Works Datawarehouse database you downloaded. In this assignment you might need to search for data tables and their columns within the adventure works datawarehouse database.

Answer the following questions:

1. Create a list of Products and their units balance.

Clue: Design the Query that shows [EnglishProductName] column and [UnitsBalance]. Make sure the [units balance] is summarized.

Assumption: Accept every record in FactProductInventory table as an new inventory addition transaction to the existing stock.

2. Create a list of Countries and their salesamount.

Clue: Design the query that shows the [SalesTerritoryCountry] broken down by [SalesAmount]. Make sure the [SalesAmount] is summarized.

Assumption: Ignore the Currency Codes and assume that each transaction is done with the same currency in the [dbo].[FactInternetSales] table.

3. Create a stored procedure that runs the above created SQL statement dynamically so that the user specifies the Sales country.

Clue: Give the query that will create the mentioned stored procedure

4. Execute the above stored procedure and provide the sales for Canada.

Clue: Give the query to execute this previously created stored procedure with the parameter

5. Create another stored procedure that will create a table whenever it runs. The table will be CustomerGeography. It should include the following attributes:

● [DimCustomer] joined with [DimGeography] to fetch the columns [City] and [EnglishCountryRegionName].

● This new table must be created everytime you run the stored procedure.

6. Create a log table that has log_date_time, row_count as columns and use this table to log the above stored procedures executions.

Clue: you might need to insert into the log table after the main load script is executed. Probably the below pre-defined functions might come handy.. GETDATE(),@@ROWCOUNT

Bonus Question:

Create a stored procedure named “GetAverageProductSalesAmountUSD” which will first calculate the USD equivalence of all transactions for the SalesAmount column according to Order Date seen within the entire FactInternetSales table. Later, in the same stored procedure, filter out for the transactions that occurred between ‘01-Jan-2012’ and ‘31-Dec-2013’ based on Order Date to calculate average SalesAmountUSD values for each product. Finally, give the combination output of each Product Key, English Product Name and calculated average SalesAmountUSD value which contains only 2 decimal digits for this specified time range. In the stored procedure, include a logging mechanism to keep the execution datetime of this stored procedure.

Hint: Use the FactCurrencyRate table’s EndOfDayRate column to find out the corresponding currency rates for the related Order Dates to convert SalesAmount into USD.

Max budget: 75 USD

Taidot: R-ohjelmointikieli, SQL

Tietoa asiakkaasta:
( 5 arvostelua ) Hai Phong, Vietnam

Projektin tunnus: #35899478

22 freelanceria on tarjonnut keskimäärin $104 tähän työhön


Dear client! I am interested in your project I want hire some one do my Assignment. I have completed similar papers in the past and can assure you of exceptional and original work within the agreed deadline. I have ski Lisää

$30 USD 3 päivässä
(59 arvostelua)

Hi, I have 8 years of working experience in R, SQL Server, Data Prep/KNIME. I have developed SSIS workflows and deployed in production server I have also developed and designed professional quality dashboards for di Lisää

$80 USD 3 päivässä
(57 arvostelua)

Hello! I hope you are doing well. I am an experienced database administrator using TSQL in long time (sql server, mysql, oracle, postgres, mariadb). You can refer my profile in link Lisää

$50 USD 2 päivässä
(29 arvostelua)

I can help you with sql server queries , please ping/connect me now I am available. Please check my reviews and project which I have completed. I can create sql queries for sql server database as per design, let me kno Lisää

$30 USD 1 päivässä
(9 arvostelua)

Greetings! I am interested in this project I want hire some one do my Assignment..I've completed various similar projects in the past.I've more than 5+ years of experience in R Programming Language and SQL. If the proj Lisää

$100 USD 1 päivässä
(3 arvostelua)

I'm experienced Data Scientist and Content writer with 08 yrs of experience in the field of Machine Learning using R & Python. I can help in writing as well programming tasks as: Python Machine Learning Excel VBA Matla Lisää

$30 USD 3 päivässä
(8 arvostelua)

Hi I have 15 years of experience in Sql server database development, mysql database development, postgresql database development. Expert in data analysis. Reporting using power Bi. Programming using C#and sql server. Lisää

$350 USD 7 päivässä
(10 arvostelua)

Hi There, I have gone through your requirement and willing to do the mentioned task list. I have 15+ years of experience software architecture, Database and SQL programming . My experience makes me confident to assur Lisää

$75 USD 5 päivässä
(20 arvostelua)

Hello, I think I would be a great fit for you. Your project seem quite straight-forward. I am very good in SQL querying. Is this an academic project? Best, Borut

$75 USD 7 päivässä
(2 arvostelua)

Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Exc Lisää

$80 USD 1 päivässä
(2 arvostelua)

Dear, I have reviewed your SQL assignment requirements carfully, I believe I am your perfect candidate and it's my pleasure to apply and offer my services. I am a certified data analyst with 10 years of experience i Lisää

$75 USD 7 päivässä
(2 arvostelua)

I want hire some one do my Assignment. Hello Trong T., Hope you are doing great. I went through your project description and it seems like I really am the perfect fit for your Task. I have 10+ years of experience Lisää

$140 USD 7 päivässä
(1 arvostelu)

Hi There, I have 11+ years of professional experience on development activities .Net, C#, SQL, JS and so on. I can complete the work on time with efficiently and effectively. Let us initiate the project and simultaneo Lisää

$70 USD 2 päivässä
(0 arvostelua)

We are Chi SquareX Technologies, one of the Top 10 DeepTech Startups in India, and have been featured in the CIO Insider Magazine in the Machine Learning Segment. We provide Research Solutions in the domain of Machine Lisää

$140 USD 7 päivässä
(0 arvostelua)

Hello, I am an expert database architect. I have working experience with SQL. I read all the assignment questions and I can answer them within a short time, however I will need the database file. Let's talk about the Lisää

$75 USD 2 päivässä
(0 arvostelua)

I will complete your project for sure give me our project please I am very interested in it. I will try to complete your project as soon as possible.

$140 USD 7 päivässä
(0 arvostelua)

HELLO DEAR CLIENT I have gone through your project details, having all the required skills and VAST EXPERIENCE.I confirm to you that the project is doable since its within my area of EXPERTISE. Timely and Good work is Lisää

$240 USD 2 päivässä
(0 arvostelua)

Hi, I am a seasoned software engineer with 4+ years of industry experience and I can delivery you the assignment in less than 1 day's time, let's connect on chat to discuss further.

$200 USD 1 päivässä
(0 arvostelua)

❤ R/SQL EXPERT ❤ Hello I have just read carefully and interested in your proposal. I have full of experience about R, python, sql, database and etc. I can do it completely for a short period. Please contact with me and Lisää

$75 USD 3 päivässä
(0 arvostelua)

Passionate about technology and data, with more than 5 years of experience with SQL Server, Azure and Oracle data platforms, responsible for managing databases, generating reports, implementing improvements focused on Lisää

$100 USD 7 päivässä
(0 arvostelua)