Microsoft Power BI is a self service solution for your data needs using Excel. It incorporates different tools for data discovery, analysis and visualization. Based in the cloud it provides you insight into almost any type of data in Excel, which is one of a DBAs best tools.
Excel has evolved so much over the years it’s difficult to stay abreast of additions and fancy tools. With the introduction of a number of Power capabilities including Power Pivot, Power View and Power Maps, it’s Excel’s Power Query that’s worth looking into further. Power Query helps end users find and prep data for analysis. Power Query makes it possible for queries to be published and reused, but the script is easier to maintain. In this white paper we will look at Power Query’s shaping capabilities when working with data inside Excel 2013.