Required Information Lab Note: The tools presented in this lab periodically change. Updated Instructions, if applicable, can be found in the eBook and lab walkthrough videos in Connect. Case summary: When you're working with a new or unknown set of data, validating the data is very important. When you make a data request, the IT manager who fills the request should also provide some summary statistics that include the total number of records and mathematical sums to ensure nothing has been lost in the transmission. This lab will help you calculate summary statistics in Power BI and Tableau Desktop. Note: Submit your answers for the following Analysis Questions in the text entry field below. AQ1. Compare the loan amounts to the validation given by LendingClub for borrowers from PA: Funded loans: $123.262.53 Number of approved loans: 8,427 Do the numbers in your analysis match the numbers provided by LendingClub? What explains the discrepancy, if any? AQ2. Does the Numerical Count provide a more useful/accurate value for validating your data? Why or why not do you think that is the case? AQ3. Compare and contrast: Why does Power Query and Tableau Desktop return different values for their summary statistics? AQ4. Compare and contrast: What are some of the summary statistics measures that are unique to Power Query? To Tableau Desktop?