The Excel BI Virtual Group offers training and support to individuals who use Excel.

News and Updates

The Conference for SQL Server & BI Professionals


Connect, Share & Learn at the largest conference for SQL Server & BI Professionals. Stay ahead of the curve with the most technical sessions, delivered by the world’s experts, and connect with 5,000 attendees from around the world. Join us in Seattle, WA, Oct. 30 – Nov 3, 2017.

Interested in presenting?    
Please contact us at excelbivc@pass.org.

 

Intro to Data Cleansing with Get & Transform (Power Query)

Intro to Data Cleansing with Get & Transform (Power Query)

Presented by Oz Du Soleil More powerful than Text-to-Columns; more flexible than VLOOKUP and INDEX/MATCH. Get & Transform has incredible capacity to cleanse and shape data. And repetitive cleansing tasks can be automated. Oz will show you critical skills that can be done with Get & Transform, from reading in large data sets to fixing critical data inconsistencies, this talk will help you always maintain access to clean, trustworthy data.


Oz du Soleil

Oz du Soleil is an Excel developer, blogger, trainer, co-host of ExcelTV, raconteur and newly recognized Excel MVP. He and his blog are known for a colorful and fierce commitment to empowering people who don’t have an IT team or the skillset to manage their own data. Oz is also lead author of the forthcoming book, Guerrilla Data Analysis 2nd Ed., co-written with Mr. Excel, Bill Jelen. He recently relocated to Portland, OR and is known for his passion for ghost pepper sriracha.

Announcements

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids