January '15 Baton Rouge SQL Server User Group

Post date: Dec 29, 2014 2:5:29 PM

Date: Wednesday, January 14, 2015

Location: The Louisiana Technology Park - http://www.brssug.org/where

Sponsored By: Complete Medical Solutions, LLC

Agenda:

5:45 - 6:15 pm: Networking and Dinner with the other user groups

6:15 - 6:30 pm: Announcements and Sponsor Message

6:30 - 7:00 pm: User Group business

7:00 - 8:00 pm: Main Topic Speaker

8:00 - 8:30 pm: Raffle and Giveaways

Main Topic: Forensic Analytics with PowerPivot for Excel

Main Topic Speaker: William E Pearson III

Main Topic 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.

Main Topic Bio: 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.