SQL Server Innovators Guild

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




Red gate 

Back to Top