Join BI Architect and SSAS Maestro Bill Pearson as he introduces his DAX and PowerPivot Essentials series, a new SSWUG exclusive. In this three-part article, we will cover getting started with PowerPivot for Excel, and then begin our first look at the Data Analysis eXpressions (“DAX”) language with hands-on exposure to the Related() and Distinct() functions.
Read this article..
Bill has been working with computers since before becoming a "big eight" CPA, after which he carried his growing information systems knowledge into management accounting, internal auditing, and various capacities of controllership.
Bill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base. Bill's background as a CPA, Internal Auditor and Management Accountant enable him to provide value to clients as a liaison between Accounting / Finance and Information Services. Moreover, as a Certified Information Technology Professional (CITP) - a CPA recognized for his or her unique ability to provide business insight by leveraging knowledge of information relationships and supporting technologies - Bill offers his clients the CPA's perspective and ability to understand the complicated business implications and risks associated with technology. From this perspective, he helps them to effectively manage information while ensuring the data's reliability, security, accessibility and relevance.
Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, focusing his practice upon the integrated Microsoft business intelligence solution. He leverages his years of experience with other enterprise OLAP and reporting applications (Cognos, Business Objects, Crystal, etc.) in regular conversions of these once-dominant applications to the Microsoft BI stack.
comments powered by