View the step-by-step solution to:

Tutorial:

I need to know how to get the database from the Northwinds and what SQL I would use to obtain it.
MIS 235 – Spring 2012 Preparation Assignment for Wednesday 4/4 This assignment is worth 24 points (see rubric on page 3) and is due at 8am on Wednesday 4/4 . Tutorial: Below are three links to online tutorials that should help get you back up to speed in how to create and use pivot tables. Depending on how “dusty” your Excel and pivot table knowledge is, it may take you some time to get back up to speed. http://office.microsoft.com/training/Training.aspx? AssetID=RC102058721033&CTT=6&Origin=RC102058721033 http://office.microsoft.com/training/training.aspx?AssetID=RC102080371033 http://office.microsoft.com/training/training.aspx?AssetID=RC102102791033 Submission Guidelines: Below are the submission guidelines: You need to submit a single Excel file with 6 sheets as follows: (1) A sheet showing the SQL query you used to generate the data. Label this sheet: SQL (2) A sheet showing the data set which you brought across from the Northwinds database. Label this sheet: Dataset (3) A sheet showing the BI tool you built (i.e., your pivot-table(s). Label this sheet: PivotTable (4) A sheet with your answer to Q1. Label this sheet: Q1 (5) A sheet with your answer to Q2. Label this sheet: Q2 (6) A sheet with your answer to Q3. Label this sheet: Q3 Name your file so that it includes your last name and first name followed by your section number followed by the assignment name followed by the assignment due date. Here’s an example: Hamdan, Basil-SectionM-PivotTableHW 4-4 Upload your file to Niihka using the ‘Assignments’ Link. Remember, you will not be able to upload your file after 8am on Wednesday 4/4. Any assignment sent to me via email will NOT be graded. Requirements: For this assignment, assume you are a data analyst for Northwinds Corporation (See Data Model on next page). Your task is to use a BI reporting tool to analyze data about Northwinds sales revenues. Specifically, you will need to use SQL to get the data from the Northwinds database and then use a pivot table-based solution to answer the following questions: Q1 : A ranked list showing the total sales revenue for each of the products (use the ProductName field) sold in the year 2010 (use the OrderDate field). The sales figures should be formatted as currency and sorted from largest to smallest. 1
Background image of page 1
Q2 : A ranked list showing the total sales revenue for each of the top 10 revenue-producing products (use the ProductName field) in 2010 (use the OrderDate field). The sales figures should be formatted as currency and sorted from largest to smallest. Q3 : A ranked list showing the total sales revenue for each of the top 10 revenue-producing products (use the ProductName field) for each of the 4 quarters in 2010 (use the OrderDate field). The sales figures should be formatted as currency and sorted from largest to smallest. http://sbaoracle.sba.muohio.edu For additional help: MIS 235 Lab: FSB 2050 Hours: M/T/W 5:00pm - 7:00pm 2
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

Dear Student, I have reviewed your assignment thoroughly, based on your assignment details and current... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online