Data Analytics in Accounting is designed to prepare your students with the necessary tools and skills they need to successfully perform data analytics. Using the IMPACT Cycle, the authors provide a conceptual framework to help students think through the steps needed to provide data-driven insights and recommendations. Integrated in each chapter, labs provide students with hands on experiences performing analysis using various datasets and tools. Students will perform data analysis using Excel, Access (including SQL), Tableau, IDEA, XBRL, and Weka. With customer feedback in mind, the authors incorporated three new chapters covering tax and capstone projects that focus on both high-level and low-level projects. Additional videos were integrated into Connect to provide more lecture and lab support. This is an innovative course solution that includes cutting-edge content and assessment paired with assignments that help students build the skills they need to succeed.
Ch. 2 Mastering the Data
Ch. 3 Performing the Test Plan and Analyzing the Results
Ch. 4 Communicating Results and Visualizations
Ch. 5 The Modern Accounting Environment
Ch. 6 Audit Data Analytics
Ch. 7 Managerial Analytics
Ch. 8 Financial Statement Analytics
Ch. 9 Tax Analytics
Ch. 10 Project Chapter (Basic)
Ch. 11 Project Chapter (Advanced): Analyzing Dillard’s Data to Predict Sales Returns
Appendix A Basic Statistics Tutorial
Appendix B Accessing the Excel Data Analysis Toolpak
Appendix C Excel (Formatting, Sorting, Filtering, and PivotTables)
Appendix D SQL Part 1
Appendix E SQLite
Appendix F Power Query
Appendix G Tableau
Appendix H SQL Part 2
Appendix I Power BI
Appendix J Dillard’s ER Diagram
Appendix K Data Dictionaries
By prompting students to engage with key concepts, while continually adapting to their individual needs, Connect activates learning and empowers students to take control resulting in better grades and increased retention rates. Proven online content integrates seamlessly with our adaptive technology, and helps build student confidence outside of the classroom.
Available within Connect, SmartBook 2.0 is an adaptive learning solution that provides personalized learning to individual student needs, continually adapting to pinpoint knowledge gaps and focus learning on concepts requiring additional study. SmartBook 2.0 fosters more productive learning, taking the guesswork out of what to study, and helps students better prepare for class. With the ReadAnywhere mobile app, students can now read and complete SmartBook 2.0 assignments both online and off-line. For instructors, SmartBook 2.0 provides more granular control over assignments with content selection now available at the concept level. SmartBook 2.0 also includes advanced reporting features that enable instructors to track student progress with actionable insights that guide teaching strategies and advanced instruction, for a more dynamic class experience.
Your text has great instructor tools, like presentation slides, instructor manuals, test banks and more. Follow the steps below to access your instructor resources or watch the step-by-step video.
- To get started, visit connect.mheducation.com to sign in. (If you do not have an account, request one from your McGraw Hill rep. To find your rep, visit Find Your Rep)
- Then, under "Find a Title," search by title, author, or subject
- Select your desired title, and create a course. (You do not have to create assignments, just a course instance)
- Go to your Connect course homepage
- In the top navigation, select library to access the title's instructor resources