"When you apply for a job in the field of analytics, you can expect to be asked technical questions and given math problems that will test your knowledge of statistical math and data management and analysis. The interviewer may test your critical thinking and decision making skills by having you solve word problems on the spot, as you will be expected to know how to gather insights into and draw conclusions from the data you collect on the job. Analytics is a broad field, and the technical questions you are asked will depend on the position you are applying for."
How would I validate the data for integrity of results?
Create quick pivot and then connect to the totals for different reports, using simple logical function in Excel.