Month: March 2015

Power BI Tutorial: How to implement Currency Conversion Using Power Query and Power Pivot

Data for the tutorial can be obtained by downloading the following files:      Exchange Rate File Working with Currency File Step 1: Load Sales Data to Data Model Open workingwithcurrency.xlsx, highlight Sales Data table, pick PowerPivot from the ribbon and select Add to Data Model Step 2: Using Power Query to transform Exchange Rate data

Continue reading

Microsoft Announces IT Pro and Developer Preview for Office 2016

New BI features include the following: Power Query is integrated into the Ribbon Three new Excel functions have been added to support forecasting Support for Slicer multi select using touch Time grouping for model based pivot tables Power View against multidimensional cubes Improved automatic relationship detection Ability to rename Power pivot measures and columns in

Continue reading

What Is Power BI Designer And Why You Should Start Playing With It Right Now

Although Microsoft has not yet given us an official roadmap for its Power BI offering, I believe it is not beyond the realm of reason to share some educated and uneducated guesses about where the Power BI Designer might fit in. Philosophically speaking, I have heard two opinions about Microsoft creating a standalone tool that

Continue reading