Find Jobs
Hire Freelancers

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

$10-30 USD

Zamknięte
Opublikowano 9 miesięcy temu

$10-30 USD

Płatne przy odbiorze
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
Identyfikator projektu: 37138473

Informację o projekcie

14 ofert
Zdalny projekt
Aktywny 7 miesięcy temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
14 freelancerzy składają oferty o średniej wysokości $24 USD dla tej pracy
Awatar Użytkownika
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 w 7 dni
4,7 (2 opinii)
2,5
2,5
Awatar Użytkownika
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 w 7 dni
5,0 (1 opinia)
1,6
1,6
Awatar Użytkownika
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 w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 7 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga UNITED STATES
SAND SPRINGS, United States
5,0
286
Zweryfikowana metoda płatności
Członek od lip 28, 2008

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.