Create pivot tables in excel using the queries

Assignment Help Database Management System

Reference no: EM132224852

Adventure Works Business Requirements -

The following documents and Adventure Works example are from the Kimball Group website.

Part 1 -

Review these documents, choose four of the Requested Analyses from the AW_Analytic_Themes_List and create the necessary SQL query to support each of them. Provide a screenshot of each of the query results in a Word document and copy and paste the query text into the Word document, as well. If the AdventureworksDW2016 database does not have the information required, use the AdventureWorks2016 database.

Provide an explanation regarding which analysis you are providing (for each of the four) and also what data (tables and fields) you have selected and why. 15 points each (60 points possible)

You will be graded on query syntax and appropriate table/field selection for each analysis. I will be verifying that the SQL queries that you submit actually run without errors in Management Studio.

Know that this will be the first time for many of you to take business requirements and create supporting queries that provide the necessary data from a database. There are several Analyses that are fairly simple and straight-forward. It is fine if you choose these. For those of you that have more SQL query experience, this is your chance to try some of the more difficult options. As long as your queries run and the explanations for how the query(s) will support the requirement are reasonable, you will be awarded full points.

Part 2 -

Create Pivot Tables in Excel using the queries you created in Part 1 and then create at least one Excel Visualization to appropriately display the data from the pivot tables for the business users. Submit the pivot tables and visualizations in one or more Excel documents.

Attachment:- Assignment Files.rar

Reference no: EM132224852

Questions Cloud

Marketing has been characterized as orientation : Marketing has been characterized as an orientation that should be adopted across the entire firm.

Construct of perceived seriousness in health belief model : The construct of perceived seriousness in the Health Belief Model explains that behavior cannot be changed unless the health issue is fatal

Increased productivity and profitability innovation provides : The required reading Mobile Technology for Increased Productivity and Profitability Innovation provides

Determine the standard time for job : Assuming allowance factor of 15 percent of work time which is applied only to the worker element, determine the standard time for this job.

Create pivot tables in excel using the queries : Create Pivot Tables in Excel using the queries you created in Part 1 and then create at least one Excel Visualization to appropriately display the data

Key performance indicators the strategic and managerial : Identify critical success factors and key performance indicators the strategic, managerial, and operational levels respectively.

Identify major sources of information to monitor these trend : Analyze their impact on the firm and, Identify major sources of information to monitor these trends.

Current state of communications technology infrastructure : What business problem was this organization trying to solve? What was the current state of their communications technology infrastructure?

Turn fragmented industry into consolidated industry : Why are industries fragmented? What are the primary ways in which companies can turn a fragmented industry into a consolidated industry?

Reviews

len2224852

1/30/2019 8:47:33 PM

Provide an explanation regarding which analysis you are providing (for each of the four) and also what data (tables and fields) you have selected and why. 15 points each (60 points possible) I know that this will be the first time for many of you to take business requirements and create supporting queries that provide the necessary data from a database. There are several Analyses that are fairly simple and straight-forward. It is fine if you choose these. For those of you that have more SQL query experience, this is your chance to try some of the more difficult options. As long as your queries run and the explanations for how the query(s) will support the requirement are reasonable, you will be awarded full points. HINT: The queries from Assignment 1 can fulfill one or more of the business requirements with some field adjustments (adding and/or subtracting). Submit the pivot tables and visualizations in one or more Excel documents. 10 points each (40 points possible).

Write a Review

Required(*) Message

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!

Submit Assignment

User Account

All Pages