Sign In
Not register? Register Now!
Essay Available:
Pages:
2 pages/β‰ˆ550 words
Sources:
2 Sources
Style:
APA
Subject:
IT & Computer Science
Type:
Coursework
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 12.96
Topic:

Reporting Services in SQL Server

Coursework Instructions:

Assessment Description
The purpose of this assignment is to practice building a reporting project.
View the "SQL Server Reporting Services SSRS" video within the "Video Playlist: Relational Databases for Business Applications," located in the topic Resources (https://youtu(dot)be/NexygDqtRgI). And attachments made to EssayZoo through PDF form.
For this assignment, you will use the SQL Server Data Tools (SSDT) referenced in the topic Resources and Microsoft Visual Studio, which is part of the SQL Server Developer Edition. Start the VM for this assignment and inside the VM, click Start, type SSDT (to open Visual Studio 2017 (SSDT). Refer to Chapter 25 in the textbook for specific information related to creating the report. Note that while the textbook steps specify creating the report in SSRS, you will be using Microsoft Visual Studio; the textbook steps can still be executed.
The purchasing manager has requested you create a report that provides a quick list of active preferred vendors and their credit ratings.
Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to a Microsoft Excel file for a visual check of accuracy.
Create a Microsoft Word document that includes the SQL query code used to explore the database tables and answer the following questions.
1. Create a report with proper formatting that displays the vendor and credit information requested using the "Purchasing.Vendor" table in the AdventureWorks2017 database. Include the "Name," "Credit Rating," "Preferred," and "Active" fields. Export the report to Excel for submission.
2. Further refine the report you created in step 1 by vendors that currently have no orders. Use the "Purchasing.ProductVendor" table. Include "Min Order Qty," "Max Order Qty," and "On Order Qty." Export the report to Excel for submission.
3. In a minimum of 250 words, explain which components of SQL Server exist to deliver reports.
4. In a minimum of 250 words, explain how teamwork supports the design and development of a corporate information system, and how the corporate information system supports the organization.
Compile the Excel data file and Word document containing the SQL query code and answers to the questions into a .zip file and submit as directed by your instructor. and screenshots

Coursework Sample Content Preview:
Students Name
Institutional Affiliation
Course Code and Title
Instructors Details
Assignment Due Date
REPORTING SERVICES
1.Create a report with proper formatting that displays the vendor and credit information requested using the "Purchasing.Vendor" table in the AdventureWorks2017 database. Include the "Name," "Credit Rating," "Preferred," and "Active" fields. Export the report to Excel for submission.
2
Further refine the report you created in step 1 by vendors that currently have no orders. Use the "Purchasing.ProductVendor" table. Include "Min Order Qty," "Max Order Qty," and "On Order Qty." Export the report to Excel for submission.
3. SQL Server is a powerful and widely used relational database management system that provides a variety of tools and components for delivering reports. Some of the main components that are used to deliver reports in SQL Server include:
1 Reporting Services: This is a server-based reporting platform that allows you to create, manage, and deliver a wide range of reports, including tabular, matrix, and graphical reports. It also includes a web-based report designer and viewer, as well as a report server that can be used to schedule and distribute reports.
2 Report Builder: This is a user-friendly report authoring tool that allows you to create reports using a drag-and-drop interface. It can be used to create a wide range of reports, including tabular, matrix, and graphical reports.
3 SQL Server Data Tools: These are a set of tools that can be used to design, develop, and deploy SQL Server databases and reporting solutions. They include tools for creating and modifying tables, views, and stored procedures, as well as tools for developing reports, data sources, and datasets.
4 SQL Server Management Studio (SSMS): This is a tool that can be used to manage and administer SQL Server databases. It includes a variety of tools and features that can be used to design and develop reports, including a query designer, a report designer, and a report viewer.
5 Power BI: This is a business intelligence tool that can be used to create interactive and visually appealing reports. It can connect to various data sources, including SQL Server, and provides a wide range of visualizations and data exploration capabilities.
In addition to these components, SQL Server also includes other features and tools that can be used to deliver reports, such as data mining, data warehousing, and data integration. These features can be used to extract, transform, and load data from various sources, and then use this data to create reports that provide insights and intelligence to help organizations make better decisions.
4.
Teamwork is essential for the successful design and development of a corporate information system (CIS). A CIS is a collection of integrated software applications and databases that support the operations and decision-making of an organization. The design and development of a CIS involves a wide range of tasks, including requirements gathering, system analysis, design, implementation, testing,...
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
Order

πŸ‘€ Other Visitors are Viewing These APA Coursework Samples:

HIRE A WRITER FROM $11.95 / PAGE
ORDER WITH 15% DISCOUNT!
Order Now