Upcoming Chapter Events

Next Meeting: Thu, Oct 16 2014

Introducing Forensic Analytics with PowerPivot for Excel - Bill Pearson

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://nextplex.com/rochester-ny/calendar/events/19478-introducing-forensic-analytics-with-powerpivot-for-excel-bill-pearson

Despite the wealth of analytical technologies available today, 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 PowerPivot for Excel to drive forensic analytics via various tests and reviews.

Session Level: Beginner / Overview

Bio: William E. Pearson III

Bill Pearson, SQL Server Analysis Services Maestro, SQL Server MVP, CPA, CITP, CGMA, 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 Professional designation multiple years 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, and he presents regularly at SQL Saturdays and other diverse events worldwide.

Bill is a member of the Boulder BI Brain Trust.

Food will be provided by our wonderful sponsor, Red Gate

When

iCal
UTC : Thu, Oct 16 2014 22:00 - 01:00
Event Time : Thu, Oct 16 2014 18:00 - 21:00 Eastern Daylight Time
Your Local Time: Thu, Oct 16 2014 22:00 - 01:00

Where

3535 Winton Place
Rochester, New York

Direction: None

Featured Presentation

Introducing Forensic Analytics with PowerPivot for Excel

Speaker: William E Pearson III, President Island Technologies Inc.

Summary: Despite the wealth of analytical technologies available today, 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 PowerPivot for Excel to drive forensic analytics via various tests and reviews. Session Level: Beginner / Overview

About William E: Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill's background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence solution.

Attachments

 Gold Sponsors

               

 Chapter Sponsors
 Announcements
PASS Summit Discount Code - Thursday, June 05, 2014

Select Full Summit - Discounted Registration and use discount code USNES3L to save $150 on PASS Summit registration
https://www.regonline.com/Register/Checkin.aspx?EventID=1302179

 
 Text/HTML
free hit counter