T-SQL, SSIS, SSAS AdventureWorks, Person and Sales Report and Update
Budget: $10 – $30 USD
For Adventureworks Transaction Database, and DataWarehouse
You can probably search the Web and Github and find something similar already complete. You can use that and just test to see that it's set up to run on SQL Server Agent Tasks
Summarize data for Persons and Sales that Management will want to know. Some examples are High and Low sales for Sales Persons and for Products.
Summarize the data, add the data to the Person table to maintain sales data. Show the difference in Sales by day in a DailySalesChanges Table. Create the Stored Procedure Transaction to summarize the data to a table (DailySalesChanges table). The table will be used to create an SSIS project to export the data to excel. The table will include a column for RunDate with the current timestamp.
Update the DataWarehouse with Sales and add Sales for Persons.
Include the current date and time, the member’s name, address, summarized metric name, value before update, value after update
Create the Stored Procedure Transaction to summarize the data to a table (SalesPerformance table). The table will include a column for RunDate with the current timestamp. The table will be used to create an SSIS project to export the data to excel.
The process needs to run automatic using Sql Server Agent with Sql Server Transactions in Stored Procedures. The project is needed in 48 hours
I'm using AdventureWorks2008R2 and AdventureWorksDW2008R2 from the Microsoft downloads. I will send you the download link if you message me.
Please reply with:
The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. Do you speak English? Are you available to login remote and work on my remote machine. What remote login app do you want to use to work remote. When you can complete the project? I need the project complete in 48 hours.
Confidentiality.
a) No Use. Recipient agrees not to use the Confidential Information in any way.
b) No Disclosure. Recipient agrees to use its best efforts to prevent and protect the Confidential Information, or any part thereof.
c) Protection of Secrecy. Recipient agrees to take all steps reasonably necessary to protect the secrecy of the Confidential Information, and to prevent the Confidential Information from falling into the public domain or into the possession of unauthorized persons.
d) Scope. The scope of Confidentiality is deemed to be in all contracts present past and future with the Parties to this request
You can probably search the Web and Github and find something similar already complete. You can use that and just test to see that it's set up to run on SQL Server Agent Tasks
Summarize data for Persons and Sales that Management will want to know. Some examples are High and Low sales for Sales Persons and for Products.
Summarize the data, add the data to the Person table to maintain sales data. Show the difference in Sales by day in a DailySalesChanges Table. Create the Stored Procedure Transaction to summarize the data to a table (DailySalesChanges table). The table will be used to create an SSIS project to export the data to excel. The table will include a column for RunDate with the current timestamp.
Update the DataWarehouse with Sales and add Sales for Persons.
Include the current date and time, the member’s name, address, summarized metric name, value before update, value after update
Create the Stored Procedure Transaction to summarize the data to a table (SalesPerformance table). The table will include a column for RunDate with the current timestamp. The table will be used to create an SSIS project to export the data to excel.
The process needs to run automatic using Sql Server Agent with Sql Server Transactions in Stored Procedures. The project is needed in 48 hours
I'm using AdventureWorks2008R2 and AdventureWorksDW2008R2 from the Microsoft downloads. I will send you the download link if you message me.
Please reply with:
The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. Do you speak English? Are you available to login remote and work on my remote machine. What remote login app do you want to use to work remote. When you can complete the project? I need the project complete in 48 hours.
Confidentiality.
a) No Use. Recipient agrees not to use the Confidential Information in any way.
b) No Disclosure. Recipient agrees to use its best efforts to prevent and protect the Confidential Information, or any part thereof.
c) Protection of Secrecy. Recipient agrees to take all steps reasonably necessary to protect the secrecy of the Confidential Information, and to prevent the Confidential Information from falling into the public domain or into the possession of unauthorized persons.
d) Scope. The scope of Confidentiality is deemed to be in all contracts present past and future with the Parties to this request