Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Assessment Instructions Bike Stores is a small business chain that sells bicycle

by | Nov 25, 2021 | Computer Science homework help

GET HELP WITH YOUR ESSAY

If you need assistance with writing your essay, our professional Essay Writing Service is here to help!

DISCOUNT CODE FIRST25

ORDER THIS OR A SIMILAR PAPER NOW

Assessment Instructions
Bike Stores is a small business chain that sells bicycles at stores in California, Texas, and New York. The business owners would like several reports to be generated that provide information on company sales. These reports will leverage data currently stored in the BikeStores database. You will install Microsoft Report Builder on the same system you have Microsoft SQL Server and SQL Server Management Studio (SSMS) installed. You will then generate column chart, bar chart, line chart, pie chart, and tabular reports presenting various views of BikeStores sales.
It is very important that you watch the Module 5 videos associated with SQL prior to completing the assessment. You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) for this course. You can download the latest versions of these free software products here:
Microsoft SQL Server Express
Microsoft SSMS
Navigate to the Academic Tools area of this Module and select Library then Required Readings to access your texts and videos. You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) for this course.
You must have SQL Server Express and SQL Server Management Studio (SSMS) installed to complete this assessment. The sample database for this module is called BikeStores. The database creation script, installation instructions, and database diagram can be downloaded below:
Create BikeStores Database Script
Instructions for Establishing the BikeStores Database
Bikestores Database Design Diagram
Use the BikeStores database design diagram to help address applicable assessment tasks. You will need to fully understand the BikeStores database design for this assessment.
You must also install the Microsoft Report Builder application. The following document provides instructions on how to install Microsoft Report Builder:
Microsoft Report Builder Installation Instructions
Provide your assessment task responses in a Microsoft® Word® report document. Also, incorporate a screenshot of each completed Microsoft Report Builder report into the assessment document as proof of completed work.
Task 1 – Generate a Column Chart Report
You are tasked to generate a column chart report showing the top five bike sales. Use the following guidance document to generate the column chart report:
Creating a BikeStores Column Chart Report
Describe how the query contained in the common table expression (CTE) works. Are correlated or uncorrelated subqueries leveraged? Are the query results filtered? If yes, how are the results filtered? Are table joins used in the query? If yes, what tables are linked together? Are aggregate functions leveraged in the query? If yes, describe what results are being sought along with the applicable grouping parameters.
Examine the generated column chart report. What information can be drawn from this report? What assertions can be made from this report?
Task 2 – Generate a Pie Chart Report
You are tasked to generate a pie chart report showing the sales percentage for each bike category. Use the following guidance document to generate the pie chart report:
Creating a BikeStores Pie Chart Report
Describe how the query contained in the common table expression (CTE) works. Are correlated or uncorrelated subqueries leveraged? Are the query results filtered? If yes, how are the results filtered? Are table joins used in the query? If yes, what tables are linked together? Are aggregate functions leveraged in the query? If yes, describe what results are being sought along with the applicable grouping parameters.
Examine the generated pie chart report. What information can be drawn from this report? What assertions can be made from this report? 
Task 3 – Generate a Bar Chart Report
You are tasked to generate a bar chart report showing monthly sales for each BikeStores location in the year 2017. Use the following guidance document to generate the bar chart report:
Creating a BikeStores Bar Chart Report
Describe how the query contained in the common table expression (CTE) works. Are correlated or uncorrelated subqueries leveraged? Are the query results filtered? If yes, how are the results filtered? Are table joins used in the query? If yes, what tables are linked together? Are aggregate functions leveraged in the query? If yes, describe what results are being sought along with the applicable grouping parameters.
Examine the generated bar chart report. What information can be drawn from this report? What assertions can be made from this report? 
Task 4 – Generate a Line Chart Report
You are tasked to generate a line chart report showing monthly sales for each bike category in the year 2016. Use the following guidance document to generate the line chart report:
Creating a BikeStores Line Chart Report
Describe how the query contained in the common table expression (CTE) works. Are correlated or uncorrelated subqueries leveraged? Are the query results filtered? If yes, how are the results filtered? Are table joins used in the query? If yes, what tables are linked together? Are aggregate functions leveraged in the query? If yes, describe what results are being sought along with the applicable grouping parameters.
Examine the generated line chart report. What information can be drawn from this report? What assertions can be made from this report? 
Task 5 – Generate a Tabular Report
You are tasked to generate a tabular report showing bike category sales by year. Use the following guidance document to generate the tabular report:
Creating a BikeStores Tabular Report
Describe how the query contained in the common table expression (CTE) works. Are correlated or uncorrelated subqueries leveraged? Are the query results filtered? If yes, how are the results filtered? Are table joins used in the query? If yes, what tables are linked together? Are aggregate functions leveraged in the query? If yes, describe what results are being sought along with the applicable grouping parameters.
Examine the generated tabular report. What information can be drawn from this report? What assertions can be made from this report?

DISCOUNT CODE FIRST25

ORDER THIS OR A SIMILAR PAPER NOW

Categories

SERVICES

What We Do

b

Essay Writing Services

h

Term Paper Writing Services

Assignment Writing Service

U

Research Paper Writing

Case Study Writing Services

k

Thesis Writing Services

TESTIMONIALS

What People Are Saying

I had casually placed an order on Lesson-edu.info for a short essay and wanted to see if their claim of timely delivery of tasks was true or not. The assignment was not delivered on time, but the quality of the essay was also remarkable.

Adeline West

“Being associated with experts minds for 1 year, i am extremely happy and fully satisfied with your high class assistance and quality writing services! Cheers!”

Rachel

“Thanks guys! You have great writer who helped me in my last assignment! I got excellent grade in my last assignment and i will recommend you!”

Theresa Reeves

“It was awesome experience to work with professional writers of experts ! This really helps to score high in university homework!”

Ada Leonard

Easy As 1…2…3…

1. Place Order/Submit Instructions
Submit the instructions in the order form. Add the number of the pages, the deadline, and attach any additional files.

2.Make Payments
Securely complete the payment process.

3. Writer Upload Solution for Quality Check

We will assign your work a writer, sit back and relax. The Quality Control department will check and verify completion to set standards.

4. Download Paper and Enjoy
Now download the uploaded solution and enjoy your life.

Confidentiality

We encrypt everything. It’s all confidential.

Secure Payment

Sleep tight: each transaction is encrypted and 100% secure.

Ready to get started?

%d bloggers like this: