Professional Association for SQL Server

Meeting Archive 2016

Feb 7th Pragmatic Power BI: Transforming Data with Bill Pearson 

6:00 – 6:30 Pizza and Networking sponsored by Find Great People

6:30 – 6:40 Announcements

6:40 – 7:00 SQL Server 2016 Open Discussion

7:0 – 8:15  Pragmatic Power BI: Transforming Data with Bill Pearson

8:15 - 8:30 Closing remarks and give-a-ways

Once we’ve extracted data from a source, we typically need to clean, or otherwise change, that data in preparation for loading it into Power BI.  In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson will explore the options Power BI offers to unpivot, filter, sort, aggregate, and perform other needed operations to make these preparations.  We’ll employ a dataset containing issues that commonly present real-world challenges, and work through the steps we can take in Power BI to transform the data to a state that works within Power BI.  Moreover, we’ll define calculations, and get a glimpse of the M language that underlies transformational processes we construct.


Bill Pearson:

William E Pearson III

President, Island Technologies Inc.

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

Welcome to the Greenville, SC Chapter

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.





Red gate