Create a table with headers

Assignment Help Database Management System
Reference no: EM13761135

Set up Lookup Table

1. In the lookup workbook, create a table: with headers: Region, Metro, University, Employment, Enrollments

2. Build the table using direct sourcing from the appropriate tables to create this chart:

East Atlanta-Sandy Springs-Marietta, GA University of Central Florida [note 2] 2.1 59,770
Central Chicago-Joliet-Naperville, IL-IN-WI Ohio State University 0.9 57,466
West Dallas-Fort Worth-Arlington, TX University of Texas at Austin 3.3 51,145

3. Insert this as a formal table named LookupTable1

Set up Analysis Table

1. In the workbook Transforms-1, create headers:

OrderDate Location Employment University Enrollments Rep Item Units Cost Total

2. Location: Use VLOOKUP to associate Source-Sales region with lookup table Metro

3. Employment: Use VLOOKUP to associate Source-Sales region with lookup table Employment

4. University: Use VLOOKUP to associate Source-Sales region with lookup table university

5. Enrollments: Use VLOOKUP to associate Source-Sales region with lookup table enrollments

6. For columns OrderDate, Rep, Item, Units, Cost: Do a direct association with these values from the Source-Sales

7. For column Total: Create a simple formula Units * Cost

Create Pivot Tables and Charts

1. Create a pivot table and associated bar chart to show total sales per rep by Metro area. Label this workbook "Report-1"

2. Create a pivot table and associated bar chart to show total sales per rep by University. Label this workbook "Report-2"

3. Create a pivot table and associated bar chart to show total sales per employment number by University. Label this workbook "Report-3"

4. Create a copy of the Transforms table in a new workbook labeled "Transforms-2" and set up filters. Hide date, rep, item, units, costs columns. Create a pivot table and chart to show total sales per Metro area. Label this workbook "Report-4"

Attachment:- dowmloads.rar

Reference no: EM13761135

Previous Q& A

  Applying theory to a practice problem

It is important to understand how borrowed theory can help you in your everyday environment as a nurse.

  Paper about cyber security and identify assess and propose

Please refer to the latest document about cyber security and identify assess and propose: Risk related indicators and governance solutions, vulnerability assessment for cyber security

  Financial systems-financial management

From the second case study and e-Activity, determine the importance of bankers having good working relationships with their clients. Support your response with two (2) examples that illustrate such importance.

  How person you have indicated fulfills emersons description

Write an essay in which you discuss how the person you discuss and how the person you have indicated fulfills Emerson's description of a friend.

  Consumer-oriented promotions

Propose two (2) uses for consumer-oriented promotions that could assist a company in both the short and long term for the product group that you selected. Provide a rationale for your response.

  Analyze personal privacy issues

Objective: Analyze personal privacy issues related to various personal and business-related cybersecurity scenarios. Competencies: Critical thinking, communication skills

  Explain the purpose of sql data access

Why is SQL Data Access considered middleware? Explain the purpose of SQL Data Access. How does it differ from other types of middleware

  Health care industrys trends and policies

Identify and analyze the various elements that comprise your health care industry's trends and policies. Define and explain the economic and business conditions, premises, policies, and other related forces that form the basis for generating change i..

  Create an annotated bibliography

For the course project, you will create an annotated bibliography of five sources that cites and describes four of the best Internet resources on a specified topic and one of the best library database resources.

  Value of working capital instead of a cash flow budget

An advantage of using the value of working capital instead of a cash flow budget to analyze a farm's liquidity would be:


Write a Review


Similar Q& A

  Prepare a set of non-functional requirements

Need a system that networks its 3 campuses in the US and one campus in Singapore. Transaction data for all campuses should be available to all locations. In addition, students should be able to use the Internet to view classes, enroll, register, and ..

  Summarize your paper by explain the database systems in

write a 600- to 700-word paper in which you do the following explain what database systems are and how they are used.

  Design scheme for determining wine bottle which poisoned

Design a scheme for determining exactly which one of the wine bottles was poisoned in just one month's time while expending O(logn) taste testers.

  Discuss social engineering techniques

Discuss how the information gathered during your footprinting analysis could be used to initiate an attack against the organization. Discuss social engineering techniques that could be utilized to gather information regarding the organization's com..

  Construct an er diagram for a hospital

Construct an er diagram for a hospital with a set of patients and a set of medical doctors. associate with each patient a log of various test and examination conducted.convert er diagram into tables

  Determine the relationship between those areas

For this question, need data mining analysis (using k-means clustering algorithm) shows the relationship between poverty area and violent crime rate (homicide) depending on any one of the datasets attached with this assignment.

  How an organization would allow programmatic access

A few years have passed, and the restaurant has grown to become a national restaurant chain. Now, they are concerned that remote and branch offices and restaurants in all fifty states will not have ready access to the data.

  Modify oracle table data using the correct sql statements

Explain how you could delete the IT department without deleting all the employees who work for that department.

  Benefits of using databases and dbmss

Assignment: Research organizational benefits of using databases and DBMS's. Supplement your research with a review of your lessons. Post a response to the discussion board: Respond to the following statements and, if appropriate, include personal e..

  Explain how you arrived at your final solution

Explain how you arrived at your final solution for the four conceptual and process view diagrams that you have created and describe how you created the conceptual and process view for all four (4) diagrams. In the description, be sure to provide a j..

  Distribution of resource consumption

Compute the activity rates for the Filling Orders and Product Support activity cost pools by filling - Distribution of resource consumption

  Demodulator circuits and amplitude modulator

Explain how much the modulating signal power is required to generate 100 percent modulation? What is the approximate center frequency of filter required to pass the lower sideband?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd