addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

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.

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, and he presents regularly at SQL Saturdays and other diverse events worldwide.  Bill is a member of the Boulder BI Brain Trust.

Join or login to comment.

  • Pat B.

    I saw this presentation in June at SQL Saturday and enjoyed it so much that I decided to attend it again. I thought that it was even better the second time around. Bill is extremely knowledgeable and very entertaining. He is one of my favorite speakers and I always make his presentations a priority to attend even if I have to sacrifice attending a different presentation.

    September 13

  • Thomas.B

    Very informative and the presenter was extremely funny, entertaining and very knowledgeable.

    September 13

  • Daniel R.

    Fascinating introduction to a very useful tool that any office nerd can use. The speaker was fantastic and had everyone spell-bound with his sense of humour and intriguing stories.

    September 12

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy