DATA ACQUISITION
Buget $10-30 USD
Job Description:
A. Summarize a research question that can be answered using both the original database and the add-on CSV data. The question should require data from both these data sources.
1. Identify which data from the original data set and the add-on CSV file are needed to answer the research question.
B. Create a logical data model for the add-on CSV file by evaluating the data contained in the file and emphasizing the relational constraints.
1. Write SQL code that creates a table that accommodates the extension of the logical data model to a physical data model by specifying the field types and relevant keys.
2. Write SQL code that loads the data from the add-on CSV file into the table created in part B1.
C. Write SQL statement(s) for a query or queries that inform the research question summarized in part A.
1. Provide a CSV file or files that capture the results from the query or queries.
D. Determine how often the add-on file should be acquired and refreshed in the database for the data to remain relevant to the business and the research question.
E. Create an SQL script that performs the process of loading the add-on data.
F. Provide a Panopto video recording that includes a demonstration of the functionality of the code used for the analysis and a summary of the programming environment.
Note: For instructions on how to access and use Panopto, use the "Panopto How-To Videos" web link provided below. To access Panopto's website, navigate to the web link titled "Panopto Access" and then choose to log in using the “WGU” option. If prompted, log in using your WGU student portal credentials, and then it will forward you to Panopto’s website.
To submit your recording, upload it to the Panopto drop box titled “XXXX.” Once the recording has been uploaded and processed in Panopto's system, retrieve the URL of the recording from Panopto and copy and paste it into the Links option. Upload the remaining task requirements using the Attachments option.
G. Record the web sources used to acquire data or segments of third-party code to support the application. Be sure the web sources are reliable.
H. Acknowledge sources, using in-text citations and references, for content that is quoted, paraphrased, or summarized.
I. Demonstrate professional communication in the content and presentation of your submission.
16 freelanceri licitează în medie 43$ pentru acest proiect
SQL , Data analysis Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating fro Mai multe
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp Mai multe
Hi I have 15 years of experience in SQL server Database development, MySQL development, postgress development, power bi. programming using python and c#. I will be able to help you with the project. Please ping me offl Mai multe
Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Data Mining ,Data Science,Machine Learning -Python programing -data analysis using python and R -Data Scraping u Mai multe
Creating crystal report with mssql database and connecting server to another i have a project that i will create 10 crystal reports
Hello Sir, I’m Juber, I’m a data entry operator. I have been working on this site last 3 years and I’m experience of two years in data entry . I read about your project and I’m very confident that I’m fi Mai multe
Hi my name is siddu i am here to show my skills and earn we can chat and start working I am can complete your project fast as I can thank you,
I can create amazing results for you with my experience. I have advanced PowerBI expertise. I have 50+ project experience.
HELLO I AM A DATA ENTRY AND EXCEL WORKER.I WILL DO YOUR WORK HONEST AND I WILL GIVE BEST FOR IT. MY TYPING SPEED IS 60% AND MY ACCURACY IS 90%.
I just finished my job as Deploymend and Acquisition Representative - East at PT Bizzy Marketplace Indonesia
