T-SQL SSIS SSAS Summarize Metrics and show Changes AdventureWorks
Budget: $10 – $30 USD
For AdventueWorks add summary for people with sales.
Determine which people will be of most interest to managers, export those records to excel, summarize the records, add the people to the people table to retain sales data.
Total sales by person for the end of the day.
Use T-SQL to add sales for the end of the day to the Data-Warehouse
Show changes from day to day, record the changes in a changes by day table.
AdventureWorks2008R2 and AdventureWorksDW2008R2
Visual Studio 2022
Sql Server 2019
You can message me if you want the links for the AdventureWorks datbases on the Microsoft Website
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
Determine which people will be of most interest to managers, export those records to excel, summarize the records, add the people to the people table to retain sales data.
Total sales by person for the end of the day.
Use T-SQL to add sales for the end of the day to the Data-Warehouse
Show changes from day to day, record the changes in a changes by day table.
AdventureWorks2008R2 and AdventureWorksDW2008R2
Visual Studio 2022
Sql Server 2019
You can message me if you want the links for the AdventureWorks datbases on the Microsoft Website
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