代码代写｜DS6504 Assignment 1: Interactive Dashboard Application

这是一篇来自新西兰的关于商业智能和大数据的代码代写

Submission details

Use the Drop Box feature I have set up called ‘Assignment 1 – Drop Box’ in the Assignment section of my Moodle site. You should submit your group’s report, as described in Task 6 and in the Assignment Deliverables section of this document. Also include the script in your submission that contains the commands you used to create the views and stored procedures (Task 2 and 3). This script should be zipped with your report and uploaded into Moodle as a single file. Only 1 submission per group is required. Please include the names of all students within your group on the cover sheet of your report.

Extensions

Extensions of time will only be granted for students who have an acceptable documented reason for not completing the assessment by the specified due date.

Grading

This assignment is worth 30% of the total module.

The assignment will be marked out of 100.

To pass a grade of 50% must be achieved.

Terms

See details of terms in the Bachelor of Information Technology handbook.

Group Work

You will work in a self-selected group to complete this assignment. Group size should not exceed 2 students. Alternatively, you may choose to work alone on this assignment.
A group contribution formmust be completed by your group and submitted with the assignment. You can find the form on my Moodle site in the Assignments section.

Purpose

This assignment requires you to work collaboratively in a small group to develop an interactive dashboard reporting service that will visualise data extracted from a SQL Server database. The layout and content of this dashboard is shown in Appendix A. Data will be extracted from a database using a combination of Views and parameterised Stored Procedures that you will create according the specifications described in the Tasks section below. The dashboard will be created using the Reporting Services template within the SQL Server Data Tools environment. It will consist of a number of widgets including tables, gauges and a map, which change dynamically in response to user input.

Tasks

Create Views and Stored Procedures to extract data:

Download the database backup file called MaxMinManufacturingDWusing the link in the Assignment One section in Moodle. Restore the database in SQL Server using the instructions on Moodle.
In SQL Server, create 3 views that will be used to provide data to stored procedures that you will define in Task 3. The content of each view is described as follows:
Create a view called vInventoryByType. This view will display the inventory levels of products, their product type and product subtype name, and the date the inventory was taken. Each row will display the product type name, product subtype name, the inventory date and the inventory level of the product recorded on that day.
Create a view called vAcceptedByCountry. The view will display the number of accepted products manufactured, the date of manufacture and the name of the plant and country where the product was manufactured. Each row will display the country code, country name, plant name, the date of manufacture and the number accepted products manufactured by machines at that plant on that day.
Create a view called vRejectedProductsByType. The view will display the number of manufactured products (accepted products + rejected products) and the percentage of rejected products to this total. It will also list the date of manufacture and the product type and product subtype name. Each row will display the product type name, product subtype name, the date of manufacture, the manufactured products total and the percentage of rejected products that were manufactured on that day.

Refer to Appendix B to see the expected content within each of these views. You should not proceed to Task 3 until your output matches Appendix B.

Create 3 stored procedures that will use the views defined in Task 2. Each stored procedure will accept two input parameters; Yearand Month. Additional processing performed by each stored procedures is described as follows:
1. Create a stored procedure called spMaxInventoryByType. The stored procedure will use the view called It will display the highest inventory level value within each product subtype, recorded during the month of the year supplied by the input parameters. Each row returned by the procedure will list the product type name, the product subtype name and the highest inventory level value recorded out of all products within that product subtype, during the specified reporting period.
2. Create a stored procedure called spAcceptedByCountry. The stored procedure will use the view called It will display the total number of accepted products manufactured at a plant during the month of the year supplied by the input parameters. Each row returned by the procedure will list the country code, country name, plant name and the total number of accepted products manufactured at that plant, during the specified reporting period. In addition, the following element from each plant name should notbe displayed ‘Maximum Miniatures -‘ in the results returned by the procedure.
3. Create a stored procedure called spAvgRejected. The stored procedure will use the view called It will display the total number of products manufactured and the percentage of those products rejected within each product subtype, during the month of the year supplied by the input parameters. Each row returned by the procedure will list the product type name, product subtype name and the total number of products manufactured and the percentage of those products rejected within that product subtype, during the specified reporting period.

Refer to Appendix C to view the output that should be generated from each of these stored procedures. You should not proceed to Task 4 until your output matches Appendix C.

Create a Report Server Project within SQL Data Tools that invokes the stored procedures developed in Task 3. Refer to Appendix Ato see the layout and content of the required dashboard. The Report Server Project will have one Shared Data Source that will be used to connect your reporting application to the MaxMinManufacturingDM data warehouse. The project will consist of three Shared Datasets; one for each of the stored procedures created in Task 3. The project will have one report called MaxMinDashBoard that will display the data provided by these stored procedures. Each element of the report is described below.
1. Create a Shared Dataset in the Solutions Explorer panel called MaxInventoryByType and bind it to the spMaxInventoryByType stored procedure created in Task 3. In the Report Data panel, create a Dataset object with the same name and set its properties so that it uses the Shared Dataset you have just created. Define a filter for this Dataset so that only rows where the inventory level exceeds a value of 10,000 are returned. Create a Table report item in the MaxMinDashBoard report and bind it to this Dataset. Refer to Appendix Afor the required layout and formatting this reporting element requires (called Products Exceeding Maximum Inventory Level (10K) in the dashboard).

Create a Shared Dataset in the Solutions Explorer panel called AcceptedByCountry and bind it to the spAcceptedByCountry stored procedure created in Task 3. In the Report Data panel, create a Dataset object with the same name and set its properties so that it uses the Shared Dataset you have just created.

程序辅导定制C/C++/JAVA/安卓/PYTHON/留学生/PHP/APP开发/MATLAB