Merger AnalysisMemo DATE 7 5 2018 MEMORANDUM FOR Young Jolly, LLC Merger Project Consultants FROM Smart Buy SUBJECT Merger Project ETL Parameters Now that the contracts are signed, we are providing more detailed guidance for the team that will help us with our Merger Project This memo addresses the following topics Analysis Final Deliverable Analysis Given the new make up of the organization Smart Buy wants to understand some specifics of the new employee base Below are a few questions that will aid in that endeavor Several employees believe that their paychecks were calculated incorrectly Management has asked that you produce a report that shows all employees living in Oklahoma in the accounting department in the 3 rd Quarter of 2018 Report the employee id, last name, department name, total gross salary This report should be in alphabetical order from A Z What were the top 75 paid seasonal retail employees that worked for Smart Buy in December of 2018 Report the city and state in which they worked, their hourly rate, total number of hours worked, and marital status, in descending order based upon the number of hours worked Smart Buy wants to understand if most of their seasonal workers worked more than 4 periods during the busy season (4 th quarter) List (by employee id and last name) the number of periods worked and the total gross pay for seasonal retail workers in the 4 th quarter of 2017 and the 4 th quarter of 2018 If the results of this query are more than 100 records, only report the first 10 in your write up If smart buy wants to relocate headquarters, where should they do this Please use at least 2 queries to answer this question Take into consideration where the employees that work jobs that would be associated with headquarters (for example accountants, IT workers, executives, and possibly others) currently live Also consider the location of our most lucrative stores Deliverables Analysis Deliverable For the purposes of insuring data integrity, we want to understand how you create the database against which you will eventually run your analysis All the analysis should be run from the same database This document must list the question and then the answer to the question

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 18, 2024

Merger AnalysisMemo DATE: 7/5/2018 MEMORANDUM FOR: Young & Jolly, LLC Merger Project Consultants FROM: Smart-Buy SUBJECT: Merger Project ETL Parameters Now that the contracts are

MergerAnalysisMemo

DATE:

7/5/2018

MEMORANDUM FOR:

Young & Jolly, LLC Merger Project Consultants

FROM:

Smart-Buy

SUBJECT:

Merger Project ETL Parameters

Now that the contracts are signed, we are providing more detailed guidance for the team that will help us with our Merger Project. This memo addresses the following topics:

Analysis
Final Deliverable

Analysis

Given the new make-up of the organization Smart-Buy wants to understand some specifics of the new employee base. Below are a few questions that will aid in that endeavor.

Several employees believe that their paychecks were calculated incorrectly. Management has asked that you produce a report that shows all employees living in Oklahoma in the accounting department in the 3^rd Quarter of 2018. Report the employee_id, last name, department name, total gross salary. This report should be in alphabetical order from A Z.
What were the top 75 paid seasonal retail employees that worked for Smart-Buy in December of 2018? Report the city and state in which they worked, their hourly rate, total number of hours worked, and marital status, in descending order based upon the number of hours worked.
Smart-Buy wants to understand if most of their seasonal workers worked more than 4 periods during the busy season (4^th quarter). List (by employee id and last name) the number of periods worked and the total gross pay for seasonal retail workers in the 4^th quarter of 2017 and the 4^th quarter of 2018. If the results of this query are more than 100 records, only report the first 10 in your write-up.
If smart-buy wants to relocate headquarters, where should they do this? Please use at least 2 queries to answer this question. Take into consideration where the employees that work jobs that would be associated with headquarters (for example: accountants, IT workers, executives, and possibly others) currently live. Also consider the location of our most lucrative stores.

Deliverables

Analysis Deliverable: For the purposes of insuring data integrity, we want to understand how you create the database against which you will eventually run your analysis. All the analysis should be run from the same database. This document must list the question and then the answer to the question.