Assignment Instructions
You must have SQL Server Express and SQL Server Management Studio (SSMS) installed to complete this assignment. You must also install the Microsoft Report Builder application. The following document provides instructions on how to install Microsoft Report Builder:
You will need to fully understand the COVID-19 database design for this assignment. The COVID-19 database design diagram and data dictionary can be accessed via the following links:
Provide your assignment task responses in a Microsoft Word report document. Incorporate a screenshot of each completed Microsoft Report Builder report into the assignment document as proof of completed work.
Task 1 – Generate a Column Chart Report
You are tasked with generating a column chart report showing the five states/jurisdictions with the highest cumulative number of reported COVID-19 cases. Use the following guidance document to generate the column chart report:
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 with generating a pie chart report showing the administration percentage of each COVID-19 vaccine. Use the following guidance document to generate the pie chart report:
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 with generating a bar chart report showing the monthly COVID-19 vaccine distribution for the first six months of 2021 in the United States. Use the following guidance document to generate the bar chart report:
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 with generating a line chart report showing the monthly reported COVID-19 cases in the 2021 calendar year. Use the following guidance document to generate the line chart report:
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 with generating a tabular chart report showing the monthly reported COVID-19 cases in the 2021 calendar year. Use the following guidance document to generate the tabular report:
Examine the generated tabular report. What information can be drawn from this report? What assertions can be made from this report?
Task 6 – Interpret Data Dashboards
Interpret the data dashboards by writing a 50-100 word description for each graph detailing the data.
Requirements: 8 PAGES
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
Leave a Reply
You must be logged in to post a comment.