baap pdf dav midterm.pdf - Contents Quiz Questions 1 Hands-on Quiz 1 1 Hands-on Quiz 2 2 Hands-on Quiz 3 3 Knowledge-based Quiz 1 3 Knowledge Based Quiz

baap pdf dav midterm.pdf - Contents Quiz Questions 1...

This preview shows page 1 - 5 out of 61 pages.

Contents Quiz Questions .............................................................................................................................................. 1 Hands-on Quiz 1 ........................................................................................................................................ 1 Hands-on Quiz 2 ........................................................................................................................................ 2 Hands-on Quiz 3 ........................................................................................................................................ 3 Knowledge-based Quiz 1 ........................................................................................................................... 3 Knowledge Based Quiz 2 ........................................................................................................................... 4 Forecasting ................................................................................................................................................ 5 Trendlines ................................................................................................................................................. 6 Data Manipulation Quiz ............................................................................................................................ 6 Calculations ............................................................................................................................................... 7 Joins and Blends ........................................................................................................................................ 8 Level of Detail ........................................................................................................................................... 9 Answers and Solutions ................................................................................................................................ 10 Hands-on Quiz 1 ...................................................................................................................................... 10 Hands-on Quiz 2 ...................................................................................................................................... 16 Hands-on Quiz 3 ...................................................................................................................................... 21 Knowledge-based Quiz 1 ......................................................................................................................... 28 Knowledge Based Quiz 2 ......................................................................................................................... 30 Forecasting .............................................................................................................................................. 31 Trendlines ............................................................................................................................................... 36 Data Manipulation Quiz .......................................................................................................................... 41 Calculations ............................................................................................................................................. 48 Joins and Blends ...................................................................................................................................... 51 Level of Detail ......................................................................................................................................... 55 Quiz Questions Hands-on Quiz 1 1. For items shipped in July of 2012, what percent of sales were sent in a Large Box?
Image of page 1
13.27% 11.46% 11.95% 2. Find the top product subcategories by Sales within each delivery method. The second highest subcategory for Regular Air sales is ranked #______ for Express Air. 1 2 3 4 5 3. In the furniture category, which unprofitable state is surrounded by only profitable states? Vermont Iowa Utah Hands-on Quiz 2 1) If 2013 Sales numbers were expected to increase by 10% in the following year in all customer segments, what would be the total estimated sales for Home Office in 2014? 617,498 679,248 2,385,847 2) Which product has the highest ship cost to sales ratio? Hoover® Commercial Lightweight Upright Vacuum Accohide Poly Flexible Ring Binders Kensington 7 Outlet MasterPiece Power Center with Fax/Phone Line Protection Lexmark 4227 Plus Dot Matrix Printer 3) Find the customer with the highest profit. What is his or her average shipping cost per order?
Image of page 2
[Hint: to calculate the shipping cost per order you will need to calculate the number of orders using the count distinct function] 66.72 10.49 12.59 12.18 Hands-on Quiz 3 1) Which product category has the largest interquartile range for sales? Furniture Office Supplies Technology 2) Which product sub-category has total sales which is $81,960 below the average sales per sub-category? (First calculate the average sales per subcategory, then subtract this value from the sales broken out by sub-category) Paper Chairs & Chairmats Tables Office Furnishings 3) The top 5 customers by sales represent ____ of the total profits. 2.63% .55% 1.65% Knowledge-based Quiz 1 1) A dimension is a field that typically holds numerical data discrete qualitative data 2) Dates are typically treated as
Image of page 3
dimensions measures 3) What word describes the area highlighted in light blue under the mouse cursor in the image below? measure 4) The icon next to a field means that field is numerical qualitative geographic date or time Knowledge Based Quiz 2
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 61 pages?

  • Winter '19

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors