SQLBits 2014

Power Query in Modern Corporate BI

Explore Power Query features to import data from existing Corporate BI systems.
In a Corporate BI environment, it is common having data available in controlled data sources such as Data Warehouse, relational Data Marts, Analysis Services cubes. Consuming this data with self-service BI is very useful, but how do you manage and validate the access to corporate data sources? How do you share and validate new queries created by end users? How can users extracts data at the right granularity level? Power Query bridges the gap between corporate and self-service BI. It empowers end-users so that they can extract and manipulate data from several data sources, inside and outside of the company. In this session, you will learn the Power Query best practices that enable the extraction of data from existing database and cubes, guided by an expert that know both worlds (Corporate BI and Power Pivot data models).