In this session we will cover the basics of using Data Explorer (Now called Power Query) + other tools to explore XML data from the SQL Saturday website. We will look at lesser-known features like XML feeds, harvesting data from other websites, and social media sources using open source tools like Curl (a command line tool for transferring data with URL syntax). We will use Business Intelligence tools such as the new Data Explorer and SQL Server to download and analyze the XML.
Speakers: Julie Smith and Rob Volk.
Julie Smith has spent the last 13 years bending data using varied tools such as MS Access, MySQL, and SQL Server[masked]. She is a Business Intelligence Consultant at Innovative Architects, and an active speaker, blogger and writer in the Microsoft SQL Server Community. In spite of being a SQL Server MVP, she remains "very simple woman with warm fuzzy secret heart." Rob Volk is a database administrator from the Atlanta, Georgia area, having worked in the wireless telecom, utility billing, and credit card processing industries for the past 10 years. He started using SQL Server with version 6.5 and is very glad to have upgraded since then. He has presented at several SQL Saturdays and user groups. In his spare time he accomplishes more than he does on the job, just don't tell his boss.