Bike Stores is a small business chain that sells bicycles at stores in California, Texas, and New York. The business owners w

 Assessment InstructionsBike 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 ExpressMicrosoft SSMSNavigate 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 ScriptInstructions for Establishing the BikeStores DatabaseBikestores Database Design DiagramUse 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 InstructionsProvide 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 ReportYou 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 ReportDescribe 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 ReportYou 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 ReportDescribe 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 ReportYou 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 ReportDescribe 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 ReportYou 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 ReportDescribe 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 ReportYou 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 ReportDescribe 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?BikeStores_Database_Design_Diagram.pdfInstructions_BikeStores_Database.pdfMicrosoftReportBuilder_Installation.pdfBikeStores_ColumnChartReport.pdfBikeStores_LineChartReport.pdfBikeStores_PieChartReport.pdfBikeStores_TabularReport.pdfCreateBikestore.sqlThe post Bike Stores is a small business chain that sells bicycles at stores in California, Texas, and New York. The business owners w Essay writing ServiceThe post Bike Stores is a small business chain that sells bicycles at stores in California, Texas, and New York. The business owners w first appeared on.
. .
No Plagiarism in OriginalpapersOrg.

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more