Webclass 75: Data analyst toolbox – Top 10 tips and tricks to know

Q1. In Claire’s opinion, do data analysts for internal audit need to understand accounting?

Q2. Which type of join could help you to do an SOD analysis on the General Ledger in five minutes?

Q3. Why would I not bother writing a degressive script for SAP negative stock analysis over time?

Q4. Why might I want to import 1000s of badge-access log files and Active Directory log files?

Q5. Why might you want to scrap Google or Duck-duck-go for each supplier on your supplier list?

Q6. Why might you want to correlate all of the results from different dashboards into one summary dashboard?

Q7. Why might you want to list the accounts on debit and the accounts on credit on one line per journal entry?

Q8. Which graph would be the best choice for immediately seeing in a large set of data, if you have suppliers that charge you an unusual price for a material, compared to all the other suppliers?

Q9. Is it possible to create an application that automatically imports data from SAP?

Q10. Which python library can you use to automatically decide if a supplier name is a person or an organisation?