Introducing Forensic Analytics with Power BI

Despite the wealth of analytical technologies available today, more than 65% of occupational fraud at public companies is detected through tips, management review, or simple accidents. Forensic Analytics can change this disappointing scenario by employing a combination of human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities.

In this session, we explore Forensic Analytics, a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of Forensic Analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected. We discuss guiding principles that are key to effectively and confidently ferreting out data anomalies, and outline a methodology to meet key principles by applying a standard, repeatable process to Forensic Analytics. Throughout the session, we view examples of how we can employ PowerBI to drive Forensic Analytics via various tests and reviews.

https://a248.e.akamai.net/secure.meetupstatic.com/photos/event/4/c/e/8/600_452599688.jpeg

Bill Pearson, SQL Server Analysis Services Maestro, Data Platform MVP, CPA, CITP, CMA, CIA, MCDBA, MCSE, is a consultant, author, mentor and business intelligence architect who has been working with business intelligence for over 18 years, and with the integrated Microsoft Business Intelligence solution since its inception. Bill has been awarded the Microsoft Most Valuable Player multiple times for his technical experience implementing Microsoft BI, as well as his contributions to the community as an author and speaker. Bill’s recent series’ include the Stairway to MDX and Stairway to PowerPivot and DAX columns at SQLServerCentral.com (http://www.sqlservercentral.com/stairway/75426/), and he presents regularly at SQL Saturdays and other diverse events worldwide. Bill is a member of the Boulder BI Brain Trust.