ACCT 4550 – Accounting Data Analytics Evidence of Significant and Authentic Learning Cover Sheet ESL 2 Name: Requirements: 1. Complete labs 3-4, 3-5, 4-1, and 4-2 and 4-3. Provide sufficient evidence...

question is in attached file



ACCT 4550 – Accounting Data Analytics Evidence of Significant and Authentic Learning Cover Sheet ESL 2 Name: Requirements: 1. Complete labs 3-4, 3-5, 4-1, and 4-2 and 4-3. Provide sufficient evidence of your completed labs, including screen prints and answers to some of the key lab questions (you choose which answers to provide.) 25 pts. 2. Develop a series of questions you want to ask about Dillards data that is all connected to a central theme. Regression analysis should help you be able to answer at least one of your questions. In addition to listing each question, describe your central theme. The questions should be deep enough that the data you pull from Dillards will require analysis in either Excel, Tableau, or both. (I’m expecting a minimum of 3 questions) 3. For each of your questions listed above, identify which fields from which tables you will need to acquire. 4. Write an SQL query (or queries) that you will use to pull the data. 5. Clean/prep your data. Describe what you did and provide screen print evidence. 6. Perform analysis on your data to help you answer the questions. Describe which analytical tools you used and provide a screen print of each. (Use at least two Excel-based tools and at least two Tableau-based tools.) Provide a description of your results. 7. Communicate your results visually. If appropriate, consider incorporating a Tableau dashboard. Your results summary page should be formatted as a one-page document that you would be willing to submit to a client or manager. 8. Did you encounter any challenges or struggle with any particular part of this assignment? Is there anything else you want me to know while I am evaluating your submission? Lab 3-4 Lab 3-5 Lab 4-1 Lab 4-2