Our book will help you to guide your team through data analytics projects, as they enable you to benchmark against what other large MNCs with SAP are doing in terms of data analytics and visualization. It also takes you through case-studies so that you can get a feeling for the typical types of dashboards for data analytics and how these dashboards are used.
The Data Analytics Secrets book for SAP includes 300 must-have data analytics tests and an appendix listing all necessary SAP tables and fields for each test, as well as Ikea-style diagrams on how the SAP tables and fields link together. The book also contains key information to help you identify manual journal entries, calculate currency conversions, understand different date and amount fields, compute user access and much more.
In this book, you will discover the following information for each business process:
77% of All Global transactions touch an SAP system. We are members of the SAP Partner Edge Ecosystem and our proud to submit our ASAP tool to SAP for certification.
Fast Company Top 10 innovator in Social Good with over 50000 customers worldwide. We are proud to be a partner of QLIK, on which our 300Framework platform is based. Our Ho Chi Minh team follow the QLIK training program and many have already achieved certification as QLIK data analysts.
Thanks to our origins in Big 4 audit firms, we are passionate ACL (now Galvanize) programmers and Certified ACL Data Analysts. We can answer any of your Galvanize questions in record time, thanks to over 20 years’ experience with their software.
Are you interested in financial reporting, purchase to pay, order to cash, inventory, fixed assets, human resources or user access? We have created one book which contains each business process so that you can focus your efforts on the area that is most important to you.
This book is for internal audit directors or heads of internal control that are working in Groups using SAP. If you are thinking of rolling out data analytics or increasing the scope of data analytics within your Group or if you are trying to get your team to adopt data analytics, then this book will let you know what all the other companies out there are typically doing in terms of data analytics.
The book will also give you background knowledge concerning why and how data analytics are used, as well as a framework that you can use to map must-have data analytics to your existing audit plan or internal control plan.
Furthermore, the book contain the key technical information on SAP that you can use in order to help your team get the necessary data and have the knowledge required to start analysing it correctly.
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.
“I was desperately looking for a solution to import extraction from one accounting software into another one. I was thinking about changing software or hiring a full-time accountant: both of which are costly and time consuming. So I had nothing to lose to try this. I send my request on the website. At the end of the day, I received some very powerful comments and questions. 24-hours after I sent the query, 90% of the job was done and I was confident that it was possible to do 100%. We continued to work together the whole week and it was really nice to work with Claire as she understood really deeply what I needed… I’m so happy that I’m considering the other services provided by the company as it seems to be really helpful for managers. ” – Maelle Jarlier, Centre Medical International
“Aufinia is a most unique analytics partner of ours, and is headed by Claire Worledge. Based in Vietnam, Aufinia specializes in Fraud Analytics – we just basically throw any data at her and her team can generate unique perspectives on potential fraud that may be happening based on that data.
We have engaged them on a cloud analytics platform service which we hope to progress to more coverage. We thank Colin for having introduced Claire and Aufinia to us” – Lauro Matias, EEI Corporation