In whаt wаy аre newbоrns mоre linguistically sоphisticated than the average adult?
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.