If you have any issue please feel free to email me. Please…

Questions

If yоu hаve аny issue pleаse feel free tо email me. Please make certain yоu review and follow the rules for taking your exams or you will receive a zero. This exam must be completed in one period, it cannot be closed and reopened. Review the exam rules below: Please make certain you review and follow the rules for taking your exams or you will receive a zero. This exam must be completed in one period, it cannot be closed and reopened. Review the exam rules below: Honorlock chrome extension and a webcam are required for this exam. Remote Proctoring: Some classes may use live proctoring or an automatic video recording system for proctored testing.  If your instructor requires you to use this testing option, your location must meet instructor guidelines for privacy and security.  If the location you choose is a home or personal environment, you agree to allow your activity and surrounding workspace to be viewed and/or recorded by video and audio to ensure testing integrity.  If you do not agree to have your private testing environment viewed and/or recorded, please contact your instructor immediately so arrangements can be made for on-campus proctored testing. Students who live near the college are welcome to contact the course instructor and testing center to schedule each of their exams for the semester. If the student decides that they wish to take the exam at home the following are requirements: Computer with webcam, microphone, reliable Internet connection Before students start the exam, they have to show their driver's license or other photo ID. Student will need to be in a room with a door that is shut. They are to use the camera to show the room (360 degrees) including the desk/table, under table and floor. Once the exam has started the student cannot get up from the location until the exam is No other person should be in the room or enter the room. Both the webcam and microphone is to be on at all time during the exam and the webcam should be pointed at the student. Items that can be used is a pencil and a sheet of paper. The paper must be shown prior to the start of the exam to ensure it is blank on both sides. Environment Requirements: A quiet, secure, fully lighted room for the examination. No other people in the room Sit at a clean desk or clean table (not in a bed or sofa) No talking out loud or communicating with others by any means (with the exception of contact with the faculty member in an emergency) No leaving the room Nothing except computer and external cameras on the desktop or tabletop - removal of all books, papers, notebooks, or other materials, unless specifically permitted in written guidelines for a particular examination. Students are not allowed to use the following unless otherwise noted by instructor/exam giver: Excel; Word; PowerPoint; Calculator (online/computer or handheld devices); Textbooks (online/computer or hardcopy books); Notes (online/computer or hardcopy notes); Pen and Paper (for the purpose of taking notes during exam or calculations); Other websites. External cameras, when possible, should be placed on the lid of the laptop or where it will have a constant, uninterrupted view of the test taker No writing visible on desk or on walls No music playing No other computers or other digital devices running in the exam room No headphones or ear buds allowed Webcam must be focused on the individual test taker Lighting must be good quality. Overhead is preferred. Failure to follow the Examination rules will RESULT in a zero for the Exam. Once you have read the above type I agree in the box below to begin:

Prоblems 5-6 Pоwer BI Desktоp: Use the dаtа in the Midterm_PowerBI_Dаta.xlsx file to create a data model in a new Power BI Desktop file. Work the following problems and submit your work in a pbix file. Problem 5 Import & Work with Data (20 points): Create a blank report in Power BI Desktop. (a) (4 Points) Import the following tables from the excel file xlsx Category, Date, Defect, Defect_Type, Material, Metrics, Plant, & Vendor (b) (4 Points) Transform the data in the Defect table to only two columns (Defect & Defect ID). All other tables can be imported as is.(c) (4 Points) Ensure the following relationships are established between tables in the data model One to many (1.) from ‘Defect_Type’[Defect Type ID] to ‘Metrics’[Defect Type ID] One to many (1.) from ‘Plant’[Plant ID] to ‘Metrics’[Plant ID] One to many (1.) from ‘Material’[Material Type ID] to ‘Metrics’[Material Type ID] One to many (1.) from ‘Defect’[Defect ID] to ‘Metrics’[Defect ID] One to many (1.) from ‘Category’[Sub Category ID] to ‘Metrics’[Sub Category ID] One to many (1.) from ‘Date’[Date] to ‘Metrics’[Date] *Note: Power BI creates many of these relationships when you import the tables. Check to ensure the relationships are correct. Make sure you add any missing relationships. (d) (4 Points) In the ‘Metrics’ table, create two measures. Measure 1: The first measure should return the maximum value for [Downtime min] (the downtime in minutes). Name this measure “MaxDowntime” Measeure 2: The second measure should return the maximum value for [Defect Qty]. Name this measure “MaxDefectQty”. (e) (4 Points) In the ‘Metrics’ table, create one calculated column. Name the calculated column “Downtime Category”. Use nested if statements to return the following. If [Downtime min] is less than or equal to 30 minutes, return “Low Impact” If [Downtime min] is greater than 30 minutes, but less than or equal to 90 minutes, return “Medium Impact” If [Downtime min] is greater than 90 minutes, return “High Impact” Problem 6 Visualize Data (15 points): (a) (1 Point) In report view, rename the first report page to “Summary” and create a second page named “Downtime Analysis”(b) (1 Point) On the left side of the Summary report page, input a Matrix visual Rows: Material Type Columns: Year Values: Sum of Defect Qty (c) (1 Point) In the middle of the Summary report page, input a stacked column chart visual X-axis: Date (include only year and month groups) Y-axis: Sum of Defect Qty Legend: Defect Type (d) (1 Point) On the right side of the Summary report page, input a slicer with the field [Material Type] (e) (1 Point) In the top right of the Summary report page, add a card visual displaying the MaxDefectQty Change the callout value font to Calibri size 20 Change the category label font to Calibri size 12 (f) (1 Point) In the top left of the Summary report page, add a Text box with the text “Defect Summary” Change the font to Calibri size 20 (g) (2 Points) Add a right arrow button at the bottom of the Summary report page The right arrow should have a page navigation action enabled to move to the “Downtime Analysis” report page if clicked. (h) (1 Points) On the left side of the Downtime Analysis report page, input a stacked bar chart visual Y-axis: Vendor X-axis: Sum of Downtime min Legend: Category Ensure the sort is in descending order on Sum of Downtime min (i) (1 Point) On the right side of the Downtime Analysis report page, input a Pie Chart Legend: DownTime Category Vaues: Sum of Defect Qty (j) (1 Point) On the right side of the Downtime Analysis report page (below the Pie Chart), input a slicer on the field [Category] (k) (1 Point) In the top right of the Downtime Analysis report page, add a Card visual showing the MaxDowntime. Change the callout value font to Calibri size 20 Change the category label font to Calibri size 12 (l) (1 Point) In the top left of the Downtime Analysis report page, add a Text box with the text “Downtime Analysis” Change the font to calibri size 20 (m) (2 Points) Add a left arrow button at the bottom of the Downtime Analysis report page The left arrow should have a page navigation action enabled to move to the “Summary” report page if clicked.

Scenаriо: Perfоrmаnce Optimizаtiоn for a Resource-Intensive ProgramScenario: A design company recently installed a new 3D rendering program on their Windows computers. The program requires significant processing power and memory, but many of the computers struggle to run it efficiently. The computers currently have 4GB of RAM and standard mechanical hard drives.Question: What optimization steps can the company take to improve the performance of the 3D rendering program on their existing machines?