Find Jobs
Hire Freelancers

T-SQL, SSIS, SSAS AdventureWorks, Person and Sales Report and Update

$10-30 USD

Closed
Posted 9 months ago

$10-30 USD

Paid on delivery
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
Project ID: 37138473

About the project

14 proposals
Remote project
Active 8 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average $24 USD for this job
User Avatar
Dear Client The time of day that you are available. Starting from EST Morning 8:30 AM onward Do you speak English? -YES Are you available to login remote and work on my remote machine. -YES What remote login app do you want to use to work remote. - ANYDESK When you can complete the project? I need the project complete in 48 hours. - Agree to complete before deadline. I am writing to express my interest in requirement you have posted. With 16 Year of experience in Database, C#, .NET MAUI and .NET Core Web API, I am confident that I can provide the high-quality work you require. I propose a fee of USD 25/Hour. I am excited about the opportunity to work with you and deliver a high-quality project. Please let me know if you have any questions or require additional information. I look forward to hearing from you soon. Thank you for considering my proposal. Best regards, Gajendra Singh
$20 USD in 7 days
4.7 (2 reviews)
2.5
2.5
User Avatar
I can handle you task for your application. I am sql / .net developer having 14+ years of experience in developing and handling different types of applications. Willing to provide best and long term relation ship. Also received good complement from client like "You are assets of our team".
$24 USD in 7 days
5.0 (1 review)
1.6
1.6
User Avatar
Hello!! Im interested in this task. Yes Im available 7am to 10pm central time. And yes I speak english and I already have experience in working on remote machines. We can discuss it in details and yes Im ready to work within your budget. Thanks
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I know sql and have good typing skills. My certifications invlude sql,plsql, java, oravle adf and C programming. Contact me if you see i'm fit for the role. I always available to work here.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I understand from your job description that you want to hire a data entry assistant for transection data. I provide this kind of service with years of experience. You mentioned that data processing, SQL etc skills required for submitting a proposal but I can strongly say that I have all the skills for. You can visit my portfolio. If you award me your project then we will discuss it more. Yeah, I am fluent in english. Thanks
$10 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I hope you're doing well. I'm available during the times you've mentioned, and I'm proficient in English. I can perform remote work on your machine using either TeamViewer or AnyDesk, or any other software that's compatible with your setup. With over 4 years of experience as a database engineer and data engineer in various multinational corporations, I bring a wealth of expertise to this project. As part of my current assignment, I am doing this kind of work daily with SQL, BigQuery, etc. I'm committed to establishing lasting client relationships and am dedicated to delivering quality work within a competitive budget. Thank you for considering my proposal. I'm enthusiastic about the opportunity to collaborate and contribute to the success of your project. Looking forward to hearing from you. Best Regards, Md Mukhlesur Rahaman
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
your time in completed brother many tolls are use and perfectly your project completed sir me is a weak in start up in freelancer web in use so one change give me
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am available 7am to 10pm UTC-06:00 Central Time US & Canada. Yes i can help with you with this i can spark english I will work with you based on your requirements Lets finish this in next 48 hrs
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I understand you are looking for someone to add data cleansing to T-SQL scripts for peoples demographic data and give recommendations on what further data cleansing should be added. I believe I am the perfect fit for this project due to my extensive knowledge in Data Analysis, Business Intelligence, NLP, DATA WAREHOUSING, Data Visualization (Excel dashboards), SQL and web development. I am confident that I have the skills necessary to complete this project within 48 hours including data analysis, statistical modeling (using R and Python), data visualization, SPARK with R (SparklyR) and ETL processes. My commitment to confidentiality, protection of secrecy and scope of Confidentiality make me an ideal candidate for this project. Please feel free to contact me if you have any questions or would like additional information about me or my services. Replies within a few minutes.
$45 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. My name is Sathiya Jeba. I am a SQL developer with hands on experience with banking applicaiton development. I have read your requirement and I am confident I can help you on your project Can we discuss the remaining requirements in detail over the chat?. I hope that am suitable match for your project. I think i will give you a better solutions in optimal time.
$50 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Great day, I have 9 years of experience in MSSql and SSIS, and have completed several data migration projects in MSSQL. I have handled several complex scenarios while doind data migration activities.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have 3 years experience in sql database, ETL, power bi, stored procedures , Microsoft sql server, data processing High-quality deliverables passed through various testing parameter would be ensured. Thanks Anmol sharma
$28 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
SAND SPRINGS, United States
5.0
286
Payment method verified
Member since Jul 28, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.