Chicago SQL BI User Group Meeting
Power Query – Microsoft’s new data exploration tool (Excel add-in, formerly known as “Data Explorer”)
Date : July 16, 2013 Time : 05:30 PM CST
Join Matt Rager at the SQL Server BI User Group meeting on July 16 to learn about the unique features of Microsoft's Power Query.

Microsoft Power Query for Excel is an add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access. Power Query enables users to easily discover, combine, and refine data for better analysis in Excel. Power Query includes a public search feature that is currently intended for use in the United States only.

With Power Query, you can:

  • Identify the data you care about from the sources you work with (e.g. relational databases, Excel, text and XML files, OData feeds, web pages, Hadoop HDFS, etc.).
  • Discover relevant data using the search capabilities within Excel.
  • Combine data from multiple, disparate data sources and shape it in order to prepare the data for further analysis in Excel and PowerPivot.

Speaker: Matthew B Rager
Location: Microsoft Technology Center, 200 E Randolph St. Suite 200 Chicago, IL 60601

Food will be served at 5:30 and the speaker will start by 6:00 PM.

Please note: Registration ends on Monday, July 15 at noon.

West Monroe Insights
Non-Revenue Water (NRW): Challenges & Solutions
View More
Related Insights
Driving business transformation with new customer experience and data analytics capabilities
Date : June 15, 2017

Partnering with West Monroe, BridgeHealth transformed its organization—establishing Salesforce, analytics, reporting, and contact center capabilities essential to further change. These new capabilities have improved efficiency and insight, and more importantly, they will help BridgeHealth deliver a better member experience and fulfill its mission of enabling high-quality care at a better value.

Date : June 15, 2017

BridgeHealth, a benefit-management organization, gained critical new Salesforce, contact center, analytics, and reporting capabilities to boost efficiencies and standardize for growth.

In a world of ever-increasing, real-time information and mounting demands from informed consumers, water utilities face exponentially greater difficulty when making business decisions.
Date : May 17, 2017

Water utility executives are starved for more insightful operational data. As a result, many water utilities are considering or investing in automated metering infrastructure (AMI) and related analytics capabilities.