TRANSFORM YOUR AUDITORS INTO AUDIT DATA LEADERS
Data visualization is kinda like having discussions about a sudden increase in sales performance at the coffee machine and then being able to check on your phone: KPIs; line graphs; scatter diagrams; box plots and bar charts; that help you to see unusual patterns.
You are chatting with your audit team member, Sara, over coffee. Sara is wondering why sales are up so much compared to last year, despite no changes to Cost Of Goods Sold. Perhaps it has something to do with the increased incentives for distributors.
You show Sara a data analytics dashboard that you can view from your phone. There, you can see all the sales per distribution. You click on the scatter diagram that shows sales volume versus margin and you click on a distributor that is way off the diagonal because they have a low margin but high sales volume. The dashboard immediately filters all tables and graphs. Scrolling down you can see a bar chart. There is a big peak on one particular day. Selecting that day, you notice in the detailed table at the end that there are 50 entries for the same product, same volume and same customer.
Data analytics secrets takes you through 300 must-have data analytics per business area. Based on over 20 years' experience of data analytics for SAP, the book provides a framework for integrating data analytics into the audit process and lists the SAP tables and fields required for all of these data analytics.
Knowing which SAP tables and fields to use and searching through blogs takes a huge amount of time and can be daunting without knowledge of SAP ABAP codes, relational database theory or SAP user interfaces. Often these online blogs give incorrect information and may send you down the wrong rabbit hole.
In this book, discover how data has a better idea to help you uncover insights quicker. Â