Hands-On Exercise 1

docx

School

California State University, Los Angeles *

*We aren’t endorsed by this school

Course

4200

Subject

Computer Science

Date

Feb 20, 2024

Type

docx

Pages

4

Uploaded by MasterOwlMaster673

Report
Kathlyne Alilain Dr. Li CIS 4200-01 15 Feb. 2024 Hands-On Exercise 1 1) Create three pivot tables/reports to answer the following questions. - Which product provided the highest revenue? (Create a new variable: Revenue = Price * quantity). Sort the table based on revenue from high to low. Laser Printer - Which department provided the highest revenue? Computer - Which customer spent the greatest amount of money? Rose Clair Add another measure to the report to show the revenue percentage. Answer the following questions: - Which product provided the highest revenue? And what percentage does this product contribute to the total revenue? Laser Printer, 25.61% - Which department provided the highest revenue? And what percentage does this department contribute to the total revenue? Computer, 46.37% Use the group function to group the observations. Answer the following questions: - For the bottom five customers that spent the least money, what percentage do these five customers contribute to the total revenue? 20.44% - For the bottom three products that provided the least revenue, what percentage do these three products contribute to the total revenue? 0.64%
Use the filter function to filter the observations. Answer the following questions: - Which product provided the highest revenue in the Domestic channel? Bike - Which department provided the highest revenue in the Domestic channel? Sport - Can we filter multiple pivot tables/reports simultaneously? Yes, use slicer function and connect the slicer to all the pivot tables. 2) Add multiple dimensions to the pivot table to answer the following questions. - Which product provided the highest revenue in Feb and March? Sort the table based on revenue from high to low. Walkman - Which department provided the highest revenue in the first quarter? Sort the table based on revenue from high to low. Hint: use the time slicer function and the group function. Computer
3) Which customer spent the most amount of money? What product did they spend the most money on? Sort the table based on revenue. Rose Clair, Laser Printer 4) Which salesperson provided the most sales revenue? Which customer bought the most from this salesperson? And which product this customer purchased the most from this salesperson? Sort the table based on revenue. Jenkin, Jones Mathew, Laser Printer 5) Choose the right measure based on requirements. And answer questions. - Which product sold the most units? (use quantity instead of sales). Mouse mats
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
6) Choose the right aggregate function of measure based on requirements. Use price as a measure. Show the average price and standard deviation for each product. Which product had the highest average price? Digital Camera, there was no standard deviation to be calculated as there was only one record for it.

Related Documents

Practice Midterm 2 - With Answers .pdf
Sample Midterm 2 - With Answers, Updated.pdf
Practice Midterm 1.pdf
Practice Midterm 1 - With Answers.pdf
Changes to Security and Safety Report by Traci Phelps.docx
CIS 4880-02_ Linux Essentials.pdf
Hands-On Exercise 2.docx
Research Brief.docx
Lab 2 (1.6.2).docx
Privacy and Civil Liberties Outline.docx
Privacy and Civil Liberties Outline Rewrite.docx
Current Topic Critique.docx
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
SEE MORE TEXTBOOKS