-
January '15 Baton Rouge SQL Server User Group
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. |
Posted Dec 29, 2014, 6:05 AM by BRSSUG SQLPass BatonRouge
-
November '14 Baton Rouge SQL Server UG
Date: Wednesday, November 12, 2014 Location: The Louisiana Technology Park - http://www.brssug.org/where
Sponsored By: Tegile
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: New Approach to Build and Test in SSIS using BIML
Main Topic Speaker: Yoke Wanneevechasilp, American Credit Acceptance
Main Topic Summary: Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SSIS development time. During this presentation, the free BIDSHelper add-in for BIDS and SSDT will be used to introduce Biml and use to automatically generate custom SSIS packages. Additionally, a new approach to unit testing and integration testing will be discussed. This approach uses metadata authored by analysts in Excel to automatically generate testing logic within the corresponding packages or to automatically generate standalone test packages that contain all of the necessary validation logic.
Main Topic Bio: Yoke Wanneevechasilp is a Senior BI Developer with 6+ years of experience in Microsoft BI Stack (SSMS, SSRS, SSIS and SSAS) and SharePoint (2007,2010. And 2013). She has a Bachelor's Degree in Information Systems and Decision Sciences from Louisiana State University (LSU). She currently works for American Credit Acceptance in Spartanburg, South Carolina. She also hold the following certifications: - Microsoft Certified Professional (MCP)
- Microsoft Certified Technology Specialist (MCTS): Microsoft Dynamic GP Installation and Configuration
- Microsoft Certified Technology Specialist (MCTS): SQL Server 2008
- Microsoft Certified IT Professional (MCITP): BI Developer 2008
- Microsoft Certified Solutions Associate (MCSA): SQL Server 2012
|
Posted Oct 22, 2014, 12:19 PM by BRSSUG SQLPass BatonRouge
|
|
